Constraint-Based Multi-Dimensional Databases

Constraint-Based Multi-Dimensional Databases

Franck Ravat (Université Toulouse I, France), Olivier Teste (Université Toulouse I, France) and Gilles Zurfluh (Université Toulouse I, France)
DOI: 10.4018/978-1-59140-684-6.ch011
OnDemand PDF Download:


This chapter deals with constraint-based multi-dimensional modelling. The model we define integrates a constellation of facts and dimensions. Along each dimension, various hierarchies are possibly defined and the model supports multiple instantiations of dimensions. The main contribution is the definition of intra-dimension constraints between hierarchies of a same dimension as well as inter-dimension constraints of various dimensions. To facilitate data querying, we define a multi-dimensional query algebra, which integrates the main multi-dimensional operators such as rotations, drill down, roll up… These operators support the constraint-based multi-dimensional modelling. Finally, we present two implementations of this algebra. First, OLAP-SQL is a textual language integrating multi-dimensional concepts (fact, dimension, hierarchy), but it is based on classical SQL syntax. This language is dedicated tospecialists such as multi-dimensional database administrators. Second, a graphical query language is presented. This language consists in a graphical representation of multi-dimensional databases, and users specify directly their queries over this graph. This approach is dedicated to non-computer scientist users.

Complete Chapter List

Search this Book:
Table of Contents
Zongmin Ma
Chapter 1
Z. M. Ma
Information systems have become the nerve center of current computer-based engineering applications, which hereby put the requirements on... Sample PDF
Databases Modeling of Engineering Information
Chapter 2
Elvira Locuratolo
This chapter is devoted to the integration of the ASSO features in B. ASSO is a database design methodology defined for achieving conceptual schema... Sample PDF
Database Design Based on B
Chapter 3
T. W. Carnduff, J. S. Goonetillake
This chapter presents research aimed at determining the requirements of a database software tool that supports integrity validation of... Sample PDF
The Management of Evolving Engineering Design Constraints
Chapter 4
Hans-Peter Kriegel, Peer Kröger, Martin Pfeifle, Stefan Brecheisen, Marco Pötke, Matthias Schubert, Thomas Seidl
Similarity search in database systems is becoming an increasingly important task in modern application domains such as multimedia, molecular... Sample PDF
Similarity Search for Voxelized CAD Objects
Chapter 5
Xun W. Xu
This chapter addresses the issue of product development chain from the perspective of data modeling and streamlining. The focus is on an emerging... Sample PDF
STEP-NC to Complete Product Development Chain
Chapter 6
Jun Yuan
Decision support systems or mission control systems for network-centric operations typically need input from multiple heterogeneous information... Sample PDF
Semantic-Based Dynamic Enterprise Information Integration
Chapter 7
Yannis Panagis, Evangelos Sakkopoulos, Spyros Sioutas, Athanasios Tsakalidis
This chapter presents the Web Service architecture and proposes Web Service integration and management strategies for large-scale datasets. The main... Sample PDF
Web Service Integration and Management Strategies for Large-Scale Datasets
Chapter 8
Indranil Bose, Lam A.K. Chun, Leung V.W. Yue, Li H.W. Ines, Wong O.L. Helen
The retailing giant Wal-Mart owes its success to the efficient use of information technology in its operations. One of the noteworthy advances made... Sample PDF
Business Data Warehouse: The Case of Wal-Mart
Chapter 9
Chia-Hung Wei, Chang-Tsun Li, Roland Wilson
Content-based image retrieval (CBIR) makes use of image features, such as color and texture, to index images with minimal human intervention.... Sample PDF
A Content-Based Approach to Medical Image Database Retrieval
Chapter 10
Sriram Mohan, Arijit Sengupta
The process of conceptual design is independent of the final platform and the medium of implementation, and is usually in a form that is... Sample PDF
Conceptual Modeling for XML: A Myth or a Reality
Chapter 11
Franck Ravat, Olivier Teste, Gilles Zurfluh
This chapter deals with constraint-based multi-dimensional modelling. The model we define integrates a constellation of facts and dimensions. Along... Sample PDF
Constraint-Based Multi-Dimensional Databases
About the Authors