Logo des Repositoriums
 

Transbase®: A leading-ege ROLAP engine supporting multidimentstional indexing and hierarchy clustering

dc.contributor.authorPieringer, R.
dc.contributor.authorElhardt, K.
dc.contributor.authorRamsak, F.
dc.contributor.authorMarkl, V.
dc.contributor.authorFenk, R.
dc.contributor.authorBayer, R.
dc.contributor.editorWeikum, Gerhard
dc.contributor.editorSchöning, Harald
dc.contributor.editorRahm, Erhard
dc.date.accessioned2019-11-14T12:34:31Z
dc.date.available2019-11-14T12:34:31Z
dc.date.issued2003
dc.description.abstractAnalysis-oriented database applications, such as data warehousing or customer relationship management, play a crucial role in the database area. In general, the multidimensional data model is used in these applications, realized as star or snow-flake schemata in the relational world. The so-called star queries are the prevalent type of queries on such schemata. All database vendors have extended their products to support star queries efficiently. However, mostly reporting queries benefit from the optimizations, like pre-aggregation, while ad-hoc queries usually lack efficient support. We present the DBMS Transbase® in this paper, which provides a new physical organization of the data based on hierarchical clustering and multidimensional clustering combined with multidimensional indexing. In combination with new query optimizations (e.g., hierarchical pre-grouping) significant performance improvements are achieved. The paper describes how the new technology is implemented in the Transbase® product and how it is made available to the user as transparently as possible. The benefits are illustrated with a real-world data warehousing scenario.en
dc.identifier.isbn3-88579-355-5
dc.identifier.pissn1617-5468
dc.identifier.urihttps://dl.gi.de/handle/20.500.12116/30088
dc.language.isoen
dc.publisherGesellschaft für Informatik e.V.
dc.relation.ispartofBTW 2003 – Datenbanksysteme für Business, Technologie und Web, Tagungsband der 10. BTW Konferenz
dc.relation.ispartofseriesLecture Notes in Informatics (LNI) - Proceedings, Volume P-26
dc.titleTransbase®: A leading-ege ROLAP engine supporting multidimentstional indexing and hierarchy clusteringen
dc.typeText/Conference Paper
gi.citation.endPage667
gi.citation.publisherPlaceBonn
gi.citation.startPage648
gi.conference.date26.-28. Februar 2003
gi.conference.locationLeipzig
gi.conference.sessiontitleRegular Research Papers

Dateien

Originalbündel
1 - 1 von 1
Lade...
Vorschaubild
Name:
GI-Proceedings.26-46.pdf
Größe:
298.6 KB
Format:
Adobe Portable Document Format