METHOD FOR USER ORIENTED MODELLING OF DATA WAREHOUSE SYSTEMS
Lars Burmester, Matthias Goeken · 2006
Abstract: The paper describes a method for data warehouse development. One critical success factor of data warehouse development is determining information requirements. Hence, the method focuses on gathering of requirements and information needs of the users first. An extended data warehouse architecture and a technique for decomposition of the system serve as a developing framework. On the one hand this framework is used to define releases (builds) of the system, which is indispensable for an incremental development process. On the other hand it defines intermediate and final work products (artifacts) that are produced and used during further development stages. Starting with information requirements elicitation, each increment is realized through a series of data models which successively are transformed from conceptual to logical level. These logical data models are then used for implementation as well as for the modelling of ETL processes. 1