Relational database query optimization to perform query evaluati

Details Relational database query optimization to perform query evaluati Relational database query optimization to perform query evaluati

1997-06-30

2000-07-18

Fetting, Anton W.

Data processing: database and file management or data structures

Database design

Data structure types

707 3, 707 4, 707 5, 707103, G06F 1730

Patent

active

060920629

ABSTRACT:
A relational data base management system includes a query processor that uses a query operator partition property to perform QEP pruning and to ensure that data input to a query operator is partitioned appropriately for the operation. The partition property indicates the group of network nodes across which a table is distributed. The query processor also makes use of partition classes that are designated "interesting classes" to perform preoptimization planning and query pruning, and to perform look-ahead partitioning based on partition classes that are identified as being of interest to future operations, thereby more efficiently evaluating complex query statements in an MPP, shared-nothing environment.

REFERENCES:
patent: 5301317 (1994-04-01), Lohman et al.
patent: 5325525 (1994-06-01), Shan et al.
patent: 5440727 (1995-08-01), Bhide et al.
patent: 5548754 (1996-08-01), Pirahesh et al.
patent: 5551027 (1996-08-01), Choy et al.
patent: 5619692 (1997-04-01), Malkemus et al.
patent: 5745746 (1998-04-01), Jhingran et al.
patent: 5765146 (1998-06-01), Wolf et al.
patent: 5774692 (1998-06-01), Boyer et al.
patent: 5822747 (1998-10-01), Graefe et al.
patent: 5822750 (1998-10-01), Jou et al.
C.J. Date in An Introduction to Database Systems, 6th Ed., 1995, pp. 12, 349, 350, 353 & 367.

Affiliated with

Also associated with

Rating

Relational database query optimization to perform query evaluati does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Relational database query optimization to perform query evaluati, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Relational database query optimization to perform query evaluati will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2047778