Automatic data consolidation

• US 20060036624A1
• Filed: 09/15/2005
• Published: 02/16/2006
• Est. Priority Date: 04/28/2003
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Pawlitzek, Rene A., Hild, Stefan G., Rjaibi, Walid W., Stolze, Markus
• Granted Patent: US 7,401,101 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99948 Application of database or data structure, e.g. distributed, multimedia, or image
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

The present invention discloses a method, request detector, inference engine, and system for consolidating data from distributed databases into a central database. The method comprises the steps of receiving access information comprising request information to the distributed databases, analyzing the received access information, and aggregating into the central database the data content of the distributed databases in dependence on the analyzed access information.

Claims

1. A method for consolidating data from distributed databases into a central database comprising:

receiving access information comprising request information to the distributed databases,

analyzing the access information, and

aggregating into the central database data content of the distributed databases based on analyzed access information.

2. The method according to claim 1, further comprising providing a request detector at each of the distributed databases to be consolidated.

3. The method according to claim 2, further comprising filtering the request information to the respective distributed databases from data traffic and forwarding the filtered request information within the access information to an inference engine.

4. The method according to claim 2, further comprising integrating the request detector into each of the distributed databases to be consolidated.

5. The method according to claim 1, further comprising generating for the central database a new data schema based on the analyzed access information.

6. The method according to claim 1, wherein analyzing comprises using log-file information.

7. A computer program element comprising program code means for performing a method of claim 1 when said program is run on a computer.

8. A computer program product stored on a computer usable medium, comprising computer readable program means for causing a computer to perform a method according to claim 1.

9. A request detector for supporting data consolidation from distributed databases into a central database comprising a detecting means for detecting request information to the distributed databases, a transforming means that derives access information from the detected request information and a providing means that sends the access information to an inference engine.

10. The request detector (2x) according to claim 9, further comprising redirecting means for redirecting a request to an individual database to the central database.

11. An inference engine for controlling data consolidation from distributed databases into a central database comprising means for analyzing of access information that is received from distributed databases and comprises request information to the respective distributed databases.

12. The inference engine according to claim 11, further comprising correlation means for correlating columns and/or rows between different distributed databases.

13. A system for consolidating data from distributed databases into a central database comprising:

a request detector at each of the distributed databases to be consolidated for providing access information comprising request information to the distributed databases;

an inference engine for analyzing the access information; and

a central database into which the data content of the distributed databases is aggregated based on analyzed access information.