Title :
Red Brick VistaTM: aggregate computation and management
Author :
Colby, Latha S. ; Cole, Richard L. ; Haslam, Edward ; Jazayeri, Nasi ; Johnson, Galt ; McKenna, William J. ; Schumacher, Lee ; Wilhite, David
Author_Institution :
Red Brick Syst. Inc., Los Gatos, CA, USA
Abstract :
Aggregate query processing in large data warehouses is computationally intensive. Precomputation is an approach that can be used to speed up aggregate queries. However, in order to make precomputation a truly viable solution to the aggregate query processing problem, it is important to identify the best set of aggregates to precompute and to use these precomputed aggregates effectively. The Red Brick aggregate computation and management system (Red Brick Vista) provides a complete server integrated solution to these problems
Keywords :
decision support systems; query processing; very large databases; Red Brick Vista; Red Brick aggregate computation; aggregate query processing; aggregate query processing problem; decision support applications; large data warehouses; management system; precomputation; precomputed aggregates; server integrated solution; Aggregates; Data warehouses; Information analysis; Knowledge management; Marketing and sales; Multidimensional systems; Navigation; Performance gain; Query processing; Relational databases;
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.655773
