Querying Multidimensional Data

Querying Multidimensional Data

Leonardo Tininini (National Institute of Statistics, Italy)
Copyright: © 2003 |Pages: 30
DOI: 10.4018/978-1-59140-053-0.ch009
OnDemand PDF Download:


A powerful and easy-to-use querying environment is certainly one of the most important components in a multidimensional database, and its effectiveness is influenced by many other aspects, both logical (data model, integration, policy of view materialization, etc.) and physical (multidimensional or relational storage, indexes, etc.). As is evident, multidimensional querying is often based on the metaphor of the data cube and on the concepts of facts, measures, and dimensions. In contrast to conventional transactional environments, multidimensional querying is often an exploratory process, performed by navigating along the dimensions and measures, increasing/decreasing the level of detail and focusing on specific subparts of the cube that appear to be “promising” for the required information. In this chapter we focus on the main languages proposed in the literature to express multidimensional queries, particularly those based on: (i) an algebraic approach, (ii) a declarative paradigm (calculus), and (iii) visual constructs and syntax. We analyze the problem of evaluation, i.e., the issues related to the efficient data retrieval and calculation, possibly (often necessarily) using some pre-computed data, a problem known in the literature as the problem of rewriting a query using views. We also illustrate the use of particular index structures to speed up the query evaluation process.

Complete Chapter List

Search this Book:
Table of Contents
Maurizio Rafanelli
Chapter 1
Basic Notions  (pages 1-45)
Maurizio Rafanelli
This chapter presents the basic notions regarding multidimensional (aggregate) databases by referring to different definitions given for them in the... Sample PDF
Basic Notions
Chapter 2
Arie Shoshani
The term “multidimensional databases” refers to data that can be viewed conceptually in a multidimensional space, where each dimension represents... Sample PDF
Multidimensionality in Statistical, OLAP and Scientific Databases
Chapter 3
Riccardo Torlone
A variety of multidimensional data models have recently been proposed by both academic and industry communities. but consensus on formalism or even... Sample PDF
Conceptual Multidimensional Models
Chapter 4
Hierarchies  (pages 91-115)
Elaheh Pourabbas, Maurizio Rafanelli
In this chapter we will focus on the rules of aggregation hierarchies in analysis dimensions of a cube. We give an overview of the related works on... Sample PDF
Chapter 5
Maurizio Rafanelli
In this chapter the author proposes the different approaches for defining operators able to manipulate this multidimensional structure. In... Sample PDF
Operators for Multidimensional Aggregate Data
Chapter 6
Alberto O. Mendelzon, Alejandro A. Vaisman
In spite of the obvious importance of time in data warehousing and OLAP, current commercial systems do not support tracking the history of a data... Sample PDF
Time in Multidimensional Databases
Chapter 7
Mirek Riedewald, Divyakant Agrawal, Amr El Abbadi
Data cubes are ubiquitous tools in data warehousing, online analytical processing, and decision support applications. Based on a selection of... Sample PDF
Dynamic Multidimensional Data Cubes
Chapter 8
Stefano Paraboschi, Giuseppe Sindoni, Elena Baralis, Ernst Teniente
This chapter presents materialized views in the context of multidimensional databases (MDDBs). A materialized view is a view whose content is... Sample PDF
Materialized Views in Multidimensional Databases
Chapter 9
Leonardo Tininini
A powerful and easy-to-use querying environment is certainly one of the most important components in a multidimensional database, and its... Sample PDF
Querying Multidimensional Data
Chapter 10
Cirtis E. Dyreson, Torben Bach Pedersen, Christian S. Jensen
While incomplete information is endemic to real-world data, current multidimensional data models are not engineered to manage incomplete information... Sample PDF
Incomplete Information in Multidimensional Databases
Chapter 11
Francesco M. Malvestuto, Marina Moscarini
When answering queries that ask for summary statistics, the query-system of a multidimensional database should guard confidential data, that is, it... Sample PDF
Privacy in Multidimensional Databases
Chapter 12
Andrea Cali, Domenico Lembo, Maurizio Lenzerini, Riccardo Rosati
While the main goal of a data warehouse is to provide support for data analysis and management’s decisions, a fundamental aspect in design of a data... Sample PDF
Source Integration for Data Warehousing
Chapter 13
Elaheh Pourabbas
The purpose of this chapter is to create cooperation between geographic databases (GDBs) and multidimensional databases (MDDBs), which are... Sample PDF
Cooperation with Geographic Databases
About the Authors