Automatic Data Consolidation

• US 20080222163A1
• Filed: 05/15/2008
• Published: 09/11/2008
• 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,930,312 B2
• Time in Patent Office: Days
• US Class Current: 707/10
• 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. An inference engine for controlling data consolidation from distributed databases into a central database, said inference engine comprising:

means for analyzing of access information that is received from a request detector associated with each of the distributed databases,

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

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

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

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

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

a first processor and a first memory implementing a request detector attached to each of the distributed databases to be consolidated said request detector detecting request information comprising access information to each distributed database;

a second processor and a second memory implementing an inference engine associated with the central database for analyzing the access information and generating an instruction indicating successful data consolidation from a distributed database; and

a central database into which data content of each distributed database is aggregated based on analyzed access information,

wherein the request detector redirects 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.