| 发明名称 |
OPTIMIZED QUERY PROCESSING USING AGGREGATES WITH VARYING GRAIN SIZES |
| 摘要 |
A computer-implemented method and system for querying aggregates in a database include maintaining aggregates based on a dimension in the database with at least two grain sizes; receiving a query of the aggregates for a defined range of the dimension; finding a start and an end for a read operation for a larger grain size of the at least two grain sizes of the aggregates for the defined range; reading a first set from the start to the end in the database of the larger grain size of the at least two grain sizes of the aggregates; reading a second set comprising a smaller grain size of the at least two grain sizes of the aggregates based on the defined range and the start and the end; and adjusting the first set with the second set. |
| 申请公布号 |
US2016048558(A1) |
申请公布日期 |
2016.02.18 |
| 申请号 |
US201414459802 |
申请日期 |
2014.08.14 |
| 申请人 |
KAILASH Kailash;PANGENI Sushil;BALAIAH Chakkaravarthy Periyasamy;REGOTI Lakshmaiah;GAURAV Kumar |
发明人 |
KAILASH Kailash;PANGENI Sushil;BALAIAH Chakkaravarthy Periyasamy;REGOTI Lakshmaiah;GAURAV Kumar |
| 分类号 |
G06F17/30 |
主分类号 |
G06F17/30 |
| 代理机构 |
|
代理人 |
|
| 主权项 |
1. A computer-implemented method for querying aggregates in a database, comprising:
maintaining aggregates based on a dimension in the database with at least two grain sizes; receiving a query of the aggregates for a defined range of the dimension; finding a start and an end for a read operation for a larger grain size of the at least two grain sizes of the aggregates for the defined range; reading a first set from the start to the end in the database of the larger grain size of the at least two grain sizes of the aggregates; reading a second set comprising a smaller grain size of the at least two grain sizes of the aggregates based on the defined range and the start and the end; and adjusting the first set with the second set. |
| 地址 |
San Jose CA US |
