Multidimensional Integrated Ontologies: A Framework for Designing Semantic Data Warehouses

  • Victoria Nebot
  • Rafael Berlanga
  • Juan Manuel Pérez
  • María José Aramburu
  • Torben Bach Pedersen
Part of the Lecture Notes in Computer Science book series (LNCS, volume 5530)


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.


Data warehouses Semantic Web Multi-ontology integration 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 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. 2.
    Abelló, A., Samos, J., Saltor, F.: Yam2: a multidimensional conceptual model extending UML. Information Systems 31(6), 541–567 (2006)CrossRefGoogle Scholar
  3. 3.
    Baader, F., Sattler, U.: Description logics with aggregates and concrete domains. Information Systems 28(8), 979–1004 (2003)zbMATHCrossRefGoogle Scholar
  4. 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)CrossRefGoogle Scholar
  5. 5.
    Borgida, A., Serafini, L.: Distributed description logics: Assimilating information from peer sources. Journal on Data Semantics 1, 153–184 (2003)Google Scholar
  6. 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. 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. 8.
    Choi, N., Song, I.-Y., Han, H.: A survey on ontology mapping. SIGMOD Record 35(3), 34–41 (2006)CrossRefGoogle Scholar
  9. 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. 10.
    Danger, R., Berlanga, R.: A Semantic Web approach for ontological instances analysis. Communications in Computer and Information Science 22, 269–282 (2008)CrossRefGoogle Scholar
  11. 11.
    Euzenat, J., Shvaiko, P.: Ontology Matching. Springer, Heidelberg (2007)zbMATHGoogle Scholar
  12. 12.
    Franconi, E., Ng, G.: The tool for intelligent conceptual modeling. In: Proc. of the 7th International Workshop on Knowledge Representation Meets Databases, pp. 45–53 (2000)Google Scholar
  13. 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. 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. 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. 16.
    Hu, W., Qu, Y., Cheng, G.: Matching large ontologies: A divide-and-conquer approach. Data and Knowledge Engineering 67, 140–160 (2008)CrossRefGoogle Scholar
  17. 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. 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. 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)CrossRefGoogle Scholar
  20. 20.
    Kalfoglou, Y., Schorlemmer, M.: Ontology mapping: the state of the art. The Knowledge Engineering Review 18(1), 1–31 (2003)CrossRefGoogle Scholar
  21. 21.
    Köhler, J., Philippi, S., Lange, M.: Semeda: ontology based semantic integration of biological databases. Bioinformatics 19(18), 2420–2427 (2003)CrossRefGoogle Scholar
  22. 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. 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. 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. 25.
    Lutz, C., Areces, C., Horrocks, I., Sattler, U.: Nominals, and Concrete Domains. Journal of Artificial Intelligence 23, 667–726 (2005)MathSciNetGoogle Scholar
  26. 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. 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)CrossRefGoogle Scholar
  28. 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. 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. 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. 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. 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. 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)zbMATHCrossRefGoogle Scholar
  34. 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)CrossRefGoogle Scholar
  35. 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)CrossRefGoogle Scholar
  36. 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. 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. 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. 39.
    Rubin, D.L., Shah, N.H., Noy, N.F.: Biomedical ontologies: a functional perspective. Briefings in Bionformatics 9(1), 75–90 (2007)CrossRefGoogle Scholar
  40. 40.
    Schmidt-Schauss, M., Smolka, G.: Attributive concept descriptions with complements. Artificial Intelligence 48(1), 1–26 (1991)zbMATHCrossRefMathSciNetGoogle Scholar
  41. 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. 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. 43.
    Stuckenschmidt, H., Klein, M.C.A.: Reasoning and change management in modular ontologies. Data and Knowledge Engineering 63(2), 200–223 (2007)CrossRefGoogle Scholar
  44. 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)CrossRefGoogle Scholar
  45. 45.
    Xyleme: A dynamic warehouse for XML data of the Web. IEEE Data Engineering Bulleting 24(2), 40–47 (2001)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2009

Authors and Affiliations

  • Victoria Nebot
    • 1
  • Rafael Berlanga
    • 1
  • Juan Manuel Pérez
    • 1
  • María José Aramburu
    • 1
  • Torben Bach Pedersen
    • 2
  1. 1.Universitat Jaume ICastellóSpain
  2. 2.Aalborg UniversityAalborg ØDenmark

Personalised recommendations