Database system with original and public databases and data exploitation support apparatus for displaying response to inquiry of database system

• US 6,216,124 B1
• Filed: 02/08/2000
• Issued: 04/10/2001
• Est. Priority Date: 12/26/1994
• Status: Expired due to Term

• Current Assignee: Fujitsu Limited
• Original Assignee: Fujitsu Limited
• Inventors: Tanaka, Tsutomu, Watanabe, Yasuhiro, Shimizu, Hajime, Watanabe, Ichiro, Terauchi, Yuji, Arai, Shoichi, Takekawa, Kazuhiro, Wakio, Koji
• Primary Examiner(s): HOMERE, JEAN RAYMOND
• Application Number:
  US09/500,061
• Time in Patent Office: 427 Days
• Field of Search: 707/3, 707/10, 707/104, 709/203, 709/211, 709/219, 709/220
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2465 Query processing support for facilitating data mining operations in structured databases
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• 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

Abstract

The data, as read out from a trunk database, and the read-out data, as processed, are stored in a public database. A setup unit and an operations support unit manage the stored data of the public database and the attribute data of the stored data by a dictionary. In accordance with a demand of a user, an inquiry unit processes and displays the data on the basis of the data stored in the public database and the attribute data.

Claims

1. A database system comprising:

a trunk database for storing master data and transaction data of a trunk system;

a public database extracted from said trunk database and subjected to a predetermined processing for an information system;

a dictionary for storing data containing consistency definition data for defining data setup jobs for assuring consistency of database data of at least one of said trunk database and said public database and restricting conditions for executing said data setup jobs;

setup means for recording/managing the consistency definition data for defining the data setup job for assuring the consistency of the database data of at least one of the master data and the transaction data, which are extracted from said trunk database, and the restricting conditions for executing said data setup jobs, by said dictionary;

operations support means for extracting said master data and said transaction data from said trunk database to generate a public database, and for executing the data setup jobs for assuring the consistency of said database data by monitoring statuses of said public database and changing data environments and by referring to said consistency definition data of said dictionary; and

inquiry means for processing/outputting the data of said public database, which have been processed by said setup means and said operations support means, in accordance with a demand of a user.

2. A system according to claim 1, wherein said operations support means includes time consistency means for compensating the time inconsistency of the transaction data collected from said original database, by executing said data setup job based on said consistency definition data.

3. A system according to claim 1, wherein said operations support means includes edition consistency means for compensating the edition inconsistency of master data corresponding to transaction data collected from said original database, by executing said data setup job based on said consistency definition data.

4. A system according to claim 1, wherein said operations support means includes processing consistency means for preventing the inconsistency of secondary processed data corresponding to the interchange of transaction data collected from said original database, by executing said data setup job based on said consistency definition data.

5. A system according to claim 1, wherein said dictionary stores calendar data for operating/managing said system, said setup means records/manages the timing data for executing said data setup job by said calendar data, and said operations support means executes said data setup job in accordance with said timing data.

6. A system according to claim 1, wherein said operations support means includes hold means for holding the publication of data within a corresponding predetermined range, if the consistency cannot be assured by the execution of said data setup job.

7. A database data exploitation support apparatus comprising:

setup means for recording/managing consistency definition data for defining data setup jobs for assuring consistency of database data of at least master data and transaction data, which are extracted from a trunk database of a trunk system, and restricting conditions for executing said data setup jobs, by a dictionary for storing the data containing said consistency definition data;

operations support means for extracting said master data and said transaction data from said trunk database to generate public database, and for executing data setup jobs for assuring assurance of said database data, by monitoring status of said public database and changing data environments and by referring to said consistency definition data of said dictionary; and

inquiry means for processing/outputting the data of said public database, which have been processed by said setup means and said operations support means, in accordance with a demand of a user.

8. An apparatus according to claim 7, wherein said operations support means includes time consistency means for compensating the time inconsistency of the transaction data collected from said original database, by executing said data setup job based on said consistency definition data.

9. An apparatus according to claim 7, wherein said operations support means includes edition consistency means for compensating the edition inconsistency of master data corresponding to transaction data collected from said original database, by executing said data setup job based on said consistency definition data.

10. An apparatus according to claim 7, wherein said operations support means includes processing consistency means for preventing the inconsistency of secondary processed data corresponding to the interchange of transaction data collected from said original database, by executing said data setup job based on said consistency definition data.

11. An apparatus according to claim 7, wherein said dictionary stores calendar data for operating/managing said system, said setup means records/manages the timing data for executing said data setup job by said calendar data, and said operations support means executes said data setup job in accordance with said timing data.

12. An apparatus according to claim 7, wherein said operations support means includes hold means for holding the publication of data within a corresponding predetermined range, if the consistency cannot be assured by the execution of said data setup job.