Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2003-11-21
2009-02-10
Pham, Khanh B. (Department: 2166)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000
Reexamination Certificate
active
07490093
ABSTRACT:
Described is a method and system for storing data into a database, where a determination is made if schema metadata that is used to load the data into the database already exists, and where the existing schema metadata is used to load the data into the database if the schema metadata already exists. If the appropriate schema metadata does not exist, then it is generated and cached so that a later load operation for the same schema type will not need to re-generate this information. In this way, the cost to generate the schema metadata is amortized over multiple load operations to load data of the same schema type. The approach is protocol neutral so that multiple different protocol-based loads can operate with the same schema metadata information and load structures.
REFERENCES:
patent: 5295261 (1994-03-01), Simonetti
patent: 5404513 (1995-04-01), Powers et al.
patent: 5467471 (1995-11-01), Bader
patent: 5680614 (1997-10-01), Bakuya et al.
patent: 5724577 (1998-03-01), Exley et al.
patent: 5734887 (1998-03-01), Kingberg et al.
patent: 5964407 (1999-10-01), Sandkleiva
patent: 5974407 (1999-10-01), Sacks
patent: 5987506 (1999-11-01), Carter et al.
patent: 6038563 (2000-03-01), Bapat et al.
patent: 6055544 (2000-04-01), DeRose et al.
patent: 6061684 (2000-05-01), Glasser et al.
patent: 6085198 (2000-07-01), Skinner et al.
patent: 6128610 (2000-10-01), Srinivasan et al.
patent: 6141655 (2000-10-01), Johnson et al.
patent: 6154741 (2000-11-01), Feldman
patent: 6199195 (2001-03-01), Goodwin et al.
patent: 6208993 (2001-03-01), Shadmon
patent: 6236988 (2001-05-01), Aldred
patent: 6263332 (2001-07-01), Nasr et al.
patent: 6269380 (2001-07-01), Terry et al.
patent: 6279006 (2001-08-01), Shigemi et al.
patent: 6279007 (2001-08-01), Uppala
patent: 6298349 (2001-10-01), Toyoshima et al.
patent: 6343287 (2002-01-01), Kumar et al.
patent: 6356920 (2002-03-01), Vandersluis
patent: 6366934 (2002-04-01), Cheng et al.
patent: 6370537 (2002-04-01), Gilbert et al.
patent: 6418448 (2002-07-01), Sarkar
patent: 6470344 (2002-10-01), Kothuri et al.
patent: 6470494 (2002-10-01), Chan et al.
patent: 6487546 (2002-11-01), Witkowski
patent: 6496842 (2002-12-01), Lyness
patent: 6542911 (2003-04-01), Chakraborty et al.
patent: 6571231 (2003-05-01), Sedlar
patent: 6571232 (2003-05-01), Goldberg et al.
patent: 6604100 (2003-08-01), Fernandez et al.
patent: 6636845 (2003-10-01), Chau et al.
patent: 6643633 (2003-11-01), Chau et al.
patent: 6675230 (2004-01-01), Lewallen
patent: 6718322 (2004-04-01), Brye
patent: 6725212 (2004-04-01), Couch et al.
patent: 6754661 (2004-06-01), Hallin et al.
patent: 6772180 (2004-08-01), Li et al.
patent: 6772350 (2004-08-01), Belani et al.
patent: 6785673 (2004-08-01), Fernandez et al.
patent: 6826568 (2004-11-01), Bernstein et al.
patent: 6836778 (2004-12-01), Manikutty et al.
patent: 6915307 (2005-07-01), Mattis et al.
patent: 6941511 (2005-09-01), Hind et al.
patent: 6964025 (2005-11-01), Angiulo et al.
patent: 7007037 (2006-02-01), Govindarajan et al.
patent: 7024425 (2006-04-01), Krishnaprasad et al.
patent: 7028037 (2006-04-01), Agarwal et al.
patent: 7031956 (2006-04-01), Lee et al.
patent: 7036072 (2006-04-01), Sulisito et al.
patent: 7047250 (2006-05-01), Agarwal et al.
patent: 7047253 (2006-05-01), Murthy et al.
patent: 7051033 (2006-05-01), Agarwal et al.
patent: 7051039 (2006-05-01), Murthy et al.
patent: 7072896 (2006-07-01), Lee et al.
patent: 7096224 (2006-08-01), Murthy et al.
patent: 7139746 (2006-11-01), Shin et al.
patent: 2002/0007363 (2002-01-01), Vaitzblit
patent: 2002/0029229 (2002-03-01), Jakopac et al.
patent: 2002/0078068 (2002-06-01), Krishnaprasad et al.
patent: 2002/0087510 (2002-07-01), Weinberg et al.
patent: 2002/0147763 (2002-10-01), Lee et al.
patent: 2002/0165865 (2002-11-01), Hosokai
patent: 2002/0169788 (2002-11-01), Lee et al.
patent: 2002/0184401 (2002-12-01), Kadel, Jr. et al.
patent: 2003/0004937 (2003-01-01), Salmenkaita et al.
patent: 2003/0009361 (2003-01-01), Hancock et al.
patent: 2003/0033285 (2003-02-01), Jalali et al.
patent: 2003/0065659 (2003-04-01), Agarwal et al.
patent: 2003/0093672 (2003-05-01), Cichowlas
patent: 2003/0101194 (2003-05-01), Rys et al.
patent: 2003/0105732 (2003-06-01), Kagalwala et al.
patent: 2003/0120665 (2003-06-01), Fox et al.
patent: 2003/0140308 (2003-07-01), Murthy et al.
patent: 2003/0154204 (2003-08-01), Chen-Wright et al.
patent: 2003/0172135 (2003-09-01), Bobick et al.
patent: 2003/0182624 (2003-09-01), Large
patent: 2003/0204787 (2003-10-01), Bartucca et al.
patent: 2004/0015936 (2004-01-01), Susarla et al.
patent: 2004/0043758 (2004-03-01), Sorvari et al.
patent: 2004/0044687 (2004-03-01), Vachuska et al.
patent: 2004/0064466 (2004-04-01), Manicutty et al.
patent: 2004/0088320 (2004-05-01), Perry
patent: 2004/0117359 (2004-06-01), Snodgrass et al.
patent: 2004/0162832 (2004-08-01), Dettinger et al.
patent: 2004/0176958 (2004-09-01), Salmenkaita et al.
patent: 2004/0220912 (2004-11-01), Manikutty et al.
patent: 2004/0220927 (2004-11-01), Murthy et al.
patent: 2004/0225680 (2004-11-01), Cameron et al.
patent: 2005/0010896 (2005-01-01), Meliksetian et al.
patent: 2005/0050056 (2005-03-01), Idicula et al.
patent: 2005/0050058 (2005-03-01), Jain et al.
patent: 2005/0050092 (2005-03-01), Jain et al.
patent: 2005/0050105 (2005-03-01), Idicula et al.
patent: 2005/0228818 (2005-10-01), Murthy et al.
patent: 2006/0031233 (2006-02-01), Liu et al.
patent: 2006/0036935 (2006-02-01), Warner et al.
patent: CN2528492 (2005-01-01), None
patent: 1367503 (2003-12-01), None
patent: 60-218142 (1985-10-01), None
patent: 2-165353 (1990-06-01), None
patent: 8-249159 (1996-09-01), None
patent: WO97/03406 (1997-01-01), None
patent: WO 00/049533 (2000-08-01), None
patent: WO 01/042881 (2001-06-01), None
patent: WO 01/59602 (2001-08-01), None
patent: WO 01/059602 (2001-08-01), None
patent: WO 01/61566 (2001-08-01), None
patent: WO 01/061566 (2001-08-01), None
patent: WO 2004/095312 (2004-11-01), None
Hsu,C et al. “A metadata system for information modeling and integration”, proceedings in systems integration, 1990, pp. 616-624.
Lenz,H , “the conceptual schema and external schemata of metadatabases”, proceedings in international working conference on scientific and statistical database management, 1994, pp. 160-165.
Rosenthal, A et al. “administering propgating metadata in large, multi-layer database systems”, 1999, pp. 11-16.
Mathew B Jones et al. “managing scientific metadata”, IEEE internet computing, Oct. 2001, pp. 59-68.
Berkley,C et al. “Metacat: a schema-independent XML database system”,, Thirteenth international conference on scientific and statistical database management, 2001, pp. 171-179.
Tan,J Zaslavsky et al;. “Meta object approach to database schema integration”, proceedings, DOA, International symposium on Distributed objects and applications, 2000 pp. 145-154.
Krippendorf,M et al. “The translation of star schema into entity-relationship diagrams”, Proceedings, eight international workshop on database and expert systems applications, 1997, pp. 390-395.
Bourret, R. et al. “A Generic Load/Extract Utility for Data Transfer Between XML Documents and Relational Databases” Proceedings for the 2nd Int'l Workshop on Advanced Issues of E-Commerce and Web-Based Information Systems, IEEE Computing Society, Jun. 8-9, 2000, pp. 134-143.
Braga, D. et al. “A Graphical Environment to Query XML Data with XQuery” Proceedings of the Fourth International Conference on Web Information Systems Engineering (WISE'03), IEEE, 2003, 10 pages.
Cheng, J. et al. “IBM DB2 XML Extender, An end-to-end solution for storing and retrieving XML documents” IEEE, ICDE'00 Conference, San Diego, CA, Feb. 2000, 128 pages.
Jajodia, S. et al. “Toward a Multilevel Secure Relational Data Model” ACM, 8393 SIGMOD Record, Jun. 20, 1991, XP 000364619, No. 2, pp. 50-59.
Mi-Ok, C. et al. “Design and Implementation of an Object-Oriented Multimedia DBMS Tightly Coupled with Information Retrieval Functi
Agarwal Nipun
Jain Namit
Murthy Ravi
Bingham & McCutchen LLP
Oracle International Corporation
Pham Khanh B.
LandOfFree
Generating a schema-specific load structure to load data... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Generating a schema-specific load structure to load data..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Generating a schema-specific load structure to load data... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4060299