Abstract: A method of efficiently extracting large data sets from a database may include receiving a first result set from a first query executed on one or more data sources. The one or more data sources may use a first schema when the first query was executed. The method may also include receiving a second result set from a second query executed on the one or more data sources. The one or more data sources may use a second schema when the second query was executed. The method may further include generating a view that combines the first result set and the second result set. The view may resolve differences between the first schema and the second schema.

Abstract: A method of efficiently extracting large data sets from a database may include receiving a first result set from a first query executed on one or more data sources. The one or more data sources may use a first schema when the first query was executed. The method may also include receiving a second result set from a second query executed on the one or more data sources. The one or more data sources may use a second schema when the second query was executed. The method may further include generating a view that combines the first result set and the second result set. The view may resolve differences between the first schema and the second schema.

Abstract: A method of efficiently extracting large data sets from a database includes receiving a query to be executed on a first view of one or more data sources, where previous result sets resulting from previous queries are stored separately from the one or more data sources. The method also includes receiving a current result set from the one or more data sources that is responsive to the query, where the query is reformatted before it is executed such that the result set does not overlap with the previous result sets. The method additionally includes generating a second view that combines the current result set and the one or more previous result sets, where the second view resolves changes in a schema of the one or data sources between when the previous result sets were received and when the current result set is received.

Abstract: A method of efficiently extracting large data sets from a database includes receiving a query to be executed on a first view of one or more data sources, where previous result sets resulting from previous queries are stored separately from the one or more data sources. The method also includes receiving a current result set from the one or more data sources that is responsive to the query, where the query is reformatted before it is executed such that the result set does not overlap with the previous result sets. The method additionally includes generating a second view that combines the current result set and the one or more previous result sets, where the second view resolves changes in a schema of the one or data sources between when the previous result sets were received and when the current result set is received.

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.