From conceptual models to schemata: An object-process-based data warehouse construction method
作者:
Highlights:
•
摘要
Data warehouse modeling is a complex task, which involves knowledge of business processes of the domain of discourse, understanding the structural and behavioral system's conceptual model, and familiarity with data warehouse technologies. The suitability of current data warehouse modeling methods for large-scale systems is questionable, as they require multiple manual actions to discover measures and relevant dimensional entities and they tend to disregard the system's dynamic aspects. We present an Object-process-based Data Warehouse Construction (ODWC) method that overcomes these limitations of existing methods by utilizing the operational system conceptual model to construct a corresponding data warehouse schema. We specify the ODWC method, apply it on a case study, evaluate it, and compare it to existing methods.
论文关键词:Data warehousing,Data models,Database design,Conceptual modeling,Object-Process Methodology
论文评审过程:Received 10 June 2007, Revised 19 January 2008, Accepted 6 February 2008, Available online 10 March 2008.
论文官网地址:https://doi.org/10.1016/j.is.2008.02.002