Advanced Data Warehouse Design

The authors explain conventional data warehouse design in detail, and additionally address two innovative domains recently introduced to extend the capabilities of data warehouse systems; namely the management of spatial and temporal information. Their presentation covers different phases, such as requirements specification, and conceptual, logical, and physical modeling. They include three different approaches for requirements specification depending on whether users, operational data sources, or both are the driving force in the requirements gathering process, and they show how each approach leads to the creation of a conceptual multidimensional model. The approaches are illustrated using many real-world examples and completed by sample implementations for Microsoft's Analysis Services 2005 and Oracle 10g with the OLAP and the Spatial extensions.

Explains conventional data warehouse design in detail Additionally addresses the management of spatial and temporal information, needed for geographical applications or for supply chain management All design steps are illustrated using many real-world examples Completed by sample implementations for Microsoft's Analysis Services 2005 and Oracle 10g with the OLAP and the Spatial extensions Includes supplementary material: sn.pub/extras

Autorentext

Elzbieta Malinowski is a professor at the department of Computer and Information
Science at the Universidad de Costa Rica and a professional consultant in
Costa Rica in the area of the Data Warehousing. She received her master degrees
from Saint Petersburg Electrotechnical University, Russia (1982) and
University of Florida, USA (1996), and her Ph.D. degree from
Université Libre de Bruxelles, Belgium (2006). Her research interests
include data warehouses, OLAP systems, geographic information systems,
and temporal databases.

Esteban Zimányi is a professor of computer science at the Engineering Department of the Université Libre de Bruxelles (ULB), Belgium. He received the BSc degree (1988) and the doctorate degree (1992) in computer science from the Sciences Department at the ULB. His current research interests include conceptual modeling, geographic information systems, spatio-temporal databases, and semantic web.

Inhalt
to Databases and Data Warehouses.- Conventional Data Warehouses.- Spatial Data Warehouses.- Temporal Data Warehouses.- Designing Conventional Data Warehouses.- Designing Spatial and Temporal Data Warehouses.- Conclusions and Future Work.