Usage based aggregation optimization
Number of patents in Portfolio can not be more than 2000
United States of America Patent
Stats
-
Aug 20, 2002
Grant Date -
N/A
app pub date -
Jun 22, 1999
filing date -
Jun 22, 1999
priority date (Note) -
In Force
status (Latency Note)
Importance
Abstract
Designing aggregations according to a weighted benefit/cost ratio is disclosed. Usage statistics including frequency counts are maintained for queries issued to the system. The usage statistics determine the domain of potentially useful aggregations. The system maintains benefit and cost data for aggregations in terms of row scans saved and number of rows required to store an aggregation. In addition, query frequency counts are used to scale the aggregation benefit/cost for a set of aggregations. The weighted benefit/cost ration determines the aggregations to instantiate, thereby providing an optimal combination of performance and cost.
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