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

  • Authors:
  • Dov Dori;Roman Feldman;Arnon Sturm

  • Affiliations:
  • Technion, Israel Institute of Technology, Haifa, Israel;Technion, Israel Institute of Technology, Haifa, Israel;Ben Gurion University of the Negev, Beer Sheva, Israel

  • Venue:
  • Information Systems
  • Year:
  • 2008

Quantified Score

Hi-index 0.00

Visualization

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.