A cube is a data structure for storing and and analyzing large amounts of multidimensional data, often referred to as On-Line Analytical Processing (OLAP). Data in a cube lives in a space spanned by a number of hierarchical dimensions. A single point in this space is called a cell. A (non-empty) cell contains the values of one or more measures.
As an example, a three-dimensional cube for capturing sales may have a Product dimension P, a Time dimension T, and a Store dimension S, capturing the product sold, the time of sale, and the store it was sold in, for each sale, respectively. The cube has two measures: Dollar Sales and ItemSales, capturing the sales price and the number of items sold, respectively. In a cube, the combinations of a dimension value from each dimension define a cellof the cube. The measure value(s), e.g., DollarSales and ItemSales, corresponding to the particular combination of dimension values are then stored stored in the...
- 3.Pedersen TB. Managing complex multidimensional data. In: Aufaure M-A, Zimányi E, editors. Business intelligence – second European summer school, eBISS 2012. Brussels: Springer LNBIB; 2013, 15–21 July 2012, Tutorial Lectures.Google Scholar
- 4.Vaisman A, Zimányi E. Data warehouse systems – design and smplementation. Springer; 2014.Google Scholar