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

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

What is claimed is:

1. A database system, comprising:

a database to store data containing master data and transaction data;

a dictionary to store management point data corresponding to data items of at least one of the master data and the transaction data of said database, the management point data containing definition data for references of managements and evaluations;

a setup unit to record in said dictionary as to the management point data, management points corresponding to the references of managements and evaluations for data exploitations in connection with the data items;

an operations support unit to monitor statuses of the master data and the transaction data of said database and for changing data environments; and

an inquiry unit to output processed data of said database, used by said setup unit and said operations support unit, based on the management points in accordance with an instruction of a user.

2. A database system according to claim 1,

wherein said database includes a trunk database of a trunk system, and a public database having data extracted from said trunk database and subjected to a predetermined processing for a data system, and

wherein said setup unit includes

a point management unit record the management points corresponding to the data items as at least one of the master data and the transaction data of said trunk database are extracted into said public database, and

a point setting unit, operative in association with said point management unit, to present extracted data from said trunk database to the user while discriminating the master data and the transaction data, and to set the management points as the data items in the extracted data in response to the instruction of the user.

3. A database system according to claim 1, wherein said inquiry unit includes a format setting unit to set a final output format by determining data processing content with reference to the management points in response to the instruction of the user selecting data items to be output as the processed data.

4. A database system according to claim 1, wherein said dictionary includes a common dictionary to store data common in said system, and a user dictionary to store data containing a sorting method for each user.

5. A database system according to claim 1, wherein said dictionary includes a common dictionary to store data common in said system, and an object dictionary to store data containing a sorting method for each object.

6. A database system, comprising:

a database to store data containing master data and transaction data;

a dictionary to store management point data corresponding to data items of at least one of the master data and the transaction data of said database, the management point data containing definition data for references of managements and evaluations;

a setup unit to record in said dictionary as the management point data, management points corresponding to the references of managements and evaluations for data exploitations in connection with the data items;

an operations support unit to monitor statuses of the master data and the transaction data of said database and for changing data environments; and

an inquiry unit to output processed data of said database, used by said setup unit and said operations support unit, based on the management points in accordance with an instruction of a user, said inquiry unit including a format setting unit to set a final output format by determining data processing content with reference to the management points in response to the instruction of the user selecting data items to be output as the processed data, and said format setting unit including a dialog setting unit to determine the final output format through dialog operations with the user if the final output format cannot be uniquely determined.

7. A database data exploitation support apparatus, comprising:

a setup unit to store management points corresponding to references of managements and evaluations for data exploitations, as data containing management point data and definition data for the references of the managements and evaluations, in a dictionary in correspondence to data items stored in a database containing master data and transaction data, and to manage the management points;

an operations support unit to monitor statuses of the master data and the transaction data of said database and to change data environments; and

an inquiry unit to output selected data items from the master data and the transaction data of said database, which have been processed by said setup unit and said operations support unit, based on said management points in accordance with an instruction of a user.

8. A database data exploitation support apparatus according to claim 7,

wherein said database includes a trunk database of a trunk system, and a public database having data extracted from said trunk database and subjected to a predetermined processing for a data system, and

wherein said setup unit includes

a point management unit to record said management points in a manner corresponding to the data items as at least one of the master data and the transaction data of said trunk database are extracted into said public database, and

a point setting unit, operative in association with said point management unit, to present extracted data from said trunk database to the user while discriminating the master data and the transaction data, and to set the management points as the data items in the extracted data in response to the instruction of the user.

9. A database data exploitation support apparatus according to claim 7, wherein said inquiry unit includes a format setting unit to set a final output format by determining data processing content with reference to said management points in response to the instruction of the user identifying the selected data items to be output.

10. A database data exploitation support apparatus according to claim 7, wherein said dictionary includes a common dictionary to store data common in said system, and a user dictionary to store data containing a sorting method for each user.

11. A database data exploitation support apparatus according to claim 7, wherein said dictionary includes a common dictionary to store data common in said system, and an object dictionary to store data containing a sorting method for each object.

12. A database data exploitation support apparatus according to claim 7, wherein said operations support unit includes a re-definition unit, associated with an updating operation of said database, to examine whether a management point is attached to a data item, to present a setting, if any, of the management point to the user through a terminal unit, and to transform the definition data of said management point in response to confirming and changing operations of the user, into new definition data based upon updated database data.

13. A database data exploitation support apparatus, comprising:

a setup unit to store management points corresponding to references of managements and evaluations for data exploitations, as data containing management point data and definition data for the references of the managements and evaluations, in a dictionary in a manner corresponding to data items stored in a database containing master data and transaction data, and to manage said management points;

an operations support unit to monitor statuses of the master data and the transaction data of said database and to change data environments; and

an inquiry unit to output selected data items from the master data and the transaction data of said database which have been processed by said setup unit and said operations support unit, based on said management points in accordance with an instruction of a user, said inquiry unit including a format setting unit to set a final output format by determining data processing content with reference to the management points in response to the instruction of the user identifying the selected data items to be output, and said format setting unit includes a dialog setting unit to determine the final output format through dialog operations with the user if output format cannot be uniquely determined.

14. A database system, comprising:

a trunk database to store 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 to store management point data corresponding to database data of said public database, definition data for references of managements and evaluations, and statistic data of corresponding data items;

a setup unit to record in said dictionary as the management point data, management points corresponding to the references of managements and evaluations for data exploitations, together with the definition data and the statistic data corresponding to the data items of the database data of said public database;

an operations support unit to extract the master data and the transaction data from said trunk database to generate said public database, and to monitor status of said public database and changing data environments; and

an inquiry unit to graph the data of said public database, which have been processed by said setup unit and said operations support unit, with reference to the management points by using the management points as at least one axis, to present the graph to a user and to output resulting data in accordance with an inquiry condition determined by the user based on graphed data.

15. A database system, comprising:

a trunk database to store 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 to store management point data corresponding to database data of said public database, definition data for references of managements and evaluations, and statistical data of corresponding data items;

a setup unit to record in said dictionary as the management point data, management points corresponding to the references of managements and evaluations for data exploitations, together with the definition data and the statistic data corresponding to the data items of the database data of said public database, said setup unit including

a segment definition data setting unit to set segment definition data as a data item corresponding to one of the management points;

a graph unit to tentatively graph the data item based on the segment definition data, to present a graph to a user; and

a segment definition adding unit to add to the statistical data the segment definition data, which are finally set by performing a desired number of times setting and graphing of the segment definition data by said definition data setting unit and said graph unit;

an operations support unit to extract the master data and the transaction data from said trunk database to generate the public database, and to monitor status of said public database and changing data environments; and

an inquiry unit to graph the data of said public database, which have been processed by said setup unit and said operations support unit, with reference to the management points by using the management points as at least one axis, to present the graph to the user and to output resulting data in accordance with an inquiry condition determined by the user based on graphed data.

16. A database system according to claim 15,

wherein said setup unit adds the graph data generated by said graph unit, to the statistical data and stores a result in said dictionary, and

wherein said inquiry unit uses the graph data for graphing.

17. A database data exploitation support apparatus, comprising:

a setup unit to store management points corresponding to references of managements and evaluations for data exploitations, as management point data, definition data for the reference of managements and evaluations, and statistic data of corresponding data items, in a dictionary in correspondence to data items of database data of a public database;

an operations support unit to extract master data and transaction data from a trunk database of a trunk system to generate the public database based on the data set by said setup unit, and to monitor status of the public database and changing data environments; and

an inquiry unit to graph the data items of the public database, which have been processed by said setup unit and said operations support unit, with reference to the management points by using the management points as at least one axis, to present the graph to a user and to output resulting data in accordance with an inquiry condition determined by the user based on graphed data.

18. A database data exploitation support apparatus, comprising:

a setup unit to store management points corresponding to references of managements and evaluations for data exploitations, as management point data, definition data for the reference of managements and evaluations, and statistical data of corresponding data items, in a dictionary in correspondence to data items of database data of a public database, said setup unit including

a segment definition data setting unit to set segment definition data as a data item corresponding to one of the management points;

a graph unit to tentatively graph the data item based on the segment definition data, to present a graph to a user; and

a segment definition adding unit to add to the statistical data the segment definition data, which are finally set by performing a desired number of times setting and graphing of the segment definition data by said definition data setting unit and said graph unit;

an operations support unit to extract master data and transaction data from a trunk database of a trunk system to generate the public database based on the data set by said setup unit, and to monitor status of the public database and changing data environments; and

an inquiry unit to graph the data items of the public database, which have been processed by said setup unit and said operations support unit, with reference to the management points by using the management points as at least one axis, to present the graph to the user and to output resulting data in accordance with an inquiry condition determined by the user based on graphed data.

19. A database data exploitation support apparatus according to claim 18,

wherein said setup unit adds the graph data generated by said graph unit, to the statistical data and stores a result in said dictionary, and

wherein said inquiry unit uses the graph data for said graphing.

20. A database system, comprising:

a trunk database to store 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 to store management point data corresponding to database data of said public database and definition data for references of managements and evaluations;

a setup unit to record in said dictionary as the management point data, management points corresponding to the references of managements and evaluations for data exploitations corresponding to the data items of the database data of said public database;

an inquiry unit to subject the database data of said public database to a predetermined processing in accordance with a demand of a user and with reference to said management points to output resulting data and to collect claim data indicating a claim to a disadvantage from the user; and

an operations support unit to extract the master data and the transaction data from said trunk database to generate said public database, and to monitor status of said public database and changing data environments and to prepare the database data based upon.

21. A database system according to claim 20, wherein said inquiry unit includes:

a claim memo input unit for the user to input a claim memo indicating contents of the claim; and

a claim data storage unit to store operation data of the user, when the claim occurs, and claim data containing the claim memo.

22. A database system according to claim 21,

wherein said operations support unit includes a claim notification unit to notify the manager of newly stored claim data by monitoring the claim data stored by said claim data storage unit, and

wherein said setup unit further includes a re-definition unit to re-define the data to be stored in said dictionary, in accordance with the operations of the manager as based upon notification of the claim data.

23. A database data exploitation support apparatus, comprising:

a setup unit to store management points corresponding to references of managements and evaluations for data exploitations, as management point data and definition data for the references of the managements and evaluations, in a dictionary in correspondence to data items of database data of a public database, and to manage the management points;

an inquiry unit to subject the data of the public database to a predetermined processing in accordance with a demand of a user and with reference to the management points to to output resulting data and to collect claim data indicating a claim to a disadvantage from the user; and

an operations support unit to extract the master data and the transaction data from a trunk database to generate the public database, and to monitor status of said public database and changing data environments and to prepare the database data based upon a notice of the claim to a manager and operations of the manager based on the claim data.

24. A database data exploitation support apparatus according to claim 23, wherein said inquiry unit includes:

a claim memo input unit for the user to input a claim memo indicating contents of the claim; and

a claim data storage unit to store operation data of the user, when the claim occurs, and claim data containing the claim memo.

25. A database data exploitation support apparatus according to claim 24,

wherein said operations support unit includes a claim notification unit to notify the manager of newly stored claim data by monitoring the claim data stored by said claim data storage unit, and

wherein said setup unit further includes a re-definition unit to re-define the data to be stored in said dictionary, in accordance with the operations of the manager as based upon notification of the claim data.

26. A database system, comprising:

a trunk database to store 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 to store secondary table definition data defining a job for generating a processed secondary table, in said public database in correspondence to database data;

a setup unit to record in said dictionary data items of the database data of said public database and management points corresponding to references of managements and evaluations for data exploitations, in a corresponding manner and the secondary table definition data;

an inquiry unit to fetch data of a final type, which have been subjected to a predetermined processing, in accordance with a demand of a user and to acquire an operation log indicating an operation history of the user; and

an operations support unit to extract the master data and the transaction data from said trunk database to generate the public database, to monitor status of said public database and changing data environments, and to arrange a processed secondary table on said public database based on the operation log and with reference to secondary table definition data of said dictionary.

27. A system according to claim 26, wherein said operations support unit includes:

a range setting unit to specify a range for a secondary table based on the operation log on a screen of a terminal unit by displaying the operation log on the screen; and

a secondary table generating unit to generate a secondary table corresponding to content of the range of the operation log, as specified by said range setting unit.

28. A system according to claim 26, wherein said inquiry unit includes a processing transformation unit to transform processing of said operations support unit into processing corresponding to a secondary table, if any, by referring secondary table definition data of said dictionary in accordance with the demand of the user.

29. A database data exploitation support apparatus, comprising:

a setup unit to store secondary table definition data defining management points corresponding to references of managements and evaluations for data exploitations and jobs for generating a secondary table processed in a public database, as data containing management point data, definition data for references of managements and evaluations, and the secondary table definition data, by a dictionary in correspondence to data items of database data stored in the public database;

an inquiry unit to fetch data of a final type, which have been subjected to a predetermineed processing, in accordance with a demand of a user and with reference to the dictionary and to acquire an operation log indicating an operation history of a user; and

an operations support unit to exact master data and transaction data from a trunk database of a trunk system to generate the public database, to monitor status of the public database and changing data environmental, and arrange the secondary table on the public database based on the operation log and with reference to the secondary table definition data of the dictionary.

30. A database data exploitation support apparatus according to claim 29, wherein said operations support it includes:

a range setting unit to specify a range for the secondary table on the operation log on a screen of a terminal unit by displaying the operation log on the screen; and

a secondary table generating unit to generate the secondary table corresponding to contents of the range of the operation log, as specified by said range setting unit.

31. An apparatus according to claim 29, wherein said inquiry unit includes a processing transformation unit to transform processing of said operations support unit into the processing corresponding to the secondary table, if any, by referring to the secondary table definition data of the dictionary in accordance with the demand of the user.

32. A database systems, comprising:

a trunk database to store master data and transaction data of a trunk system;

a public database extracted from said trunk database and having been subjected to a predetermined processing for a data system;

a dictionary to store data containing any of calendar data intrinsic to a branch and a business and common to said database system, in correspondence to database data of at least one of said trunk database and said public database;

a setup unit to record the calendar data in said dictionary in correspondence to the database data;

an inquiry unit to fetch data of a final type, which have been subjected to a predetermined processing, in accordance with a demand of a user and based on the calendar data stored in said dictionary; and

an operations support unit to extract the master data and the transaction data from said trunk database to generate said public database and to monitor status of said public database and changing data environments.

33. A database system according to claim 32,

wherein said setup unit includes a formula definition unit to store in said dictionary definition data defining an operation/processing formula using a calendar for a desired data item, and

wherein said inquiry unit includes a calculation processing unit to execute calculation processings according to the operation/processing formula, when said inquiry unit refers to the desired data item for the operation/processing formula defined in said dictionary, based on the definition data of said dictionary.

34. A database data exploitation support apparatus, comprising:

a setup unit for recording/managing data containing at least any of calendar data intrinsic to a branch and a business and common to both, as corresponds to database data of at least one of a trunk database and a public database, in a manner to correspond to said database data by a dictionary for storing data containing said calendar data;

an inquiry unit for fetching the data of final type, which have been subjected to a predetermined processing, in accordance with a demand of a user and on the basis of the calendar data stored in said dictionary; and

an operations support unit for extracting said master and said transaction data from said trunk database to generate said public database and for monitoring stats of said public database and data environments.

35. A database data exploitation support apparatus according to claim 34,

wherein said setup unit includes a formula definition unit to store in said dictionary definition data defining an operation/processing formula using a calendar for a desired data item, and

wherein said inquiry unit includes a calculation processing unit to execute calculation processings according to the operation/processing formula, when said inquiry unit refers to the desired data item for the operation/processing formula defined in said dictionary, based on the definition data of said dictionary.

36. A database system, comprising:

a trunk database to store master data and transaction data of a trunk system;

a public database extracted from said trunk database and having been subjected to a predetermined processing for a data system;

a dictionary to store data containing the unit data as the attributes of the data items of database data of at least one of said trunk database and said public database;

a setup unit to store unit data in said dictionary in correspondence to data items of the database data;

an inquiry unit to fetch data of a final type, which have been subjected to a predetermined processing, in accordance with a demand of a user and to generate the data of the final type of the data items by calculating a unit based upon the unit data, with reference to the unit data stored in said dictionary; and

an operations support unit to extract the master data and the transaction data from said trunk database to generate said public database and to monitor status of said public database and changing data environments.

37. A database system according to claim 36,

wherein said dictionary stores the data containing operation rules and the unit data of the data items generated,

wherein said setup unit includes a rule management unit to record the operation rules and the unit data of the data items in said dictionary, and

wherein said inquiry unit includes a calculation processing unit to perform calculation processings according to arithmetic rules, if defined, when the data of the data items are to be fetched.

38. A database system according to claim 36,

wherein said dictionary stores data containing operation rules for achieving a plurality of unit data and units for one data item,

wherein said setup unit includes a rule management unit to record the operation rules and the unit data in said dictionary, and

wherein said inquiry unit includes a calculation processing unit to perform the calculation processings according to arithmetic rules, if defined, when the data of the data items generated by said operations/processings are to be fetched.

39. A database system, comprising:

a trunk database to store master data and transaction data of a trunk system;

a public database extracted from said trunk database and having been subjected to a predetermined processing for a data system;

a dictionary to store data containing operation rules and the unit data as the attributes of the data items of database data of at least one of said trunk database and said public database;

a setup unit to store unit data in said dictionary in correspondence to data items of the database data, said setup unit including a rule management unit to record the operation rules and the unit data of the data items in said dictionary;

an inquiry unit to fetch data of a final type, which have been subjected to a predetermined processing, in accordance with a demand of a user and to generate the data of the final type of the data items by calculating a unit based upon the unit data, with reference to the unit data stored in said dictionary; said inquiry unit including

a calculation processing unit to perform calculation processing according to arithmetic rules, if defined, when the data of the data items are to be fetched, and

a unit processing unit to create an arithmetic formula to make identical units of data items to be calculated, based on the unit data of said dictionary if the data item having the units defined is selected to be operated, in case the user designates at least one of a desired unit and an arithmetic formula undefined in said dictionary, and

an operations support unit to extract the master data and the transaction data from said trunk database to generate said public database and to monitor status of said public database and changing data environments.

40. A database data exploitation support apparatus, comprising:

a setup unit to record data containing unit data as attributes of data items of at least one of a trunk database of a trunk system and a public database, which is extracted from the trunk database, by a dictionary in correspondence to the data items;

an inquiry unit to fetch data of a final type, which have been subjected to a predetermined processing, in accordance with a demand of a user and to generate the data of the final type of the data items by referring to the unit data stored in the dictionary and by calculating the unit based upon the unit data; and

an operations support unit to extract master data and transaction data from the trunk database to generate the public database and to monitor status of the public database and changing data environments.

41. A database data exploitation support apparatus according to claim 40,

wherein the dictionary stores the data containing the operation rules and unit data of the data items generated by the operations/processings,

wherein said setup unit includes a rule management unit to record the operation rules and the unit data of the data items in the dictionary, and

wherein said inquiry unit includes a calculation processing unit to perform the calculation processings according to the arithmetic rules, if defined, when the data of the data items generated are to be fetched.

42. A database data exploitation support apparatus according to claim 40,

wherein said dictionary stores the data containing operation rules for achieving a plurality of unit data and units for one data item,

wherein said setup unit includes a rule management unit to record the unit data and the operation rules in the dictionary, and

wherein said inquiry unit includes a calculation processing unit to perform the calculation processings according to arithmetic rules, if defined, when the data of the data items generated by the operations/processings are to be fetched.

43. A database data exploitation support apparatus, comprising:

