Skip to main content
SpringerLink
Log in

Ontology-Based Exchange and Immediate Application of Business Calculation Definitions for Online Analytical Processing

  • Conference paper
Data Warehousing and Knowledge Discovery (DaWaK 2009)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 5691))

Included in the following conference series:

Abstract

Business users define calculated facts based on the dimensions and facts contained in a data warehouse. These business calculation definitions contain necessary knowledge regarding quantitative relations for deep analyses and for the production of meaningful reports. The business calculation definitions are implementation and widely organization independent. But no automated procedures facilitating their exchange across organization and implementation boundaries exist. Separately each organization currently has to map its own business calculations to analysis and reporting tools. This paper presents an innovative approach based on standard Semantic Web technologies. This approach facilitates the exchange of business calculation definitions and allows for their automatic linking to specific data warehouses through semantic reasoning. A novel standard proxy server which enables the immediate application of exchanged definitions is introduced. Benefits of the approach are shown in a comprehensive case study.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Inmon, W.H.: Building the Data Warehouse. Wiley, New York (2005)

    Google Scholar 

  2. Kimball, R.: The Data Warehouse Lifecycle Toolkit. Wiley, New York (2008)

    Google Scholar 

  3. Microsoft Corporation: Microsoft Analysis Services, http://www.microsoft.com/sql/technologies/analysis/default.mspx

  4. Pentaho Corporation: Pentaho Analysis Services, http://mondrian.pentaho.org

  5. SAP AG: SAP NetWeaver Business Intelligence http://www.sap.com/germany/plattform/netweaver/components/businessintelligence/index.epx

  6. Guizzardi, G.: On Ontology, ontologies, Conceptualizations, Modeling Languages, and (Meta)Models. Frontiers in Artificial Intelligence and Applications 155, 18–35 (2007)

    Google Scholar 

  7. Object Management Group (OMG): Ontology Definition Metamodel (ODM) Beta 2 (2007), http://www.omg.org/cgi-bin/doc?ptc/07-09-09

  8. Object Management Group (OMG): Common Warehouse Metamodel (CWM) 1.1 (2003), http://www.omg.org/spec/CWM/1.1/PDF/

  9. Object Management Group (OMG): CWM Metadata Interchange Patterns (2004), http://www.omg.org/cgi-bin/doc?formal/04-03-25

  10. Object Management Group (OMG): XML Metadata Interchange 2.1.1 (2007), http://www.omg.org/docs/formal/07-12-01.pdf

  11. Januszewski, A., Pankowski, T.: Modeling Analytical Indicators Using Data Warehouse Metamodel. In: Bressan, S., Küng, J., Wagner, R. (eds.) DEXA 2006. LNCS, vol. 4080, pp. 642–646. Springer, Heidelberg (2006)

    Google Scholar 

  12. Object Management Group (OMG): MDA Guide 1.0.1 (2003), http://www.omg.org/docs/omg/03-06-01.pdf

  13. Object Management Group (OMG): Unified Modeling Language 2.2 Beta 1 (2008), http://www.omg.org/docs/pct/08-04-04.pdf

  14. Object Management Group (OMG): MOF Query / View / Transformations 1.0 (2008), http://www.omg.org/docs/formal/08-04-03.pdf

  15. Mazón, J.-N., Trujillo, J.: An MDA approach for the development of data warehouses. Decision Support Systems 45, 41–58 (2008)

    Article  Google Scholar 

  16. Pardillo, J., Mazón, J.-N., Trujillo, J.: Bridging the Semantic Gap in OLAP Models: Platform-independent Queries. In: Proceedings of the 11th International Workshop on Data Warehousing and OLAP (DOLAP 2008), pp. 89–96. ACM Press, New York (2008)

    Google Scholar 

  17. World Wide Web Consortium (W3C): OWL Web Ontology Language, http://www.w3.org/TR/2004/REC-owl-features-20040210/

  18. Xie, G., Yang, Y., Liu, S., Qiu, Z., Pan, Y., Zhou, X.: EIAW: Towards a Business-friendly Data Warehouse Using Semantic Web Technologies. In: ASWC 2007 and ISWC 2007, pp. 857–870. IEEE, Los Alamitos (2007)

    Google Scholar 

  19. Diamantini, C., Potena, D.: Semantic Enrichtment of Strategic Datacubes. In: Proceedings of the 11th International Workshop on Data Warehousing and OLAP (DOLAP 2008), pp. 81–88. ACM Press, New York (2008)

    Google Scholar 

  20. World Wide Web Consortium (W3C): Mathematical Markup Language (MathML) 3.0, http://www.w3.org/TR/2008/WD-MathML3-20081117/

  21. The OpenMath Standard 2.0, http://www.openmath.org/standard/om20-2004-06-30/omstd20.pdf

  22. de Laborda, C.P., Conrad, S.: Relational.OWL - A Data and Schema Representation Format Based on OWL. In: Proceedings of the 2nd Asia-Pacifc Conference on Conceptual Modelling (APCCM 2005) (2005)

    Google Scholar 

  23. World Wide Web Consortium (W3C): Extensible Markup Language(XML) 1.0, http://www.w3.org/TR/2008/REC-xml-20081126/

  24. Organization for the Advancement of Structured Information Standards (OASIS): The OpenDocument v1.0 Specification, http://www.oasis-open.org/committees/download.php/12572/OpenDocument-v1.0-os.pdf

  25. University of Manchester: The Manchester OWL Syntax, http://www.co-ode.org/resources/reference/manchester_syntax/

  26. World Wide Web Consortium (W3C): XHTML 1.0: The Extensible HyperText Markup Language, http://www.w3.org/TR/2000/REC-xhtml1-20000126/

  27. Microsoft Corporation: OLE DB for Online Analytical Processing (OLAP), http://msdn.microsoft.com/en-us/library/ms717005(VS.85).aspx

    Google Scholar 

  28. Microsoft Corporation, Hyperion Solutions Corporation: XML for Analysis Specification 1.1, http://www.xmlforanalysis.com/xmla1.1.doc

  29. Horridge, M., Bechhofer, S., Noppens, O.: Igniting the OWL 1.1 Touch Paper: The OWL API. Proceedings of the OWLED 2007, Workshop on OWL: Experiences and Directions. CEUR-WS.org (2007)

    Google Scholar 

  30. World Wide Web Consortium (W3C): SWRL: A Semantic Web Rule Language Combining OWL and RuleML, http://www.w3.org/Submissions/2004/SUBM-SWRL-20040521/

  31. Microsoft Corporation: COM: Component Object Model Technologies, http://www.microsoft.com/com/default.mspx

  32. World Wide Web Consortium (W3C): SOAP 1.2, http://www.w3.org/TR/2007/REC-soap12-part1-20070427/

  33. World Wide Web Consortium (W3C): Web Services Definition Language (WSDL) 2.0, http://www.w3.org/TR/2007/REC-wsdl20-primer-20070626/

  34. The Apache Software Foundation: Apache CXF: An Open Source Service Framework, http://cxf.apache.org/

  35. Simba Technologies: SimbaO2X, http://www.simba.com/odbo-to-xmla.htm

  36. Integre Technical Publishing Co., Inc.: MathML Equation Editor, http://www.integretechpub.com/zed/

  37. Clark & Parsia, LLC: Pellet: The Open Source OWL DL Reasoner, http://clarkparsia.com/pellet/

  38. Sun Microsystems, Inc: JSR 224: Java API for XML-Based Web Services (JAX-WS) 2.0, http://jcp.org/en/jsr/detail?id=224

  39. Microsoft Corporation: Multidimensional Expressions (MDX) Reference, http://msdn.microsoft.com/en-us/library/ms145506.aspx

  40. International Business Machines Corp. (IBM): Dataquant, http://www-01.ibm.com/software/data/db2imstools/db2tools/dataquant/index.html

  41. Microsoft Corporation: Microsoft Office Excel, http://office.microsoft.com/en-us/excel/FX100487621033.aspx

