Method for efficient query execution using dynamic queries...

Details Method for efficient query execution using dynamic queries... Method for efficient query execution using dynamic queries...

2007-10-09

2007-10-09

Truong, Cam Y T (Department: 2162)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

10830584

ABSTRACT:
A system and method allowing for optimization of query execution in database environments is provided. In an illustrative implementation, a database having distributed partitioned views is provided such that queries may initiate at any of the participating data stores. In operation, an offered query is analyzed to determine if it has predicate expression and/or sub-queries. Using this information the expressions and/or sub-queries are analyzed and processed to determine if appropriate start-up filters are available for the offered query. The start-up filters are applied to the query such that during compile and/or run time, redundant partitions in the distributed partitioned database environment are eliminated during query execution.

REFERENCES:
patent: 4845658 (1989-07-01), Gifford
patent: 5412804 (1995-05-01), Krishna
patent: 5600831 (1997-02-01), Levy et al.
patent: 5666528 (1997-09-01), Thai
patent: 5740440 (1998-04-01), West
patent: 5893125 (1999-04-01), Shostak
patent: 5960427 (1999-09-01), Goel et al.
patent: 6275818 (2001-08-01), Subramanian et al.
patent: 6604100 (2003-08-01), Fernandez et al.
patent: 6785668 (2004-08-01), Polo et al.
patent: 6996557 (2006-02-01), Leung et al.

Affiliated with

Also associated with

Rating

Method for efficient query execution using dynamic queries... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method for efficient query execution using dynamic queries..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method for efficient query execution using dynamic queries... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3868687