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

• US 6,065,014 A
• Filed: 12/22/1995
• Issued: 05/16/2000
• 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, Wakio, Koji, Terauchi, Yuji, Arai, Shoichi, Takekawa, Kazuhiro
• Primary Examiner(s): HOMERE, JEAN RAYMOND
• Application Number:
  US08/576,933
• Time in Patent Office: 1,607 Days
• Field of Search: 395/610, 395/617, 395/619, 395/620, 707/10, 707/3, 707/104, 707/2, 707/200
• 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:

an original database;

a public database for storing data including readout data read from said original database and processed data processed from the readout data;

data management means for managing the data stored in said public database and attribute data of the data stored in said public database, in a corresponding manner, the attribute data including management point data corresponding firstly to items of the processed data stored in said public database and secondly to references of management and evaluation for data exploitations; and

inquiry means for processing and displaying output data based on the data stored in said public database and the attribute data in accordance with a demand of a user.

2. A system according to claim 1, wherein said original database includes a trunk database of a trunk system.

3. A system according to claim 2, wherein said data management means includes:

attribute management means for recording/managing the attribute data of the data stored in said public database; and

setup means for setting the attribute data to be managed by said attribute management means.

4. A system according to claim 2, wherein said data management means manages in the attribute data time series definition data for regulating a grouping format to transform the data stored in said public database into time series data, and includes operations support means for extracting the readout data from said original database based on the attribute data, for processing and registering the readout data in said public database, for monitoring status of said public database and changing data environments, and for transforming the readout data and the changing data environments, into time series data with reference to the time series definition data.

5. A system according to claim 2, wherein said data management means manages in the attribute data consistency definition data for defining a data setup job for assuring consistency of at least one of original data in said original database and the data in said public database and for defining restricting conditions upon execution of said data setup job, and includes operations support means for extracting the readout data from said original database based on the attribute data, for processing and registering readout extracted data in said public database, for monitoring status of said public database and changing data environments, and for executing said data setup job as to the readout data to be processed, with reference to said consistency definition data.

6. A system according to claim 2,

wherein said inquiry means includes means for collecting claim data indicating a claim to a disadvantage from the user, and

wherein said data management means includes operations support means for extracting the data from said original database based on the attribute data, for processing and registering the readout data in said public database, for monitoring status of said public database and changing data environments, for notifying a manager of the claim based on the claim data, and for preparing database data based on operations of the manager.

7. A system according to claim 1, wherein said data management means includes:

attribute management means for recording/managing the attribute data of the data stored in said public database; and

setup means for setting the attribute data to be managed by said attribute management means.

8. A system according to claim 7, wherein said attribute management means has a dictionary for storing the attribute data which correspond to the data stored in said public database.

9. A system according to claim 8, wherein said attribute management means uses a common dictionary for storing data common in the entire system, and a user dictionary for storing data containing a sorting method for each user.

10. A system according to claim 8, wherein said attribute management means uses a common dictionary for storing data common in the entire system, and an object dictionary for storing data containing a sorting method for each object.

11. A system according to claim 7, wherein said data management means further includes operations support means for extracting selected data from said original database based on the attribute data to be managed by said setup means and said attribute management means, for processing and registering the selected data in said public database, and for monitoring status of said public database and changing data environments.

12. A system according to claim 1, wherein said inquiry means includes format setting means for setting a final data output format by determining processed content of the data in accordance with the demand of the user and with reference to the attribute data.

13. A system according to claim 12, wherein said format setting means includes dialog setting means for determining the final output format through dialog operations by the user if the final output format cannot be uniquely determined.

14. A system according to claim 1, wherein said data management means manages in the attribute data time series definition data for regulating a grouping format to transform the data stored in said public database into time series data, and includes operations support means for extracting the readout data from said original database based on the attribute data, for processing and registering the readout data in said public database, for monitoring status of said public database and changing data environments, and for transforming the readout data and the changing data environments, into time series data with reference to the time series definition data.

15. A system according to claim 14, wherein said inquiry means includes format setting means for determining corresponding time series data in accordance with a data item demanded by the user and an output format of the data item and with reference to the time series definition data, to fetch final data.

16. A system according to claim 15, wherein said inquiry means includes means for handling the output format, including formatting relating to time, as a management point corresponding to the references of management and evaluation for the data exploitations.

17. A system according to claim 15, wherein said format setting means includes time series editing means for time-series editing the corresponding time series data when unedited.

18. A system according to claim 15, wherein said inquiry means further includes vertical-horizontal transformation means for vertically-horizontally transforming the time series data based on a layout instruction of the data item demanded by the user.

19. A system according to claim 1, wherein said data management means manages in the attribute data consistency definition data for defining a data setup job for assuring consistency of at least one of original data in said original database and the data in said public database and for defining restricting conditions upon execution of said data setup job, and includes operations support means for extracting the readout data from said original database based on the attribute data, for processing and registering the readout data in said public database, for monitoring status of said public database and changing data environments, and for executing said data setup job as to the readout data to be processed, with reference to said consistency definition data.

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

21. A system according to claim 19, wherein said operations support means includes editing consistency means for compensating 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.

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

23. A system according to claim 1,

wherein said data management means manages in said attribute data the management point data and statistical data of data items corresponding to said management point data, and

wherein said inquiry means comprises means for referring to and graphing a management point on at least one axis to present a graph to the user and for setting an inquiry condition for the user based on the graph.

24. A system according to claim 23, wherein said data management means further includes:

segment definition data setting means for setting segment definition data as to a data item corresponding to said management point;

graph means for tentatively graphing the data item based on segment definitions provided by said segment definition setting means, to present the graph to the user; and

segment definition adding means for adding segment definition data, finally set by performing a desired number of times of the setting and graphing of the segment definition data by said definition data setting means and said graph means, to the statistical data.

25. A system according to claim 24,

wherein said data management means adds graph data generated by said graph means, to the statistical data to obtain stored graph data, and

wherein said inquiry means uses the stored graph data for said graphing.

26. A system according to claim 1,

wherein said inquiry means includes means for collecting claim data indicating a claim to a disadvantage from the user, and

wherein said data management means includes operations support means for extracting the data from said original database based on the attribute data, for processing and registering the readout data in said public database, for monitoring status of said public database and changing data environments, for notifying a manager of the claim based on the claim data, and for preparing database data based on operations of the manager.

27. A system according to claim 26, wherein said inquiry means includes:

claim memo input means for the user to input a claim memo indicating content of the claim; and

claim data storage means for storing operation data of the user, when the claim occurs, and the claim data containing said claim memo.

28. A system according to claim 26,

wherein said operations support means includes claim notification means for notifying the manager of newly stored claim data by monitoring the claim data stored by said claim data storage means, and

wherein said data management means further includes re-definition means for re-defining the data to be stored in a dictionary, in accordance with the operations of the manager as based upon notification of said claim data.