Data processing: database and file management or data structures – Database design – Data structure types
Patent
1997-08-29
1999-08-17
Amsbury, Wayne
Data processing: database and file management or data structures
Database design
Data structure types
707 3, 707101, G06F 1730
Patent
active
059408197
ABSTRACT:
A relational data base management system includes a query processor that permits consideration of alternative user-specified access paths, which the processor will validate and incorporate into the query execution plan it otherwise generates. The optimizer of the query processor retrieves user-specified data that defines an access path for a query during bind operations. Any access path parameters that are invalid are replaced with processor-selected values.
REFERENCES:
patent: 4531186 (1985-07-01), Knapman
patent: 5043872 (1991-08-01), Cheng et al.
patent: 5367675 (1994-11-01), Cheng et al.
patent: 5546570 (1996-08-01), McPherson, Jr. et al.
patent: 5546573 (1996-08-01), Obermann et al.
patent: 5548758 (1996-08-01), Pirahesh et al.
patent: 5822750 (1998-10-01), Jou et al.
P. G. Selinger et al., "Access Path Selection in Distributed Data Base Management Systems", Jul. 1980, pp. 204-215, International Conference on Data Bases, University of Aberdeen, Aberdeen, Scotland.
Beavin Thomas Abel
Haderle Donald J.
Shibamiya Akira
Tie Hong Sang
Wang Yun
Amsbury Wayne
Havan Thu-Thao
International Business Machines - Corporation
LandOfFree
User specification of query access paths in a relational 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 User specification of query access paths in a relational databas, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and User specification of query access paths in a relational databas will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-325736