OLAP schemata for correct applications

Authors:
Hans-Joachim Lenz;Bernhard Thalheim
Affiliations:
Institute of Production, Information Systems and Operations Research, Free University Berlin, Berlin, Germany;Department of Computer Science and Applied Mathematics, Christian Albrechts University Kiel, Kiel, Germany
Venue:
TEAA'05 Proceedings of the 31st VLDB conference on Trends in Enterprise Application Architecture
Year:
2005

Citing 9
Cited 4

Comprehension syntax

ACM SIGMOD Record
Developing time-oriented database applications in SQL

Developing time-oriented database applications in SQL
Entity-Relationship Modeling: Foundations of Database Technology

Entity-Relationship Modeling: Foundations of Database Technology
Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals

Data Mining and Knowledge Discovery
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
Modelling and Optimisation Issues for Multidimensional Databases

CAiSE '00 Proceedings of the 12th International Conference on Advanced Information Systems Engineering
Aggregation operators: new trends and applications

Aggregation operators: new trends and applications
OLAP Databases and Aggregation Functions

SSDBM '01 Proceedings of the 13th International Conference on Scientific and Statistical Database Management

Model Suites For Multi-Layered Database Modelling

Proceedings of the 2010 conference on Information Modelling and Knowledge Bases XXI
Achievements and problems of conceptual modelling

Active conceptual modeling of learning
Specifying aggregation functions in multidimensional models with OCL

ER'10 Proceedings of the 29th international conference on Conceptual modeling
Architecture-Driven Modelling Methodologies

Proceedings of the 2011 conference on Information Modelling and Knowledge Bases XXII

Quantified Score

Hi-index	0.00

Visualization

Abstract

OLAP applications are currently widely used in business applications. These applications are implicitly defined on top of OLTP systems. The applications make use of aggregation functions and data combinations. A number of paradoxes is observed if arbitrary aggregation functions and combinations are used. We develop a theory of aggregation functions, OLTP-OLAP transformations, and of the data cube. Based on these investigations we derive an architecture for OLTP-OLAP applications that supports sound and correct querying: OLTP-OLAP specification frames. The specification frame of OLTP-OLAP schemata specifically emphasises soundness of all operations involved by built-in guards. Or to turn it around, we make provision that an innocent user does not start non-sense operations. This specification frame is based on OLTP schemata, OLTP-OLAP transformations, and a rigid theory of OLAP schemata and functions.