By Topic

Transforming an operational system model to a data warehouse model: a survey of techniques

Sign In

Cookies must be enabled to login.After enabling cookies , please use refresh or reload or ctrl+f5 on the browser for the login options.

Formats Non-Member Member
$31 $13
Learn how you can qualify for the best price for this item!
Become an IEEE Member or Subscribe to
IEEE Xplore for exclusive pricing!
close button

puzzle piece

IEEE membership options for an individual and IEEE Xplore subscriptions for an organization offer the most affordable access to essential journal articles, conference papers, standards, eBooks, and eLearning courses.

Learn more about:

IEEE membership

IEEE Xplore subscriptions

3 Author(s)
Dori, D. ; Technion-Israel Inst. of Technol., Haifa, Israel ; Feldman, R. ; Sturm, A.

Data warehouse modeling is a complicated task, which involves both knowledge of business processes, as well as 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. In this paper, we survey these techniques and analyze their capabilities using a feature-based comparison method. Our analysis clearly indicates that the various techniques are limited in their applicability to model large-scale systems, as they require acquaintance with the business processes and ability to select relevant transactional entities. These techniques also require multiple manual actions, since discovering measures and relevant dimensional entities are unassisted, and usually disregard the process perspective. Our analysis points out the need for improving the surveyed techniques.

Published in:

Software - Science, Technology and Engineering, 2005. Proceedings. IEEE International Conference on

Date of Conference:

22-23 Feb. 2005