a setup unit to record data containing unit data as attributes of data items of at least one of a trunk database of a trunk system and a public database, which is extracted from the trunk database, in a dictionary in correspondence to the data items, the dictionary storing operation rules and unit data of the data items, said setup unit including a rule management unit to record the operation rules and the unit data of the data items in the dictionary;

an inquiry unit to fetch data of a final type, which have been subjected to a predetermined processing, in accordance with a demand of a user and to generate the data of the final type of the data items by referring to the unit data stored in the dictionary and by calculating the unit based upon the unit data, said inquiry unit including

a calculation processing unit to perform the calculation processings according to the arithmetic rules, if defined, when the data of the data items generated are to be fetched, and

a unit processing unit to create an arithmetic formula to make identical the units of data items to be calculated, based on the unit data of the dictionary if the data item having its unit defined is selected to be operated, in case the user designates at least one of a desired unit and the arithmetic formula undefined in said dictionary; and

an operations support unit to extract master data and transaction data from the trunk database to generate the public database and to monitor status of the public database and changing data environments.

44. A database system comprising:

a trunk database to store master data and transaction data of a trunk system;

a public database extracted from said trunk database and having been subjected to a predetermined processing for a data system;

a dictionary to store management point data corresponding to at least one of said trunk database and said public database, and definition data for references of managements and evaluations;

a setup unit to record in said dictionary the management point data corresponding to the references of managements and the evaluations for data exploitations in correspondence to data items of database data;

an inquiry unit to fetch data of a final type, which have been subjected to a predetermined processing, as a layout based upon said management points in accordance with a demand of a user; and

an operations support unit to extract the master data and the transaction data from said trunk database to generate said public database and to monitor status of said public database and changing data environments.

45. A database system according to claim 44, wherein said setup unit includes a segment definition unit to define segment data containing a method of using the data directly and a method of adding a meaning, as a segment method of a management point.

46. A database system according to claim 44, wherein said inquiry unit includes a layout determination unit to determine a fetching format by adhering a selected management point to a worksheet for determining the fetching format of the database data, dialogically by the user through a display screen of a terminal unit.

47. A database system, comprising:

a trunk database to store master data and transaction data of a trunk system;

a public database extracted from said trunk database and having been subjected to a predetermined processing for a data system;

a dictionary to store management point data corresponding to at least one of said trunk database and said public database, and definition data for references of managements and evaluations, said dictionary storing data for hierarchizing and defining a segment method of the management point data;

a setup unit to record in said dictionary the management point data corresponding to the references of managements and the evaluations for data exploitations in correspondence to data items of said database data, said setup unit recording the data for hierarchizing and defining the segment method of the management point data, in correspondence to the management point data;

an inquiry unit to fetch data of a final type, which have been subjected to a predetermined processing, as a layout based upon said management points in accordance with a demand of a user; and

an operations support unit to extract the master data and the transaction data from said trunk database to generate said public database and to monitor status of said public database and changing data environments, said inquiry unit laying out and fetching the data of the final type, which have been processed by said setup unit and said operations support unit, in accordance with the segment method of the management point data in accordance with the demand of the user and with reference to the management point data.

48. A database data exploitation support apparatus, comprising:

a dictionary to store management point data containing management points corresponding to at least one of a trunk database and a public database, and definition data for references of managements and evaluations;

a setup unit to record in said dictionary management point data corresponding to database data of at least one of the trunk database and the public database, and definition data for the references of managements and evaluations, with the management points and the definition data, in a manner to correspond to data items of the database data;

an inquiry unit to fetch data of a final type, which have been subjected to a predetermined processing, as a layout based upon the management points in accordance with a demand of a user; and

an operations support unit to extract the master data and the transaction data from the trunk database to generate said public database and monitor status of the public database and changing data environments.

49. A database data exploitation support apparatus, comprising:

a dictionary to store management point data containing management points corresponding to at least one of a trunk database and a public database, and definition data for references of managements and evaluations, said dictionary storing data for hierarchizing and defining a segment method of the management points;

a setup unit to record in said dictionary management point data corresponding to database data of at least one of the trunk database and the public database, and definition data for the references of managements and evaluations, with the management points and the definition data, in a manner to correspond to data items of the database data, said setup unit recording the data for hierarchizing and defining the segment method of the management points, in correspondence to the management point data;

an inquiry unit to fetch data of a final type, which have been subjected to a predetermined processing, as a layout based upon the management points in accordance with a demand of a user; and

an operations support unit to extract the master data and the transaction data from the trunk database to generate said public database and monitor status of the public database and changing data environments, said inquiry unit laying out and fetching the data of the final type, which have been processed by said setup unit and said operations support unit, in accordance with the segment method of the management point in accordance with the demand of the user and with reference to the management point.

50. A database data exploitation support apparatus according to claim 48, wherein said setup unit includes a segment definition unit to define segment data containing a method of using the data directly and a method of adding a meaning, as a segment method of a management point.

51. A database data exploitation support apparatus according to claim 48, wherein said inquiry unit includes a layout determination unit to determine a fetching format by adhering a selected management point to a worksheet for determining the fetching format of the database data, dialogically by the user through a display screen of a terminal unit.

Description

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 and said operations support unit, in accordance with a demand of a user.

According to a fifth aspect of the present invention, there is provided a second database data exploitation support apparatus comprising:

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

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 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 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 and said operations support unit, in accordance with a demand of a user.

According to a sixth aspect of the present invention, there is provided a fourth 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 consistency definition data for defining data setup jobs for assuring the consistency of the database data of at least one of said trunk database and said public database and the restricting conditions for executing said data setup jobs;

a setup unit 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;

an operations support unit 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 the statuses of said public database and changing the data environments and by referring to said consistency definition data of said dictionary; and

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

According a seventh aspect of the present invention, there is provided a third database data exploitation support apparatus comprising:

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

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

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

According to an eighth aspect of the present invention, there is provided a fifth 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 the management point data corresponding to the database data of said public database, the definition data for references of managements and evaluations, and the statistic data of the corresponding data items;

a setup unit for recording/managing the management points corresponding to the references of the managements and the evaluations for data exploitations, together with said definition data and said statistic data by said dictionary in a manner to correspond to the data items of the database data of said public database;

an operations support unit for extracting said master data and said transaction data from said trunk database to generate a public database, and for monitoring the status of said public database and changing the data environments; and

an inquiry unit for graphing the data of said public database, which have been processed by said setup unit and said operations support unit, with reference to said management points by using said management points as at least one axis, to present the graph to a user and for processing/outputting said data in accordance with the inquiry condition which has been determined by the user on the basis of the graphed data.

According to a ninth aspect of the present invention, there is provided a fourth database data exploitation support apparatus comprising:

a setup unit for storing the management points corresponding to the references of managements and evaluations for data exploitations, as the data containing said management point data, the definition data for the reference of the managements and evaluations, and the statistic data of the corresponding data items, in a dictionary in a manner to correspond to the data items of the database data of a public database, to record/manage said management points;

an operations support unit for extracting master data and transaction data from the trunk database of a trunk system to generate said public database on the basis of the setting of said setup unit, and for monitoring the status of said public database and changing the data environments; and

an inquiry unit for graphing the data of said public database, which have been processed by said setup unit and said operations support unit, with reference to said management points by using said management points as at least one axis, to present the graph to a user and for processing/outputting said data in accordance with the inquiry condition which has been determined by the user on the basis of the graphed data.

According to a tenth aspect of the present invention, there is provided a sixth 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 the management point data corresponding to the database data of said public database and the definition data for references of managements and evaluations;

a setup unit for recording/managing the management points corresponding to the references of the managements and the evaluations for data exploitations by said dictionary in a manner to correspond to the data items of the database data of said public database;

an inquiry unit for subjecting the data of said public database to a predetermined processing in accordance with a demand of a user and with reference to said management points to process/output the same and for collecting claim data indicating a claim to a disadvantage from the user; and

an operations support unit for extracting said master data and said transaction data from said trunk database to generate a public database, and for monitoring the status of said public database and changing the data environments and for preparing the database data based upon the notice of said claim to a manager and the operations of said manager on the basis of said collected claim data.

According to an eleventh aspect of the present invention, there is provided a fifth database data exploitation support apparatus comprising:

a setup unit for storing the management points corresponding to the references of managements and evaluations for data exploitations, as the data containing said management point data and the definition data for the reference of the managements and evaluations, in a dictionary in a manner to correspond to the data items of the database data of a public database, to record/manage said management points;

an inquiry unit for subjecting the data of said public database to a predetermined processing in accordance with a demand of a user and with reference to said management points to process/output the same and for collecting claim data indicating a claim to a disadvantage from the user; and

an operations support unit for extracting said master data and said transaction data from a trunk database to generate said public database, and for monitoring the status of said public database and changing the data environments and for preparing the database data based upon the notice of said claim to a manager and the operations of said manager on the basis of said collected claim data.

According to a twelfth embodiment of the present invention, there is provided a seventh 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 secondary table definition data for defining a job for generating a processed secondary table, in said public database in a manner to correspond to database data;

a setup unit for recording/managing the data items of the database data of said public database and the management points corresponding to references of managements and evaluations for data exploitations, by said dictionary in a corresponding manner and for recording/managing said secondary table definition data by said dictionary;

an inquiry unit for fetching the data of the final type, which have been subjected to a predetermined processing, in accordance with a demand of a user and for acquiring an operation log indicating the operation history of the user; and

an operations support unit for extracting said master data and said transaction data from said trunk database to generate a public database, for monitoring the status of said public database and changing the data environments, and for making/arranging the processed secondary table on said public database on the basis of said operation log and with reference to the secondary table definition data of said dictionary.

According to a thirteenth embodiment of the present invention, there is provided a sixth database data exploitation support apparatus comprising:

a setup unit for storing and recording/managing the secondary table data definition data for defining the management points corresponding references of managements and evaluations for data exploitations and the jobs for generating a secondary table processed in a public database, as the data containing said management point data, the definition data for the references of the managements and evaluations, and said secondary table definition data, by a dictionary in a manner to correspond to the data items of the database data stored in said public database;

an inquiry unit for fetching the data of the final type, which have been subjected to a predetermined processing, in accordance with a demand of a user and with reference to said dictionary and for acquiring an operation log indicating the operation history of the user; and

an operations support unit for extracting said master data and said transaction data from the trunk database of a trunk system to generate said public database, for monitoring the status of said public database and changing the data environments, and for making/arranging the processed secondary table on said public database on the basis of said operation log and with reference to the secondary table definition data of said dictionary.

According to a fourteenth embodiment of the present invention, there is provided a 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 data base and having been subjected to a predetermined processing for a data system;

a dictionary for storing the data containing at least any of calendar data intrinsic to a branch and a business and common to the entirety, as corresponds to the database data of at least one of said trunk database and said public database;

a setup unit for recording/managing said calendar data by said dictionary in a manner to correspond to said database data;

an inquiry unit for fetching the data of the final type, which have been subjected to a predetermined processing, in accordance with a demand of a user and on the basis of the calendar data stored in said dictionary; and

an operations support unit for extracting said master data and said transaction data from said trunk database to generate said public database and for monitoring the status of said public database and changing the data environments.

According to a fifteenth embodiment of the present invention, there is provided a seventh database data exploitation support apparatus comprising:

a setup unit for recording/managing the data containing at least any of calendar data intrinsic to a branch and a business and common to the entirety, as corresponds to the database data of at least one of a trunk database and a public database, in a manner to correspond to said database data by a dictionary for storing the data containing said calendar data;

an inquiry unit for fetching the data of the final type, which have been subjected to a predetermined processing, in accordance with a demand of a user and on the basis of the calendar data stored in said dictionary; and

an operations support unit for extracting said master data and said transaction data from said trunk database to generate said public database and for monitoring the status of said public database and changing the data environments.

According to a sixteenth embodiment of the present invention, there is provided a ninth 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 having been subjected to a predetermined processing for a data system;

a dictionary for storing the data containing the unit data as the attributes of the data items of the database data of the database data of at least one of said trunk database and said public database;

a setup unit for recording/managing said unit data by said dictionary in a manner to correspond to the data items of said database data;

an inquiry unit for fetching the data of the final type, which have been subjected to a predetermined processing, in accordance with a demand of a user and for generating the data of the final type of said data items by calculating the unit based upon said unit data, with reference to the unit data stored in said dictionary; and

an operations support unit for extracting said master data and said transaction data from said trunk database to generate said public database and for monitoring the status of said public database and changing the data environments.

According to a seventeenth embodiment of the present invention, there is provided an eighth database data exploitation support apparatus comprising:

a setup unit for recording/managing the data containing the unit data as the attributes of the data items of at least one of the trunk database of a trunk system and the public database, which is extracted from said trunk database, by a dictionary in a manner to correspond to said data items;

an inquiry unit for fetching the data of the final type, which have been subjected to a predetermined processing, in accordance with a demand of a user and for generating the data of the final type of said data items by referring to the unit data stored in said dictionary and by calculating the unit based upon said unit data; and

an operations support unit for extracting master data and transaction data from said trunk database to generate said public database and for monitoring the status of said public database and changing the data environments.

According to an eighteenth embodiment of the present invention, there is provided a tenth 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 having been subjected to a predetermined processing for a data system;

a dictionary for storing the data containing the management point data corresponding to at least one of said trunk database and said public database, and the definition data for references of managements and evaluations;

a setup unit for recording/managing the management point data corresponding to the references of the managements and the evaluations for data exploitations, by said dictionary in a manner to correspond to the data items of said database data;

an inquiry unit for fetching the data of the final type, which have been subjected to a predetermined processing, as a layout based upon said management points in accordance with a demand of a user; and

an operations support unit for extracting said master data and said transaction data from said trunk database to generate said public database and for monitoring the status of said public database and changing the data environments.

According to a nineteenth embodiment of the present invention, there is provided a ninth database data exploitation support apparatus comprising:

a dictionary for storing the data containing the management point data corresponding to at least one of said trunk database and said public database, and the definition data for references of managements and evaluations;

a setup unit for recording/managing the management point data corresponding to the database data of at least one of a trunk database and a public database, and definition data for references of the managements and the evaluations, by a dictionary to be stored with said management points and said definition data, in a manner to correspond to the data items of said database data;

an inquiry unit for fetching the data of the final type, which have been subjected to a predetermined processing, as a layout based upon said management points in accordance with a demand of a user; and

an operations support unit for extracting said master data and said transaction data from said trunk database to generate said public database and for monitoring the status of said public database and changing the data environments.

In the database system according to the present invention: the data read out from the original database and the data processed from the read-out data are stored in the public database; the stored data of the public database and their attribute data are managed in a corresponding manner by the data management unit; and data are processed/displayed by the 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.

More specifically, the database system and its data exploitation support apparatus according to the present invention realizes the easy and highly reliable data exploitations by extracting the data items, to which the references for managements and evaluations common in the entire system or intrinsic to the business correspond, as the management point for the attribute data while noting the relations between the master data and the transaction data, and by adding the definition data for the references of the managements and the evaluations.

The data items common in the whole system are exemplified by the data items which are common in the whole company in the aspect of operations/managements such as the productions or sales, and the definition data for the references of the managements and the evaluations are exemplified by the definition data for regulating the bundle of commodities in terms of commodity codes or for regulating the evaluation references of customers in terms of the volume of transactions.

In the database system and its data exploitation support apparatus, moreover, it is processed around a dictionary while realizing the integration of data: to record/manage the management points arbitrarily in relation to the data items in connection with the extractions of the master data and the transaction data; to add new management points by processing the data items of the master data or adding the data; to fetch the data of the proper final type by interpreting the intention of the data exploiter while referring the management points; and to support the smooth operations and the reliability maintenance of the dictionary for recording/managing the data containing the management points associated with the database.

The management points are recorded/managed by the dictionary in relation to the data items composing the master data. For example, the data to be sent out from the trunk business system are separated into the master data and the transaction data. The management points are set while confirming the data items composing the master data in a terminal display. After the data items for setting the management points have been selected, the definitions for regulating the sorting system can be hierarchically in a signifying manner to the values of the data items.

For the data exploitations, on the basis of the minimum instruction of the user, the system can refer to the management points of the dictionary to deduce the accumulating/processing method of the data thereby to determine the final data fetching method. In this case, the minimum instruction of the user is effected by selecting/instructing the necessary item from the list of data items which are displayed in the screen of the terminal unit, for example. The definition data to be added to the management points are so devised that the system can automatically determine the accumulating/processing method or the data layout method. This determination is made depending upon whether or not the data item selected in the terminal screen is defined as the management point or which location the selected data item is allocated to the layout screen of the terminal screen.

According to the database system and its data exploitation support apparatus of the present invention, as described above: the data read out from the original database and the data processed from the read-out data are stored in the public database; the stored data of the public database and their attribute data are managed in a corresponding manner by the data management unit; and data are processed/displayed by the 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. As a result, it is possible to drastically improve the reliability of the database data and the productivity of the database exploitations.

BRIEF DESCRIPTION OF THE DRAWINGS

Other objects and advantages of the invention will become apparent during the following discussion in conjunction with the accompanying drawings, in which:

FIG. 1 is a block diagram showing a basic entire construction of a database system according to an embodiment of the present invention;

FIG. 2 is a block diagram showing the functional construction of a setup unit of the database system according to a first embodiment of the present invention;

FIG. 3 is a block diagram showing the functional construction of an inquiry unit of the database system according to the first embodiment of the present invention;

FIG. 4 is a block diagram showing the functional construction of an operations support unit of the database system according to the first embodiment of the present invention;

FIG. 5 is a diagram showing the display screen of an initial menu of the operations management for explaining the database system of FIGS. 2 to 4;

FIG. 6 is a schematic diagram for explaining the extracted job data recording area of the dictionary of the database system of FIGS. 2 to 4;

FIG. 7 is a diagram showing the extracted job data recording area for explaining the database system of FIGS. 2 to 4;

FIG. 8 is a diagram showing a display screen of an extracted job attribute defining worksheet for explaining the database system of FIGS. 2 to 4;

FIG. 9 is a diagram showing an extracted table selecting screen for explaining the database system of FIGS. 2 to 4;

FIG. 10 is a diagram showing a data item selecting screen for explaining the database system of FIGS. 2 to 4;

FIG. 11 is a schematic diagram for explaining an extracted job of the extracted job data recording area of the database system of FIGS. 2 to 4;

FIG. 12 is a diagram showing an extraction condition table screen for explaining the database system of FIGS. 2 to 4;

FIG. 13 is a diagram showing a display screen of an extraction condition setting worksheet for explaining the database system of FIGS. 2 to 4;

FIG. 14 is a diagram showing an extraction condition table screen for explaining the database system of FIGS. 2 to 4;

FIG. 15 is a schematic diagram for explaining an extracted job in the extracted job recording area of the database system of FIGS. 2 to 4;

FIG. 16 is a schematic diagram for explaining the extracted data recording area and the extracted job recording area of the database system of FIGS. 2 to 4;

FIG. 17 is a diagram showing an extracted job selecting screen for explaining the database system of FIGS. 2 to 4;

FIG. 18 is a diagram showing an extracted job selecting screen for explaining the database system of FIGS. 2 to 4;

FIG. 19 is a diagram showing an extracted job execution confirming screen for explaining the database system of FIGS. 2 to 4;

FIG. 20 is a schematic diagram for explaining a datable management data recording area of the database system of FIGS. 2 to 4;

FIG. 21 is a schematic diagram for explaining a data item recording area and a date item attribute recording area of the database system of FIGS. 2 to 4;

FIG. 22 is a diagram showing an extracted job selecting screen for explaining the database system of FIGS. 2 to 4;

FIG. 23 is a diagram showing a display screen of the initial menu of a setup processing for explaining the database system of FIGS. 2 to 4;

FIG. 24 is a diagram showing a table segment selecting screen for explaining the database system of FIGS. 2 to 4;

FIG. 25 is a diagram showing a table selecting screen for explaining the database system of FIGS. 2 to 4;

FIG. 26 is a diagram showing a data item selecting screen for explaining the database system of FIGS. 2 to 4;

FIG. 27 is a schematic diagram for explaining a data item recording area and a data item attribute recording area of the database system of FIGS. 2 to 4;

FIG. 28 is a diagram showing the display screen of a data item attribute defining worksheet for explaining the database system of FIGS. 2 to 4;

FIG. 29 is a diagram showing the display screen of a data item attribute defining worksheet for explaining the database system of FIGS. 2 to 4;

FIG. 30 is a diagram showing the display screen of a data item attribute defining worksheet for explaining the database system of FIGS. 2 to 4;

FIG. 31 is a diagram showing the display screen of a data item attribute defining worksheet for explaining the database system of FIGS. 2 to 4;

FIG. 32 is a diagram for explaining the data item recording area and the data item attribute recording area of the database system of FIGS. 2 to 4;

FIG. 33 is a diagram showing the display screen of the initial menu of a table defining processing for explaining the database system of FIGS. 2 to 4;

FIG. 34 is a schematic diagram for explaining the table management data recording area of the database system of FIGS. 2 to 4;

FIG. 35 is a diagram showing a table segment selecting screen for explaining the database system of FIGS. 2 to 4;

FIG. 36 is a diagram showing a table selecting screen for explaining the database system of FIGS. 2 to 4;

FIG. 37 is a diagram showing the selecting screen for explaining the database system of FIGS. 2 to 4;

FIG. 38 is a diagram showing a table selecting screen for explaining the database system of FIGS. 2 to 4;

FIG. 39 is a diagram showing a table selecting screen for explaining the database system of FIGS. 2 to 4;

FIG. 40 is a schematic diagram for explaining the table management data recording area of the database system of FIGS. 2 to 4;

FIG. 41 is a diagram showing a table selecting screen for explaining the database system of FIGS. 2 to 4;

FIG. 42 is a schematic diagram for explaining the table management data recording area of the database system of FIGS. 2 to 4;

FIG. 43 is a diagram showing a table segment selecting screen for explaining the database system of FIGS. 2 to 4;

FIG. 44 is a diagram showing a table selecting screen for explaining the database system of FIGS. 2 to 4;

FIG. 45 is a diagram showing a link key item selecting screen for explaining the database system of FIGS. 2 to 4;

FIG. 46 is a diagram showing a display screen of a table link defining worksheet for explaining the database system of FIGS. 2 to 4;

FIG. 47 is a diagram for explaining a linking method in a table link management data table of the database system of FIGS. 2 to 4;

FIG. 48 is a schematic diagram for explaining the table link management data recording area of the database system of FIGS. 2 to 4;

FIG. 49 is a schematic diagram for explaining the table management data recording area of the database system of FIGS. 2 to 4;

FIG. 50 is a schematic diagram for explaining the data item recording area and data item attribute recording area of the database system of FIGS. 2 to 4;

FIG. 51 is a diagram showing a table segment selecting screen for explaining the database system of FIGS. 2 to 4;

FIG. 52 is a diagram showing a table selecting screen for explaining the database system of FIGS. 2 to 4;

FIG. 53 is a schematic diagram for explaining the data item recording area and the data item attribute recording area of the database system of FIGS. 2 to 4;

FIG. 54 is a diagram showing the display screen of an operation/process defining worksheet for explaining the database system of FIGS. 2 to 4;

FIG. 55 is a diagram showing a data item attribute defining worksheet for explaining the database system of FIGS. 2 to 4;

FIG. 56 is a diagram showing the display screen of the operation/process defining worksheet for explaining the database system of FIGS. 2 to 4;

FIG. 57 is a schematic diagram for explaining a data item recording area and a data item attribute recording area of the database system of FIGS. 2 to 4;

FIG. 58 is a schematic diagram for explaining a data item recording area and a data item attribute recording area of the database system of FIGS. 2 to 4;

FIG. 59 is a schematic diagram for explaining a data item grouping definition data recording area of the database system of FIGS. 2 to 4;

FIG. 60 is a diagram showing a representative name selecting screen for explaining the database system of FIGS. 2 to 4;

FIG. 61 is a diagram showing the display screen of the table of grouping data items for explaining the database system of FIGS. 2 to 4;

FIG. 62 is a diagram showing the display screen of a representative name defining worksheet for explaining the database system of FIGS. 2 to 4;

FIG. 63 is a diagram showing the display screen of the table of grouping data items for explaining the database system of FIGS. 2 to 4;

FIG. 64 is a diagram showing a table segment selecting screen for explaining the database system of FIGS. 2 to 4;

FIG. 65 is a diagram showing a table selecting screen for explaining the database system of FIGS. 2 to 4;

FIG. 66 is a diagram showing a data item selecting screen for explaining the database system of FIGS. 2 to 4;

FIG. 67 is a schematic diagram for explaining a sales data item recording area and a data item attribute recording area of the database system of FIGS. 2 to 4;

FIG. 68 is a schematic diagram for explaining a data item grouping definition data recording area of the database system of FIGS. 2 to 4;

FIG. 69 is a diagram showing a representative name selecting screen for explaining the database system of FIGS. 2 to 4;

FIG. 70 is a diagram showing the display screen of the table of grouping data items for explaining the database system of FIGS. 2 to 4;

FIG. 71 is a schematic diagram for explaining a management point recording area of the database system of FIGS. 2 to 4;

FIG. 72 is a diagram showing the display screen of the table of management points for explaining the database system of FIGS. 2 to 4;

FIG. 73 is a diagram showing the display screen of a management point defining worksheet for explaining the database system of FIGS. 2 to 4;

FIG. 74 is a schematic diagram for explaining the management point recording area of the database system of FIGS. 2 to 4;

FIG. 75 is a diagram showing the display screen of the table of management points for explaining the database system of FIGS. 2 to 4;

FIG. 76 is a schematic diagram for explaining the management point recording area and the segment data recording area of the database system of FIGS. 2 to 4;

FIG. 77 is a diagram showing the display screen of the table of segment definitions for explaining the database system of FIGS. 2 to 4;

FIG. 78 is a diagram showing a table segment selecting screen for explaining the database system of FIGS. 2 to 4;

FIG. 79 is a diagram showing a table selecting screen for explaining the database system of FIGS. 2 to 4;

FIG. 80 is a diagram showing a table selecting screen for explaining the database system of FIGS. 2 to 4;

FIG. 81 is a database system showing a confirmation screen of a segment defining method for explaining the database system of FIGS. 2 to 4;

FIG. 82 is a diagram showing the display screen of a segment attribute defining worksheet for explaining the database system of FIGS. 2 to 4;

FIG. 83 is a diagram showing the display screen of a segment attribute defining worksheet for explaining the database system of FIGS. 2 to 4;

FIG. 84 is a diagram showing the confirmation screen for explaining the database system of FIGS. 2 to 4;

FIG. 85 is a schematic diagram for explaining the management point recording area, the segment data recording area and the segment specification recording area of the database system of FIGS. 2 to 4;

FIG. 86 is a diagram showing the display screen of the table of segment definitions for explaining the database system of FIGS. 2 to 4;

FIG. 87 is a diagram showing the display screen of the table of management points for explaining the database system of FIGS. 2 to 4;

FIG. 88 is a diagram showing the display screen of the table of segment definitions for explaining the database system of FIGS. 2 to 4;

FIG. 89 is a diagram showing the display screen of a layout determination worksheet for explaining the database system of FIGS. 2 to 4;

FIG. 90 is a diagram showing the display screen of a layout determination worksheet for explaining the database system of FIGS. 2 to 4;

FIG. 91 is a diagram showing the display screen of a layout determination worksheet for explaining the database system of FIGS. 2 to 4;

FIG. 92 is a diagram showing the display screen of an extracted job processing menu for explaining the database system of FIGS. 2 to 4;

FIG. 93 is a diagram showing the display screen of the table of extracted jobs for explaining the database system of FIGS. 2 to 4;

FIG. 94 is a diagram showing the display screen of the table of extracted jobs for explaining the database system of FIGS. 2 to 4;

FIG. 95 is a diagram showing a mismatch warning screen for explaining the database system of FIGS. 2 to 4;

FIG. 96 is a diagram showing a mismatch warning screen for explaining the database system of FIGS. 2 to 4;

FIG. 97 is a schematic diagram for explaining the management point recording area, the segment data recording area and the segment specification recording area of the database system of FIGS. 2 to 4;

FIG. 98 is a diagram showing the display screen of segment data changes for explaining the database system of FIGS. 2 to 4;

FIG. 99 is a diagram showing the display screen of the segment data changes for explaining the database system of FIGS. 2 to 4;

FIG. 100 is a schematic diagram for explaining the management point recording area, the segment data recording area and the segment specification recording area of the database system of FIGS. 2 to 4;

FIG. 101 is a block diagram showing the functional construction of a setup unit of a database system according to a second embodiment of the present invention;

FIG. 102 is a block diagram showing the functional construction of an inquiry unit of the database system according to a second embodiment of the present invention;

FIG. 103 is a block diagram showing the functional construction of an operations support unit according to the second embodiment of the present invention;

FIG. 104 is a diagram showing the display screen of the initial menu of the operations management for explaining the database system of FIGS. 101 to 103;

FIG. 105 is a diagram showing a table extraction selecting screen for explaining the database system of FIGS. 101 to 103;

FIG. 106 is a diagram showing a key item selecting screen for explaining the database system of FIGS. 101 to 103;

FIG. 107 is a diagram showing a display screen of a time series key item data determining worksheet for explaining the database system of FIGS. 101 to 103;

FIG. 108 is a diagram showing a display screen of the table of data items to be extracted for explaining the database system of FIGS. 101 to 103;

FIG. 109 is a diagram showing the display screen of the table of the data items to be extracted for explaining the database system of FIGS. 101 to 103;

