System for consolidating data from distributed databases

• US 7,930,312 B2
• Filed: 05/15/2008
• Issued: 04/19/2011
• 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., Stolze, Markus, Pawlitzek, Rene A.
• Primary Examiner(s): Vital; Pierre M
• Assistant Examiner(s): Nguyen; Loan T
• Application Number:
  US12/121,002
• Publication Number:
  US 20080222163A1
• Time in Patent Office: 1,069 Days
• Field of Search: None
• US Class Current: 707/758
• 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 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.

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

3. The system according to claim 1, said system 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 system according to claim 1, said system integrating the request detector into each of the distributed databases to be consolidated.

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