Data management system, that enables a user to connect existing data to an external file and a program to process that data

• US 5,842,198 A
• Filed: 04/10/1996
• Issued: 11/24/1998
• Est. Priority Date: 04/28/1995
• Status: Expired due to Term

• Current Assignee: Fuji Xerox Company Limited (Xerox Holdings Corp.)
• Original Assignee: Fuji Xerox Company Limited (Xerox Holdings Corp.)
• Inventors: Matsunaga, Yoshifumi, Suzuki, Toshikatsu, Ishima, Hiroyuki, Taniguchi, Shinichiro, Ishida, Eiji
• Primary Examiner(s): Amsbury, Wayne
• Application Number:
  US08/630,252
• Time in Patent Office: 958 Days
• Field of Search: 395/602, 395/603, 707/2, 707/3
• US Class Current: 1/1
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching

Abstract

A data management system which enables a user to flexibly make corresponding relation between data stored in a existing database, and a data file and a program for processing the data file, is disclosed. A user register in advance corresponding relation between a data unit stored in a existing database, and a data file and a program for processing the data file, both of which exist outside of said first database. After the retrieval of the data unit from the existing database, if the corresponding relation for the retrieved data unit is registered, the program related to the data unit is activated for processing the related data file in response to the user'"'"'s instruction.

Claims

1. In a computer system that includes a first database that stores a plurality of first data units, a plurality of data files, each data file existing outside of the first database, and at least one program, each program processing at least one of the data files and existing outside of the first database, a data management system comprising:

query input means for receiving a query;

database retrieval means for retrieving at least one first data unit from the first database according to the query received by the query input means;

an external relation database, provided separately from the first database, for storing at least one second data unit each second data unit including external relation information that associates one of the plurality of first data units stored in the first database with at least one of the data files and with at least one of the at least one program;

instruction receiving means for receiving an instruction;

external relation retrieval instruction means for giving the database retrieval means a retrieval instruction to retrieve at least one of the at least one second data unit from the external relation database, said database retrieval means further retrieving from said external relation database the second data unit corresponding to the first data unit retrieved from the first database;

program invoking means for invoking, in response to the instruction received by the instruction receiving means, at least one related program of the at least one program to process at least one related data file of the plurality of data files, the at least one related program and the at least one related data file associated with the at least one first data unit by the external relation information included in the retrieved second data unit.

2. A data management system as defined in claim 1, wherein:

the first data unit stored in the first database includes an identifier which identifies the first data unit, a data body which represents a main data, and a keyword to be used for retrieving the data unit,

the second data unit includes an identifier which identifies the second data unit, a data body which represents at least one data file name and at least one program name, and a keyword corresponding to the identifier of the first data unit stored in said first database,

the query input means receives a first search key as a query, said database retrieval means retrieving the first data unit having the keyword corresponding to the first search key from said first database,

said external relation retrieval instruction means generates a second search key corresponding to the identifier of the first data unit retrieved from said first database, and gives it to the database retrieval means as the retrieval instruction,

the database retrieval means further retrieves from said external relation database the at least one of the second data unit having the keyword corresponding to the second search key given by the external relation retrieval instruction means, and

said program invocation means invokes the at least one of the program to process the at least one related data file in accordance with the data file name and the program name included in the second data unit retrieved by said database retrieval means.

3. In a computer system that includes a first database that stores a plurality of data units, a plurality of data files, each data file existing outside of the first database, and at least one program, each program processing at least one of the plurality of data files and existing outside of the first database, a data management system comprising:

query input means for receiving a query;

database retrieval means for retrieving at least one data unit from the first database according to the query received by the query input means;

external relation storing means, provided separately from the first database, for storing at least one item of external relation information, each item associating at least one of the plurality of data units stored in the first database with at least one of the plurality of data files and with at least one of the at least one program;

instruction receiving means for receiving an instruction;

program invoking means for retrieving the item of external relation information associated with the at least one data unit retrieved by the database retrieval means, and for invoking, in response to the instruction received by the instruction receiving means, at least one related program of the at least one related program that processes at least one related data file of the plurality of data files, the at least one related program and the at least one related data file associated with the at least one data unit by the retrieved item of external relation information.

4. A data management system as defined in claim 3, wherein:

said external relation storing means stores the external relational information in a form of a table which includes at least one entry, each entry having an identifier corresponding to one of the plurality of data units stored in said first database, at least one data file name and at least one program name, and

said program invocation means retrieves from said external relation storing means at least one entry whose identifier corresponds to that of the at least one data unit retrieved by the database retrieval means, and invokes the at least one program to process the at least one related data file in accordance with the data file name and the program name included in the retrieved entry.

