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

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.

[1]  Matteo Golfarelli,et al.  Conceptual design of data warehouses from E/R schemes , 1998, Proceedings of the Thirty-First Hawaii International Conference on System Sciences.

[2]  Gurindar S. Sohi,et al.  Speculative Multithreaded Processors , 2001, Computer.

[3]  Michael Böhnlein,et al.  Deriving initial data warehouse structures from the conceptual data models of the underlying operational information systems , 1999, DOLAP '99.

[4]  A Min Tjoa,et al.  Multidimensional Business Process Analysis with the Process Warehouse , 2002 .

[5]  G. G. Stokes.  "J." , 1890, The New Yale Book of Quotations.

[6]  Elmar J. Sinz,et al.  The structures entity-relationship model (SERM) , 1988 .

[7]  Matteo Golfarelli,et al.  Beyond data warehousing: what's next in business intelligence? , 2004, DOLAP '04.

[8]  Qing Li,et al.  Star/Snow-Flake Schema Driven Object-Relational Data Warehouse - Design and Query Processing Strategies , 1999, DaWaK.

[9]  Sixto Ortiz,et al.  Is Business Intelligence a Smart Move? , 2002, Computer.

[10]  Elmar J. Sinz.  Das Strukturierte Entity-Relationship-Modell (SER-Modell) , 1988, Angew. Inform..

[11]  Matteo Golfarelli,et al.  The Dimensional Fact Model: A Conceptual Model for Data Warehouses , 1998, Int. J. Cooperative Inf. Syst..

[12]  Achim Ulbrich-vom Ende,et al.  Business Process Oriented Development of Data Warehouse Structures , 2000 .

[13]  Matteo Golfarelli,et al.  Designing the Data Warehouse: Key Steps and Crucial Issues , 1999 .

[14]  Barbara Dinter,et al.  Extending the E/R Model for the Multidimensional Paradigm , 1998, ER Workshops.

[15]  Elmar J. Sinz,et al.  Modeling of Business Systems Using SOM , 1998 .

[16]  Witold Abramowicz,et al.  Knowledge Discovery for Business Information Systems , 2001 .

[17]  Dov Dori,et al.  OPCAT - A Bimodal Case Tool for Object-Process Based System Development , 2003, ICEIS.

[18]  Dov Dori,et al.  Object-process methodology - a holistic systems paradigm , 2013 .

[19]  Laurian M. Chirica,et al.  The entity-relationship model: toward a unified view of data , 1975, SIGF.

[20]  David Mellor,et al.  Common Warehouse Metamodel: An Introduction to the Standard for Data Warehouse Integration , 2001 .

[21]  Daniel L. Moody,et al.  From enterprise models to dimensional models: a methodology for data warehouse and data mart design , 2000, DMDW.

[22]  Walid G. Aref,et al.  Digital government security infrastructure design challenges , 2001 .

[23]  Jorge Oliveira e Sá,et al.  Data Warehouse Methodology: A Process Driven Approach , 2004, CAiSE.

[24]  Nectaria Tryfona,et al.  starER: a conceptual model for data warehouse design , 1999, DOLAP '99.

[25]  Karen C. Davis,et al.  Automating data warehouse conceptual schema design and evaluation , 2002, DMDW.

[26]  Elmar J. Sinz,et al.  SOM Modeling of Business Systems , 1998 .

[27]  L. Garber.  Profile - Katherine Glassey: Business intelligence is a smart move , 1999, IT Professional.

[28]  Manuel Palomar,et al.  Designing Data Warehouses with OO Conceptual Models , 2001, Computer.

[29]  Surajit Chaudhuri,et al.  An overview of data warehousing and OLAP technology , 1997, SGMD.

[30]  Peter Bernus,et al.  Handbook on Architectures of Information Systems (International Handbooks on Information Systems) (International Handbooks on Information Systems) , 2005 .

[31]  Boris Vrdoljak,et al.  Data warehouse design from XML sources , 2001, DOLAP '01.

[32]  Dov Dori,et al.  Transforming an operational system model to a data warehouse model: a survey of techniques , 2005, IEEE International Conference on Software - Science, Technology & Engineering (SwSTE'05).

[33]  Julius T. Tou,et al.  Information Systems , 1973, GI Jahrestagung.

[34]  Juan Trujillo,et al.  A Standard for Representing Multidimensional Properties: The Common Warehouse Metamodel (CWM) , 2002, ADBIS.

[35]  Sang-goo Lee,et al.  Automated Data Warehousing for Rule-based CRM Systems , 2003, ADC.