Bridging the Gap between Multidimensional Business Problem Formulation and the Implementation of Multidimensional Data Models

Franca Piazza, Friedrich Röhrs

Abstract

In data warehouse implementations the comprehensive identification of user requirements is a critical success factor. The translation of business problems into conceptual data models is very challenging and currently there are no information systems that assist in these tasks. In this research, we therefore elaborate on the challenges in that specific area and develop an information system to gather information needs and automatically transform them into conceptual multidimensional data models. We then demonstrate the use of the information system within the domain of Human Resource Management.

References

  1. Bostrom, R. P., S. Gupta, and D. Thomas. 2009. “A MetaTheory for Understanding Information Systems Within Sociotechnical Systems.” Journal of Management Information Systems 26 (1): 17-48.
  2. De Bruijn, H., and P. M. Herder. 2009. “Systems and Actor Perspectives on Sociotechnical Systems.” IEEE Transactions on Systems, Man and Cybernetics, Part A: Systems and Humans 39 (5): 981-992.
  3. Chaudhuri, Surajit, and Umeshwar Dayal. 1997. “Overview of Data Warehousing and OLAP Technology.” ACM SIGMOD Record 26 (1): 65-74.
  4. Davis, F. D. 1989. “Perceived Usefulness, Perceived Ease of Use, and User Acceptance of Information Technology.” MIS Quarterly 13: 319-340.
  5. DeLone, W. H., and E. R. McLean. 2003. “The DeLone and McLean Model of Information Systems Success: A Ten-Year Update.” Journal of Management Information Systems 19 (4): 9-30.
  6. Earl, Michael. 2001. “Knowledge Management Strategies.” Journal of Management Information Systems 18 (1) (October): 215-233.
  7. Gluchowski, P., C. Kurze, and C. Schieder. 2009. “A Modeling Tool for Multidimensional Data Using the ADAPT Notation.” In The 42nd Hawaii International Conference on System Sciences (HICSS), 3575-3584. IEEE Press.
  8. Kimball, Ralph. 1996. The Data Toolkit: Practical Techniques for Building Dimensional Warehouses. New York, NY, USA: John Wiley & Sons.
  9. Kurze, Christian, and Peter Gluchowski. 2008. “Computer-Aided Warehouse Engineering (CAWE): Leveraging MDA and ADM for the Development of Data Warehouses.” In AMCIS 2010 Proceedings. Paper 282.
  10. Mazón, J. -N., and J. Trujillo. 2008. “An MDA Approach for the Development of Data Warehouses.” Decision Support Systems 45: 41-58.
  11. Mazón, J. -N., J. Trujillo, M. Serrano, and M. Piattini. 2005. “Applying MDA to the Development of Data Warehouses.” In The 8th ACM International Workshop on Data Warehousing and OLAP (DOLAP), 57-66. ACM Press.
  12. Neo Technology, Inc. “Neo4j - The World's Leading Graph Database.” http://www.neo4j.org/.
  13. Olbrich, S., J. Pöppelbuß, and B. Niehaves. 2012. “Critical Context Success Factors for Business Intelligence: A Delphi Study on Their Relevance, Variability, and Controllability.” In 45th IEEE International Conference in System Sciences, 4148-4157. IEEE Press.
  14. OMG Group. 2012. “OMG Model Driven Architecture.” http://www.omg.org/mda/.
  15. Peffers, K., T. Tuuanen, M. A. Rothenberger, and S. Chatterjee. 2007. “A Design Science Research Methodology for Information Systems Research.” Journal of Management Information Systems 24: 45- 77.
  16. Priebe, T., and G. Pernul. 2001. “Metadaten-gestützter Data-Warehouse-Entwurf Mit ADAPTed UML.” In 5th Internationale Tagung Wirtschaftsinformatik. Paper 8.
  17. Tichy, Noel M., Charles J. Fombrun, and Mary Anne Devanna. 1982. “Strategic Human Resource Management.” Sloan Management Review 23 (2): 47- 61.
  18. Winter, R., and B. Strauch. 2003. “A Method for Demanddriven Information Requirements Analysis in Data Warehousing Projects.” In The 36th Hawaii International Conference on System Sciences (HICSS), 1359-1365. IEEE Press.
  19. Xu, Hongjiang, and Mark I. Hwang. 2008. “A Structural Model of Data Warehousing Success. Journal of Computer Information Systems.” The Journal of Computer Information Systems 49: 48-56.
  20. Yeoh, William. 2011. “Business Intelligence Systems Implementation: Testing a Critical Success Factors Framework in Multiple Cases.” International Journal of Business Information Systems 8 (2): 192-209.
  21. Yeoh, William, and Andy Koronios. 2010. “Critical Success Factors for Business Intelligence Systems.” Journal of Computer Information Systems 50 (3): 23- 32.
Download


Paper Citation


in Harvard Style

Piazza F. and Röhrs F. (2013). Bridging the Gap between Multidimensional Business Problem Formulation and the Implementation of Multidimensional Data Models . In Proceedings of the 15th International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-989-8565-59-4, pages 79-87. DOI: 10.5220/0004394700790087


in Bibtex Style

@conference{iceis13,
author={Franca Piazza and Friedrich Röhrs},
title={Bridging the Gap between Multidimensional Business Problem Formulation and the Implementation of Multidimensional Data Models},
booktitle={Proceedings of the 15th International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2013},
pages={79-87},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0004394700790087},
isbn={978-989-8565-59-4},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 15th International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - Bridging the Gap between Multidimensional Business Problem Formulation and the Implementation of Multidimensional Data Models
SN - 978-989-8565-59-4
AU - Piazza F.
AU - Röhrs F.
PY - 2013
SP - 79
EP - 87
DO - 10.5220/0004394700790087