Database quality management system

• US 5,933,836 A
• Filed: 05/16/1996
• Issued: 08/03/1999
• Est. Priority Date: 05/16/1996
• Status: Expired due to Fees

• Current Assignee: Lucent Technologies, Inc. (Nokia Corporation)
• Original Assignee: Lucent Technologies, Inc. (Nokia Corporation)
• Inventors: Gobat, James M.
• Primary Examiner(s): Amsbury, Wayne
• Assistant Examiner(s): Jung, David Yiuk
• Application Number:
  US08/648,647
• Time in Patent Office: 1,174 Days
• Field of Search: 707/1-206, 395/200.3-200.83
• US Class Current: 1/1
• CPC Class Codes: G06F 16/273 Asynchronous replication or reconciliation
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users

Abstract

A facility is provided for maintaining automatically the integrity of data associated with respective data applications. The facility achieves this result by providing a plurality of data modules for interfacing respective ones of the applications with their associated data bases such that, in response to receipt of a data request from one of the applications, the respective interfacing module unloads the requested data from the associated data base. The interfacing module then communicates with other ones of the modules to determine if the requested data is consistent with related data stored in their associated data bases. If the requested data is found to be so consistent, then the data is supplied to the requesting application. If not, then the interfacing module corrects the inconsistency in accord with predefined data rules, and then supplies the corrected data to the requesting data application.

Claims

1. Apparatus comprising

a plurality of independent data bases for storing data associated with respective ones of different applications,

a plurality of data modules for interfacing respective ones of said applications with respective ones of the data bases, and

means, contained in each of the data modules and responsive to receipt of a request from an associated one of said applications requesting particular data stored in the respective one of said data bases, for unloading the requested data from the respective one of said data bases and for communicating with individual other ones of said data modules to determine if the unloaded data is consistent with related data stored in their respective ones of said data bases.

2. The apparatus of claim 1 wherein said means for communicating includes means, operative in the event that said requested data is determined to be consistent with said related data stored in said associated ones of said data bases, for supplying said requested data to the associated one of said applications.

3. The apparatus of claim 1 wherein said means for communicating includes means, operative in the event that said requested data is determined to be inconsistent with said related data stored, for reconciling the inconsistency between said requested data and said related data.

4. The apparatus of claim 1 wherein each of said data modules is associated with respective rule bases, each of said rule bases comprising a plurality of specifications specifying how the associated module is to process related data that is inconsistent with requested data, and wherein said means for communicating includes means, operative in the event that said requested data is determined to be inconsistent with said related data, for processing said requested data and said related data in accordance with the specifications stored in the associated one of said rule bases.

5. The apparatus of claim 4 wherein said specifications include a specification to postpone supplying said requested data to said associated one of said applications until the inconsistency between said requested data and said related data is reconciled.

6. The apparatus set forth in claim 1 further comprising

means for determining which of said associated ones of said data bases contain said related data, if any, and for sending a message requesting said related data to each of said associated ones of said data bases that contains said related data.

7. The apparatus set forth in claim 6 further comprising a Data directory for storing a plurality of records each identifying which of said data bases contain data related to requested data, and identifying which data elements in said data bases are related to said requested data.

9. The apparatus of claim 1 wherein said means for communicating includes means, operative in the event that said requested data is determined to be inconsistent with said related data stored, for reconciling the inconsistency between said requested data and said related data.

10. The apparatus of claim 1 wherein said data modules are associated with respective rule bases each comprising a plurality of specifications specifying how the associated module is to process related data that is inconsistent with requested data, and wherein said means for supplying includes means, operative in the event that said requested data is determined to be inconsistent with said related data, for processing said requested data and said related data in accordance with the specifications stored in the associated one of said rule bases.

11. The apparatus of claim 10 wherein said specifications include a specification to post supplying said requested data to said associated one of said applications until the inconsistency between said requested data and said related data is reconciled.

8. Apparatus comprising

a plurality of independent data bases, one of said data bases being associated with respective applications, said data bases containing data associated with said applications

a plurality of data modules associated with respective ones of said data bases,

means, contained in at least one of said data modules and responsive to receipt of a request from one of said applications requesting particular data contained in that one of said data bases respectively associated with said at least one of said data modules, for unloading said requested data from said one of said data bases,

means, contained in said at least one of said data modules, for identifying which of other ones of said data bases contain data related to the requested and for sending a request for a copy of said related data to each of said other ones of said data bases via their respective data modules, and

means, contained in said at least one of said data modules and responsive to receipt of said related data, for supplying said requested data and said related data to said one of said applications if said requested data and said related data are consistent with each other.

12. The apparatus set forth in claim 8 further comprising a Data directory for storing a plurality of records each identifying which of said data bases contain data related to requested data, and identifying which data elements in said data bases are related to said requested data.