Skip to main content
SpringerLink
Log in

Using Domain Ontologies as Semantic Dimensions in Data Warehouses

  • Conference paper
Conceptual Modeling (ER 2012)

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

Included in the following conference series:

Abstract

More and more transaction systems collect records that reference concepts of domain ontologies in so-called semantic attributes. This paper investigates how such semantic attributes together with their referenced domain ontology can be best exploited for data analysis in data warehouses. This gives rise to two challenges: first, exploit the rich knowledge represented in domain ontologies for targeted analysis and, second, aggregate data along the subsumption hierarchy of concepts and ensuring summarizability in the absence of predefined aggregation levels. To meet these challenges, the paper extends OLAP (OnLine Analytical Processing) by integrating concept expressions and proper level definitions over domain ontologies into OLAP operations. A prototype demonstrates the feasibility of the approach.

This work is funded by the Austrian Ministry of Transport, Innovation, and Technology in program FIT-IT Semantic Systems and Services under grant FFG-829594 (Semantic Cockpit: an ontology-driven, interactive business intelligence tool for comparative data analysis).

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. Baader, F., Nutt, W.: Basic description logics. Description Logic Handbook, 43–95 (2003)

    Google Scholar 

  2. Baader, F., Sattler, U.: Description logics with aggregates and concrete domains. Inf. Syst. 28(8), 979–1004 (2003)

    Article  MATH  Google Scholar 

  3. Benson, T.: Principles of health interoperability HL7 and SNOMED. Springer (2010)

    Google Scholar 

  4. Berndt, D., Hevner, A., Studnicki, J.: The catch data warehouse: support for community health care decision-making. Decision Support Systems 35(3), 367–384 (2003)

    Article  Google Scholar 

  5. Calvanese, D., Kharlamov, E., Nutt, W., Thorne, C.: Aggregate queries over ontologies. In: ONISW 2008: Proceeding of the 2nd International Workshop on Ontologies and Information Systems for the Semantic Web, pp. 97–104. ACM, New York (2008)

    Chapter  Google Scholar 

  6. Das, S., Chong, E.I., Eadon, G., Srinivasan, J.: Supporting ontology-based semantic matching in rdbms. In: VLDB, pp. 1054–1065 (2004)

    Google Scholar 

  7. Eder, J., Koncilia, C.: Incorporating icd-9 and icd-10 data in a warehouse. In: CBMS, pp. 91–96. IEEE Computer Society (2002)

    Google Scholar 

  8. Horridge, M., Bechhofer, S.: The owl api: a java api for working with owl 2 ontologies. In: Proc. OWLED 2009 Workshop on OWL: Experiences and Directions. CEUR Workshop Proceedings, vol. 529 (2009)

    Google Scholar 

  9. Hurtado, C.A., Mendelzon, A.O.: Reasoning about Summarizability in Heterogeneous Multidimensional Schemas. In: Van den Bussche, J., Vianu, V. (eds.) ICDT 2001. LNCS, vol. 1973, pp. 375–389. Springer, Heidelberg (2000)

    Chapter  Google Scholar 

  10. Khouri, S., Bellatreche, L.: A methodology and tool for conceptual designing a data warehouse from ontology-based sources. In: DOLAP, pp. 19–24 (2010)

    Google Scholar 

  11. Lehner, W., Albrecht, J., Wedekind, H.: Normal forms for multidimensional databases. In: Rafanelli, Jarke [21], pp. 63–72.

    Google Scholar 

  12. Lenz, H.J., Shoshani, A.: Summarizability in olap and statistical data bases. In: SSDBM, pp. 132–143 (1997)

    Google Scholar 

  13. Lieberman, M.I., Ricciardi, T.N., Masarie, F., Spackman, K.A.: The use of SNOMED CT simplifies querying of a clinical data warehouse. In: AMIA Annu. Symp. Proc. (2003)

    Google Scholar 

  14. Malinowski, E., Zimányi, E.: Hierarchies in a multidimensional model: From conceptual modeling to logical representation. Data Knowl. Eng. 59(2), 348–377 (2006)

    Article  Google Scholar 

  15. Martinenghi, D., Torlone, R.: Querying Databases with Taxonomies. In: Parsons, J., Saeki, M., Shoval, P., Woo, C., Wand, Y. (eds.) ER 2010. LNCS, vol. 6412, pp. 377–390. Springer, Heidelberg (2010)

    Chapter  Google Scholar 

  16. Nebot, V., Llavori, R.B., Pérez-Martínez, J.M., Aramburu, M.J., Pedersen, T.B.: Multidimensional Integrated Ontologies: A Framework for Designing Semantic Data Warehouses. In: Spaccapietra, S., Zimányi, E., Song, I.-Y. (eds.) Journal on Data Semantics XIII. LNCS, vol. 5530, pp. 1–36. Springer, Heidelberg (2009)

    Chapter  Google Scholar 

  17. Neumayr, B., Schrefl, M., Thalheim, B.: Hetero-homogeneous hierarchies in data warehouses. In: Link, S., Ghose, A. (eds.) APCCM. CRPIT, vol. 110, pp. 61–70. Australian Computer Society (2010)

    Google Scholar 

  18. Pardillo, J., Mazón, J.N.: Using ontologies for the design of data warehouses. International Journal of Database Management Systems (IJDMS) 3(2), 73–87 (2011)

    Article  Google Scholar 

  19. Pedersen, T.B., Jensen, C.S.: Research issues in clinical data warehousing. In: Rafanelli, Jarke [21], pp. 43–52.

    Google Scholar 

  20. The PostgreSQL Global Development Group: PostgreSQL 9.0.7 Documentation (2010), http://www.postgresql.org/docs/9.0/static/index.html (viewed March 11, 2012)

  21. Rafanelli, M., Jarke, M. (eds.): Proceedings of 10th International Conference on Scientific and Statistical Database Management, July 1-3. IEEE Computer Society, Capri (1998)

    Google Scholar 

  22. Rizzi, S., Abelló, A., Lechtenbörger, J., Trujillo, J.: Research in data warehouse modeling and design: dead or alive? In: Proceedings of the 9th ACM International Workshop on Data Warehousing and OLAP, pp. 3–10. ACM (2006)

    Google Scholar 

  23. Romero, O., Abelló, A.: A framework for multidimensional design of data warehouses from ontologies. Data Knowl. Eng. 69(11), 1138–1157 (2010)

    Article  Google Scholar 

  24. Rosenbloom, S., Miller, R., Johnson, K., Elkin, P., Brown, S.: Interface terminologies: facilitating direct entry of clinical data into electronic health record systems. Journal of the American Medical Informatics Association 13(3), 277–288 (2006)

    Article  Google Scholar 

  25. Schulz, S., Cornet, R.: Snomed cts ontological commitment. In: International Conference on Biomedical Ontology (2009)

    Google Scholar 

  26. Shearer, R., Motik, B., Horrocks, I.: Hermit: A highly-efficient owl reasoner. In: Proceedings of the 5th International Workshop on OWL: Experiences and Directions (OWLED 2008), pp. 26–27 (2008)

    Google Scholar 

  27. Vassiliadis, P., Sellis, T.: A survey of logical models for olap databases. ACM SIGMOD Record 28(4), 64–69 (1999)

    Article  Google Scholar 

  28. World Health Organization: The icd-10 classification of mental and behavioural disorders: diagnostic criteria for research (1993)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department of Business Informatics - Data & Knowledge Engineering, Johannes Kepler University Linz, Austria

    Stefan Anderlik, Bernd Neumayr & Michael Schrefl

Authors
  1. Stefan Anderlik
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Bernd Neumayr
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Michael Schrefl
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Dipartimento di informatica e Automazione, Università Roma Tre, Via Vasca Navale, 79, 00145, Roma, Italy

    Paolo Atzeni

  2. Department of Computer Science, University of Hong Kong, Pok Fu Lam Road, Hong Kong, China

    David Cheung

  3. Eller College of Management, University of Arizona, McClelland Hall, Room 108, P.O. Box 210108, 85721-0108, Tucson, AZ, USA

    Sudha Ram

Rights and permissions

Reprints and permissions

Copyright information

© 2012 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Anderlik, S., Neumayr, B., Schrefl, M. (2012). Using Domain Ontologies as Semantic Dimensions in Data Warehouses. In: Atzeni, P., Cheung, D., Ram, S. (eds) Conceptual Modeling. ER 2012. Lecture Notes in Computer Science, vol 7532. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-34002-4_7

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-34002-4_7

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-34001-7

  • Online ISBN: 978-3-642-34002-4

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation