Skip to main content
SpringerLink
Log in

Multidimensional Integrated Ontologies: A Framework for Designing Semantic Data Warehouses

  • Chapter
Book cover Journal on Data Semantics XIII

Part of the book series: Lecture Notes in Computer Science ((JODS,volume 5530))

Abstract

The Semantic Web enables organizations to attach semantic annotations taken from domain and application ontologies to the information they generate. The concepts in these ontologies could describe the facts, dimensions and categories implied in the analysis subjects of a data warehouse. In this paper we propose the Semantic Data Warehouse to be a repository of ontologies and semantically annotated data resources. We also propose an ontology-driven framework to design multidimensional analysis models for Semantic Data Warehouses. This framework provides means for building a Multidimensional Integrated Ontology (MIO) including the classes, relationships and instances that represent interesting analysis dimensions, and it can be also used to check the properties required by current multidimensional databases (e.g., dimension orthogonality, category satisfiability, etc.) In this paper we also sketch how the instance data of a MIO can be translated into OLAP cubes for analysis purposes. Finally, some implementation issues of the overall framework are discussed.

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. Abelló, A.: YAM2: A Multidimensional Conceptual Model. PhD thesis, Departament de Llenguatges i Sistemes Informàtics, Universitat Politècnica de Catalunya, Spain (2002)

    Google Scholar 

  2. Abelló, A., Samos, J., Saltor, F.: Yam2: a multidimensional conceptual model extending UML. Information Systems 31(6), 541–567 (2006)

    Article  Google Scholar 

  3. Baader, F., Sattler, U.: Description logics with aggregates and concrete domains. Information Systems 28(8), 979–1004 (2003)

    Article  MATH  Google Scholar 

  4. Bao, J., Caragea, D., Honavar, V.: Package-based description logics - preliminary results. In: Cruz, I., Decker, S., Allemang, D., Preist, C., Schwabe, D., Mika, P., Uschold, M., Aroyo, L.M. (eds.) ISWC 2006. LNCS, vol. 4273, pp. 967–969. Springer, Heidelberg (2006)

    Chapter  Google Scholar 

  5. Borgida, A., Serafini, L.: Distributed description logics: Assimilating information from peer sources. Journal on Data Semantics 1, 153–184 (2003)

    Google Scholar 

  6. Bouquet, P., Giunchiglia, F., van Harmelen, F., Serafini, L., Stuchenschmidt, H.: C-OWL: Contextualizing ontologies. In: Fensel, D., Sycara, K.P., Mylopoulos, J. (eds.) ISWC 2003. LNCS, vol. 2870, pp. 164–179. Springer, Heidelberg (2003)

    Google Scholar 

  7. Calvanese, D., Giacomo, G.D., Lenzerini, M.: A framework for ontology integration. In: Semantic Web Working Symposium, pp. 303–316 (2001)

    Google Scholar 

  8. Choi, N., Song, I.-Y., Han, H.: A survey on ontology mapping. SIGMOD Record 35(3), 34–41 (2006)

    Article  Google Scholar 

  9. Cuenca-Grau, B., Parsia, B., Sirin, E., Kalyanpur, A.: Automatic partitioning of OWL ontologies using E-connections. In: Description Logics. CEUR Workshop Online Proceedings, vol. 147 (2005)

    Google Scholar 

  10. Danger, R., Berlanga, R.: A Semantic Web approach for ontological instances analysis. Communications in Computer and Information Science 22, 269–282 (2008)

    Article  Google Scholar 

  11. Euzenat, J., Shvaiko, P.: Ontology Matching. Springer, Heidelberg (2007)

    MATH  Google Scholar 

  12. Franconi, E., Ng, G.: The i.com tool for intelligent conceptual modeling. In: Proc. of the 7th International Workshop on Knowledge Representation Meets Databases, pp. 45–53 (2000)

    Google Scholar 

  13. Garwood, K., McLaughlin, T., Garwood, C., Joens, S., Morrison, N., Taylor, C.F., Carroll, K., Evans, C., Whetton, A.D., Hart, S., Stead, D., Yin, Z., Brown, A.J., Hesketh, A., Chater, K., Hansson, L., Mewissen, M., Ghazal, P., Howard, J., Lilley, K.S., Gaskell, S.J., Brass, A., Hubbard, S.J., Oliver, S.G., Paton, N.W.: PEDRo: a database for storing, searching and disseminating experimental proteomics data. BMC Genomics 5(68) (2004)

    Google Scholar 

  14. Harris, S., Gibbins, N.: 3store: Efficient Bulk RDF Storage. In: Proc. of the First International Workshop on Practical and Scalable Semantic Systems. CEUR Workshop Online Proceedings, vol. 89 (2003)

    Google Scholar 

  15. Horrocks, I., Sattler, U.: Decidability of SHIQ with complex role inclusion axioms. In: International Joint Conference on Artificial Intelligence, pp. 343–348 (2003)

    Google Scholar 

  16. Hu, W., Qu, Y., Cheng, G.: Matching large ontologies: A divide-and-conquer approach. Data and Knowledge Engineering 67, 140–160 (2008)

    Article  Google Scholar 

  17. Hurtado, C.A., Mendelzon, A.O.: OLAP dimension constraints. In: Proc. ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems, pp. 169–179 (2002)

    Google Scholar 

  18. Jiménez-Ruiz, E., Berlanga, R., Nebot, V., Sanz, I.: OntoPath: A Language for Retrieving Ontology Fragments. In: Meersman, R., Tari, Z. (eds.) Proc. of On the Move to Meaningful Internet Systems, pp. 897–914 (2007)

    Google Scholar 

  19. Jiménez-Ruiz, E., Cuenca-Grau, B., Sattler, U., Schneider, T., Berlanga, R.: Safe and economic re-use of ontologies: A logic-based methodology and tool support. In: Bechhofer, S., Hauswirth, M., Hoffmann, J., Koubarakis, M. (eds.) ESWC 2008. LNCS, vol. 5021, pp. 185–199. Springer, Heidelberg (2008)

    Chapter  Google Scholar 

  20. Kalfoglou, Y., Schorlemmer, M.: Ontology mapping: the state of the art. The Knowledge Engineering Review 18(1), 1–31 (2003)

    Article  Google Scholar 

  21. Köhler, J., Philippi, S., Lange, M.: Semeda: ontology based semantic integration of biological databases. Bioinformatics 19(18), 2420–2427 (2003)

    Article  Google Scholar 

  22. Lenz, H., Shoshani, A.: Summarizability in OLAP and statistical data bases. In: Ninth International Conference on Scientific and Statistical Database Management, pp. 132–143 (1997)

    Google Scholar 

  23. Louie, B., Mork, P., Martin-Sanchez, F., Halevy, A., Tarczy-Hornoch, P.: Data integration and genomic medicine. Journal of Biomedical Informatics 10(1), 5–16 (2006)

    Google Scholar 

  24. Lu, J., Ma, L., Zhang, L., Brunner, J.-S., Wang, C., Pan, Y., Yu, Y.: SOR: A practical system for ontology storage, reasoning and search. In: Proc. of the 33th International Conference on Very Large Data Bases, pp. 1402–1405 (2007)

    Google Scholar 

  25. Lutz, C., Areces, C., Horrocks, I., Sattler, U.: Nominals, and Concrete Domains. Journal of Artificial Intelligence 23, 667–726 (2005)

    MathSciNet  Google Scholar 

  26. Marian, A., Abiteboul, S., Cóbena, G., Mignet, L.: Change-centric management of versions in an XML warehouse. In: Proc. of the 27th International Conference on Very Large Data Bases, pp. 581–590 (2001)

    Google Scholar 

  27. Mena, E., Illarramendi, A., Kashyap, V., Sheth, A.P.: Observer: An approach for query processing in global information systems based on interoperation across pre-existing ontologies. Distributed and Parallel Databases 8(2), 223–271 (2000)

    Article  Google Scholar 

  28. Nebot, V., Berlanga, R.: Building Ontologies from Very Large Knowledge Resources. In: Proc. Of 11th International Conference on Enterprise Information Systems (submitted, 2009)

    Google Scholar 

  29. Nguyen, T.B., Abiteboul, S., Cóbena, G., Preda, M.: Monitoring XML data on the web. In: Proc. of the 2001 ACM SIGMOD International Conference on Management of Data, pp. 437–448 (2001a)

    Google Scholar 

  30. Nguyen, T.B., Tjoa, A.M., Mangisengi, O.: Meta Cube-X: An XML Metadata Foundation of Interoperability Search among Web Data Warehouses. In: Nguyen, T.B. (ed.) Proc. of the Third International Workshop on Design and Management of Data Warehouses. CEUR Workshop Online Proceedings, vol. 39 (2001b)

    Google Scholar 

  31. Pedersen, D., Riis, K., Pedersen, T.B.: XML-extended OLAP querying. In: Proc. of the 14th International Conference on Scientific and Statistical Database Management, pp. 195–206 (2002)

    Google Scholar 

  32. Pedersen, T.B., Jensen, C.S., Dyreson, C.E.: Extending practical pre-aggregation in on-line analytical processing. In: Proc. of the 25th International Conference on Very Large Data Bases, pp. 663–674 (1999)

    Google Scholar 

  33. Pedersen, T.B., Jensen, C.S., Dyreson, C.E.: A foundation for capturing and querying complex multidimensional data. Information Systems 26(5), 383–423 (2001)

    Article  MATH  Google Scholar 

  34. Pérez, J.M., Berlanga, R., Aramburu, M.J., Pedersen, T.B.: Integrating data warehouses with web data: A survey. IEEE Transactions on Knowledge and Data Engineering 20(7), 940–955 (2008)

    Article  Google Scholar 

  35. Pérez-Rey, D., Maojo, V., García-Remesal, M., Alonso-Calvo, R., Billhardt, H., Martin-Sánchez, F., Sousa, A.: Ontofusion: Ontology-based integration of genomic and clinical databases. Compututers in Biology and Medicine 36(7-8), 712–730 (2005)

    Article  Google Scholar 

  36. Priebe, T., Pernul, G.: Ontology-based integration of OLAP and information retrieval. In: Proc. of the 14th International Workshop on Database and Expert Systems Applications, pp. 610–614 (2003)

    Google Scholar 

  37. Roldán-García, M., del, M., Aldana-Montes, J.F.: DBOWL: Towards a scalable and persistent OWL reasoner. In: The Third International Conference on Internet and Web Applications and Services, pp. 174–179 (2008)

    Google Scholar 

  38. Romero, O., Abelló, A.: Automating multidimensional design from ontologies. In: Proc. of the 10th International Workshop on Data Warehousing and OLAP, pp. 1–8 (2007)

    Google Scholar 

  39. Rubin, D.L., Shah, N.H., Noy, N.F.: Biomedical ontologies: a functional perspective. Briefings in Bionformatics 9(1), 75–90 (2007)

    Article  Google Scholar 

  40. Schmidt-Schauss, M., Smolka, G.: Attributive concept descriptions with complements. Artificial Intelligence 48(1), 1–26 (1991)

    Article  MATH  MathSciNet  Google Scholar 

  41. Simitsis, A., Skoutas, D., Castellanos, M.: Natural language reporting for ETL processes. In: Proc. of the ACM 11th International Workshop on Data Warehousing and OLAP, pp. 65–72 (2008)

    Google Scholar 

  42. Skoutas, D., Simitsis, A.: Designing ETL processes using Semantic Web technologies. In: Proc. of the ACM 9th International Workshop on Data Warehousing and OLAP, pp. 67–74 (2006)

    Google Scholar 

  43. Stuckenschmidt, H., Klein, M.C.A.: Reasoning and change management in modular ontologies. Data and Knowledge Engineering 63(2), 200–223 (2007)

    Article  Google Scholar 

  44. Wang, L., Zhang, A., Ramanathan, M.: Biostar models of clinical and genomic data for biomedical data warehouse design. International Journal of Bioinformatics Research and Applications 1(1), 63–80 (2005)

    Article  Google Scholar 

  45. Xyleme: A dynamic warehouse for XML data of the Web. IEEE Data Engineering Bulleting 24(2), 40–47 (2001)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Universitat Jaume I, Av. Vicent Sos Baynat, s/n, E-12071, Castelló, Spain

    Victoria Nebot, Rafael Berlanga, Juan Manuel Pérez & María José Aramburu

  2. Aalborg University, Selma Lagerløfs Vej 300, DK-9220, Aalborg Ø, Denmark

    Torben Bach Pedersen