5. A data management system as defined in claim 3, further comprising file format relation storing means for storing file format relation which relates a file format to a program for processing a data file defined by the file format, wherein said program invocation means comprises:

file determining means for determining the at least one of the data files which is related to the first data unit retrieved by said database retrieval means in accordance with the external relational information stored in the external relationship storing means;

file format determining means for determining the file format corresponding to the at least one data file determined by said file determining means; and

program determining means for determining the it least one related program for processing the at least one related data file determined by said file determining means in accordance with the file format determined by said file format relation stored in said file format relation storing means.

6. A data management system as defined in claim 5, wherein

said external relation storing means further stores a file format corresponding to each of the data file, and

said file format determining means determines the file format by retrieving the file format corresponding to the data file determined by said file determining means from said external relation storing means.

7. A data management system as defined in claim 3, further comprising external relation editing means for adding a new item of external relational information to said external relationship storing means, and for modifying or eliminating the external relational information stored in said external relation storing means.

8. A data management system as defined in claim 3, further comprising an interface display means that includes:

a search key input area for inputting a search key as the query received by the query input means;

a database retrieval indicating area for indicating the retrieval of the data unit from said first database using the search key inputted in the search key input area, which is executed by said database retrieval means;

a retrieval result display area for displaying the content of the data unit retrieved by said database retrieving means; and

a program invocation indicating area for indicating the instruction to invoke the program related to the data unit displaying in said retrieval result display area, the instruction received by the instruction receiving means.

9. A data management system as defined in claim 8, wherein said program invocation indicating area accepts the indication only if the external relational information corresponding to the data unit retrieved from said first database exists.

10. A data management method for managing a first database that stores a plurality of data units, a plurality of data files, each data file existing outside of said first database, and at least one program, each program processing at least one of said data files and existing outside of said first database, the method comprising:

registering beforehand at least one item of external relational information, each item relating the data unit stored in said first database to at least one of the data files and at least one of the at least one program;

receiving a query;

retrieving at least one of the data units from said first database according to the query;

retrieving at least one item of the external relational information corresponding to the retrieved data unit from the at least one registered item of the external relational information;

receiving an instruction; and

invoking at least one related program for processing at least one related data file of the plurality of data files from the at least one program, the at least one related program and the at least one data file related to the retrieved data unit retrieved from the first database by the retrieved external relational information in response to the received instruction.

11. A data management method for managing a first database that stores a plurality of first data units, each first data unit including an identifier to identify the data unit, a data body which represents main data, and a keyword to retrieve the first data unit, a plurality of data files, each data file existing outside of said first database and at least one program, each program processing at least one of said data files and existing outside of said first database, the method comprising:

registering beforehand at least one item of external relational information, each item relating the data unit stored in said first database to at least one of the data files and at least one of the at least one program, each item of the external relational information in a form of a second data unit, the second data unit including an identifier to identify the second data unit, a file name and a program name as a data body, and a keyword to retrieve the second data unit corresponding to the identifier of the first data unit stored in the first database;

receiving a first search key;

retrieving from said first database at least one of the first data units having a keyword corresponding to the received first search key;

generating a second search key to retrieve the external relational information in accordance with the identifier of the first data unit retrieved from said first database;

retrieving at least one second data unit of the external relational information having a keyword corresponding to the second search key;

receiving an instruction; and

invoking at least one related program for processing at least one related data file of the data files of the at least one program, the at least one related program and the data file related to the first data unit retrieved from said first database by the retrieved external relational information in response to the received instruction.

12. A data management method for managing a first database that stores a plurality of data units, a plurality of data files, each data file existing outside of said first database, and at least one program, each program processing at least one of said data files and existing outside of said first database, the method comprising:

registering beforehand at least one item of external relational information each item relating one of the data units stored in the first database to at least one of the data files and at least one of the at least one program;

registering beforehand at least one item of file format relation, each item of file format relation relating a file format to a program for processing a data file defined by that file format;

receiving a query;

retrieving at least one of the data units from said first database in accordance with the query;

retrieving at least one item of the external relational information in accordance with the retrieved data unit from the at least one registered tem of the external relational information;

determining the file format of the data file which is related to the retrieved data unit by the retrieved external relational information;

retrieving the file format relation from the at least one registered item of file format relation in accordance with the determined file format;

receiving an instruction; and

invoking at least one related program related to the determined file format by the retrieved file format relation of the at least one program, the at least one related program processing at least one of the data files related to the data unit retrieved from the first database by the retrieved external relational information in response to the received instruction.