Abstract
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.
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.