Query transformation for union all view join queries using join predicates for pruning and distribution
Number of patents in Portfolio can not be more than 2000
United States of America Patent
Stats
-
Mar 6, 2007
Grant Date -
Mar 24, 2005
app pub date -
Sep 24, 2003
filing date -
Sep 24, 2003
priority date (Note) -
In Force
status (Latency Note)
Importance
Abstract
A method, apparatus, and article of manufacture for optimizing a query in a computer system, wherein the query is performed by the computer system to retrieve data from a database stored on the computer system. The optimization includes: (a) combining join predicates from a query with local predicates from each branch of one or more UNION ALL views referenced by the query; (b) analyzing the combined predicates; and (c) not generating the join when the analysis step indicates that the combined predicates lead to an empty result.
First Claim
Family
International Classification(s)
Cited Art Landscape
Patent Citation Ranking
Advertisement
Advertisement
Advertisement
Recipient Email Address
Recipient Email Address
Comment
Recipient Email Address
Add to Portfolio(s)
To add this patent to one, or more, of your portfolios, simply click the add button.
This Patent is in these Portfolios:
Add to additional portfolios:
Last Refreshed On:
Changes done successfully