Data Management Apparatus And Method Thereof

• US 20080016099A1
• Filed: 10/12/2005
• Published: 01/17/2008
• Est. Priority Date: 10/13/2004
• Status: Active Grant

• Current Assignee: Nissay Information Technology Company Limited (Nippon Life Insurance Company)
• Original Assignee: Nissay Information Technology Company Limited (Nippon Life Insurance Company)
• Inventors: Ikeda, Mitsuyuki
• Granted Patent: US 8,554,582 B2
• Time in Patent Office: Days
• US Class Current: 707/102
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures
• CPC Class Codes: G06F 16/24 Querying
• CPC Class Codes: G06F 16/245 Query processing
• CPC Class Codes: G06Q 30/06 Buying, selling or leasing transactions
• CPC Class Codes: G06Q 90/00 Systems or methods specially adapted for administrative, commercial, financial, managerial or supervisory purposes, not involving significant data processing

Abstract

The present invention provides a data management apparatus (i-Win™) which carries out centralized management of data containing data on each product during the management of product data having different data items to be handled and which has increased maintenance-ability in system and program(s).

A data storage part 13 stores transaction data (contract data) including class ID (logic key) and data contents ID (variable). A data definition part 17 records data contents IDs and data contents (clause data) for each clause ID. A data processing means 15 acquires combination data of a data contents ID and data content from the data definition part 17 (definition body) in accordance with a class ID recorded in the data storage part 13 and performs processing which relates to data contents of a predetermined data item (contract condition). In this way, centralized management of plurality of product data having different product features from its clause and prospectus and the like can be carried out.

Claims

1. A data management apparatus for managing data in which data items to be managed are respectively different, the apparatus comprising:

a data storage part storing at least a data ID, a class ID and a data content ID;

a data definition part recording data content corresponding to the data content ID for each data item; and

data processing means for implementing processing of determining a data content corresponding to a predetermined data item of a class ID representing a data class specified by the data ID in accordance with a data content ID stored in the data definition part which conform to the data content ID recorded in the data storage part.

3. One of the data management apparatus and the program according to claims 1 and 2, wherein the data definition part stores a data item to be managed for each class ID, and wherein the data processing means specifies a data item corresponding to the class ID.

4. One of the data management apparatus and the program according to claim 3, wherein the data storage part respectively stores a plurality of data content IDs correspondingly to a plurality of data item numbers commonly used for each combination of a data ID and the class ID, and wherein the data definition part stores data items respectively corresponding to a plurality of data item numbers, for each class ID.

5. One of the data management apparatus and the program according to claim 4, wherein the data definition part stores at least two or more of data contents corresponding to the data content ID, for each data item corresponding to a data item number stored for each class ID.

6. One of the data management apparatus and the program according to claim 5, wherein the data processing means acquires all combinations of data content IDs and data contents recorded for data items corresponding to data item numbers stored by the data definition part,

and wherein the data processing means determines a data content ID corresponding to one of data content corresponding to a predetermined data content ID and a data content ID corresponding to a predetermined data content in accordance with combinations of the acquired data content IDs and the data contents.

7. One of the data management apparatus and the program according to claim 5, wherein the data definition part describes a processing code for executing processing for handling one of a data content ID and a data content together with a combination of a data ID and a data content, for each data item,

wherein the data processing means acquires from the data definition part the processing code together with the combination of the data content ID and the data content,

and wherein the data processing means determines a data content ID corresponding to one of data content corresponding to a predetermined data content ID and a data content ID corresponding to a predetermined data content in accordance with a combination of the acquired processing code, the data content ID and the data content.

8. One of the data management apparatus and the program according to claim 7, wherein the data processing means comprises a main processing part, a processing program requesting/execution part requesting a processing program to the data definition part and executing the program and a processing program generation part generating a processing program in accordance with the processing code and the combination data,

and wherein the data definition part comprises a processing code storage part storing a processing code for implementing processing of handing data content ID and data content, and a combination data storage part recording a combination of the data content ID and the data content.

