Title :
Ending the ROLAP/MOLAP debate: usage based aggregation and flexible HOLAP
Author_Institution :
Microsoft Corp., Redmond, WA, USA
Abstract :
Summary form only given, as follows. Over the past few years, OLAP vendors have engaged in a debate regarding relational versus multidimensional data stores. This debate has obscured the more significant problems facing today´s OLAP customers: managing the exponential growth generated by multidimensional pre-aggregations, and architectural support for a wide array of OLAP data models. Microsoft discusses several aspects of its upcoming OLAP Server product, placing special emphasis on these areas. Solutions for managing voluminous pre-aggregates are discussed in the context of understanding of the dynamics of the data explosion problem, and a partial aggregation scheme that is adjusted according to user query needs. Flexible Hybrid OLAP is discussed as a compelling solution to a wide array of user needs and data requirements, with a focus on understanding the many different meanings associated with Hybrid OLAP and the strengths and weaknesses of each
Keywords :
data structures; distributed databases; relational databases; systems analysis; very large databases; OLAP Server product; OLAP customers; OLAP data models; OLAP vendors; ROLAP/MOLAP debate; architectural support; data explosion problem; data requirements; flexible HOLAP; flexible Hybrid OLAP; multidimensional data stores; multidimensional pre-aggregations; online analysis and processing; partial aggregation scheme; relational versus multidimensional data stores; usage based aggregation; user needs; user query needs; Aggregates; Explosions; Multidimensional systems;
Conference_Titel :
Data Engineering, 1998. Proceedings., 14th International Conference on
Conference_Location :
Orlando, FL
Print_ISBN :
0-8186-8289-2
DOI :
10.1109/ICDE.1998.655775