How to ”Make a Bridge to the New Town” Using OntoAccess

  • Matthias Hert
  • Giacomo Ghezzi
  • Michael Würsch
  • Harald C. Gall
Part of the Lecture Notes in Computer Science book series (LNCS, volume 7032)


Business-critical legacy applications often rely on relational databases to sustain daily operations. Introducing Semantic Web technology in newly developed systems is often difficult, as these systems need to run in tandem with their predecessors and cooperatively read and update existing data.

A common pattern is to incrementally migrate data from a legacy system to its successor by running the new system in parallel, with a data bridge in between. Existing approaches that can be deployed as a data bridge in theory, restrict Semantic Web-enabled applications to read legacy data in practice, disallowing update operations completely.

This paper explains how our RDB-to-RDF platform OntoAccess can be used to transition legacy systems into Semantic Web-enabled applications. By means of a case study, we exemplify how we successfully made a bridge between one of our own large-scale legacy systems and its long-term replacement. We elaborate on challenges we faced during the migration process and how we were able to overcome them.


Legacy System Relational Database Mapping Language Database Schema Version Control 
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.
    Barrasa, J., Corcho, O., Gómez-Pérez, A.: R2O, an Extensible and Semantically Based Database-to-Ontology Mapping Language. In: Proc. Workshop on Sem. Web and Databases (August 2004)Google Scholar
  2. 2.
    Berners-Lee, T.: Linked Data (2009), (last visited June 2011)
  3. 3.
    Berners-Lee, T.: Relational Databases on the Semantic Web (2009), (last visited June 2011)
  4. 4.
    Bizer, C., Cyganiak, R.: D2R Server – Publishing Releational Databases on the Semantic Web. In: Proc. Int’l Sem. Web Conf. (November 2006)Google Scholar
  5. 5.
    Bizer, C., Seaborne, A.: D2RQ – Treating Non-RDF Databases as Virtual RDF Graphs. In: Proc. Int’l Sem. Web Conf. (November 2004)Google Scholar
  6. 6.
    Brügger, N.: RDB-RDF Mapping Generation from Relational Database Schemata. Master’s thesis, University of Zurich (December 2009)Google Scholar
  7. 7.
    Das, S., Sundara, S., Cyganiak, R.: R2RML: RDB to RDF Mapping Language. W3C Working Draft (October 2010),
  8. 8.
    Demeyer, S., Ducasse, S., Nierstrasz, O.: Object Oriented Reengineering Patterns. Morgan Kaufmann Publishers Inc., San Francisco (2002)zbMATHGoogle Scholar
  9. 9.
    Erling, O., Mikhailov, I.: RDF Support in the Virtuoso DBMS. In: Proc. of the SABRE Conf. on Social Sem. Web (September 2007)Google Scholar
  10. 10.
    Fielding, R.T.: Architectural Styles and the Design of Network-based Software Architectures. Ph.D. thesis, University of California, Irvine (2000)Google Scholar
  11. 11.
    Fischer, M., Pinzger, M., Gall, H.: Populating a Release History Database from Version Control and Bug Tracking Systems. In: Proc. Int’l Conf. Softw. Maintenance (September 2003)Google Scholar
  12. 12.
    Fürber, C., Hepp, M.: Using SPARQL and SPIN for Data Quality Management on the Semantic Web. In: Abramowicz, W., Tolksdorf, R. (eds.) BIS 2010. LNBIP, vol. 47, pp. 35–46. Springer, Heidelberg (2010)CrossRefGoogle Scholar
  13. 13.
    Gall, H.C., Fluri, B., Pinzger, M.: Change Analysis with Evolizer and ChangeDistiller. IEEE Softw. (January/February 2009)Google Scholar
  14. 14.
    Garcia-Molina, H., Ullman, J.D., Widom, J.: Database Systems: The Complete Book. Prentice Hall Press (2008)Google Scholar
  15. 15.
    Garrote, A., Garcia, M.N.M.: RESTful Writable APIs for the Web of Linked Data Using Relational Storage Solutions. In: Proc. WWW 2011 Workshop on Linked Data on the Web (April 2011)Google Scholar
  16. 16.
    Ghezzi, G., Gall, H.C.: Towards Software Analysis as a Service. In: Proc. Int’l ERCIM Workshop on Softw. Evolution and Evolvability (September 2008)Google Scholar
  17. 17.
    Ghezzi, G., Gall, H.C.: SOFAS : A Lightweight Architecture for Software Analysis as a Service. In: Working IEEE/IFIP Conf. on Softw. Architecture (June 2011)Google Scholar
  18. 18.
    Halpin, H., Herman, I.: RDB2RDF Working Group Charter (2009), (last visited June 2011)
  19. 19.
    Hert, M.: Relational Databases as Semantic Web Endpoints. In: Proc. European Sem. Web Conf. (June 2009)Google Scholar
  20. 20.
    Hert, M., Reif, G., Gall, H.C.: Updating Relational Data via SPARQL/Update. In: EDBT Workshop Proc. (March 2010)Google Scholar
  21. 21.
    Hert, M., Reif, G., Gall, H.C.: A Comparison of RDB-to-RDF Mapping Languages. In: Proc. Int’l Conf. on Semantic Systems (2011)Google Scholar
  22. 22.
    Malhotra, A.: W3C RDB2RDF Incubator Group Report (January 2009),
  23. 23.
    Prud’hommeaux, E., Seaborne, A.: SPARQL Query Language for RDF. W3C Recommendation (January 2008),
  24. 24.
    Seaborne, A., Manjunath, G., Bizer, C., Breslin, J., Das, S., Davis, I., Harris, S., Idehen, K., Corby, O., Kjernsmo, K., Nowack, B.: SPARQL Update – A Language for Updating RDF Graphs. W3C Member Submission (July 2008),

Copyright information

© Springer-Verlag Berlin Heidelberg 2011

Authors and Affiliations

  • Matthias Hert
    • 1
  • Giacomo Ghezzi
    • 1
  • Michael Würsch
    • 1
  • Harald C. Gall
    • 1
  1. 1.s.e.a.l. – software architecture and evolution lab, Department of InformaticsUniversity of ZurichSwitzerland

Personalised recommendations