FIG. 110 is a diagram showing the display screen of a retrieving condition setting worksheet for explaining the database system of FIGS. 101 to 103;

FIG. 111 is a schematic diagram for explaining the extracted job data recording area and the extracted job recording area of the database system of FIGS. 101 to 103;

FIG. 112 is a diagram showing the extracted job selecting screen for explaining the database system of FIGS. 101 to 103;

FIG. 113 is a schematic diagram for explaining the extracted job data recording area of the database system of FIGS. 101 to 103;

FIG. 114 is a diagram showing the confirmation screen of the finish of an extracted job for explaining the database system of FIGS. 101 to 103;

FIG. 115 is a schematic diagram for explaining the table management data recording area of the database system of FIGS. 101 to 103;

FIG. 116 is a schematic diagram for explaining the data item recording area and the data item attribute recording area of the database system of FIGS. 101 to 103;

FIG. 117 is a schematic diagram for explaining the data item recording area and the data item attribute recording area of the database system of FIGS. 101 to 103;

FIG. 118 is a schematic diagram for explaining the data item recording area and the data item attribute recording area of the database system of FIGS. 101 to 103;

FIG. 119 is a schematic diagram for explaining the management point recording area and the segment data recording area of the database system of FIGS. 101 to 103;

FIG. 120 is a diagram showing a layout determining worksheet for explaining the database system of FIGS. 101 to 103;

FIG. 121 is a diagram showing the display screen of a layout determining worksheet for explaining the database system of FIGS. 101 to 103;

FIG. 122 is a diagram showing the display screen of a layout determining worksheet for explaining the database system of FIGS. 101 to 103;

FIG. 123 is a diagram showing the display screen of a layout determining worksheet for explaining the database system of FIGS. 101 to 103;

FIG. 124 is a diagram showing the display screen of a layout determining worksheet for explaining the database system of FIGS. 101 to 103;

FIG. 125 is a diagram showing the display screen of a layout determining worksheet for explaining the database system of FIGS. 101 to 103;

FIG. 126 is a schematic diagram for explaining the extracted job data recording area of the database system of FIGS. 101 to 103;

FIG. 127 is a schematic diagram for explaining the attribute data of the database system of FIGS. 101 to 103;

FIG. 128 is a schematic diagram for explaining quasi-date data of the database system of FIGS. 101 to 103;

FIG. 129 is a schematic diagram for explaining date data of the database system of FIGS. 101 to 103;

FIG. 130 is a schematic diagram for explaining a method for storing time series data of the database system of FIGS. 101 to 103;

FIG. 131 is a schematic diagram for explaining the time series data storing method of the database system of FIGS. 101 to 103;

FIG. 132 is a schematic diagram for explaining the time series data storing method of the database system of FIGS. 101 to 103;

FIG. 133 is a schematic diagram for explaining the time series data storing method of the database system of FIGS. 101 to 103;

FIG. 134 is a schematic diagram for explaining the time series data storing method of the database system of FIGS. 101 to 103;

FIG. 135 is a schematic diagram for explaining the time series data storing method of the database system of FIGS. 101 to 103;

FIG. 136 is a schematic diagram for explaining an edition for the time series data of the database system of FIGS. 101 to 103;

FIG. 137 is a block diagram showing the functional construction of a setup unit of a database system according to a third embodiment of the present invention;

FIG. 138 is a block diagram showing the functional construction of an operations support unit of a database system according to a third embodiment of the present invention;

FIG. 139 is a schematic diagram for explaining an extracted job data recording area of the database system of FIGS. 137 and 138;

FIG. 140 is a diagram showing an extracted job selecting screen for explaining the database system of FIGS. 137 and 138;

FIG. 141 is a diagram showing the display screen of an extracted job attribute defining worksheet for explaining the database system of FIGS. 137 and 138;

FIG. 142 is a diagram showing an extracted table selecting screen for explaining the database system of FIGS. 137 and 138;

FIG. 143 is a diagram showing a data item selecting screen for explaining the database system of FIGS. 137 and 138;

FIG. 144 is a schematic diagram for explaining an extracted job recording area of the database system of FIGS. 137 and 138;

FIG. 145 is a diagram showing a display screen of an extraction condition table for explaining the database system of FIGS. 137 and 138;

FIG. 146 is a diagram showing the display screen of an extraction condition setting worksheet for explaining the database system of FIGS. 137 and 138;

FIG. 147 is a diagram showing a display screen of the extraction condition table for explaining the database system of FIGS. 137 and 138;

FIG. 148 is a schematic diagram for explaining the extracted job recording area of the database system of FIGS. 137 and 138;

FIG. 149 is a schematic diagram for explaining the extracted job data recording area and the extracted job recording area of the database system of FIGS. 137 and 138;

FIG. 150 is a diagram showing an extracted job selecting screen for explaining the database system of FIGS. 137 and 138;

FIG. 151 is a diagram showing a preceding extracted job selecting screen for explaining the database system of FIGS. 137 and 138;

FIG. 152 is a diagram showing an extracted job order defining screen for explaining the database system of FIGS. 137 and 138;

FIG. 153 is a diagram showing the extracted job order defining screen for explaining the database system of FIGS. 137 and 138;

FIG. 154 is a diagram showing the extracted job order defining screen for explaining the database system of FIGS. 137 and 138;

FIG. 155 is a schematic diagram for explaining the extracted job data recording area of the database system of FIGS. 137 and 138;

FIG. 156 is a diagram showing an extracted job selecting screen for explaining the database system of FIGS. 137 and 138;

FIG. 157 is a diagram showing the extracted job selecting screen for explaining the database system of FIGS. 137 and 138;

FIG. 158 is a diagram showing a succeeding job confirmation screen for explaining the database system of FIGS. 137 and 138;

FIG. 159 is a diagram showing an extracted job execution confirmation screen for explaining the database system of FIGS. 137 and 138;

FIG. 160 is a diagram showing a use limit setting confirmation screen for explaining the database system of FIGS. 137 and 138;

FIG. 161 is a diagram showing a use limit setting confirmation screen for explaining the database system of FIGS. 137 and 138;

FIG. 162 is a schematic diagram for explaining an extracted job data recording area of the database system of FIGS. 137 and 138;

FIG. 163 is a schematic diagram for explaining a table management data recording area of the database system of FIGS. 137 and 138;

FIG. 164 is a diagram showing a display screen of the initial menu of an operations support process for explaining the database system of FIGS. 137 and 138;

FIG. 165 is a schematic diagram for explaining an extraction source table management data recording area of the database system of FIGS. 137 and 138;

FIG. 166 is a diagram showing a table selection screen for explaining the database system of FIGS. 137 and 138;

FIG. 167 is a schematic diagram for explaining an extracted job data recording area of the database system of FIGS. 137 and 138;

FIG. 168 is a schematic diagram for explaining the table management data recording area of the database system of FIGS. 137 and 138;

FIG. 169 is a diagram showing an edition number matching confirmation screen for explaining the database system of FIGS. 137 and 138;

FIG. 170 is a diagram showing the edition number matching confirmation screen for explaining the database system of FIGS. 137 and 138;

FIG. 171 is a schematic diagram for explaining the table management data recording area of the database system of FIGS. 137 and 138;

FIG. 172 is a schematic diagram for explaining the extracted job recording area of the database system of FIGS. 137 and 138;

FIG. 173 is a schematic diagram for explaining the table management data recording area of the database system of FIGS. 137 and 138;

FIG. 174 is a diagram showing the table segment selecting screen for explaining the database system of FIGS. 137 and 138;

FIG. 175 is a diagram showing a table selecting screen for explaining the database system of FIGS. 137 and 138;

FIG. 176 is a diagram showing a link key item selecting screen for explaining the database system of FIGS. 137 and 138;

FIG. 177 is a diagram showing a display screen of a table link defining worksheet for explaining the database system of FIGS. 137 and 138;

FIG. 178 is a diagram showing an edition number check confirmation screen for explaining the database system of FIGS. 137 and 138;

FIG. 179 is a schematic diagram for explaining the table link management data recording area of the database system of FIGS. 137 and 138;

FIG. 180 is a schematic diagram for explaining the table management data recording area of the database system of FIGS. 137 and 138;

FIG. 181 is a schematic diagram for explaining the data item recording area and the data item attribute recording area of the database system of FIGS. 137 and 138;

FIG. 182 is a diagram showing a table segment selecting screen for explaining the database system of FIGS. 137 and 138;

FIG. 183 is a schematic diagram for explaining the data item recording area and the data item attribute recording area of the database system of FIGS. 137 and 138;

FIG. 184 is a diagram showing the display screen of an operation/process defining worksheet for explaining the database system of FIGS. 137 and 138;

FIG. 185 is a diagram showing the display screen of a data item attribute defining worksheet for explaining the database system of FIGS. 137 and 138;

FIG. 186 is a diagram showing the display screen of the operation/process defining worksheet for explaining the database system of FIGS. 137 and 138;

FIG. 187 is a schematic diagram for explaining the data item recording area and the data item attribute recording area of the database system of FIGS. 137 and 138;

FIG. 188 is a diagram showing a table segment selecting screen for explaining the database system of FIGS. 137 and 138;

FIG. 189 is a schematic diagram for explaining the data item recording area and the data item attribute recording area of the database system of FIGS. 137 and 138;

FIG. 190 is a diagram showing the operation/process defining worksheet for explaining the database system of FIGS. 137 and 138;

FIG. 191 is a diagram showing a display screen of an operation/process defining worksheet for explaining the database system of FIGS. 137 and 138;

FIG. 192 is a diagram showing a display screen of a data item attribute defining worksheet for explaining the database system of FIGS. 137 and 138;

FIG. 193 is a schematic diagram for explaining the data item recording area and the data item attribute recording area of the database system of FIGS. 137 and 138;

FIG. 194 is a schematic diagram for explaining the management point recording area of the database system of FIGS. 137 and 138;

