User-Specific Semantic Integration of Heterogeneous Data: The SIRUP Approach

  • Patrick Ziegler
  • Klaus R. Dittrich
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 3226)


We give an overview of the SIRUP (Semantic Integration Reflecting User-specific semantic Perspectives) approach to semantic data integration that takes into account heterogeneity of data receivers. Our goal is to provide means that allow data from heterogeneous sources to be integrated in a way that it perfectly fits to a particular user’s information needs, emphasizing his individual way to perceive a domain of interest. To achieve this, we propose to use a semantic multidatasource language to declaratively manipulate so-called IConcepts; these are basic conceptual building blocks to which attribute data that refers to the same real-world concept is linked by data providers. We provide explicit, queryable semantics by connecting IConcepts to concepts of ontologies. Additionally, pre-integrating data on a conceptual level through IConcepts shields SIRUP end-users from low-level heterogeneity and technical details of underlying data sources.


Global Schema Data Provider Data Semantic Ontology Language Semantic Integration 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


  1. 1.
    Ahmed, R., Smedt, P.D., Du, W., Kent, W., Ketabchi, M.A., Litwin, W., Rafii, A., Shan, M.-C.: The Pegasus Heterogeneous Multidatabase System. IEEE Computer 24(12), 19–27 (1991)Google Scholar
  2. 2.
    Arens, Y., Chee, C.Y., Hsu, C.-N., Knoblock, C.A.: Retrieving and Integrating Data from Multiple Information Sources. International Journal of Cooperative Information Systems (IJCIS) 2(2), 127–158 (1993)CrossRefGoogle Scholar
  3. 3.
    Bergamaschi, S., Castano, S., De Capitani di Vimercati, S., Montanari, S., Vincini, M.: An Intelligent Approach to Information Integration. In: Guarino, N. (ed.) 1st International Conference on Formal Ontologies in Information Systems (FOIS 1998), Trento, Italy, June 6-8, pp. 253–267. IOS Press, Amsterdam (1998)Google Scholar
  4. 4.
    Carey, M., Haas, L., Schwarz, P., Arya, M., Cody, W., Fagin, R., Flickner, M., Luniewski, A., Niblack, W., Petkovic, D., Thomas, J., Williams, J., Wimmers, E.: Towards Heterogeneous Multimedia Information Systems: The Garlic Approach. In: 5th International Workshop on Research Issues in Data Engineering-Distributed Object Management (RIDE-DOM 1995), Taipei, Taiwan, March 6-7, pp. 124–131 (1995)Google Scholar
  5. 5.
    Chawathe, S., Garcia-Molina, H., Hammer, J., Ireland, K., Papakonstantinou, Y., Ullman, J., Widom, J.: The TSIMMIS Project: Integration of Heterogeneous Information Sources. In: 16th Meeting of the Information Processing Society of Japan (IPSJ), Tokyo, Japan, October 1994, pp. 7–18 (1994)Google Scholar
  6. 6.
    Collet, C., Huhns, M.N., Shen, W.-M.: Resource Integration Using a Large Knowledge Base in Carnot. IEEE Computer 24(12), 55–62 (1991)Google Scholar
  7. 7.
    Corcho, O., Gómez-Pérez, A.: A Roadmap to Ontology Specification Languages. In: Dieng, R., Corby, O. (eds.) EKAW 2000. LNCS (LNAI), vol. 1937, pp. 80–96. Springer, Heidelberg (2000)CrossRefGoogle Scholar
  8. 8.
    Fensel, D., Angele, J., Decker, S., Erdmann, M., Schnurr, H.-P., Staab, S., Studer, R., Witt, A.: On2broker: Semantic-based Access to Information Sources at the WWW. In: Bra, P.D., Leggett, J.J. (eds.) World Conference on the WWW and Internet (WebNet 1999), Honolulu, Hawaii, USA, October 25-30, pp. 25–30 (1999) ,Association for the Advancement of Computing in Eduction (AACE)Google Scholar
  9. 9.
    Garc‘ia-Solaco, M., Saltor, F., Castellanos, M.: Semantic Heterogeneity in Multidatabase Systems. In: Bukhres, O.A., Elmagarmid, A.K. (eds.) Object- Oriented Multidatabase Systems. A Solution for Advanced Applications, pp. 129–202. Prentice-Hall, Englewood Cliffs (1996)Google Scholar
  10. 10.
    Goasdoué, F., Reynaud, C.: Modeling Information Sources for Information Integration. In: Fensel, D., Studer, R. (eds.) EKAW 1999. LNCS (LNAI), vol. 1621, pp. 121–138. Springer, Heidelberg (1999)CrossRefGoogle Scholar
  11. 11.
    Goh, C.H., Madnick, S.E., Siegel, M.: Context Interchange: Overcoming the Challenges of Large-Scale Interoperable Database Systems in a Dynamic Environment. In: Third International Conference on Information and Knowledge Management (CIKM 1994), Gaithersburg, USA, November 29 - December 2, pp. 337–346. ACM, New York (1994)CrossRefGoogle Scholar
  12. 12.
    Gruber, T.R.: Toward Principles for the Design of Ontologies Used for Knowledge Sharing. In: Guarino, N., Poli, R. (eds.) Formal Ontology in Conceptual Analysis and Knowledge Representation, Kluwer, Dordrecht (1993)Google Scholar
  13. 13.
    Gupta, A., Ludäscher, B., Martone, M.E.: Knowledge-Based Integration of Neuroscience Data Sources. In: Günther, O., Lenz, H.-J. (eds.) 12th International Conference on Scientific and Statistical Database Management (SSDBM 2000), Berlin, Germany, July 26-28, 2000, pp. 39–52. IEEE Computer Society Press, Los Alamitos (2000)CrossRefGoogle Scholar
  14. 14.
    Huhns, M.N., Singh, M.P.: Agents on the Web: Ontologies for Agents. IEEE Internet Computing 1(6), 81–83 (1997)CrossRefGoogle Scholar
  15. 15.
    Kent, W.: Data and Reality. Basic Assumptions in Data Processing Reconsidered. North-Holland, Amsterdam (1978)Google Scholar
  16. 16.
    Kim, W., Choi, I., Gala, S.K., Scheevel, M.: On Resolving Schematic Heterogeneity in Multidatabase Systems. Distributed and Parallel Databases 1(3), 251–279 (1993)CrossRefGoogle Scholar
  17. 17.
    Lakshmanan, L.V.S., Sadri, F., Subramanian, I.N.: SchemaSQL - A Language for Interoperability in Relational Multi-Database Systems. In: Vijayaraman, T.M., Buchmann, A.P., Mohan, C., Sarda, N.L. (eds.) 22nd International Conference on Very Large Data Bases (VLDB 1996), Bombay, India, September 3-6, 1996, pp. 239–250. Morgan Kaufmann, San Francisco (1996)Google Scholar
  18. 18.
    Landers, T., Rosenberg, R.L.: An Overview of MULTIBASE. In: Schneider, H.-J. (ed.) Second International Symposium on Distributed Data Bases (DDB 1982), Berlin, Germany, September 1-3, 1982, pp. 153–184. North-Holland, Amsterdam (1982)Google Scholar
  19. 19.
    Mena, E., Kashyap, V., Sheth, A.P., Illarramendi, A.: OBSERVER: An Approach for Query Processing in Global Information Systems Based on Interoperation Across Pre-existing Ontologies. In: First IFCIS International Conference on Cooperative Information Systems (CoopIS 1996), Brussels, Belgium, June 19-21, pp. 14–25. IEEE Computer Society, Los Alamitos (1996)CrossRefGoogle Scholar
  20. 20.
    Missier, P., Rusinkiewicz, M.: Extending a Multidatabase Manipulation Language to Resolve Schema and Data Conflicts. In: Meersman, R., Mark, L. (eds.) IFIP Conference Proceedings,Sixth IFIP TC-2 Working Conference on Data Semantics (DS-6), Stone Mountain, Atlanta, Georgia, USA, May 30 - June 2, vol. 74, pp. 93–115. Chapman & Hall, Boca Raton (1995)Google Scholar
  21. 21.
    Ouksel, A.M., Sheth, A.P.: Semantic Interoperability in Global Information Systems: A Brief Introduction to the Research Area and the Special Section. SIGMOD Record 28(1), 5–12 (1999)CrossRefGoogle Scholar
  22. 22.
    Raguenaud, C., Kennedy, J.B., Barclay, P.J.: The Prometheus Taxonomic Database. In: Bourbakis, N.G. (ed.) 1st IEEE International Symposium on Bioinformatics and Biomedical Engineering (BIBE 2000), Arlilngton, Virginia, USA, November 8-10, 2000, pp. 63–70. IEEE Computer Society Press, Los Alamitos (2000)CrossRefGoogle Scholar
  23. 23.
    Saltor, F., Garc‘ia-Solaco, M.: Diversity with Cooperation in Database Schemata: Semantic Relativism. In: DeGross, J.I., Bostrom, R.P., Robey, D. (eds.) Fourteenth International Conference on Information Systems (ICIS 1993), Orlando, Florida, USA, December 5-8, 1993, pp. 247–254. ACM Press, New York (1993)Google Scholar
  24. 24.
    Sattler, K.-U., Conrad, S., Saake, G.: Adding Conflict Resolution Features to a Query Language for Database Federations. In: Roantree, M., Hasselbring, W., Conrad, S. (eds.) Third Workshop on Engineering Federated Information Systems (EFIS 2000), Dublin, Ireland, June 19-20, pp. 41–52. IOS Press, Amsterdam (2000)Google Scholar
  25. 25.
    Scheuermann, P., Elmagarmid, A.K., Garcia-Molina, H., Manola, F., McLeod, D., Rosenthal, A., Templeton, M.: Report on the Workshop on Heterogenous Database Systems held at Northwestern University, Evanston, Illinois, December 11-13 (1989) , SIGMOD Record 19(4),23–31 (1990)Google Scholar
  26. 26.
    Sheth, A., Thacker, S., Patel, S.: Complex Relationships and Knowledge Discovery Support in the InfoQuilt System. The VLDB Journal 12(1), 2–27 (2002)CrossRefGoogle Scholar
  27. 27.
    Sheth, A.P., Gala, S.K., Navathe, S.B.: On Automatic Reasoning for Schema Integration. International Journal of Intelligent and Cooperative Information Systems 2(1), 23–50 (1993)CrossRefGoogle Scholar
  28. 28.
    Sheth, A.P., Larson, J.A.: Federated Database Systems for Managing Distributed, Heterogeneous, and Autonomous Databases. ACM Computing Surveys 22(3), 183–236 (1990)CrossRefGoogle Scholar
  29. 29.
    Sowa, J.F.: Conceptual Structures: Information Processing in Mind and Machine. Addison-Wesley, Reading (1984)zbMATHGoogle Scholar
  30. 30.
    Templeton, M., Brill, D., Hwang, A., Kameny, I., Lund, E.: An Overview of the Mermaid System - A Frontend to Heterogeneous Databases. In: Walker, J.M. (ed.) Sixteenth Annual Electronics and Aerospace Conference and Exposition - Technology Shaping the Future (IEEE EASCON 1983), Washington, D.C., USA, September 19-21, pp. 387–402. IEEE Aerospace and Electronic Systems Society, Los Alamitos (1983)Google Scholar
  31. 31.
    Ziegler, P.: User-Specific Semantic Integration of Heterogeneous Data: What Remains to be Done? Technical Report ifi-2004.01, Department of Informatics, University of Zurich (2004),

Copyright information

© Springer-Verlag Berlin Heidelberg 2004

Authors and Affiliations

  • Patrick Ziegler
    • 1
  • Klaus R. Dittrich
    • 1
  1. 1.Database Technology Research Group, Department of InformaticsUniversity of ZurichZürichSwitzerland

Personalised recommendations