US 7,490,093 B2
Generating a schema-specific load structure to load data into a relational database based on determining whether the schema-specific load structure already exists
Namit Jain, Folsom, Calif. (US); Nipun Agarwal, Santa Clara, Calif. (US); and Ravi Murthy, Foster City, Calif. (US)
Assigned to Oracle International Corporation, Redwood Shores, Calif. (US)
Filed on Nov. 21, 2003, as Appl. No. 10/718,823.
Application 10/718823 is a continuation in part of application No. 10/648577, filed on Aug. 25, 2003.
Application 10/648577 is a continuation in part of application No. 10/648600, filed on Aug. 25, 2003.
Prior Publication US 2005/0050074 A1, Mar. 03, 2005
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 17/00 (2006.01); G06F 17/30 (2006.01)
U.S. Cl. 707—100  [707/1; 707/102] 24 Claims
OG exemplary drawing
 
1. A method of storing data into a database, comprising:
identifying the data to load into the database, wherein the data is associated with a schema information;
identifying the schema information for the data;
determining whether the schema information and a schema-specific load structure that are used to load the data into the database already exist;
acquiring the schema information from the data based on a first criteria, wherein the first criteria is associated with determining whether the schema information already exists;
generating an in memory representation of the schema information to load the data into the database based on the first criteria;
generating the schema-specific load structure to load the data into the database based on a second criteria, wherein the second criteria is associated with determining whether the schema-specific load structure already exists; and
storing the generated schema information and schema-specific load structures for subsequent loads of the data.