Advertisement

Key Performance Indicators in Data Warehouses

  • Manfred A. JeusfeldEmail author
  • Samsethy Thoun
Conference paper
Part of the Lecture Notes in Business Information Processing book series (LNBIP, volume 253)

Abstract

Key performance indicators are widely used to manage any type of processes including manufacturing, logistics, and business processes. We present an approach to map informal specifications of key performance indicators to prototypical data warehouse designs that support the calculation of the KPIs via aggregate queries. We argue that the derivation of the key performance indicators shall start from a process definition that includes scheduling and resource information.

Keywords

Key performance indicator Data warehouse Business process 

References

  1. 1.
    Wetzstein, B., Leitner, P., Rosenberg, F., Brandic, I., Dustdar, S., Leymann, F.: Monitoring and analyzing influential factors of business process performance. In: Proceedings of the 2009 IEEE International Enterprise Distributed Object Computing Conference, EDOC 2009, Auckland, New Zealand, pp. 141–150 (2009)Google Scholar
  2. 2.
    Deming, W.E.: On Probability as a basis for action. Am. Stat. 29(4), 146–152 (1975)Google Scholar
  3. 3.
    CMMI Guidebook Acquirer Team: Understanding and Leveraging a Supplier’s CMMI Efforts: A Guidebook for Acquirers, CMU/SEI-2007-TR-004. Software Engineering Institute, March 2007. http://resources.sei.cmu.edu/library/asset-view.cfm?assetID=8315
  4. 4.
    Horkoff, J., Barone, D., Jiang, L., Yu, E.S.K., Amyot, D., Borgida, A., Mylopoulos, J.: Strategic business modeling: representation and reasoning. Softw. Syst. Model. 13(3), 1015–1041 (2014)CrossRefGoogle Scholar
  5. 5.
    Golfarelli, M., Maio, D., Rizzi, S.: Conceptual design of data warehouses from E/R schema.In: Proceedings of the 31st Annual Hawaii International Conference on System Sciences, HICSS 1998, vol. 7, pp. 334–243 (1998)Google Scholar
  6. 6.
    Golfarelli, M., Rizzi, S.: Data Warehouse Design - Modern Principles and Methodologies. McGraw-Hill, Osborne (2009)Google Scholar
  7. 7.
    Song, I.-Y., Khare, R., Dai, B.: SAMSTAR: a semi-automated lexical method for generating star schemas from an entity-relationship diagram. In: Proceedings of the 10th ACM International Workshop on Data Warehousing and OLAP, DOLAP 2007, Lisbon, Portugal, pp. 9–16 (2007)Google Scholar
  8. 8.
    Zepeda, L., Celma, M., Zatarain, R.: A methodological framework for conceptual data warehouse design. In: Proceedings of the 43nd Annual Southeast Regional Conference, 2005, Kennesaw, Georgia, Alabama, USA, vol. 1, pp. 256–259 (2005)Google Scholar
  9. 9.
    Phipps, D., Davis, K.C.: Automating data warehouse conceptual schema design and evaluation. In: Proceedings of the 4th International Workshop on Design and Management of Data Warehouses, DMDW 2002, Toronto, Canada, CEUR-WS.org/Vol-58, pp. 23–32 (2002)Google Scholar
  10. 10.
    Moody, D., Kortink, M.A.R.: From enterprise models to dimensional models: a methodology for data warehouse and data mart design. In: Proceedings of the International Workshop on Design and Management of Data Warehouses, DMDW 2000, Stockholm, Sweden, CEUR-WS.org/Vol-28 (2000)Google Scholar
  11. 11.
    Prakash, N., Gosain, A.: Requirements Driven Data Warehouse Development. Short Paper Proceedings CAiSE 2003, Klagenfurt, Austria. CEUR-WS.org/Vol-74 (2003)Google Scholar
  12. 12.
    Giorgini, P., Rizzi, S., Garzetti, M.: Goal-oriented requirement analysis for data warehouse design. In: Proceedings of the 8th ACM International Workshop on Data Warehousing and OLAP, DOLAP 2005, Bremen, Germany, pp. 47–56 (2005)Google Scholar
  13. 13.
    Tryfona, N., Busborg, F., Christiansen, J.G.B.: StarER: a conceptual model for data warehouse design. In: Proceedings of the 2nd ACM International Workshop on Data Warehousing and OLAP, DOLAP 1999, Kansas City, Missouri, USA, pp. 3–8 (1999)Google Scholar
  14. 14.
    Jones, M.E., Song, I.-Y.: Dimensional modeling: identification, classification, and applying patterns. In: Proceedings of the 8th ACM International Workshop on Data Warehousing and OLAP, DOLAP 2005, Bremen, Germany, pp. 29–38 (2005)Google Scholar
  15. 15.
    Shoshani, A.: OLAP and statistical databases: Similarities and differences. In: Proceedings of the 16th ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems, PODS 1997, Tucson, Arizona, USA, pp. 185–196 (1997)Google Scholar
  16. 16.
    Horner, J., Song, I.Y., Chen, P.P.: An analysis of additivity in OLAP systems. In: Proceedings of the 7th ACM International Workshop on Data Warehousing and OLAP, DOLAP 2004, Washington, DC, USA, pp. 83–91 (2004)Google Scholar
  17. 17.
    Martyn, T.: Reconsidering multi-dimensional schemas. ACM SIGMOD Rec. 33(1), 83–88 (2004)CrossRefGoogle Scholar
  18. 18.
    Guo, Y., Tang, S., Tong, Y., Yang, D.: Triple-driven data modeling methodology in data warehousing: a case study. In: Proceedings of the 9th ACM International Workshop on Data Warehousing and OLAP, DOLAP 2006, Arlington, Virginia, USA, pp. 59–66 (2006)Google Scholar
  19. 19.
    Lenz, H.J., Shoshani, A.: Summarizability in OLAP and statistical databases. In: Proceedings of the 9th International Conference on Scientific and Statistical Database Management, SSDBM 1997, Olympia, Washington, USA, pp. 132–143 (1997)Google Scholar
  20. 20.
    van der Aalst, W.M.P., van Hee, K.M.: Workflow Management - Models, Methods, and Systems. MIT Press, Cambridge (2002)Google Scholar
  21. 21.
    Vaisman, A.A., Zimányi, E.: Data Warehouse Systems - Design and Implementation. Springer, New York (2014)Google Scholar
  22. 22.
    Fenton, N.E., Pfleeger, S.L.: Software Metrics - A Practical and Rigorous Approach. Thomson, Fenton (1996)Google Scholar
  23. 23.
    Software Engineering Institute: CMMI for Development - Version 1.3. Technical Report CMU/SEO-2010-TR-033, Carnegie-Mellon University, November 2010Google Scholar
  24. 24.
    Oivo, M., Basili, V.R.: Representing software engineering models - the TAME goal oriented approach. IEEE Trans. Softw. Eng. 18(10), 886–898 (1992)CrossRefGoogle Scholar
  25. 25.
    Oakland, J.S.: Statistical Process Control, 6th edn. Routledge, New York (2008)Google Scholar

Copyright information

© Springer International Publishing Switzerland 2016

Authors and Affiliations

  1. 1.University of Skövde, IITSkövdeSweden
  2. 2.Pannasastra UniversityPhnom PenhCambodia

Personalised recommendations