System for relational database retrieval through a link file built to access components of relational tables

• US 5,513,348 A
• Filed: 06/09/1995
• Issued: 04/30/1996
• Est. Priority Date: 10/17/1989
• Status: Expired due to Fees

• Current Assignee: Fujitsu Limited
• Original Assignee: Fujitsu Limited
• Inventors: Ryu, Tadamitsu, Takahara, Toshio, Matsumoto, Tohru, Hirono, Shingo
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): AMSBURY, WAYNE P
• Application Number:
  US08/488,859
• Time in Patent Office: 326 Days
• Field of Search: 395/600
• US Class Current: 1/1
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: Y10S 707/99931 Database or file accessing

Abstract

A data retrieval system for a relational database, for retrieving a relational table in a relational database having parts separately identifiable within the system. A link data file stores link data which include parts descriptors that describe command names assigned to parts located at table item positions of the relational table, attribute descriptors which which describe command names of parts arranged in a row of the relational table corresponding to the command names described by the parts descriptors, and mode descriptors which describe command names of parts arranged in a column of the relational table corresponding to the command names described by the parts descriptors. An actual data file is provided for storing actual data related to the command names of the parts which form the relational table. A link process responds to requests for retrieval from the relational table. The link process obtains a command name corresponding to a retrieval request by referring to the link data file and then obtains the actual data described by the command name, from the actual data file.

Claims

1. A data retrieval system for a relational database, for retrieving a relational table in the relational database of parts which form data, said data retrieval system comprising:

a link data file managing link data including parts sensors which describe command names assigned to parts located at table item positions of the relational table, attribute sensors which describe command names of parts arranged in a row direction of the relational table corresponding to the command names described by said parts sensors, and mode sensors which describe command names of parts arranged in a column direction of the relational table corresponding to the command names described by said parts sensors;

an actual data file for managing actual data, of the parts corresponding to the command names, which form the relational table; and

link processing means for linking said link data file and said actual data file, responsive to a retrieval request which requests retrieval of the relational table, for reading a command name description corresponding to a retrieval condition of the retrieval request by referring to said link data file, and for obtaining the actual data described by said command name description from said actual data file.

2. The data retrieval system as claimed in claim 1, further comprising a parts file, coupled to said link processing means, managing first attribute information of the parts managed by said actual data file and second attribute information of the parts sensors, the attribute sensors and the mode sensors using predetermined names respectively assigned to the first and second attribute information, said first attribute information including at least the command names managed by said actual data file, said second attribute information including at least the command names managed by said link data file.

3. The data retrieval receives system as claimed in claim 2, wherein said link processing means receives the retrieval request via said parts file.

4. The data retrieval system as claimed in claim 2, which further comprises a table, coupled to said link processing means, managing corresponding relationships of the command names and storage addresses of the command names in said link data file and said actual data file.

5. The data retrieval system as claimed in claim 1, further comprising an object data file, coupled to said link processing means, managing program addresses of application programs.

6. The data retrieval system as claimed in claim 5, wherein said retrieval request is made by a program specified by said object data file.

7. The data retrieval system as claimed in claim 1, wherein said link processing part includes means for modifying arbitrary data in the relational table by modifying command names in said link data file and/or said actual data file.

8. The data retrieval system as claimed in claim 1, wherein the retrieval condition of said retrieval request requests retrieval of only a portion of the relational table.

9. The data retrieval system as claimed in claim 8, wherein the retrieval condition of said retrieval request specifies one of a logical sum and a logical product of command names.

10. The data retrieval system as claimed in claim 1, which further comprises display means, coupled to said link processing means, for displaying the actual data described by said command name description.

11. A data retrieval system for retrieving requested data in a relational database having data referenced by parts including item parts referencing actual data and table parts referencing rows and columns of the item parts, said data retrieval system comprising:

an actual data storage storing actual data corresponding to command names;

a link data storage operatively connected to said actual data storage and storing link data including;

table descriptors describing command names of table parts;

row descriptors describing command names of parts in a same row in the relational database as the table parts described by the table descriptors; and

column descriptors describing command names of parts in a same column in the relational database as the table parts described by the table descriptors; and

link processing means for receiving a request for the requested data, accessing said link data storage to obtain the link data corresponding to the requested data, and accessing said actual data storage to obtain the actual data corresponding to the command names in the link data obtained from the link data storage.

12. A data retrieval system as claimed in claim 11, further comprising:

request means for requesting the requested data as a portion of a relational table in the relational database; and

display means for displaying the actual data obtained by said link processing means as the portion of the table requested by said request means.

13. A method of retrieving requested data in a relational database having data referenced by parts including item parts referencing actual data and table parts referencing rows and columns of the item parts, comprising the steps of:

(a) storing actual data corresponding to command names in an actual data storage;

(b) storing link data in a link data storage, the link data including;

table descriptors, describing command names of table parts;

row descriptors describing command names of parts in a same row in the relational database as the table parts described by the table descriptors; and

column descriptors describing command names of parts in a same column in the relational database as the table parts described by the table descriptors;

(c) reading the link data corresponding to the requested data from the link data storage; and

(d) reading the actual data corresponding to the command names in the link data read from the link storage, from the actual data storage.

14. A method as claimed in claim 13, additionally comprising step (e) of displaying the actual data obtained responsive to the requested data.