Erweiterte Suche

Conceptual models as basis for integrated information warehouse development

Research in the field of information warehousing mostly focuses technical aspects. Only recently some contributions are found dealing with methodical aspects of information warehouse development processes. With respect to the central role information warehouses play for the management a development method is presented which strictly concentrates on management views. Language concepts are developed which allow the specification of information warehouses out of the managements perspective and a representation formalism supporting this language is presented. Methodically the language construction is based on constructive philosophy. Conceptual models are used as meta information in later development phases and it is shown how meta data of etl and olap tools available on the market can be generated out of the conceptual models. The approach presented has been verified by means of a prototype.

Titel: Conceptual models as basis for integrated information warehouse development
Verfasser: Holten, Roland GND
Organisation: FB 04: Wirtschaftswissenschaftliche Fakultät
Dokumenttyp: Arbeitspapier
Medientyp: Text
Erscheinungsdatum: Oktober 2001
Publikation in MIAMI: 21.10.2008
Datum der letzten Änderung: 25.03.2015
Reihe Arbeitsberichte des Instituts für Wirtschaftsinformatik ; 81
Fachgebiete: Datenverarbeitung; Informatik; Wirtschaft
Sprache: Englisch
Format: PDF-Dokument
URN: urn:nbn:de:hbz:6-43569563488
1 Introduction ..... 1
2 Information Warehouse Development Framework ..... 4
2.1 Organizing Model and Abstraction Levels ..... 4
2.2 Organizing Development Phases ..... 7
2.3 Combining the Dimensions: IWH Development Framework ..... 9
3 Conceptual Specification of Management’s Information Requirements: Meta Information Creation ..... 11
3.1 Scientific Background and Methodology ..... 11
Background ..... 11
Methodology ..... 13
3.2 Language and Meta Model for IWH Concepts..... 14
3.3 Representation and Technique for IWH Concepts ..... 18
3.4 Method for IWH Concepts: Creating IWH Meta Information..... 20
4 Horizontal Integration of Information Warehouse Development: Meta Information Use ..... 23
4.1 Enlargement of Language and Meta Model ..... 23
4.2 Meta Information Repository and Development Tool..... 25
4.3 Using Meta Information ..... 27
4.3.1 Data Warehouse Parameters ..... 28
Definition of fact table attributes ..... 29
Definition of the bottom level for every dimension ..... 30
Definition of hierarchical levels and foreign key relations within the dimensions ..... 31
4.3.2 Etl and Olap Parameters ..... 32
5 Related Work and Discussion ..... 38
6 Conclusion..... 40
References ..... 41
Appendix ..... 45