Reporting Repository: Using Standard Office Software to Manage Semantic Multidimensional Data Models

Christian Kurze, Peter Gluchowski

2009

Abstract

Implementing a business intelligence solution requires the appropriate integration of numerous tasks and components. The so-called Data Track requires three main steps: Dimensional Modeling, Physical Design, and ETL Design & Development. This paper focuses on the Dimensional Modeling step and provides a solution for managing multidimensional data models with standard office tools, namely Microsoft Visio and Access. A real-world project in the telecommunications industry provides business requirements and is used in order to prove the solution. We outline the lessons learned and give hints for further development.

References

  1. Kimball, R., Ross, M., Thorntwaite, W., Mundy, J., Recker, B.: The Data Warehouse Lifecycle Toolkit. 2nd edn. Wiley, Indianapolis (2008)
  2. Gluchowski, P., Kurze, C., Schieder, C.: A Modeling Tool for Multidimensional Data using the ADAPT Notation. Proceedings of the 42nd Hawaii International Conference on System Sciences, CD-ROM. IEEE (2009)
  3. Rittgen, P.: Collaborative Modeling - A Design Science Approach. Proceedings of the 42nd Hawaii International Conference on System Sciences, CD-ROM. IEEE (2009)
  4. Rekers, J., Schürr, A.: Defining and Parsing Visual Languages with Layered Graph Grammars. Journal of Visual Languages and Computing 1 (1997) 27-55
  5. March, S.T., Smith, G.F.: Design and natural science research on information technology. Decision Support Systems 4 (1995) 251-266
  6. Hevner, A.R., March, S.T., Park, J., Ram, S.: Design Science in Information Systems Research. MIS Quarterly 1 (2004) 75-105
  7. Rizzi, S., Abelló, A., Lechtenbörger, J., Trujillo, J.: Research in Data Warehouse Modeling and Design: Dead or Alive? Proceedings of the 9th ACM international workshop on Data warehousing and OLAP. ACM, Arlington (2006) 3-10
  8. Sapia, C., Blaschka, M., Höfling, G., Dinter, B.: Extending the E/R Model for the Multidimensional Paradigm. Proceedings of the Workshops on Data Warehousing and Data Mining: Advances in Database Technologies. Springer, London (1998) 105-116
  9. Malinowski, E., Zimámyi, E.: Hierarchies in a Multidimensional Model: From Conceptual Modeling to Logical Representation. Data & Knowledge Engineering 2 (2006) 348-377
  10. Luján-Mora, S., Trujillo, J., Song, I.: A UML profile for multidimensional data modeling in data warehouses. Data & Knowledge Engineering 3 (2006) 725-769
  11. Golfarelli, M., Maio, D., Rizzi, S.: The Dimensional Fact Model: A Conceptual Model for Data Warehouses. International Journal of Cooperative Information Systems 2-3 (1998) 215-247
  12. Bulos, D., Forman, S.: Getting Started with ADAPT. Whitepaper http://symcorp.com/ downloads/ADAPT_white_paper.pdf (2006). [01-22-2009]
  13. OMG: Common Warehouse Metamodel (CWM) Specification V 1.1. http://www.omg.org/ docs/formal/03-03-02.pdf (2003). [01-23-2009]
  14. OMG: Request For Proposal: Information Management Metamodel (IMM). http://www.omgwiki.org/imm/lib/exe/fetch.php?id=welcome_to_imm&cache=cache&medi a=05-12-02.pdf (2005). [01-23-2009]
  15. ISO/IEC 10027 Information technology - Information Resource Dictionary System (IRDS)
  16. ISO/IEC 11179 Information technology - Metadata registries (MDR)
  17. Zhu, N., Grundy, J., Hosking, J., Liu, N., Shuping, C., Mehra, A.: Pounamu: A meta-tool for exploratory domain-specific visual language tool development. The Journal of Systems and Software 3 (2007) 1390-1407
  18. Steven, K., Kalle, L., Matti, R.: MetaEdit+: A Fully Configurable Multi-User and MultiTool CASE and CAME Environment. Lecture Notes In Computer Science, Vol. 1080. Springer-Verlag, London (1996) 1-21
  19. Ferguson, R.I., Parrington, N.F., Dunne, P., Hardy, C., Archibald, J.M., Thompson, J.B.: MetaMOOSE - an object-oriented framework for the construction of CASE tools. Information and Software Technology 2 (2000) 115-128
  20. Eclipse Graphical Modeling Framework (GMF). http://www.eclipse.org/modeling/gmf/. [01-23-2009]
  21. Cook, S., Jones, G., Kent, S., Wills, A.C.: Domain-Specific Development with Visual Studio DSL Tools. Addison-Wesley, Amsterdam (2007)
  22. Bulos, D.: OLAP Database Design. A new dimension. database programming & design, 6 (1996) 33-37.
  23. Symmetry Corporation: Free ADAPT Visio Stencil. http://symcorp.com/downloads/ ADAPTv3_visio_stencil.zip. [01-23-2009]
  24. Rosemann, M., Green, P.: Developing a meta model for the Bunge-Wand-Weber ontological constructs. Information Systems 2 (2002) 75-91
Download


Paper Citation


in Harvard Style

Kurze C. and Gluchowski P. (2009). Reporting Repository: Using Standard Office Software to Manage Semantic Multidimensional Data Models . In Proceedings of the Joint Workshop on Advanced Technologies and Techniques for Enterprise Information Systems - Volume 1: AER, (ICEIS 2009) ISBN 978-989-8111-93-7, pages 67-76. DOI: 10.5220/0002174500670076


in Bibtex Style

@conference{aer09,
author={Christian Kurze and Peter Gluchowski},
title={Reporting Repository: Using Standard Office Software to Manage Semantic Multidimensional Data Models},
booktitle={Proceedings of the Joint Workshop on Advanced Technologies and Techniques for Enterprise Information Systems - Volume 1: AER, (ICEIS 2009)},
year={2009},
pages={67-76},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002174500670076},
isbn={978-989-8111-93-7},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Joint Workshop on Advanced Technologies and Techniques for Enterprise Information Systems - Volume 1: AER, (ICEIS 2009)
TI - Reporting Repository: Using Standard Office Software to Manage Semantic Multidimensional Data Models
SN - 978-989-8111-93-7
AU - Kurze C.
AU - Gluchowski P.
PY - 2009
SP - 67
EP - 76
DO - 10.5220/0002174500670076