An analysis of additivity in OLAP systems

Authors:
John Horner;Il-Yeol Song;Peter P. Chen
Affiliations:
Drexel University, Philadelphia, PA;Drexel University, Philadelphia, PA;Louisiana State University, Baton Rouge, LA
Venue:
Proceedings of the 7th ACM international workshop on Data warehousing and OLAP
Year:
2004

Citing 14
Cited 16

An overview of data warehousing and OLAP technology

ACM SIGMOD Record
OLAP and statistical databases: similarities and differences

PODS '97 Proceedings of the sixteenth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems
Data warehouse design solutions

Data warehouse design solutions
Data warehousing in an integrated health system: building the business case

Proceedings of the 1st ACM international workshop on Data warehousing and OLAP
starER: a conceptual model for data warehouse design

Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP
Characterization of hierarchies and some operators in OLAP environment

Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling

The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
A Taxonomy of Dirty Data

Data Mining and Knowledge Discovery
Designing Data Warehouses with OO Conceptual Models

Computer
Modelling Large Scale OLAP Scenarios

EDBT '98 Proceedings of the 6th International Conference on Extending Database Technology: Advances in Database Technology
Outstanding Challenges in OLAP

ICDE '98 Proceedings of the Fourteenth International Conference on Data Engineering
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
Data warehousing in environmental digital libraries

Communications of the ACM - Why CS students need math
Reconsidering Multi-Dimensional schemas

ACM SIGMOD Record

Modeling, querying and reasoning about OLAP databases: a functional approach

Proceedings of the 8th ACM international workshop on Data warehousing and OLAP
Research in data warehouse modeling and design: dead or alive?

DOLAP '06 Proceedings of the 9th ACM international workshop on Data warehousing and OLAP
Dimensional modeling: Identification, classification, and evaluation of patterns

Decision Support Systems
Top_Keyword: An Aggregation Function for Textual Document OLAP

DaWaK '08 Proceedings of the 10th international conference on Data Warehousing and Knowledge Discovery
Integrated Model-Driven Development of Goal-Oriented Data Warehouses and Data Marts

ER '08 Proceedings of the 27th International Conference on Conceptual Modeling
FCLOS: A client-server architecture for mobile OLAP

Data & Knowledge Engineering
Extending OCL for OLAP querying on conceptual multidimensional models of data warehouses

Information Sciences: an International Journal
Repairing OLAP queries in databases with referential integrity errors

DOLAP '10 Proceedings of the ACM 13th international workshop on Data warehousing and OLAP
Improving the development of data warehouses by enriching dimension hierarchies with WordNet

ODBIS'05/06 Proceedings of the First and Second VLDB conference on Ontologies-based databases and information systems
Combining objects with rules to represent aggregation knowledge in data warehouse and OLAP systems

Data & Knowledge Engineering
Enforcing strictness in integration of dimensions: beyond instance matching

Proceedings of the ACM 14th international workshop on Data Warehousing and OLAP
A taxonomy of inaccurate summaries and their management in OLAP systems

ER'05 Proceedings of the 24th international conference on Conceptual Modeling
Enriching data warehouse dimension hierarchies by using semantic relations

BNCOD'06 Proceedings of the 23rd British National Conference on Databases, conference on Flexible and Efficient Information Handling
Multidimensional models meet the semantic web: defining and reasoning on OWL-DL ontologies for OLAP

Proceedings of the fifteenth international workshop on Data warehousing and OLAP
An MDA Approach and QVT Transformations for the Integrated Development of Goal-Oriented Data Warehouses and Data Marts

Journal of Database Management
Detecting summarizability in OLAP

Data & Knowledge Engineering

Quantified Score

Hi-index	0.00

Visualization

Abstract

Accurate summary data is of paramount concern in data warehouse systems; however, there have been few attempts to completely characterize the ability to summarize measures. The sum operator is the typical aggregate operator for summarizing the large amount of data in these systems. We look to uncover and characterize potentially inaccurate summaries resulting from aggregating measures using the sum operator. We discuss the effect of classification hierarchies, and non-, semi-, and fully- additive measures on summary data, and develop a taxonomy of the additive nature of measures. Additionally, averaging and rounding rules can add complexity to seemingly simple aggregations. To deal with these problems, we describe the importance of storing metadata that can be used to restrict potentially inaccurate aggregate queries. These summary constraints could be integrated into data warehouses, just as integrity constraints and are integrated into OLTP systems. We conclude by suggesting methods for identifying and dealing with non- and semi- additive attributes.