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

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

• Current Assignee: Fujitsu Limited
• Original Assignee: Fujitsu Limited
• Inventors: Tanaka, Tsutomu, Watanabe, Yasuhiro, Shimizu, Hajime, Watanabe, Ichiro, Wakio, Koji, Terauchi, Yuji, Arai, Shoichi, Takekawa, Kazuhiro
• Primary Examiner(s): HOMERE, JEAN RAYMOND
• Application Number:
  US09/500,219
• Time in Patent Office: 441 Days
• Field of Search: 707/10, 707/3, 707/102, 707/104, 707/200, 709/203, 709/201, 709/259
• US Class Current: 707/703
• CPC Class Codes: G06F 16/2465 Query processing support for facilitating data mining operations in structured databases
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99948 Application of database or data structure, e.g. distributed, multimedia, or image

Abstract

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

Claims

1. A database system, comprising:

a 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.

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.

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.