Conceptual Design Model Using Operational Data Store (CoDMODS) for Developing Business Intelligence Applications

Summary Building a Business Intelligence (BI) application is very challenging as it is a young discipline and does not yet offer well-established strategies and techniques for the developments process when compared to the software engineering discipline. Furthermore, information requirements analysis for BI applications which integrate data from heterogeneous sources differs significantly from requirements analysis for a conventional information system. Conceptual Design Model Operational Data Store (CoDMODS) to build BI application that focuses on operational information to support business operations is proposed. In this model, combination of community interaction and data integration approach were used to identify the requirements for developing BI application. Furthermore, how the operational data store can be used for operational and tactical information and can be transferred to a data warehouse for supporting analytical information and decision making is also presented. Finally, to verify and validate the proposed model, the case study approach using web application development in selected subject areas is elaborated.

[1]  Ralph Kimball,et al.  The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling , 1996 .

[2]  Markus Grünwald,et al.  Business Intelligence , 2009, Informatik-Spektrum.

[3]  Ralph Kimball,et al.  The Microsoft Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset , 2006 .

[4]  Anjana Gosain,et al.  Requirements Driven Data Warehouse Development , 2003, CAiSE Short Paper Proceedings.

[5]  Bashar Nuseibeh,et al.  Requirements engineering: a roadmap , 2000, ICSE '00.

[6]  Beate List,et al.  A Comparison of Data Warehouse Development Methodologies Case Study of the Process Warehouse , 2002, DEXA.

[7]  James R. Lewis,et al.  IBM computer usability satisfaction questionnaires: Psychometric evaluation and instructions for use , 1995, Int. J. Hum. Comput. Interact..

[8]  W. H. Inmon,et al.  Building the Operational Data Store , 1995 .

[9]  Jaelson Brelaz de Castro,et al.  DWARF: an approach for requirements definition and management of data warehouse systems , 2003, Proceedings. 11th IEEE International Requirements Engineering Conference, 2003..

[10]  Efraim Turban,et al.  Business Intelligence: Second European Summer School, eBISS 2012, Brussels, Belgium, July 15-21, 2012, Tutorial Lectures , 2013 .

[11]  Robert Winter,et al.  A method for demand-driven information requirements analysis in data warehousing projects , 2003, 36th Annual Hawaii International Conference on System Sciences, 2003. Proceedings of the.

[12]  Sylvia Encheva,et al.  Automated decision support system based on ordered sources , 2008 .

[13]  Manon Ghislaine Guillemette,et al.  What is Business Intelligence? , 2010, Int. J. Bus. Intell. Res..

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

[15]  Ezio Lefons,et al.  Design and implementation of a national data warehouse , 2006 .

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

[17]  Paolo Giorgini,et al.  Goal-oriented requirement analysis for data warehouse design , 2005, DOLAP '05.

[18]  Shiwei Tang,et al.  Triple-driven data modeling methodology in data warehousing: a case study , 2006, DOLAP '06.