Abstract: An approach for reconciling a data warehouse includes automatically identifying, based upon a change made to a definition of an object, one or more other objects in the data warehouse that are affected by the change made to the definition of the object. The object and the other objects may be any type or form of data, for example, database tables or routines, and the invention is not limited to any particular type of object. Dependency analysis is used to evaluate dependency data to identify the one or more other objects affected by the change made to the definition of the object. The dependency data specifies dependencies between the object and the one or more other objects. The dependency data may also specify dependencies between the one or more other objects. As described in more detail hereinafter, the dependency data used may vary depending upon a particular function to be performed.

Abstract: A method for determining the dependencies between objects in a system is provided. Determining the dependencies between objects involves analyzing data about the objects and applying rules to the data about the objects. According to one embodiment, a first set of dependencies between a plurality of objects may be based on data in a set of sources and dependency rules, whereas a second set of dependencies between the plurality of objects may be based on data from a different set of sources but the same dependency rules. According to another embodiment, a first set of dependencies between a plurality of objects may be based on data in a set of sources and dependency rules, whereas a second set of dependencies between the plurality of objects is based on data from the same set of sources but different dependency rules.