9. One of the data management apparatus and the program according to claim 8, wherein the processing program requesting/execution part of the data processing means comprises a processing program requesting part requesting a processing program to the processing program generation part and a processing program execution part executing the processing program received from the processing program generation part,

and wherein the processing program requesting part is composed as a wrapper program.

10. One of the data management apparatus and the program according to claim 5, wherein the data definition part describes a processing code for checking a combination of data contents corresponding respectively to more than two classes of data items,

wherein the data processing means acquires from the processing code together with the combination of the data content ID and the data content,

and wherein the data processing means judges whether or not the combination of the data contents corresponding respectively to more than the two classes of data items is correct one in accordance with the acquired processing code and a combination of the data content ID and the data content.

11. One of the data management apparatus and the program according to claim 10, wherein the data processing means comprises a main processing part, a processing program requesting/execution part requesting a processing program to the data definition part and executing the program and a processing program generation part generating a processing program in accordance with the processing code and the combination data,

and wherein the data definition part comprises a processing code storage part storing a processing code for implementing processing of handing data content ID and data content and a combination data storage part recording a combination of the data content ID and the data content.

12. One of the data management apparatus and the program according to claim 11, wherein the processing program requesting/execution part of the data processing means comprises a processing program requesting part requesting a processing program to the processing program generation part and a processing program execution part executing the processing program received from the processing program generation part,

and wherein the processing program requesting part is composed as a wrapper program.

13. One of the data management apparatus and the program according to claim 5, wherein the data processing means acquires all combinations of data content IDs and data contents in all data items stored by the data definition part for predetermined class IDs,

and wherein the data processing means outputs one of the data content ID and the data content capable of being selected for each data item of the predetermined class ID in accordance with a combination of the acquired data content IDs and the data contents.

14. One of the data management apparatus and the program according to claim 13 wherein a display formant definition part recording a display format for one of the data content ID and the data content for each data item is further provided thereto,

and wherein the data processing means outputs one of the data content ID and the data content capable of being selected in accordance with the display format acquired from the display formant definition part.

15. One of the data management apparatus and the program according to claim 13 wherein the data processing means acquires data contents corresponding to all data items for a class ID of the data ID in accordance with the class ID and the data content ID of a predetermined data ID stored in the data storage part and outputs one of the data content ID and the data content capable of being selected using the acquired data content as an initial value.

16. One of the data management apparatus and the program according to claim 5, wherein the data definition part records a combination of a data content ID and data content capable of being selected for each data item and describes a processing code for executing processing for handling one of the data content ID and the data content capable of being selected for all data items of a class ID,

and wherein the data processing means acquires from the data definition part the processing code for the predetermined class ID together with all combinations of data content IDs and data contents capable of being selected in all data items for predetermined class IDs and outputs one of the data content ID and the data content capable of being selected for each data item of the predetermined class ID in accordance with all combinations of data content IDs and data contents and the data contents capable of being selected and the processing code.

17. One of the data management apparatus and the program according to claim 16, wherein a display formant definition part recording a display format for one of the data content ID and the data content for each data item is further provided thereto,

and wherein the data processing means outputs one of the data content ID and the data content capable of being selected in accordance with the display format acquired from the display formant definition part.

18. The data management apparatus and the program according to claim 16, wherein the data processing means acquires data contents corresponding to all data items for a class ID of the data ID in accordance with the class ID and the data content ID of a predetermined data ID stored in the data storage part and outputs one of the data content ID and the data content capable of being selected using the acquired data content as an initial value.

19. One of the data management apparatus and the program according to claim 1 and claim 2, wherein the data definition part separately records a processing code for executing processing for handling one of, a combination of the data content ID and the data content, and, the data content ID and the data content in hierarchy according to the class ID.

20. One of the data management apparatus and the program according to claim 1 and 2, wherein the data storage part records transaction data including product data,

