Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
1997-09-25
2002-03-12
Homere, Jean R. (Department: 2177)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000
Reexamination Certificate
active
06356912
ABSTRACT:
DESCRIPTION
1. Technical Field
The present invention relates generally to computer database systems, and more particularly to functional compensation in a heterogeneous, distributed database environment.
2. Background Art
In modern data processing environments, a client's data is often distributed among a plurality of heterogeneous database systems (more precisely, a client's data is distributed among a plurality of database instances which were instantiated from different database management systems). “Heterogeneous database systems” are database systems that have different data definition and manipulation procedures, security procedures, system management approaches, capabilities, etc. Examples of “heterogeneous database systems” include DB2 produced by International Business machines (IBM) Corporation, oracle produced by Oracle Corp., Sybase produced by Sybase Inc., etc. Such heterogeneous database systems, when used together, collectively represent a heterogeneous, distributed database environment (or system). Heterogeneous, distributed database systems are also sometimes called federated database systems and/or multi-database systems.
In order to enhance user-friendliness, it is preferred that clients be provided with a common interface to all of the heterogeneous database systems (heterogeneous database systems to which a client is not directly connected are called back-end database systems, or simply back-ends). In other words, it is preferred that clients be under the illusion that they are interacting with a single database system.
One conventional approach for achieving this goal is to introduce an interface module between the clients and the back-end database systems. This interface module, also called database middleware or data access middleware, attempts to provide to clients transparent access to the back-end database systems. Generally speaking, the interface module receives data definition and manipulation instructions from clients. The interface module translates these instructions such that they are understandable to the appropriate back-end database systems, and then transfers the translated instructions to the appropriate back-end database systems. Similarly, the interface module translates information and messages received from the back-end database systems such that they are understandable to the appropriate clients, and then transfers the translated information and messages to the appropriate clients.
Generally, back-end database systems support different sets of functions. For example, some back-end database systems (such as DB2) support the declaration of cursors “with hold”. Other back-end database systems (such as current versions of Oracle and Sybase) do not support this function.
Some conventional interface modules address this functional dissimilarity problem by relying on a “least-common denominator” approach wherein the only functions that are supported are those functions that are supported by all of the back-ends. This is not an optimal approach, however, because it does not allow clients to take advantage of all of the functions offered by all of the back-ends.
Other conventional interface modules address the functional dissimilarity problem by disallowing the use of functions when operating with back-ends that do not support the functions. Such functions are allowed when operating with back-ends that do support the functions. This is not an optimal approach, however, since it violates location transparency. That is, clients must be aware of which back-ends they are interacting with.
Thus, what is needed is an improved system and method for addressing the functional dissimilarity problem in a heterogeneous, distributed database environment.
DISCLOSURE OF INVENTION
The present invention is directed to a system and method of compensating for functional differences between heterogeneous database management systems, wherein data associated with a client is distributed among the heterogeneous database management systems. The present invention simulates support of multiple pending actions on a single connection in any of the heterogeneous database management systems which does not support multiple pending actions on a single connection. Also, the present invention: (1) simulates support of cursors declared “with hold” in any of the heterogeneous database management systems which does not support cursors declared “with hold”; (2) simulates support of positioned update actions in any of the heterogeneous database management systems which does not support positioned update actions; (3) simulates support of host variables in any of the heterogeneous database management systems which does not support host variables; and (4) compensates for security log-in procedure differences between the heterogeneous database management systems.
Further features and advantages of the present invention, as well as the structure and operation of various embodiments of the present invention, are described in detail below with reference to the accompanying drawings. In the drawings, like reference numbers indicate identical or functionally similar elements.
REFERENCES:
patent: 4714989 (1987-12-01), Billings
patent: 4714995 (1987-12-01), Materna et al.
patent: 4881166 (1989-11-01), Thompson et al.
patent: 5046002 (1991-09-01), Takashi et al.
patent: 5058000 (1991-10-01), Cox
patent: 5142470 (1992-08-01), Bristow et al.
patent: 5161158 (1992-11-01), Chakravorty et al.
patent: 5239577 (1993-08-01), Bates et al.
patent: 5247664 (1993-09-01), Thompson et al.
patent: 5257366 (1993-10-01), Adair et al.
patent: 5278978 (1994-01-01), Demers et al.
patent: 5301302 (1994-04-01), Blackard et al.
patent: 5345587 (1994-09-01), Fehskens et al.
patent: 5375207 (1994-12-01), Blakely et al.
patent: 5381534 (1995-01-01), Shi
patent: 5390320 (1995-02-01), Smithline
patent: 5416917 (1995-05-01), Adair et al.
patent: 5459860 (1995-10-01), Burnett et al.
patent: 5493671 (1996-02-01), Pitt et al.
patent: 5522066 (1996-05-01), Lu
patent: 5561797 (1996-10-01), Gilles et al.
patent: 5581749 (1996-12-01), Hossian et al.
patent: 5581758 (1996-12-01), Burnett et al.
patent: 5640550 (1997-06-01), Coker
patent: 5689633 (1997-11-01), Cotner et al.
Arbee L. P. Chen, “A Localized Approach to Distributed Query Processing,” Published in the Proceedings of the International Conference on Extending Database Technology, Venice, Italy, Mar. 26-30, 1990, pp. 188-202.
S.M. Deen et al., “Query Decomposition in PRECI*,” Distributed Data Sharing Systems, Elsevier Science Publishers B.V. (North Holland), pp. 91-103, 1985.
M. Rusinkiewicz et al., “Query Transformation in Heterogeneous Distributed Database Systems,” IEEE, pp. 300-307, 1985.
Clement, T. Yu et al., “Query Processing in a Fragmented Relational Distributed System: Mermaid,” IEEE Trans. on Software Engineering, vol. SE-11, No. 8, pp. 795-810, Aug. 1985.
M. Rusinkiewicz et al., “An Approach to Query Processing in Federated Database Systems,” Proc. of the Twentieth Annual Hawaii Intl' Conf. on System Sciences, pp. 430-440, 1987.
S. Kang et al., “Global Query Management in Heterogeneous Distributed Database Systems,”Microproccessing and Microprogramming,vol. 38, pp. 377-384, 1993.
Kleewein James C.
Lin Eileen T.
Wang Yun
Gates & Cooper LLP
Homere Jean R.
International Business Machines - Corporation
LandOfFree
Compensation for different connection and cursor... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Compensation for different connection and cursor..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Compensation for different connection and cursor... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2827210