Optimistic coarse-grained cache semantics for data marts
Research output: Contribution to book/Conference proceedings/Anthology/Report › Conference contribution › Contributed › peer-review
Contributors
Abstract
Data marts and caching are two closely related concepts in the domain of multi-dimensional data. Both store precomputed data to provide fast response times for complex OLAP queries, and for both it must be guaranteed that every query can be completely processed. However, they differ extremely in their update behaviour which we utilise to build a specific data mart extended by cache semantics. In this paper, we introduce a novel cache exploitation concept for data marts - coarse-grained caching - in which the contalnedness check for a multi-dimensional query is done through the comparison of the expected and the actual cardinalities. Therefore, we subdivide the multi-dimensional data into coarse partitions, the so called cubletets, which allow to specify the completeness criteria for incoming queries. We show that during query processing, the completeness check is done with no additional costs.
Details
| Original language | English |
|---|---|
| Title of host publication | Proceedings - 18th International Conference on Scientific and Statistical Database Management, SSDBM 2006 |
| Pages | 311-320 |
| Number of pages | 10 |
| Publication status | Published - 2006 |
| Peer-reviewed | Yes |
Publication series
| Series | Proceedings of the International Conference on Scientific and Statistical Database Management, SSDBM |
|---|---|
| ISSN | 1099-3371 |
Conference
| Title | 18th International Conference on Scientific and Statistical Database Management, SSDBM 2006 |
|---|---|
| Duration | 3 - 5 July 2006 |
| City | Vienna |
| Country | Australia |
External IDs
| ORCID | /0000-0001-8107-2775/work/200630405 |
|---|