From conceptual models to schemata: An object-process-based data warehouse construction method

Dov Dori, Roman Feldman, Arnon Sturm

Research output: Contribution to journalArticlepeer-review

17 Scopus citations

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 languageEnglish
Pages (from-to)567-593
Number of pages27
JournalInformation Systems
Volume33
Issue number6
DOIs
StatePublished - 1 Sep 2008

Keywords

  • Conceptual modeling
  • Data models
  • Data warehousing
  • Database design
  • Object-Process Methodology

Fingerprint

Dive into the research topics of 'From conceptual models to schemata: An object-process-based data warehouse construction method'. Together they form a unique fingerprint.

Cite this