wherein the data definition part records data representing feature of a product as data content,

and wherein the data processing means determines data content of a product according to the product data upon receipt of an instruction for processing to the transaction data.

21. One of the data management apparatus and the program according to claim 20, wherein the product data is data on a product defined based on a clause,

and wherein data representing feature of the product is data representing content thereof defined in the clause.

22. One of the data management apparatus and the program according to claim 21, wherein the data definition part separately records a processing code for executing processing for handling one of data content corresponding to the data content ID, the data content ID and data content in hierarchy defined respectively by product category in which a product determined based on the clause belongs thereto, a class of clause and a version of clause.

23. One of the data management apparatus and the program according to claim 22, wherein the class of clause in the data definition part is composed of a company code representing nature of a company and a clause code representing class of clause for the company.

24. One of the data management apparatus and the program according to claim 1 and claim 2, wherein a group definition part recording a set-up condition of predetermined data for each group combining a plurality of class IDs is further provided thereto.

25. One of the data management apparatus and the program according to claim 24, wherein the data processing means specifies the group combining a plurality of class IDs according to the data ID,

and wherein processing for determining whether or not a data content ID to be stored in the data storage part is recordable in accordance with a set-up condition of the predetermined data recorded in the group definition part.

26. One of the data management apparatus and the program according to claim 25, wherein the set-up condition of the predetermined data includes a data content ID capable of being recorded in the data storage part and a processing code for checking whether or not the predetermined data content ID conforms to the data content ID capable of being recorded in the data storage part.

27. One of the data management apparatus and the program according to claim 25, wherein the set-up condition of the predetermined data includes data content corresponding to data content ID storable in the data storage part and a processing code for checking whether or not the predetermined data content has data content corresponding to the data content ID recordable in the data storage part.

28. One of the data management apparatus and the program according to claim 27, wherein the predetermined data content is data acquired from the data definition part in accordance with data content ID to be recorded in the data storage part.

29. One of the data management apparatus and the program according to claim 24, wherein the data processing means specifies a group composed of combining a plurality of class IDs in accordance with the data ID and implements processing for determining whether or not a data value to be recorded in the data storage part is recordable in accordance with the set-up condition of predetermined data stored in the group definition part.

30. One of the data management apparatus and the program according to claim 29, wherein the set-up condition of predetermined data includes condition of a data value capable of being recorded in the data storage part and a processing code for checking whether or not the predetermined data value conforms to the data value capable of being recorded in the data storage part.

31. One of the data management apparatus and the program according to claim 24, wherein the data processing means specifies a group composed of combining a plurality of class IDs in accordance with the data ID and acquires name of the group in accordance with the set-up condition of predetermined data stored in the group definition part.

32. One of the data management apparatus and the program according to claim 3, wherein the data storage part is composed so that a unique data value according to a data ID is recordable therein,

wherein the data definition part records a processing code describing a method of set-up the unique data value for each class ID,

wherein the data processing means specifies a second class ID relating to a first class ID in accordance with the first class ID to be recorded in the data storage part and acquires from the data definition part a processing code according to the specified second class ID,

and wherein the data processing means sets a unique data value according to the first class ID in accordance with the acquired processing code.

33. One of the data management apparatus and the program according to claim 32, wherein the data storage part records transaction data containing insurance product data defined in accordance with a clause,

wherein when data on date according to transaction data of a class ID representing of a rider is set, the data definition part records a processing code describing a method of set-up data on date according to transaction data representing the basic policy corresponding to the rider,

and wherein the data processing means sets up the data on date according to the transaction data of the class ID representing of the rider in accordance with the processing code acquired from the data definition part.

34. One of the data management apparatus and the program according to claim 1 and claim 2, wherein the data storage part records a data item ID corresponding to a predetermined data item,

wherein the data definition part correspondingly records a combination of data item ID and data content ID with data item and data content,