Authors
  1. Victoria Nebot
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Rafael Berlanga
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Juan Manuel Pérez
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. María José Aramburu
    View author publications

    You can also search for this author in PubMed Google Scholar

  5. Torben Bach Pedersen
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. EPFL-IC, Database Laboratory, École Polytechnique Fédérale de Lausanne, 1015, Lausanne, Switzerland

    Stefano Spaccapietra

  2. Department of Computer and Decision Engineering,, Université Libre de Bruxelles, 50av. F.D. Roosevelt, 1050, Bruxelles, Belgium

    Esteban Zimányi

  3. College of Information Science and Technology,, Drexel University, 19104, Philadelphia, PA, USA

    Il-Yeol Song

Rights and permissions

Reprints and permissions

Copyright information

© 2009 Springer-Verlag Berlin Heidelberg

About this chapter

Cite this chapter

Nebot, V., Berlanga, R., Pérez, J.M., Aramburu, M.J., Pedersen, T.B. (2009). Multidimensional Integrated Ontologies: A Framework for Designing Semantic Data Warehouses. In: Spaccapietra, S., Zimányi, E., Song, IY. (eds) Journal on Data Semantics XIII. Lecture Notes in Computer Science, vol 5530. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-03098-7_1

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-03098-7_1

  • Publisher Name: Springer, Berlin, Heidelberg

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

  • Online ISBN: 978-3-642-03098-7

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation