Data Warehouse Schema Design

Kein Bild zugeordnet
Autor/en:
J. Lechtenbörger
Umfang:
233
EAN/ISBN/ISSN:
978-3-89838-479-7
Band:
79
Ausgabe:
softcover
Buchreihe:
Dissertationen zu Datenbanken und Informationssystemen
Kategorien:
Buch
Informatik
Informationstechnologie und Informationssysteme
Dissertationen zu Datenbanken und Informationssytemen
Preis:
inkl. 7% MWSt
33,00 €
A data warehouse is an integrated database primarily used in organizational decision making. Although the deployment of data warehouses is current practise in modern information technology landscapes, the methodical schema design for such databases has only been studied cursorily. This book presents conceptual and logical schema design phases as parts of a general design process for data warehouses. The specification of conceptual schemata and the assessment of their quality are based on a formal multidimensional data model in conjunction with associated normal forms. Moreover, a conceptual design phase is developed whose output schemata provably satisfy the normal forms. Logical design is supported by an algorithmic approach, which transforms conceptual schemata into relational database schemata that satisfy several desirable properties. Furthermore, the notion of self-maintainability is generalized towards independence, and an approach towards warehouse independence based on so-called view complements is proposed.