Commercial OLAP systems usually treat OLAP dimensions as static entities. In practice, dimension updates are often needed to adapt the warehouse to changing requirements. In earlier work, we defined a taxonomy for these dimension updates and a minimal set of operators to perform them. In this paper we present TSOLAP, an OLAP server supporting fully dynamic dimensions. TSOLAP conforms to the OLE DB for OLAP norm, so it can be used by any client application based on this norm, and can use as backend any conformant relational server. We incorporate dimension update support to MDX, Microsoft’s language for OLAP, and introduce TSShow, a visualization tool for dimensions and data cubes. Finally, we present the results of a real-life case study in the application of TSOLAP to a medium-sized medical center.
CITATION STYLE
Vaisman, A. A., Mendelzon, A. O., Ruaro, W., & Cymerman, S. G. (2002). Supporting dimension updates in an OLAP server. In Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics) (Vol. 2348, pp. 67–82). Springer Verlag. https://doi.org/10.1007/3-540-47961-9_8
Mendeley helps you to discover research relevant for your work.