Automatic data consolidation

• US 7,401,101 B2
• Filed: 09/15/2005
• Issued: 07/15/2008
• Est. Priority Date: 04/28/2003
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Hild, Stefan G., Rjaibi, Walid W., Pawlitzek, Rene A., Stolze, Markus
• Primary Examiner(s): Vital; Pierre M.
• Assistant Examiner(s): NGUYEN, LOAN T
• Application Number:
  US11/227,875
• Publication Number:
  US 20060036624A1
• Time in Patent Office: 1,034 Days
• Field of Search: None
• 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, from a request detector attached to each distributed database, request information comprising access information to each distributed database,

analyzing the access information in an inference engine associated with the central database,

aggregating, into the central database, data content from each distributed database based on analyzed access information,

generating, by the inference engine, an instruction indicating successful data consolidation from a distributed database, based on the aggregating,

redirecting, by the request detector, a request to the distributed database as a redirect request to the central database, based on the instruction received by the request detector from the inference engine indicating successful data consolidation.

2. The method according to claim 1, 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.

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

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

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

7. The method of claim 1, wherein the request detector comprises a transforming means that derives access information from the detected request information.

6. A program product storage device readable by machine, tangibly embodying a program of instructions executable by said machine to perform a method for consolidating data from distributed databases into a central database, said method comprising:

receiving, from a request detector attached to each distributed database, request information comprising access information to each distributed database,

analyzing the access information in an inference engine associated with the central database,

aggregating, into the central database, data content from each distributed database based on analyzed access information,

generating, by the inference engine, an instruction indicating successful data consolidation from a distributed database, based on the aggregating,

redirecting, by the request detector, a request to the distributed database as a redirect request to the central database, based on the instruction received by the request detector from the inference engine indicating successful data consolidation.