Optimistic coarse-grained cache semantics for data marts

Research output: Contribution to book/Conference proceedings/Anthology/ReportConference contributionContributedpeer-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 languageEnglish
Title of host publicationProceedings - 18th International Conference on Scientific and Statistical Database Management, SSDBM 2006
Pages311-320
Number of pages10
Publication statusPublished - 2006
Peer-reviewedYes

Publication series

SeriesProceedings of the International Conference on Scientific and Statistical Database Management, SSDBM
ISSN1099-3371

Conference

Title18th International Conference on Scientific and Statistical Database Management, SSDBM 2006
Duration3 - 5 July 2006
CityVienna
CountryAustralia

External IDs

ORCID /0000-0001-8107-2775/work/200630405

Keywords

Research priority areas of TU Dresden

DFG Classification of Subject Areas according to Review Boards

Subject groups, research areas, subject areas according to Destatis

ASJC Scopus subject areas