IDEA: interactive data exploration and analysis
SIGMOD '96 Proceedings of the 1996 ACM SIGMOD international conference on Management of data
Requirement-based data cube schema design
Proceedings of the eighth international conference on Information and knowledge management
The entity-relationship model—toward a unified view of data
ACM Transactions on Database Systems (TODS) - Special issue: papers from the international conference on very large data bases: September 22–24, 1975, Framingham, MA
A relational model of data for large shared data banks
Communications of the ACM
A Logical Approach to Multidimensional Databases
EDBT '98 Proceedings of the 6th International Conference on Extending Database Technology: Advances in Database Technology
Datawarehousing Has More Colours Than Just Black & White
VLDB '99 Proceedings of the 25th International Conference on Very Large Data Bases
Summarizability in OLAP and Statistical Data Bases
SSDBM '97 Proceedings of the Ninth International Conference on Scientific and Statistical Database Management
Normal Forms for Multidimensional Databases
SSDBM '98 Proceedings of the 10th International Conference on Scientific and Statistical Database Management
Extending the E/R Model for the Multidimensional Paradigm
ER '98 Proceedings of the Workshops on Data Warehousing and Data Mining: Advances in Database Technologies
Conceptual Design of Data Warehouses from E/R Schema
HICSS '98 Proceedings of the Thirty-First Annual Hawaii International Conference on System Sciences-Volume 7 - Volume 7
Constructing an OLAP cube from distributed XML data
Proceedings of the 5th ACM international workshop on Data Warehousing and OLAP
A UML-based data warehouse design method
Decision Support Systems
Integrated Model-Driven Development of Goal-Oriented Data Warehouses and Data Marts
ER '08 Proceedings of the 27th International Conference on Conceptual Modeling
DC proposal: online analytical processing of statistical linked data
ISWC'11 Proceedings of the 10th international conference on The semantic web - Volume Part II
An ETL process for OLAP using RDF/OWL ontologies
Journal on Data Semantics XIII
Journal of Database Management
A multidimensional data model for TPC-DS benchmarking
Proceedings of the 5th Asia-Pacific Symposium on Internetware
Hi-index | 0.00 |
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.