| 摘要 |
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. A transformation mechanism may also be updated, in response to the change made to the definition of the object, so that the transformation mechanism can generate the one or more other objects based upon a new object defined by the changed definition of the object. Data that defines the one or more other objects may also be updated to reflect the change made to the definition of the object. |
