Method for integrating and accessing of heterogeneous data sources
First Claim
1. A data access method for use in a computer system in which a first computer and a second computer are connected via a network, in which secondary storage of said second computer contains first data composed of a plurality of records each composed of one or more columns, in which a first program accepting an inquiry issued from an application program to the first data is prepared in said first computer, and in which a second program performing input/output of the first data is prepared in said second computer, wherein the inquiry accepted by said first program includes a first search condition for one or more columns included in the first data, wherein said first program extracts a distributed index from the first data before the inquiry is accepted and maintains the distributed index, said distributed index indicating a correspondence between an index column composed of columns which are a part of records of the first data and a key column composed of columns which are arguments used to access said second program, converts the first search condition included in the inquiry upon accepting the inquiry and obtains from the distributed index a key column of records satisfying the first search condition, and accesses the first data using the key column via the second program to obtain the records satisfying the first search condition and returns the records to the application program as a result of the inquiry.
1 Assignment
0 Petitions
Accused Products
Abstract
A method for integrating data, stored not only in a relational database management system but also in data sources such as legacy application programs or tertiary storage where inquiry cannot be executed efficiently, and for performing inquiry quickly. A distributed index for use by a data source is generated in a database hub in advance, and a distribution index application unit converts and disassembles an inquiry using the distributed index.
10 Citations
17 Claims
-
1. A data access method for use in a computer system in which a first computer and a second computer are connected via a network, in which secondary storage of said second computer contains first data composed of a plurality of records each composed of one or more columns, in which a first program accepting an inquiry issued from an application program to the first data is prepared in said first computer, and in which a second program performing input/output of the first data is prepared in said second computer,
wherein the inquiry accepted by said first program includes a first search condition for one or more columns included in the first data, wherein said first program extracts a distributed index from the first data before the inquiry is accepted and maintains the distributed index, said distributed index indicating a correspondence between an index column composed of columns which are a part of records of the first data and a key column composed of columns which are arguments used to access said second program, converts the first search condition included in the inquiry upon accepting the inquiry and obtains from the distributed index a key column of records satisfying the first search condition, and accesses the first data using the key column via the second program to obtain the records satisfying the first search condition and returns the records to the application program as a result of the inquiry.
-
5. A data access method for use in a computer system in which a first computer and a second computer are connected via a network, in which secondary storage of said second computer contains first data composed of a plurality of records each composed of one or more columns, in which a first program accepting an inquiry issued from an application program to the first data is prepared in said first computer, and in which a second program performing input/output of the first data is prepared in said second computer,
wherein said first program extracts a plurality of distributed indexes from the first data and maintains the distributed indexes, each of said plurality of distributed indexes indicating a correspondence between an index column composed of columns which are a part of records of the first data and a key column composed of columns which are arguments used to access said second program, wherein the application program issues the inquiry including a first search condition for one or more columns included in the first data, as well as information specifying a permitted distributed index that may be used in the inquiry, said permitted distributed index being one of the plurality of distributed indexes, and wherein, upon accepting the inquiry, said first program converts the first search condition included in the inquiry and obtains, from the permitted distributed index, a key column of the records satisfying the first search condition, and accesses the first data using the key column via the second program to obtain the records satisfying the first search condition and returns the records to the application program as a result of the inquiry.
-
10. A distributed index creation method for creating a distributed index used for accessing first data and stored in a first computer, said method being used in a computer system in which said first computer and a second computer are connected via a network, in which secondary storage of said second computer contains the first data composed of a plurality of records each composed of one or more columns, in which a first program accepting an inquiry issued from an application program to the first data is prepared in said first computer, and in which a second program performing input/output of the first data is prepared in said second computer,
wherein a distributed index creation program prepared in said second computer accepts a distributed index creation request from said first program, and wherein said distributed index creation program obtains a correspondence between an index column composed of columns which are a part of records of the first data for which said distributed index is to be created and a key column composed of columns which are arguments used by said second program to access the first data, and returns an obtained result to said first program.
-
16. A distributed index creation method for use in a computer system in which a first computer and a second computer are connected via a network, in which secondary storage of said second computer contains first data composed of a plurality of records each composed of one or more columns, in which a first program accepting an inquiry issued from an application program to the first data is prepared in said first computer, in which a second program performing input/output of the first data is prepared in said second computer, in which said first computer maintains a distributed index indicating a correspondence between an index column composed of first columns which are a part of records of the first data and a key column composed of second columns which are arguments used to access said second program, and in which, when the inquiry is accepted, said first program obtains a key column of records satisfying the inquiry from the distributed index and accesses the first data using the key column via the second program,
wherein, when a request to create said distributed index is received from the application program, said first program references data source information on the first data to determine an index column and a key column and creates said distributed index with the determined index column and the key column specified for the distributed index creation program prepared in said second computer.
Specification