Abstract
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.
| Original language | English |
|---|---|
| Pages (from-to) | 567-593 |
| Number of pages | 27 |
| Journal | Information Systems |
| Volume | 33 |
| Issue number | 6 |
| DOIs | |
| State | Published - 1 Sep 2008 |
Keywords
- Conceptual modeling
- Data models
- Data warehousing
- Database design
- Object-Process Methodology
ASJC Scopus subject areas
- Software
- Information Systems
- Hardware and Architecture