DATABASE ACCESS SYSTEM AND RECORDING MEDIUM WHICH RECORDS PROGRAM FOR CONTROLLING THE SYSTEM

• US 20030145040A1
• Filed: 08/31/1999
• Published: 07/31/2003
• Est. Priority Date: 09/04/1998
• Status: Abandoned Application

• Current Assignee: Casio Computer Company Limited
• Original Assignee: Casio Computer Company Limited
• Inventors: IWADATE, AKIHITO, FUKUMURA, MASAAKI, TOHARA, TOSHIO
• Application Number:
  US09/387,426
• Publication Number:
  US 20030145040A1
• Time in Patent Office: Days
• US Class Current: 709/203
• CPC Class Codes: G06F 16/972 Access to data in other repository systems, e.g. legacy data or dynamic Web page generation
• CPC Class Codes: H04L 67/02 based on web technology, e.g. hypertext transfer protocol [HTTP]
• CPC Class Codes: H04L 69/329 in the application layer [OSI layer 7]
• CPC Class Codes: H04L 9/40 Network security protocols

Abstract

A data access system can access a plurality of database servers distrivitively arranged on a network. A user defines and records, with respect to each of the tables stored in a database, links from the table to another table stored in another database in a data link information file and the manner of displaying data in a specification file with her/his WWW client through a WWW server and the database server. The WWW server, when the user accesses a table stored in the database through the database server from her/his WWW client, refers the data link information file and detects the link to another table in the another database, and accesses the another table. It displays accessed data items of the another table in the manner defined in the corresponding one of the specification files.

Claims

1. A database access system which accesses tables contained in a plurality of databases distributively arranged on a network, said system comprising:

data link information defining means which defines, in a data link information file, a link from a table contained in one of the plurality of databases to another table in another database in the plurality of databases, with respect to each table contained in the plurality of databases which are distributively arranged on the network; and

database retrieval means which retrieves, when accessing a table contained in one of the plurality of databases, a link from the table to another table contained in another database in the plurality of databases, by referring to the data link information file, and which accesses the another table linked from the accessed table contained in the another database specified by the data link information file.

2. The system according to claim 1, further comprising a specification file defining means which defines, in a specification file, a method of displaying each data item included in each of the tables contained in the plurality of databases which are distributivey arranged on the network, and

wherein said database retrieval means controls, when accessing a table contained in the plurality of databases, a way of displaying each data item contained in the table, by referring to the specification file corresponding to the table.

3. The system according to claim 1, wherein:

said data link information file defining means, receives a request of defining link information from a World Wide Web (WWW) client, processes the request and sends back a processed result to the WWW client, based on a WWW interface; and

said database retrieval means receives and processes a request for accessing the table contained in the plurality of databases from the WWW client, on the basis of the WWW interface, and sends back a processed result to the WWW client.

4. The system according to claim 2, wherein:

said specification file defining means receives a request of defining link information from a World Wide Web (WWW) client, processes the request and sends back a processed result to the WWW client, based on a WWW interface; and

said database retrieval means receives and processes a request for accessing the table contained in the plurality of databases from the WWW client, on the basis of the WWW interface, and sends back a processed result to the WWW client.

5. The system according to claim 4, wherein each of said data link information file defining processor, the specification file defining processor and said database retrieval processor includes a part which can be executed on the WWW client.

6. A computer readable recording medium which records programs read out by a computer, said programs including:

a data link information definition function which defines, in a data link information file, a link from a table included in one of a plurality of databases to another table included in another database in the plurality of databases, with respect to each table contained in the plurality of databases which are distributively arranged on a network; and

a database retrieval process function which retrieves, when accessing a table contained in one of the plurality of databases, a link to a table included in another database in the plurality of databases, by referring to the data link information file, and which accesses the another table linked from the accessed table contained in the another database specified by the data link information file.

7. The computer readable recording medium according to claim 6, further comprising a specification file definition function which defines, in a specification file, a method of displaying each data item included in each table contained in a plurality of databases which are distributively arranged on the network, and

wherein said database retrieval definition function controls, when accessing a table included in the plurality of databases, a way of displaying each data item contained in the table, by referring to the specification file corresponding to the table.