International Business Machines Corporation

David Sciaraffa

Leo Tat Man Lau

Sean W McKeough

Marko Milek

Qing Song

Mark Donald Leitch

A method for recreating a plurality of database dependencies of objects from one database to another is disclosed. The method comprises categorizing the dependencies based upon at least one base object and formalizing the relationships of the dependencies based upon the categorization. The method includes determining the order of recreating the objects based upon the formalizing of the relationships of the dependencies. In a preferred embodiment, the method builds a Dependency Management Table (DMT) that describes the relationship of each object to a base-table. The DMT includes an entry for every object-to-object relationship, including the category of the relationship, and the nesting-level of the dependency from the base-table. Using this information, objects can be recreated in an order which ensures correct management of dependencies.

Method for representing and recreating object dependencies from one database system to another

An apparatus, system, and method are disclosed for efficient adaptive parallel data clustering for loading data into a table by generating a hint-key for each of one or more records in the input data stream, ordering the one or more records in a first-level clustering agent to generate one or more record lists ordered by hint-key. The apparatus, system, and method simultaneously processes one or more record lists in a second-level clustering agent, outputs the one or more records of the one or more record lists clustered by the hint-key of the one or more records, stores, in a partial block cache, a plurality of partial blocks that are output by the second-level clustering agent, and stores, in a partial page cache, a plurality of last partial pages of the partial blocks that have been victimized from the partial block cache.

Growing community of inventors

Markham, Canada

David Sciaraffa