Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
1997-07-31
2001-07-31
Vu, Kim (Department: 2172)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000
Reexamination Certificate
active
06269365
ABSTRACT:
BACKGROUND OF THE INVENTION
The present invention relates to an integrated database system having as a purpose to perform data processing utilizing a plurality of different databases.
A requirement to share or to commonly use databases is widely encountered within an organization, among organizations or among individuals. Further, because of the prevalence of wide-spread networks, regions sharing a group of databases are also extended. In such an environment, various attempts have already been made to realize sharing and common use of databases or practical commercialization within a limited area.
In order to enable sharing and common use of the group of databases not only within the aforementioned limited area, but also in a wider area, it is necessary to realize a multi-database system suitable for an environment where a large number of database systems are connected via a wide-spread high-speed computer network. Moreover, the cost of constructing such multi-database system must be as low as possible, and in addition, the multi-database system must be able to change freely after being constructed, and must be flexible in terms of necessary maintenance.
Herein, the “multi-database system” is a general term for a system which widely realizes data sharing within a distributed system or in a network system. The environment constructed by the multi-database system will be called “multi-database environment.”
However, when a database is shared and commonly used, the following problems arise in general:
1. Data included in different databases may have different meanings even if the data is represented by the same representation form;
2. Vice versa to the above-mentioned problem 1, data included in different databases may be represented by different styles even if the data have the same meaning;
3. Although establishing a conventional manner of combining data is possible among different databases, the representation forms with regard to combining attributes may nonetheless be different. Herein, the term “conventional manner of combining data” means combining processing realized by pattern matching that has been adopted by the conventional database system, and the combining attributes mean attributes of interest at the time of combining);
4. Databases subjected to integration may lack necessary data for the combining process; and
5. Even if different types of plural databases are combined, new data cannot be generated therefrom.
As a partial solution to the above-described problems 1 to 4, the following processes have conventionally been executed:
1) To transform or absorb the difference in meanings of the data, difference in the representation forms, difference in the combining attributes and the like, codes are incorporated in an application program; and
2) To compensate for lacking data, the lacking data is incorporated in the application program as data or as a constant value, alternatively a database which compensates for the lacking data is newly added.
However, as a result of the above solution, the following problems are further raised:
6. The aforementioned application program is generated independently each time a command related to sharing and common use of the database is sent; thus, responding to the command takes time;
7. When the aforementioned command related to sharing and common use of the database is changed, for most cases, it is difficult or impossible to reuse the aforementioned application program.
SUMMARY OF THE INVENTION
The present invention has been made in consideration of the above situation, and has as its object to provide an integrated database system capable of retrieving desired information from a plurality of different databases by combining necessary databases.
Another object of the present invention is to provide an integrated database system which can standardize a retrieving operation (retrieval) performed by users, regardless of difference or changes in structure of the database system.
According to the present invention, the foregoing object is attained by providing a data processing system capable of referring to plural types of databases, the data processing system including an upper-level system and a lower-level system, the upper-level system comprising: control data issue means for interpreting an inquiry represented by a first representation form addressed to one of the plural types of databases and issuing control data represented by a second representation form; and output means for receiving from the lower-level system a reply to the inquiry represented by the second representation form, transforming the reply into the first representation form, and outputting the transformed reply, and the lower-level system comprising: command output means for transforming the control data, which is represented by the second representation form and issued by the control data issue means, into a control command corresponding to the type of a database and outputting the transformed control command to at least one of the plural types of databases; and reply means for providing the upper-level system with a process result of the control command obtained from at least one of the plural types of databases, as a reply represented by the second representation form.
Furthermore, according to the present invention, the foregoing object is attained by providing a data processing method of a data processing system capable of referring to plural types of databases, the data processing system including an upper-level system and a lower-level system, comprising: a control-data issuing step of, in the upper-level, interpreting an inquiry represented by a first representation form addressed to one of the plural types of databases and issuing control data represented by a second representation form; a command outputting step of, in the lower-level, transforming the control data represented by the second representation form into a control command corresponding to the type of a database and outputting the transformed control command to at least one of the plural types of databases; a replying step of, in the lower-level system, providing the upper-level system with a process result of the control command obtained from at least one of the plural types of databases, as a reply represented by the second representation form; and an outputting step of, in the upper-level system, receiving from the lower-level system the reply to the inquiry represented by the second representation form, transforming the reply into the first representation form, and outputting the transformed reply.
Other features and advantages of the present invention will be apparent from the following description taken in conjunction with the accompanying drawings, in which like reference characters designate the same or similar parts throughout the figures thereof.
REFERENCES:
patent: 5325465 (1994-06-01), Hung et al.
patent: 5442791 (1995-08-01), Wrabetz et al.
patent: 5475836 (1995-12-01), Harris et al.
patent: 5537590 (1996-07-01), Amado
patent: 5584026 (1996-12-01), Knudsen et al.
patent: 5590321 (1996-12-01), Lin et al.
patent: 5596744 (1997-01-01), Dao et al.
patent: 5754845 (1998-05-01), White
patent: 5884306 (1999-03-01), Bliss et al.
Huang J-W: “Multibase: A Heterogenous Multidatabase Management System” Proceedings of the Annual International Computer Software and Applications Conference (COMPSAC), Taipei, Nov. 9-11, 1994, No. Conf. 18, Nov. 9, 1994, pp. 332-339, XP000531333 Institute of Electrical and Electronics Engineers.
Owrang M et al: “Translation of Queries to Account for Different DBMSS” Proceedings of the National Computer Conference, Chicago, Jun. 15-18, 1987, No. vol. 56, Jun. 15, 1987, pp 637, 639-643, XP000011451 American Federation of Information Processing Societies, pp 641, col. 1, line 1—p. 643, col. 1, line 33.
Kitagawa Takashi
Kiyoki Yasushi
Canon Kabushiki Kaisha
Fitzpatrick ,Cella, Harper & Scinto
Kindred Alford W.
Vu Kim
LandOfFree
Integrated database system does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Integrated database system, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Integrated database system will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2547172