Patent ID: 7792875

Claim:
A computer-implemented method for recreating a plurality of database dependencies of objects from one database to another database, wherein the computer performs the following functions comprising: categorizing the dependencies based upon at least one base object, wherein dependencies include all dependency classes of direct dependencies and nested dependencies, wherein a nested dependency describes a relationship between nested levels of objects, multi-level dependencies and up level/down level dependencies, wherein the categorizing includes creating a graph for each category to depict the relationships and dependency between the nested levels of objects; formalizing the relationships of the dependencies based upon the graph wherein the graph depicts the relationship of each category of the categorizing step by deriving a dependency table from the graph of each category, wherein the dependency table describes the relationship of each object to the at least one base object, the dependency table having at least an entry for every object-to-object relationship, including a category of relationship, and nesting-level of the dependency from a base-table; and determining a guaranteed order of recreating the objects based upon the built dependency table, wherein all objects related to the built dependency table are automatically recreated without requiring the objects to exist before the built dependency table is derived, wherein the guaranteed order of recreating the objects ensures management of the dependencies wherein when duplicate entries exist for the objects, the next highest nesting-level takes precedence.