Shrinked data marts enabled for negative caching

Publikation: Beitrag in Buch/Konferenzbericht/Sammelband/GutachtenBeitrag in KonferenzbandBeigetragenBegutachtung

Beitragende

Abstract

Data marts storing pre-aggregated data, prepared for further roll-ups, play an essential role in data warehouse environments and lead to significant performance gains in the query evaluation. However, in order to ensure the completeness of query results on the data mart without to access the underlying data warehouse, null values need to be stored explicitly; this process is denoted as negative caching. Such null values typically occur in multi-dimensional data sets, which are naturally very sparse. To our knowledge, there is no work on shrinking the null tuples in a multi-dimensional data set within ROLAP. For these tuples, we propose a lossless compression technique, leading to a dramatic reduction in size of the data mart. Queries depending on null value information can be answered with 100% precision by partially inflating the shrunken data mart. We complement our analytical approach with an experimental evaluation using real and synthetic data sets, and demonstrate our results.

Details

OriginalspracheEnglisch
TitelProceedings - 10th International Database Engineering and Applications Symposium, IDEAS 2006
Seiten148-157
Seitenumfang10
PublikationsstatusVeröffentlicht - 2006
Peer-Review-StatusJa

Publikationsreihe

ReiheInternational Symposium on Database Engineering and Applications (IDEAS)
ISSN1098-8068

Konferenz

Titel10th International Database Engineering and Applications Symposium, IDEAS 2006
Dauer11 - 14 Dezember 2006
StadtDelhi
LandIndien

Externe IDs

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

Schlagworte

Forschungsprofillinien der TU Dresden

Fächergruppen, Lehr- und Forschungsbereiche, Fachgebiete nach Destatis