Information management system and method
View Patent ↗To obtain information having a relation, it is required for an application program to execute retrieval processing in which the program first acquires key information supervising relations between tables to sequentially trace the relations to finally obtain the target information. Since it is required for the program to execute as many access operations as there are hierarchic level of relations, the access efficiency is lowered. By establishing a correspondence between first relating information representing relations between a first table and a second table and second relating information, path information representing hierarchic structure of data between a plurality of tables is stored in a storage. Various processings are executed by use of the path information.
1. An information management method in an information management apparatus having an information processor which performs a retrieval process based on information input via an input unit and information stored in a storage unit, the method performed by the information processor comprising the steps of:
preparing plural relating pin tables, each of which includes plural records for associating parent key information with child key information, and storing the plural relating pin tables in the storage unit;
preparing plural access path tables, each of which hierarchically links between the plural relating pin tables, and storing the plural access path tables in the storage unit;
obtaining parent key information and child key information, both of which are input via the input unit;
referring to the plural relating pin tables, specifying a first relating pin table stored therein including the input parent key information and a second relating pin table stored therein including the input child key information;
referring to the plural access path tables, retrieving access path tables including the first relating pin table and the second relating pin table;
if more than two access path tables are retrieved in the access path tables retrieving step, specifying, from the retrieved access path tables, one access path table having a shortest distance between a first hierarchic level to which the input parent key information belongs and a second hierarchic level to which the input child key information belongs; and
performing a retrieval process based on the specified access path table, the input parent key information, and the input child key information.
2. The information management method according to claim 1 ,
further comprising the step of:
obtaining identifiers of the relating pin tables via the input unit,
wherein the information processor performs the retrieval process based on the input parent key information, the input child key information, and the relating pin tables identified by the obtained identifiers.
3. The information management method according to claim 1 , further comprising the step of:
obtaining an identifier of the access path table via the input unit,
wherein the information processor performs the retrieval process based on the input parent key information, the input child key information, the access path table identified by the obtained identifier.
4. The information management method according to claim 2 , further comprising the step of:
obtaining relating pin effective period information via the input unit,
wherein each relating pin is stored with its effective period information in the storage unit, and
the information processor performs the retrieval process based on the input parent key information, the input child key information, the relating pin tables identified by the obtained identifiers and the obtained period information.
5. An information management apparatus comprising:
an input unit;
a storage unit; and
an information processor which performs a retrieval process based on information input via the input unit and information stored in the storage unit; wherein the storage unit stores plural relating pin tables, each of which includes plural records for associating parent key information with child key information in the storage unit, and plural access path tables, each of which hierarchically links between the plural relating pin tables;
wherein the information processor:
obtains parent key information and child key information, both of which are input via the input unit;
referring to the plural relating pin tables, specifies a first relating pin table including the input parent key information and a second relating pin table including the input child key information;
referring to the plural access path tables, retrieves access path tables including the first relating pin table and the second relating pin table;
if more than two access path tables are retrieved, specifies, from the retrieved access path tables, one access path table having a shortest distance between a first hierarchic level to which the input parent key information belongs and a second hierarchic level to which the input child key information belongs; and
performs a retrieval process based on the specified access path table, the input parent key information, and the input child key information.
6. The information management apparatus according to claim 5 , wherein
the information processor obtains identifiers of the relating pin tables via the input unit, and
performs the retrieval process based on the input parent key information, the input child key information, and the relating pin tables identified by the obtained identifiers.
7. The information management apparatus according to claim 5 ,
wherein
the information processor obtains an identifier of the access path table via the input unit, and
performs the retrieval process based on the input parent key information, the input child key information, and the access path table identified by the obtained identifier.
8. The information management apparatus according to claim 6 ,
wherein:
the storage unit stores each relating pin with its effective period information, and
the information processor obtains effective period information via the input unit, and performs the retrieval process based on the input parent key information, the input child key information, the relating pin tables identified by the obtained identifiers and the obtained effective period information.