FIG. 195 is a diagram showing a display screen of the table of management points for explaining the database system of FIGS. 137 and 138;

FIG. 196 is a diagram showing the display screen of a management point defining worksheet for explaining the database system of FIGS. 137 and 138;

FIG. 197 is a schematic diagram for explaining the management point recording area of the database system of FIGS. 137 and 138;

FIG. 198 is a diagram showing the display screen of the table of management points for explaining the database system of FIGS. 137 and 138;

FIG. 199 is a schematic diagram for explaining the management point recording area and the segment data recording area of the database system of FIGS. 137 and 138;

FIG. 200 is a diagram showing a segment definition confirmation screen for explaining the database system of FIGS. 137 and 138;

FIG. 201 is a schematic diagram for explaining the management point recording area, the segment data recording area and the segment specification recording area of the database system of FIGS. 137 and 138;

FIG. 202 is a block diagram showing the functional construction of a setup unit of a database system according to a fourth embodiment of the present invention;

FIG. 203 is a block diagram showing the functional construction of an inquiry unit of the database system according to the fourth embodiment of the present invention;

FIG. 204 is a block diagram showing the functional construction of an operations support unit of the database system according to the fourth embodiment of the present invention;

FIG. 205 is a schematic diagram for explaining a management point recording area of the database system of FIGS. 202 to 204;

FIG. 206 is a diagram showing the display screen of the table of management points for explaining the database system of FIGS. 202 to 204;

FIG. 207 is a schematic diagram for explaining the management point recording area and the segment data recording area of the database system of FIGS. 202 to 204;

FIG. 208 is a diagram showing the display screen of the table of segment definitions for explaining of the database system of FIGS. 202 to 204;

FIG. 209 is a diagram showing a table segment selecting screen for explaining the database system of FIGS. 202 to 204;

FIG. 210 is a diagram showing a table selecting screen for explaining the database system of FIGS. 202 to 204;

FIG. 211 is a diagram showing a data item selecting screen for explaining the database system of FIGS. 202 to 204;

FIG. 212 is a diagram showing a segment defining method confirmation screen for explaining the database system of FIGS. 202 to 204;

FIG. 213 is a diagram showing the display screen of a segment attribute defining worksheet for explaining the database system of FIGS. 202 to 204;

FIG. 214 is a diagram showing the display screen of a tentative graph display for explaining the database system of FIGS. 202 to 204;

FIG. 215 is a diagram showing the display screen of a segment attribute defining worksheet for explaining the database system of FIGS. 202 to 204;

FIG. 216 is a diagram showing a segment definition confirmation screen for explaining the database system of FIGS. 202 to 204;

FIG. 217 is a diagram showing the display screen of a decision histogram display for explaining the database system of FIGS. 202 to 204;

FIG. 218 is a diagram showing a management point selecting screen for explaining the database system of FIGS. 202 to 204;

FIG. 219 is a diagram showing a segment definition selecting screen for explaining the database system of FIGS. 202 to 204;

FIG. 220 is a diagram showing the display screen of a three-dimensional graph display for explaining the database system of FIGS. 202 to 204;

FIG. 221 is a diagram showing a graph registration confirmation screen for explaining the database system of FIGS. 202 to 204;

FIG. 222 is a schematic diagram for explaining the management point recording area, the segment data recording area, the segment specification recording area and the management point graph data recording area of the database system of FIGS. 202 to 204;

FIG. 223 is a schematic diagram for explaining the graph attribute data of the database system of FIGS. 202 to 204;

FIG. 224 is a diagram showing the display screen of the table of segment definitions for explaining the database system of FIGS. 202 to 204;

FIG. 225 is a diagram showing the display screen of the table of management points for explaining the database system of FIGS. 202 to 204;

FIG. 226 is a schematic diagram for explaining the management point recording area, the segment data recording area, the segment specification recording area and the management point graph data recording area of the database system of FIGS. 202 to 204;

FIG. 227 is a diagram showing the display screen of the table of management points for explaining the database system of FIGS. 202 to 204;

FIG. 228 is a diagram showing the display screen of a three-dimensional graph display for explaining the database system of FIGS. 202 to 204;

FIG. 229 is a diagram showing the display screen of a layout determining worksheet for explaining the database system of FIGS. 202 to 204;

FIG. 230 is a diagram showing the graph display screen of a layout determining worksheet for explaining the database system of FIGS. 202 to 204;

FIG. 231 is a diagram showing the range selecting screen of a layout determining worksheet for explaining the database system of FIGS. 202 to 204;

FIG. 232 is a diagram showing the display screen of a layout determining worksheet for explaining the database system of FIGS. 202 to 204;

FIG. 233 is a diagram showing an extracted job selecting screen for explaining the database system of FIGS. 202 to 204;

FIG. 234 is a diagram showing a mismatch warning screen for explaining the database system of FIGS. 202 to 204;

FIG. 235 is a diagram showing a mismatch warning screen for explaining the database system of FIGS. 202 to 204;

FIG. 236 is a schematic diagram for explaining the management point recording area, the segment data recording area, the segment specification recording area and the management point graph data recording area of the database system of FIGS. 202 to 204;

FIG. 237 is a diagram showing the display screen of the table of the segment definitions for explaining the database system of FIGS. 202 to 204;

FIG. 238 is a diagram showing the display screen of the segment definitions changing worksheet for explaining the database system of FIGS. 202 to 204;

FIG. 239 is a schematic diagram for explaining the management point recording area, the segment data recording area, the segment specification recording area and the management point graph data recording area of the database system of FIGS. 202 to 204;

FIG. 240 is a diagram showing the confirmation screen of a graph update for explaining the database system of FIGS. 202 to 204;

FIG. 241 is a block diagram showing the functional construction of a claim settlement of a database system according to a fifth embodiment of the present invention;

FIG. 242 is a schematic diagram for explaining a claim recording area of the database system of FIG. 241;

FIG. 243 is a schematic diagram for explaining an attached material recording area of the database system of FIG. 241;

FIG. 244 is a flow chart for explaining the claim settlement of the database system of FIG. 241;

FIG. 245 is a schematic diagram for explaining the claim recording area and the attached material recording area of the database system of FIG. 241;

FIG. 246 is a flow chart for explaining the claim storage of the database system of FIG. 241;

FIG. 247 is a diagram showing the display screen of the table of claim states for explaining the database system of FIG. 241;

FIG. 248 is a diagram showing the display screen of the table of undefined management points for explaining the database system of FIG. 241; and

FIG. 249 is a diagram showing a notification screen of the finish of a claim settlement for explaining the database system of FIG. 241.

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

With reference to the accompanying drawings, here will be described an embodiment of a database system which is equipped with a data exploitation support unit of a database according to the present invention.

FIG. 1 shows a basic construction of the database system which is common among the individual embodiments of the present invention.

The database system of FIG. 1 is constructed to include a trunk database 1, a public database 2, a dictionary 3, a setup unit 4, an operations support unit 5, an inquiry unit 6 and data files 7.

This database system has its database composed of the original database or the trunk database 1 and the public database 2. The trunk database 1 stores the master data and the transaction data of the trunk system. The public database 2 is composed of the data which are extracted from the trunk database 1 and subjected to a predetermined processing.

The dictionary 3 stores both the management point data, which are related to the master data of the trunk database 1, and the definition data for management and evaluation references, as its attribute data. The dictionary 3 may store other data as its attribute data.

The setup unit 4, the operations support unit 5 and the inquiry unit 6 are the functions to be realized mainly by the softwares for handling the stored data of the trunk database 1, the public database 2, the dictionary 3 and the data files 7, which have memories stored with the data. The setup unit 4 and the operations support unit 5 construct the data management unit.

The setup unit 4 records and manages the management points, which correspond to the management and evaluation references for exploiting the data, in the dictionary 3 in relation to the data items of the master data. The setup unit 4 records and manages the management points in relation to the data items in accordance with the extraction of at least one of the master data and the transaction data of the trunk database to the public database 2.

The operations support unit 5 monitors the states of and changes the data environment of the aforementioned master data and transaction data based upon the setting by the setup unit 4.

The inquiry unit 6 refers to the management points on the basis of the business dealing operations to extract the data of the final format, that are processed by the setup unit 4 and the operations support unit 5, in a usable mode.

The data files 7 store a variety of data to be used in association with the operations of the system and its individual portions.

<<Embodiment 1>>

The first embodiment of the present invention is characterized by the functional constructions of the setup unit 4, the inquiry unit 6 and the operations support unit 5, which makes the basic construction of the database system, as shown in FIG. 1.

FIGS. 2, 3 and 4 show the individual details of the functional constructions of the setup unit 4, the inquiry unit 6 and the operations support unit 5 in the database system according to the first embodiment of the present invention.

As shown in FIG. 2, the setup unit 4 is composed of a data setup main controller 11, a data item definer 12, a table data definer 13, a table sorter 14, a table combination definer 15, an operated data item definer 16, a function parameter definer 17, a data item grouping definer 18, a management point definer 19, a sorting data definer 20, a data item management support 22 and a point management support 23.

As shown in FIG. 3, the inquiry unit 6 is composed of a data exploiting main controller 31, a layout determinator 32, a sorting data selection optimizer 33, a grouping data item selector 34, a data fetch driver 35, a retriever 36, a function processor 37, a media transformer 38 and a data display linker 39.

As shown in FIG. 4, the operations support unit 5 is composed of an operations management supporting main controller 41, an extracted job definer 42, a data extractor 43, a sorted data consistency assurer 44 and a database tuner 45.

The data extractor 43 outputs the data, which is sent out from the trunk database 1 of the trunk business system and extracted from sent database 1A, to the public database 2. The database tuner 45 refers to a use log file 7A contained in the aforementioned data files 7.

Next, the functions and operations of the aforementioned individual units will be described in more detail in connection with the specific operations and processings.

(1-1) Generation of Extracted Job from Trunk Database to Public Database

