An OPM-based method for transformation of operational system modle to data warehouse model

D Dori, R Feldman, A Sturm

Research output: Chapter in Book/Report/Conference proceedingChapterpeer-review

Abstract

Data warehouse modeling is a complicated task, which involves both knowledge of business processes and familiarity with operational information systems structure and behavior. Several modeling techniques were suggested to utilize the operational system structural or behavioral model in order to construct a data warehouse conceptual model. However, these techniques are hardly applicable for modeling large-scale systems, as they require acquaintance with the business processes and ability to select relevant transactional entities. They require multiple manual actions because discovering measures and relevant dimensional entities are unassisted, and they usually disregard the process perspective. In this paper we propose a technique for data warehouse model construction based on the object process methodology, and demonstrate it on a case study emphasizing its advantages over other techniques.
Original languageEnglish
Title of host publication IEEE International Conference on Software - Science, Technology & Engineering (SwSTE'05)
Pages57-66
StatePublished - 2005

Fingerprint

Dive into the research topics of 'An OPM-based method for transformation of operational system modle to data warehouse model'. Together they form a unique fingerprint.

Cite this