Abstract: 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.

Abstract: A system for recreating a plurality of database dependencies of objects from one database to another is disclosed. The system comprises categorizing the dependencies based upon at least one base object and formalizing the relationships of the dependencies based upon the categorization. The system includes determining the order of recreating the objects based upon the formalizing of the relationships of the dependencies. In a preferred embodiment, the system and 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.

Abstract: 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.

Abstract: 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.

Abstract: A method and system for recreating a plurality of database dependencies of objects from one database to another is disclosed. The method and system comprise categorizing the dependencies based upon at least one base object and formalizing the relationships of the dependencies based upon the categorization. The method and system includes determining the order of recreating the objects based upon the formalizing of the relationships of the dependencies. In a preferred embodiment, the system and 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.