Loading data with complex relationships
AssigneeInternational Business Machines Corporation
InventorsPeter GERSTL, Mike GRASSELT, Albert MAIER, Thomas SCHWARZ, Oliver SUHRE
Life of this patent
Estimating the term…
Loading patent…
AssigneeInternational Business Machines Corporation
InventorsPeter GERSTL, Mike GRASSELT, Albert MAIER, Thomas SCHWARZ, Oliver SUHRE
Estimating the term…
Data to be loaded into a target system includes entities having corresponding unique primary data value and secondary data values. The secondary data values have associated foreign key relationships, which links the secondary data value to the primary data value of another entity. In loading the data, the entities are split into insertion leaf groups by execution of an iteration process, each iteration involving generation of a respective set of insertion leaf groups containing entities whose secondary data values have no foreign key relationships or only foreign key relationships with the primary data values of entities of the insertion leaf groups generated during any prior iteration. The iteration process is executed until there are no such entities are left. A sequence of generation of the sets of insertion leaf groups is recorded, and the sets of insertion leaf groups are consecutively loaded into the target system according to the sequence.
A computer implemented method for loading data into a target system, wherein the data comprises entities, each of the entities having a corresponding unique primary data value and one or more corresponding secondary data values, at least a portion of the secondary data values having associated foreign key relationships, each foreign key relationship linking the corresponding secondary data value to the corresponding primary data value of another entity, the method comprising:
A system for loading data into a target system, wherein the data comprises entities, each of the entities having a corresponding unique primary data value and one or more corresponding secondary data values, at least a portion of the secondary data values having associated foreign key relationships, each foreign key relationship linking the corresponding secondary data value to the corresponding primary data value of another entity, the system comprising:
A computer program product for loading data into a target system, wherein the data comprises entities, each of the entities having a corresponding unique primary data value and one or more corresponding secondary data values, at least a portion of the secondary data values having associated foreign key relationships, each foreign key relationship linking the corresponding secondary data value to the corresponding primary data value of another entity, the computer program product comprising a computer readable storage medium having program instructions embodied therewith, the program instructions executable by a processor to cause the processor to perform:
Dependencies are inferred from the claim text.