Paper Info
Title
Constructing OLAP cubes based on queries
Abstract
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.
Year
DOI
Venue
2001
10.1145/512236.512238
DOLAP
Keywords
Field
DocType
general form,data warehouse,sample olap,existing cube,functional dependency information,on-line analytical processing,related query,constructing olap,minimal cube,olap design method,cube design,data warehousing,functional dependency,design method
Data warehouse,Train of thought,Data mining,Computer science,Design methods,Functional dependency,Online analytical processing,Database,Cube
Conference
ISBN
Citations 
PageRank 
1-58113-437-1
16
0.86
References 
Authors
8
3
Name
Order
Citations
PageRank
Tapio Niemi116318.90
Jyrki Nummenmaa2143131.75
Peter Thanisch3529128.32