and wherein the data processing means implements processing of determining a data item and a data content corresponding thereto in accordance with a combination of the data item ID and the data content ID stored in the data definition part which conform to a combination of the data item ID and the data content ID recorded in the data storage part.

35. One of the data management apparatus and the program according to claim 34, wherein the data storage part records plural combinations of data item IDs and data content IDs.

36. One of the data management apparatus and the program according to claim 35, wherein the data item represents a processing status on data to be recorded at the data storage part.

37. One of the data management apparatus and the program according to claim 34, wherein the data storage part records an attribution ID representing attribution of data specified by a data ID,

wherein the data definition part records a combination of a data item ID and a data content ID for each attribution ID,

and wherein the data processing means implements processing of determining a data item and a data content corresponding thereto for each attribution ID.

38. One of the data management apparatus and the program according to claim 1 and claim 2, wherein the data storage part records a combination of a data item ID and a data content ID corresponding to a predetermined data item,

wherein the data definition part records a combination of a data item ID and a data item,

and wherein the data processing means implements processing of determining a data item corresponding to the data content stored in the data storage part in accordance with the data item ID stored in the data definition part which conform to the data item ID recorded in the data storage part.

39. One of the data management apparatus and the program according to claim 38, wherein the data storage part records plural combinations of data item IDs and data contents.

40. One of the data management apparatus and the program according to claim 39, wherein the data storage part records a combination of a data item ID and a data item for each data-type in the data content to be recorded in the data storage part.

41. One of the data management apparatus and the program according to claim 40, wherein the data-type includes one of a date-type, a value-type, a character-type and a binary-type.

42. One of the data management apparatus and the program according to claim 38, wherein the data storage part records an attribute ID representing data specified by a data ID,

wherein the data definition part records a combination of a data item ID and a data item for each attribution ID,

and wherein the data processing means implements processing of determining a data item for each attribution ID.

43. One of the data management apparatus and the program according to claim 1 and claim 2, wherein the data processing means comprises a condition set-up part for setting up a calculation condition used at a calculation processing part and the calculation processing part for executing predetermined calculation processing in accordance with the calculation condition, and wherein access to one of the data definition part and the group definition part is carried out only at the condition set-up part.

44. One of the data management apparatus and the program according to claim 43, wherein the data processing means comprises a combination of the condition set-up part and the calculation processing part for each calculation processing.

45. One of the data management apparatus and the program according to claim 43, wherein a processing data storage part containing all data potentially to be handled is further provided,

and wherein the condition set-up part at the data processing means implements data input and data output of data to the processing data storage part.

46. One of the data management apparatus and the program according to claim 45, wherein the processing data storage part comprises transaction data, screen image input data and calculation result data.

2. A program for realizing a data management apparatus for managing data in which data items to be managed are respectively different with a computer, the program functioning as following means (a) through (c) on the computer:

(a) means, accessing to a data storage part at least storing a data ID, a class ID and a data content ID;

(b) means, accessing to a data definition part recording data content corresponding to the data content ID for each data item; and

(c) means, implementing processing of determining a data content corresponding to a predetermined data item of a class ID representing data class specified by the data ID in accordance with a data content ID stored in the data definition part which conform to the data content ID recorded in the data storage part.

47. An insurance policy data management apparatus for managing data on insurance policy in which contract conditions to be managed are respectively different depending on a clause, the apparatus comprising:

a data storage part storing at least a policy ID for specifying a insurance policy, a clause ID for specifying a clause of the insurance policy and a contractual coverage ID for specifying contractual coverage of the clause;

a data definition part recording contractual coverage corresponding to the contractual coverage ID for each data item; and

data processing means for implementing processing of determining contractual coverage corresponding to a predetermined contract condition of insurance policy data specified by the policy ID in accordance with a contractual coverage ID stored in the data definition part which conform to the contractual coverage ID recorded in the data storage part.

48. A program for realizing an insurance policy data management apparatus for managing data on insurance policy in which contract conditions to be managed are respectively different depending on a clause with a computer, the program functioning as following means (a) through (c) on the computer:

(a) means, accessing to a data storage part at least storing a policy ID for specifying a insurance policy, a clause ID for specifying a clause of the insurance policy and a contractual coverage ID for specifying contractual coverage of the clause;

(b) means, accessing to a data definition part recording contractual coverage corresponding to the contractual coverage ID for each contract condition; and

(c) data processing means for implementing processing of determining contractual coverage corresponding to a predetermined contract condition of insurance policy data specified by the policy ID in accordance with a contractual coverage ID stored in the data definition part which conform to the data content ID recorded in the data storage part.

49. A data structure for managing data in which data items to be managed are respectively different, the structure comprising:

a data storage part storing at least a data ID for identifying data, a class ID for representing class of data contents specified by the data ID and a data content ID corresponding to data content of data item according to the class ID; and

a data definition part recording data content corresponding to the data content ID for each data item.

50. The data structure according to claim 49, wherein the data definition part stores a data item to be managed for each class ID.

51. The data structure according to claim 50, wherein the data storage part respectively stores a plurality of data content IDs correspondingly to a plurality of data item numbers commonly used for each combination, for each combination of a data ID and a class ID, and wherein the data definition part stores data items respectively corresponding to a plurality of data item numbers, for each class ID.

52. A data structure for managing data in which data items to be managed are respectively different, the structure comprising:

a data storage part storing at least a policy ID for specifying a insurance policy, a clause ID for specifying a clause of the insurance policy and a contractual coverage ID for specifying contractual coverage of the clause; and

a data definition part recording contractual coverage corresponding to the contractual coverage ID for each clause ID and each contract condition.

53. The data structure according to claim 52, wherein the data storage part respectively stores a plurality of contractual coverage IDs correspondingly to a plurality of contract condition numbers commonly used for each combination of the policy ID and the clause ID,

and wherein the data definition part stores contract conditions respectively corresponding to a plurality of contract condition numbers, for each clause ID.

54. A program generation apparatus for generating a program for implementing designated processing for designated data, the apparatus comprising:

a data definition part recording a correspondence table representing correspondence between a data content ID and data content for each data item;

a processing definition part storing a processing code for processing;

correspondence table acquisition means acquiring from the data definition part a correspondence table on a data item specified by a class ID contained in the designated data and content of the designated processing;

processing code acquisition means acquiring from the processing definition part a processing code on the designated processing; and

a program generation means generating a program in accordance with the acquired correspondence table and the processing code.

56. One of the program generation apparatus and the program according to claim 54, wherein a class ID contained in the designated data is extracted from a data storage part managing data in which data items to be managed are respectively different depending upon the class ID, and the data storage part stores at least a data ID for identifying data, a class ID specified by the data ID and data content ID for specifying data content in the class ID.

57. The program generation apparatus and the program according to claim 54, wherein the data definition part record the correspondence table for each class ID and each data item.

55. A program for realizing a program generation apparatus for generating a program for implementing designated processing for designated data with a computer, the program functioning as following means (a) through (e) on the computer:

(a) means, accessing to a data definition part recording a correspondence table representing correspondence between a data content ID and data content for each data item;

(b) means, accessing to a processing definition part storing a processing code for processing;

(c) correspondence table acquisition means acquiring from the data definition part a correspondence table on a data item specified by a class ID contained in the designated data and content of the designated processing;

(d) processing code acquisition means acquiring from the processing definition part a processing code on the designated processing; and

(e) a program generation means generating a program in accordance with the acquired correspondence table and the processing code.

58. A screen-image generation apparatus for generating a screen-image for implementing designated processing according to a predetermined class ID, the apparatus comprising:

a data definition part recording a correspondence table representing correspondence between a data content ID and data content for each data item;

a processing definition part storing a processing code for processing;

correspondence table acquisition means acquiring from the data definition part a correspondence table on a data item specified by a class ID contained in the designated data and content of the designated processing;

