Results 1 - 10 of 2,329

Implementing data cubes efficiently

by Venky Harinarayan, Anand Rajaraman, Jeffrey D. Ulman - In SIGMOD , 1996
"... Decision support applications involve complex queries on very large databases. Since response times should be small, query optimization is critical. Users typically view the data as multidimensional data cubes. Each cell of the data cube is a view consisting of an aggregation of interest, like total ..."
Abstract - Cited by 548 (1 self) - Add to MetaCart
Decision support applications involve complex queries on very large databases. Since response times should be small, query optimization is critical. Users typically view the data as multidimensional data cubes. Each cell of the data cube is a view consisting of an aggregation of interest, like

Data cube: A relational aggregation operator generalizing group-by, cross-tab, and sub-totals

by Jim Gray, Adam Bosworth, Andrew Layman, Don Reichart, Hamid Pirahesh , 1996
"... Abstract. Data analysis applications typically aggregate data across many dimensions looking for anomalies or unusual patterns. The SQL aggregate functions and the GROUP BY operator produce zero-dimensional or one-dimensional aggregates. Applications need the N-dimensional generalization of these op ..."
Abstract - Cited by 860 (11 self) - Add to MetaCart
of these operators. This paper defines that operator, called the data cube or simply cube. The cube operator generalizes the histogram, crosstabulation, roll-up, drill-down, and sub-total constructs found in most report writers. The novelty is that cubes are relations. Consequently, the cube operator can be imbedded

The Dynamic Data Cube

by S. Geffner, D. Agrawal, A. El Abbadi, Srikant [hams Have , 2000
"... Range sum queries on data cubes are a powerful tool for analysis. A range sum query applies an aggregation operation (e.g., SUM, AVERAGE) over all selected cells in a data cube, where the selection is specified by providing ranges of values for numeric dimensions. We present the Dynamic Data Cube, a ..."
Abstract - Cited by 70 (6 self) - Add to MetaCart
Range sum queries on data cubes are a powerful tool for analysis. A range sum query applies an aggregation operation (e.g., SUM, AVERAGE) over all selected cells in a data cube, where the selection is specified by providing ranges of values for numeric dimensions. We present the Dynamic Data Cube

The Computation of Semantic Data Cube

by Yubao Liu, Jian Yin
"... Abstract. The multidimensional analysis based on data cube has been growing interest. However existing data cube model usually does not have the semantics of attributes and hence the analysis usually provides results with raw numbers and ignores the real meanings of these numbers. An example result ..."
Abstract - Add to MetaCart
Abstract. The multidimensional analysis based on data cube has been growing interest. However existing data cube model usually does not have the semantics of attributes and hence the analysis usually provides results with raw numbers and ignores the real meanings of these numbers. An example result

The Iterative Data Cube

by Mirek Riedewald, Divyakant Agrawal, Amr El Abbadi
"... . Data cubes provide aggregate information to support the analysis of the contents of data warehouses and databases. An important tool to analyze data in data cubes is the range query. For range queries that summarize large regions of massive data cubes, computing the query result on-the-fly can ..."
Abstract - Add to MetaCart
. Data cubes provide aggregate information to support the analysis of the contents of data warehouses and databases. An important tool to analyze data in data cubes is the range query. For range queries that summarize large regions of massive data cubes, computing the query result on-the-fly can

Nested Data Cubes for OLAP

by Stijn Dekeyser, Bart Kuijpers, Jan Paredaens, Jef Wijsen - LNCS 1552, Advances in Database Technologies , 1998
"... We present a new model for OLAP, called the nested data cube (NDC) model. Nested data cubes are a generalization of other OLAP models such as f-tables [3], and hypercubes [2], but also of classical structures such as sets, bags, and relations. The model we propose adds to the previous models mainly ..."
Abstract - Cited by 5 (1 self) - Add to MetaCart
We present a new model for OLAP, called the nested data cube (NDC) model. Nested data cubes are a generalization of other OLAP models such as f-tables [3], and hypercubes [2], but also of classical structures such as sets, bags, and relations. The model we propose adds to the previous models

Range Queries in OLAP Data Cubes

by Ching-Tien Ho, Rakesh Agrawal, Nimrod Megiddo, Ramakrishnan Srikant - In Proceedings of the 1997 ACM SIGMOD International Conference on Management of Data , 1997
"... A range query applies an aggregation operation over all selected cells of an OLAP data cube where the selection is specified by providing ranges of values for numeric dimensions. We present fast algorithms for range queries for two types of aggregation operations: SUM and MAX. These two operations c ..."
Abstract - Cited by 64 (1 self) - Add to MetaCart
A range query applies an aggregation operation over all selected cells of an OLAP data cube where the selection is specified by providing ranges of values for numeric dimensions. We present fast algorithms for range queries for two types of aggregation operations: SUM and MAX. These two operations

Dynamic Assembly of Views in Data Cubes

by John R. Smith, Vittorio Castelli, Anant Jhingran, Chung-Sheng Li - In Seventeenth ACM Symposium on Principles of Database Systems , 1998
"... In this paper, we present a method for dynamically assembling views in multi-dimensional data cubes in order to more e#ciently support data analysis and querying involving aggregations. The proposed method decomposes the data cubes into an indexed hierarchy of view elements. The view elements di#er ..."
Abstract - Cited by 11 (1 self) - Add to MetaCart
In this paper, we present a method for dynamically assembling views in multi-dimensional data cubes in order to more e#ciently support data analysis and querying involving aggregations. The proposed method decomposes the data cubes into an indexed hierarchy of view elements. The view elements di

Flexible data cubes for online aggregation

by Mirek Riedewald, Divyakant Agrawal, Amr El Abbadi - In ICDT , 2001
"... Abstract. Applications like Online Analytical Processing depend heavily on the ability to quickly summarize large amounts of information. Techniques were proposed recently that speed up aggregate range queries on MOLAP data cubes by storing pre-computed aggregates. These approaches try to handle dat ..."
Abstract - Cited by 15 (0 self) - Add to MetaCart
Abstract. Applications like Online Analytical Processing depend heavily on the ability to quickly summarize large amounts of information. Techniques were proposed recently that speed up aggregate range queries on MOLAP data cubes by storing pre-computed aggregates. These approaches try to handle

Parallelizing the Data Cube

by Frank Dehne, Todd Eavis, Susanne Hambrusch, Andrew Rau-Chaplin
"... ..."
Abstract - Cited by 18 (7 self) - Add to MetaCart
Abstract not found
Results 1 - 10 of 2,329