loading...
 This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
IEEE International Conference on Software - Science, Technology & Engineering (SwSTE'05)
Transforming an Operational System Model to a Data Warehouse Model: A Survey of Techniques
Herzlia, Israel
February 22-February 23
ISBN: 0-7695-2335-8
Dov Dori, Technion - Israel Institute of Technology, Israel
Roman Feldman, Technion - Israel Institute of Technology, Israel
Arnon Sturm, Ben Gurion University of the Negev, Israel
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.
Citation:
Dov Dori, Roman Feldman, Arnon Sturm, "Transforming an Operational System Model to a Data Warehouse Model: A Survey of Techniques," swste, pp.47-56, IEEE International Conference on Software - Science, Technology & Engineering (SwSTE'05), 2005
Usage of this product signifies your acceptance of the Terms of Use.