processing code acquisition means acquiring from the processing definition part a processing code on the designated processing; and

a program generation means generating a program in accordance with the acquired correspondence table and the processing code;

wherein the data processing means generates a display screen by acquiring all combinations of data content IDs and data contents recorded for data items corresponding to data item numbers stored in the data definition part and by outputting one of the data content ID and the data content capable of being selected for each data item of the predetermined class ID in accordance with a combination of the acquired data content IDs and the data contents.

60. One of the program generation apparatus and the program according to claim 58, wherein one of a display format definition part storing display formats for one of data content IDs and data contents and means for accessing thereto, for each data item, is further provided, and wherein the data processing means outputs one of the data content ID and the data content capable of being selected in accordance with the display format acquired from the display format definition part.

59. A program for realizing a program generation apparatus for generating a program for implementing designated processing for designated data with a computer, the program functioning as following means (a) through (d) on the computer:

(a) means, accessing to a data definition part recording a correspondence table representing correspondence between a data content ID and data content for each data item;

(b) means, accessing to a processing definition part storing a processing code for processing;

(c) correspondence table acquisition means acquiring from the data definition part a correspondence table on a data item specified by a class ID contained in the designated data and content of the designated processing;

processing code acquisition means acquiring from the processing definition part a processing code on the designated processing; and

(d) program generation means generating a program in accordance with the acquired correspondence table and the processing code;

wherein the data processing means generates a display screen by acquiring all combinations of data content IDs and data contents recorded for data items corresponding to data item numbers stored in the data definition part and by outputting one of the data content ID and the data content capable of being selected for each data item of the predetermined class ID in accordance with a combination of the acquired data content IDs and the data contents.

61. A method of managing data in which data items to be managed are respectively different, the method comprising the steps of:

storing in a data storage part at least a data ID, a class ID and a data content ID;

recording in a data definition part data content corresponding to the data content ID for each data item; and

determining a data content corresponding to a predetermined data item of a class ID representing a data class specified by the data ID in accordance with a data content ID stored in the data definition part which conform to the data content ID recorded in the data storage part.

62. A method of managing insurance policy data for managing data on insurance policy in which contract conditions to be managed are respectively different depending on a clause, the method comprising the steps of:

storing in a data storage part at least a policy ID for specifying a insurance policy, a clause ID for specifying a clause of the insurance policy and a contractual coverage ID for specifying contractual coverage of the clause;

recording in a data definition part contractual coverage corresponding to the contractual coverage ID for each data item; and

determining contractual coverage corresponding to a predetermined contract condition of insurance policy data specified by the policy ID in accordance with a contractual coverage ID stored in the data definition part which conform to the contractual coverage ID recorded in the data storage part.

63. A method of generating a program for implementing designated processing for designated data, the method comprising the steps of:

recording in a data definition part a correspondence table representing correspondence between a data content ID and data content for each data item;

storing in a processing definition part a processing code for processing;

acquiring from the data definition part a correspondence table on a data item specified by a class ID contained in the designated data and content of the designated processing;

acquiring from the processing definition part a processing code on the designated processing; and

generating a program in accordance with the acquired correspondence table and the processing code.

64. A method of generating a screen-image for implementing designated processing according to a predetermined class ID, the method comprising the steps of:

recording in a data definition part a correspondence table representing correspondence between a data content ID and data content for each data item;

storing in a processing definition part a processing code for processing;

correspondence table acquisition means acquiring from the data definition part a correspondence table on a data item specified by a class ID contained in the designated data and content of the designated processing;

acquiring from the processing definition part a processing code on the designated processing; and

generating a program in accordance with the acquired correspondence table and the processing code;

wherein a display screen is generated by acquiring all combinations of data content IDs and data contents recorded for data items corresponding to data item numbers stored in the data definition part and by outputting one of the data content ID and the data content capable of being selected for each data item of the predetermined class ID in accordance with a combination of the acquired data content IDs and the data contents.