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

• US 6,253,199 B1
• Filed: 02/08/2000
• Issued: 06/26/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, Wakio, Koji, Terauchi, Yuji, Arai, Shoichi, Takekawa, Kazuhiro
• Primary Examiner(s): HOMERE, JEAN RAYMOND
• Application Number:
  US09/500,081
• Time in Patent Office: 504 Days
• Field of Search: 707/3, 707/10, 707/104, 709/203, 709/211, 709/220, 709/219
• 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 time series definition data to regulating a grouping type for making time series data from data which are sent out from said trunk database to said public database;

setup means for recording/managing the time series definition data for making the time series data from the data of said transaction data, which are extracted from said trunk database, in connection with data items by said dictionary;

operations support means for extracting said master data and said transaction data from said trunk database on the basis of setting of said setup means to generate a public database, and for making time series data from the data which are extracted from said trunk database, by monitoring statuses of said public database and changing data environments and by referring to said time series definition data; and

inquiry means for processing said time series data with reference to said time series definition data and 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 inquiry means includes format setting means for fetching the final data by determining the corresponding time series data with reference to said time series definition data in response to the instruction of said data items and their output format by the user.

3. A system according to claim 2, wherein said inquiry means is means in which an output format instructed by the user includes an output format relating to time, and for handling said output format relating to the time as a management point corresponding to the references of managements and evaluations for the data exploitations.

4. A system according to claim 2, wherein said format setting means includes time series edition means for time-series editing said corresponding time series data if unedited.

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

6. A database data exploitation support apparatus comprising:

setup means for storing time series definition data for regulating grouping type to make times series data from transaction data to be stored in the trunk database of a trunk system, in a dictionary in a manner to correspond to data items of said transaction data and master data to be stored in the trunk database of said trunk system, to record/manage said time series definition data;

operations support means for extracting said master data and said transaction data from said trunk database on the basis of setting of said setup means to generate public database, and for making time series data from the data which are extracted from said trunk database, by monitoring the status of said public database and changing data environments and by referring to said time series definition data; and

inquiry means for processing said time series data with reference to said time series definition data and 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.

7. An apparatus according to claim 6, wherein said inquiry means includes format setting means for fetching the final data by determining the corresponding time series data with reference to said time series definition data in response to the instruction of said data items and their output format by the user.

8. An apparatus according to claim 7, wherein said inquiry means is means in which an output format instructed by the user includes an output format relating to time, and for handling said output format relating to time as a management point corresponding to the references of managements and evaluations for the data exploitations.

9. An apparatus according to claim 7, wherein said format setting means includes time series edition means for time-series editing said corresponding time series data if unedited.

10. An apparatus according to claim 7, wherein said inquiry means further includes vertical-horizontal transformation means for vertically-horizontally transforming the time series data on the basis of the layout instruction of the data item by the user.