The operations support unit 5 has functions to generate or create (at the extracted job definer 42) an extracted job (or extracted procedure) for fetching the database data (1A) from the trunk database 1 of the trunk business system into the public database 2, to execute (at the data extractor 43) the extracted job, and to tune (at the database tuner 45), and supports the smooth operations of the database. This operations support unit 5 is controlled in its entirety by the operations management supporting main controller 41.

In order to start a predetermined processing, the operations management supporting main controller 41 displays an initial menu for the operations management, as shown in FIG. 5, in the display screen of a terminal unit. When the terminal operator selects a menu item corresponding to the extracted job definition, for example, from the menu of FIG. 5 by making use of a mouse or the like, the extracted job definer 42 is controlled to define the extracted job of the trunk database data.

Incidentally, at the time of fetching the data from the trunk database 1 to the public database 2, an extraction intrinsic to time series data may be executed for the time series data. This extraction intrinsic to the time series data will be described in connection with a second embodiment of the present invention.

When a menu item corresponding to the database tuning is selected from the aforementioned menu, the database tuner 45 is controlled so that the database may be tuned for improving the processing efficiency on the basis of the use log data to be recorded with the hysteresis data of using the database.

In order to assure consistency or matching the database information, the order of executing the extracted jobs in association may be regulated, or the restricting conditions for executing the extracted jobs may be defined. The detail of this consistency of the database data will be described in connection a third embodiment of the present invention.

The extracted job definer 42 of the trunk data base data generates and stores in the dictionary 3 the extracted job for fetching the database data of the trunk database 1 from the trunk business system into the public database 2. This extracted job definer 42 also has a function to change or delete the job which is generated and stored in the dictionary 3.

The extracted job definer 42 of the trunk database data tabulates the extracted job data, as recorded/managed by the dictionary 3, in the display screen of the terminal unit.

Specifically, the extracted job data recording area of the dictionary 3 is stored, as shown in FIG. 6, with extracted job data D1, which contain existence data D2 indicating the existence of the extracted job or an execution format program, and the extracted job D3 itself is stored in the extracted job recording area of the dictionary 3.

At the time of the extracted job selection, there are displayed the table of the aforementioned extracted job data and the buttons "END", "ADD", "CHANGE" and "DELETE", as shown in FIG. 7.

By selecting the "ADD" button by the mouse or the like, an extracted job can be newly defined. If, on the other hand, the "CHANGE" button is selected after a certain extracted job has been selected by the mouse or the like, it is possible to change the content of the defined extracted job, as selected. If, on the other hand, the "DELETE" button is selected after a certain extracted job has been selected, it is possible to delete the defined extracted job, as selected.

The definitions of the extracted job are executed by effecting the selection of a table to be extracted from the trunk database 1 of the trunk business system, the selection of a data item and the indication of a retrieving condition and are based by generating as the extracted job the procedure of extracting/registering the desired data as a table in the public database 2. In this case, moreover, a program, as described in a program language such as COBOL, can be allocated as the extracted job.

By selecting the "ADD" button, as described above, it is possible to define the extracted job. In this case, the worksheet for defining the attributes of the extracted job, as shown in FIG.8, is displayed in the screen of the terminal unit so that the attributes of the extracted job such as the extracted job name, the extraction source schema name, the extraction destination schema name, the table name and the creator can be defined by inputting through a keyboard or the like. The screen, as shown in FIG. 8, displays the "OK" and "DELETE" buttons in addition to the attribute defining worksheet.

With the attributes being defined in the worksheet of FIG. 8, the generation of an extracted job is started when the "OK" button is selected.

For generating the extracted job, the database data, as sent out from the trunk database 1 of the trunk business system, are tabulated at first at the unit of table in the screen of the terminal unit, as shown in FIG. 9, so that the extracted table can be selected by the mouse or the like. In the screen of FIG. 9, the "END" and "OK" buttons are also displayed.

The table to be extracted is selected in the screen of FIG. 9, and the "OK" button is selected. Then, as shown in FIG. 10, the data items composing the selected table are tabulated in the screen of the terminal unit so that the data item to be extracted can be selected by using the mouse or the like. In the screen of FIG. 10, there are also displayed the "OK", "DELETE" and "OPERATION/PROCESS" buttons.

In case a plurality of tables are selected from the screen of FIG. 9, the table of the data items composing those tables is displayed in the screen of the terminal unit, as corresponds to the screen of FIG. 10, and the linking conditions among those tables are automatically generated by selecting the data items associatively.

By selecting the "OPERATION/PROCESS" button in the screen of FIG. 10 by the mouse or the like, on the other hand, the result of the operation/process between the data items can be extracted. When the "OPERATION/PROCESS" button is selected, the worksheet for defining the operation/process formula is displayed in the screen of the terminal unit so that the desired operation/process formula can be defined by selecting a data item from the table of data items and an operand from the table of operands by using the mouse or the like and by attaching the selected ones to the worksheet.

When the generation of the fundamental procedure is completed, an extraction condition table screen for setting the extraction conditions is then displayed on the screen of the terminal unit, as shown in FIG. 12. The "OK", "ADD" and "DELETE" buttons are also displayed in the screen of FIG. 12. By selecting the "ADD" button by the mouse or the like, the worksheet for setting the individual extraction conditions is displayed in the screen of the terminal unit, as shown in FIG. 13, so that the extraction conditions can be defined. The "OK" and "DELETE" buttons are also displayed in the screen of FIG. 13.

Specifically, by selecting a data item for setting the conditions by the mouse or the like from the table of the lefthand data items of the screen of the terminal unit, as shown in FIG. 13, the data item names are transferred to the righthand worksheet of FIG. 13. In case the data items are composed of characters, operation parts for setting the character type conditions are displayed in the lower rows of the worksheet so that they can be used for the selection to complete the conditional formulas.

Specifically, in FIG. 13, after the data item "a" has been selected from the lefthand side of the screen, and a comparison character row "1" is inputted, and the "FRONT MATCH" is selected to generate "aLIKE`1%`".

When the definition of the conditional formula is completed, the "OK" button is selected in the screen of FIG. 13. Then, the screen of the extraction condition table, as shown in FIG. 14, is restored. Substantially as in the screen of FIG. 12, the above-defined conditional formula is additionally displayed in the table in FIG. 14. In the screen of FIG. 14, there are also displayed the "OK", "ADD", "CHANGE" and "DELETE" buttons.

After the conditional formula has been selected in the screen of FIG. 14 by using the mouse or the like, the "CHANGE" button is selected. Then, the extraction condition setting worksheet, as shown in FIG. 13, is displayed again in the screen of the terminal unit so that the preset conditional formula can be changed. Moreover, the designated conditional formula can be deleted by selecting the "DELETE" button after the conditional formula has been selected.

When the definitions of all extraction conditions are completed, the "OK" is selected. Then, the definitions of the series extraction conditions are completed so that the extracted jobs, as shown in FIG. 11, are changed to those shown in FIG. 15. As to the extracted jobs thus generated, as shown in FIG. 16, the extracted job data are written in the extracted job data recording area of the dictionary 3, and the extracted jobs are stored in the extracted job recording area of the dictionary 3.

When the write of the extracted job in the dictionary 3 is completed, the extracted job selecting screen, as shown in FIG. 17, is restored. In the extracted job selecting screen of FIG. 17, the extracted job "EXTRACT1" of the series extracted jobs, as added in their definitions, is further added to the table screen of the extracted job selections of FIG. 7.

(1-2) Fetch to Public Database of Trunk Database

The operations management supporting main controller 41 controlling the entirety of the operations support unit 5 displays the initial menu for starting a predetermined processing, as shown in FIG. 5, in the screen of the terminal unit at the start and at the end of another processing (e.g., the aforementioned extracted job definition). The control is transferred to the data extractor 43 to start the extracted job when the terminal operator selects such a menu item by the mouse or the like as corresponds to the extracted job execution for extracting the data from the trunk database 1 to the public database 2.

The data extractor 43 of the trunk database data starts the extracted job which is generated extracted job definer 42 of the trunk database data and extracts predetermined database data from the database 1A, as sent out from the trunk database 1 of the trunk business system, to the public database 2.

At the start of the extracted job, the table of the extracted job data, as recorded/managed by the dictionary 3, is displayed in the screen of the terminal unit, as shown in FIG. 18, by the control of the data extractor 43 so that an arbitrary extracted job can be started when the terminal operator selects the arbitrary extracted job by operating the mouse or the like. In the screen of FIG. 18, there are also displayed the "OK", "NARROW" and "END" buttons. If the "NARROW" button is selected by the mouse or the like, on the other hand, the narrowing worksheet is displayed in the screen of the terminal unit so that the narrowing condition for narrowing the job executing day to a designated date and after can be designated for the worksheet.

By selecting a desired extracted job from the table of FIG. 18 and the "OK" button, the selected job is executed so that the message indicating the result of execution is outputted to the screen of the terminal unit, as shown in FIG. 19.

By executing the extracted job, the table is extracted/registered in the public database 2 so that the job execution date of the extracted job data recording area of the dictionary 3 is updated at that date.

In case the blank of the basic data, as recorded/managed in the extracted job recording area, is "NOT FINISHED", as shown in FIG. 16, the fetch (i.e., the creation/update of the data item attribute data) of the basic data of the data item is executed if it is instructed by the terminal operator.

The basic data of the data item are recorded/managed together the table management data in the dictionary 3. FIG. 20 shows a recording format of the table management data of the table management data recording area in the dictionary 3, and FIG. 21 shows a recording format of the data item of the data item recording area and the data item attribute (including the basic data).

When the extracted job is executed, its execution date is written in the extracted job table of the extracted job selecting screen, as shown in FIG. 22.

(1-3) Definition of Data Items

The setup unit 4 has functions to define the tables existing in the trunk database 1 and the public database 2 and the various attributes of the data items composing the tables (e.g., the data item definer 12, the table data definer 13, the table sorter 14, the table combination definer 15, the data item management support 21 and the table management support 22) and to define the management points