Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2000-02-08
2001-04-10
Homere, Jean R. (Department: 2771)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C709S203000, C709S211000, C709S219000, C709S220000
Reexamination Certificate
active
06216124
ABSTRACT:
BACKGROUND OF THE INVENTION
1. Field of the Invention
The present invention relates to a database system and, more particularly, to a database system for effectively performing the setup, exploitation and operations management of database data, and to a database data exploitation support apparatus for effecting the setup, exploitation and operations management of the database data by supporting the exploitations of the database data.
2. Description of the Related Art
In the database system, the data to be utilized for exploiting the data in the various branches of business can be coarsely divided into the data to be managed and stored in a trunk business system for production and sales managements, the data intrinsic to branches, as occur in the individual branches, and the data such as the market data, as occur at the outside.
The data to be managed/stored in the trunk business system are exemplified by the master data such as the product master or the customer master, and the transaction data for recording the daily transactions and these data are exploited by their combinations while assuring their time consistency.
At the data exploiting time, the types of data to be finally fetched are frequently used by accumulating the values of the data items of the master data of commodities, customers and shops. In this case, the objects to be accumulated such as the data items or the sorting references have to be specifically instructed in addition to the arrangement of the data items from a terminal screen. Therefore, the data exploiter is required to understand the functions and operating methods of the software for supporting the data exploitations and to be conscious of the correspondence between the values of the data items opened in the database and the sorting method intended by the data exploiter. Moreover, the sales of new commodities and the stop of commodity sales may change the references for regulating the sorting method. Therefore, the system for recording/managing the sorting references independently of the master data finds it difficult to follow the change in the master data and is liable to have an inconsistency or mismatch of the data so that it cannot avoid a danger of fetching the erroneous data.
In the prior art, there has been realized a technique for managing the data items of the database by making a dictionary corresponding to the database. However, the dictionary is provided for the individual objects in the forms such as a data storing medium for managing the names and types of data items for establishing the productivity of a program for the database in a manner to correspond to the program, a medium for storing the data of the meaning and use of the data items for the data exploiter, or a medium for storing the definition data for fetching the multidimensional database data while aiming at facilitating the data exploitations.
The dictionary of the prior art does not perform the data managements of the entire system, as centered by the data setup, the data exploitation and the data operations managements, so that it cannot drastically solve the operability and reliability of the data exploiter.
SUMMARY OF THE INVENTION
An object of the present invention is to provide a database system and a database data exploitation support apparatus, which are enabled to drastically improve the reliability of database data and the productivity of data exploitations by managing in a corresponding manner the stored data of a public database made of the data extracted and processed from original data and their attribute data thereby to realize the data management and exploitation system based upon the attribute data.
In the database system according to the present invention: the data read out from an original database and the data processed from the read-out data are stored in a public database; the stored data of the public database and their attribute data are managed in a corresponding manner by a data management unit; and data are processed/displayed by an inquiry unit in accordance with a demand of a user and on the basis of the data stored in the public database and the attribute data.
Specifically, according to a first aspect of the present invention, there is provided a first database system comprising:
an original database;
a public database for storing the data read out from said original database and the data processed from the read-out data;
a data management unit for managing the data stored in said public database and the attribute data of the stored data in a corresponding manner; and
an inquiry unit for processing and displaying data on the basis of the data stored in said public database and said attribute data in accordance with a demand of a user.
According to a second aspect of the present invention, there is provided a second database system comprising:
a database for storing data containing master data and transaction data;
a dictionary for storing the management point data corresponding to the data items of at least one of the master data of the transaction data of said database, and the data containing definition data for the references of managements and evaluations;
a setup unit for recording/managing the management points corresponding to the references of managements and evaluations for data exploitations in connection with said data items by said dictionary;
an operations support unit for monitoring the statuses of the master data and the transaction data of said database and for changing the data environments; and
an inquiry unit for processing/outputting the data of said database, which have been processed by said setup unit and said operations support unit, on the basis of said management points in accordance with a demand of a user.
According to a third aspect of the present invention, there is provided a first database data exploitation support apparatus comprising:
a setup unit for storing the management points corresponding to references of managements and evaluations for data exploitations, as the data containing management point data and definition data for the references of the managements and evaluations, in a dictionary in a manner to correspond to the data items stored in a database containing master data and transaction data, to record/manage said management points;
an operations support unit for monitoring the statuses of the master data and the transaction data of said database and for changing the data environments; and
an inquiry unit for processing/outputting the data of said database, which have been processed by said setup unit and said operations support unit, on the basis of said management points in accordance with a demand of a user.
According to a fourth aspect of the present invention, there is provided a third database system comprising:
a trunk database for storing the master data and the 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 the data containing time series definition data to regulating a grouping type for making time series data from the data which are sent out from said trunk database to said public database;
a setup unit 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;
an operations support unit for extracting said master data and said transaction data from said trunk database on the basis of the setting of said setup unit to generate a public database, and for making time series data from the data which are extracted from said trunk database, by monitoring the statuses of said public database and changing the data environments and by referring to said time series definition data; and
an inquiry unit 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 unit an
Arai Shoichi
Shimizu Hajime
Takekawa Kazuhiro
Tanaka Tsutomu
Terauchi Yuji
Fujitsu Limited
Homere Jean R.
Staas & Halsey , LLP
LandOfFree
Database system with original and public databases and data... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Database system with original and public databases and data..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Database system with original and public databases and data... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2524923