Proceedings ArticleDOI
Normal forms for multidimensional databases
Wolfgang Lehner,Jens Albrecht,Hartmut Wedekind +2 more
- pp 63-72
TLDR
This paper proposes two multidimensional normal forms that ensure the validity of analytical computations on the multiddimensional database, but also favor an efficient physical database design.Abstract:
In the area of online analytical processing (OLAP), the concept of multidimensional databases is receiving much popularity. Thus, a couple of different multidimensional data models were proposed from the research as well as from the commercial product side, each emphasizing different perspectives. However, very little work has been done investigating guidelines for good schema design within such a multidimensional data model. Based on a logical reconstruction of multidimensional schema design, this paper proposes two multidimensional normal forms. These normal forms define modeling constraints for summary attributes describing the cells within a multidimensional data cube and constraints to model complex dimensional structures appropriately. Multidimensional schemas compliant to these normal forms do not only ensure the validity of analytical computations on the multidimensional database, but also favor an efficient physical database design.read more
Citations
More filters
Journal ArticleDOI
Theoretical and practical issues in evaluating the quality of conceptual models: current state and future directions
TL;DR: It is argued that the current proliferation of quality frameworks is counterproductive to the progress of the field, and that researchers and practitioners should work together to establish a common standard (or standards) for conceptual model quality.
Journal ArticleDOI
A survey of logical models for OLAP databases
Panos Vassiliadis,Timos Sellis +1 more
TL;DR: This paper presents different proposals for multidimensional data cubes, which are the basic logical model for OLAP applications, and divides the work in the field in two categories: commercial tools and academic efforts.
Journal ArticleDOI
Hierarchies in a multidimensional model: from conceptual modeling to logical representation
TL;DR: The MultiDimER model is formally defined, a conceptual multidimensional model that allows to represent facts with measures as well as the different kinds of hierarchies already classified in the previous work.
Conceptual Data Warehouse Design
TL;DR: This paper shows how to systematically derive a conceptual warehouse schema that is even in generalized multidimensional normal form from an operational database.
Proceedings ArticleDOI
Research in data warehouse modeling and design: dead or alive?
TL;DR: Issues regarding conceptual models, logical models, methods for design, interoperability, and design for new architectures and applications are considered.
References
More filters
Book
Word and Object
TL;DR: This edition offers a new preface by Quine's student and colleague Dagfinn Follesdal that describes the never-realized plans for a second edition of Word and Object, in which Quine would offer a more unified treatment of the public nature of meaning, modalities, and propositional attitudes.
Journal ArticleDOI
Data cube: a relational aggregation operator generalizing GROUP-BY, CROSS-TAB, and SUB-TOTALS
TL;DR: The data cube operator as discussed by the authors generalizes the histogram, cross-tabulation, roll-up, drill-down, and sub-total constructs found in most report writers.
Journal ArticleDOI
Database abstractions: aggregation and generalization
TL;DR: A triggering mechanism for automatically maintaining these invariants during update operations is proposed, and a simple mapping of aggregation/generalization hierarchies onto owner-coupled set structures is given.
Proceedings ArticleDOI
Modeling multidimensional databases
TL;DR: A data model and a few algebraic operations that provide semantic foundation to multidimensional databases and provide an algebraic application programming interface (API) that allows the separation of the front end from the back end are proposed.