Performance optimization in a heterogeneous, distributed databas

Details Performance optimization in a heterogeneous, distributed databas Performance optimization in a heterogeneous, distributed databas

1997-10-29

1999-07-27

Kulik, Paul V.

Data processing: database and file management or data structures

Database design

Data structure types

707 2, 707 4, 39520031, 39520053, 39520057, G06F 15173

Patent

active

059307935

ABSTRACT:
The performance of a heterogeneous, distributed database system is optimized by supporting both block fetch operations and positioned update operations. Specifically, a data block is fetched from a target database management system (DBMS), and a positioned update instruction issued by a client is processed. The positioned update instruction, when executed by the target DBMS, enables the target DBMS to modify a row contained in the data block and addressed by a cursor as the cursor is perceived by the client. Also, performance of the database system is optimized by identifying database statements that reference invariant host variables, and modifying such database statements by replacing in the database statements the host variables with literal values equivalent to the host variables.

REFERENCES:
patent: 4714989 (1987-12-01), Billings
patent: 4714995 (1987-12-01), Materna et al.
patent: 4769772 (1988-09-01), Dwyer
patent: 4881166 (1988-11-01), Thompson et al.
patent: 5046002 (1991-09-01), Takashi et al.
patent: 5058000 (1991-10-01), Cox et al.
patent: 5142470 (1992-08-01), Bristow et al.
patent: 5161158 (1992-11-01), Chakravarty 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: 5381534 (1995-01-01), Shi
patent: 5452450 (1995-09-01), Delory
patent: 5561797 (1996-10-01), Gilles et al.
patent: 5581749 (1996-12-01), Hossain et al.
patent: 5581758 (1996-12-01), Burnett et al.
patent: 5630124 (1997-05-01), Coyle, Jr. et al.
Arbee L.P. Chen, A Localized Approach to Distributed Query Processing, Bell Communications Research, Piscataway, N.J., Mar. 26, 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.
T. Yu Clement 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," Microprocessing and Microprogramming, vol. 38, pp. 377-384, 1993.

Affiliated with

Also associated with

Rating

Performance optimization in a heterogeneous, distributed databas does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Performance optimization in a heterogeneous, distributed databas, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Performance optimization in a heterogeneous, distributed databas will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-892975