Method for minimizing the number of sorts required for a query block containing window functions
Number of patents in Portfolio can not be more than 2000
United States of America Patent
Stats
-
May 14, 2002
Grant Date -
N/A
app pub date -
Sep 7, 2000
filing date -
Sep 7, 2000
priority date (Note) -
In Force
status (Latency Note)
Importance
Abstract
Techniques are described for reducing the number of sort operations required for a query that contains window functions. The techniques involves determining a set of Partition By and Order By clause pairs that corresponds to the set of window functions and then grouping the Partition By and Order By clause pairs into Ordering Groups where each Ordering Group may be satisfied by a single sort operation. From the set of Ordering Groups, a minimal set of Ordering Groups is determined. The techniques account for the interaction of orderings from Group By and Order By clauses in the query block.
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