Small materialized aggregates : a light weight index structure for data warehousing

Moerkotte, Guido

Preview

PDF
1998_01.pdf - Published
Download (961kB)

URL:	http://ub-madoc.bib.uni-mannheim.de/1745
URN:	urn:nbn:de:bsz:180-madoc-17456
Document Type:	Working paper
Year of publication:	1998
The title of a journal, publication series:	None
Publication language:	English
Institution:	School of Business Informatics and Mathematics > Sonstige - Fakultät für Wirtschaftsinformatik und Wirtschaftsmathematik
MADOC publication series:	Veröffentlichungen der Fakultät für Mathematik und Informatik > Institut für Informatik > Technical Reports
Subject:	004 Computer science, internet
Subject headings (SWD):	Data-Warehouse-Konzept
Abstract:	Small Materialized Aggregates (SMAs for short) are considered a highly flexible and versatile alternative for materialized data cubes. The basic idea is to compute many aggregate values for small to medium-sized buckets of tuples. These aggregates are then used to speed up query processing. We present the general idea and present an application of SMAs to the TPC-D benchmark. We show that application of SMAs to TPC-D Query 1 results in a speed up of two orders of magnitude. Then, we elaborate on the problem of query processing in the presence of SMAs. Last, we briefly discuss some further tuning possibilities for SMAs.
Additional information:

Das Dokument wird vom Publikationsserver der Universitätsbibliothek Mannheim bereitgestellt.

BASE: Moerkotte, Guido

Google Scholar: Moerkotte, Guido

Downloads per month over past year

You have found an error? Please let us know about your desired correction here: E-Mail

Show item