2001 · 47 citations · 9 references
ComputingComputer ScienceInformation SystemsData ManagementDatabasesDesign AutomationData AggregationData IntegrationData WarehousingDatabase ManagementQuery OptimizationQuery ProcessingAggregation QueriesCube AggregationData CubesData Warehouse DesignFunctional Dependency ModelingFunctional Dependency TheoryOlap Cube DesignOlap Query Processing
An On-Line Analytical Processing (OLAP) user often follows a train of thought, posing a sequence of related queries against the data warehouse. Although their details are not known in advance, the general form of those queries is apparent beforehand. Thus, the user can outline the relevant portion of the data posing generalised queries against a cube representing the data warehouse.Since existing OLAP design methods are not suitable for non-professionals, we present a technique that automates cube design given the data warehouse, functional dependency information, and sample OLAP queries expressed in the general form. The method constructs complete but minimal cubes with low risks related to sparsity and incorrect aggregations. After the user has given queries, the system will suggest a cube design. The user can accept it or improve it by giving more queries. The method is also suitable for improving existing cubes using respective real MDX queries.
9
A relational model of data for large shared data banks
E. F. Codd · Communications of the ACM · 1970 · 5.2K citations · Full text
A relational model of data for large shared data banks
E. F. Codd · Communications of the ACM · 1983 · 4.8K citations
Summarizability in OLAP and statistical data bases
H. Lenz, Arie Shoshani · 2002 · 292 citations
Conceptual design of data warehouses from E/R schemes
Matteo Golfarelli, Dario Maio, Stefano Rizzi · 2002 · 280 citations