Download references

Author information

Authors and Affiliations

  1. Institut für Wirtschaftsinformatik, Leibniz Universität Hannover, Germany

    Matthias Kehlenbeck & Michael H. Breitner

Authors
  1. Matthias Kehlenbeck
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Michael H. Breitner
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Department of Computer Science, Aalborg University, Selma Lagerlöfsvej 300, 9220, Aalborg Ø, Denmark

    Torben Bach Pedersen

  2. IBM India Research Lab, Plot No. 4, Block C, Institutional Area, Vasant Kunj, 110 070, New Delhi, India

    Mukesh K. Mohania

  3. Institute of Software Technology and Interactive Systems, Vienna University of Technology, Favoritenstr. 9-11/188, 1040, Wien, Austria

    A Min Tjoa

Rights and permissions

Reprints and permissions

Copyright information

© 2009 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Kehlenbeck, M., Breitner, M.H. (2009). Ontology-Based Exchange and Immediate Application of Business Calculation Definitions for Online Analytical Processing. In: Pedersen, T.B., Mohania, M.K., Tjoa, A.M. (eds) Data Warehousing and Knowledge Discovery. DaWaK 2009. Lecture Notes in Computer Science, vol 5691. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-03730-6_24

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-03730-6_24

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-03729-0

  • Online ISBN: 978-3-642-03730-6

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation