Skip to main content
SpringerLink
Log in

StdTrip: Promoting the Reuse of Standard Vocabularies in Open Government Data

  • Chapter
  • First Online:
Linking Government Data

Abstract

Linked Data is the standard generally adopted for publishing Open Government Data. This operation requires that a myriad of public information datasets be converted to a set of RDF triples. A major step in this process is deciding how to represent the database schema concepts in terms of RDF classes and properties. This is done by mapping database concepts to a vocabulary, which will be used as the base for generating the RDF representation. The construction of this vocabulary is extremely important, because it determines how the generated triples interlink the resulting dataset with other existing ones. However, most engines today provide support only to the mechanical process of transforming relational to RDF data. In this chapter, we discuss this process and present the StdTrip framework, a tool that supports the conceptual modeling stages of the production of RDF datasets, promoting the reuse of W3C recommended standard RDF vocabularies or suggesting the reuse of non-standard vocabularies already adopted by other RDF datasets.

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 59.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
USD 54.99
Price excludes VAT (USA)
  • Durable hardcover 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. Improving access to government through better use of the web (2009). URL http://www.w3.org/TR/egov-improving/

  2. Publishing open government data (2009). URL http://www.w3.org/TR/gov-data/

  3. Allemang, D., Hendler, J.: Semantic Web for the Working Ontologist: Effective Modeling in RDFS and OWL. Morgan Kaufmann (2008) 132

    Google Scholar 

  4. Auer, S., Dietzold, S., Lehmann, J., Hellmann, S., Aumueller, D.: Triplify: light-weight linked data publication from relational databases. In: WWW ’09: Proceedings of the 18th international conference on World wide web, pp. 621–630. ACM, New York, NY, USA (2009). DOI http://doi.acm.org/10.1145/1526709.1526793

  5. Barrasa, J., Corcho, O., Gómez-Pérez, A.: R2O, an extensible and semantically based database-to-ontology mapping language, vol. 3372 (2004)

    Google Scholar 

  6. Batini, C., Ceri, S., Navathe, S.B.: Conceptual database design: an Entity-relationship approach (1991)

    Google Scholar 

  7. Berners-Lee, T.: Cool uris don’t change. Retrieved January 10, 2010, from http://www.w3.org/Provider/Style/URI (1998)

  8. Berrueta, D., Phipps, J.: Best practice recipes for publishing rdf vocabularies – w3c working group note. Retrieved December 14, 2010, from http://www.w3.org/TR/swbp-vocab-pub/ (2008)

  9. Bizer, C., Cyganiak, R., Heath, T.: How to publish linked data on the web. Retrieved December 14, 2010, from http://www4.wiwiss.fuberlin.de/bizer/pub/LinkedDataTutorial/ (2007)

  10. Bizer, C., Heath, T., Ayers, D., Raimond, Y.: Interlinking Open Data on the Web (Poster). In: In Demonstrations Track, 4th European Semantic Web Conference (ESWC2007) (2007)

    Google Scholar 

  11. Bizer, C., Seaborne, A.: D2RQ-treating non-RDF databases as virtual RDF graphs (2004)

    Google Scholar 

  12. Breitman, K., Casanova, M.A., Truszkowski, W.: Semantic Web: Concepts, Technologies and Applications (NASA Monographs in Systems and Software Engineering). Springer-Verlag New York, Inc., Secaucus, NJ, USA (2006)

    Google Scholar 

  13. Breslin, J., Passant, A., Decker, S.: The Social Semantic Web. Springer Publishing Company, Incorporated (2009)

    Book  Google Scholar 

  14. Carroll, J.J., Dickinson, I., Dollin, C., Reynolds, D., Seaborne, A., Wilkinson, K.: Jena: implementing the semantic web recommendations, pp. 74–83 (2004)

    Google Scholar 

  15. Casanova, M.A., Breitman, K., Brauner, D., Marins, A.: Database conceptual schema matching. IEEE Computer 40(10), 102–104 (2007)

    Google Scholar 

  16. Casanova, M.A., Lauschner, T., Leme, L.A.P., Breitman, K., Furtado, A.L., Vidal, V.: A strategy to revise the constraints of the mediated schema. In: Proc. of the 28th Int’l. Conf. on Conceptual Modeling, Lecture Notes in Computer Science, vol. 5829, pp. 265–279. Springer (2009). DOI 10.1007\/978-3-642-04840-1\_21

    Google Scholar 

  17. Casanova, M.A., de Sá, J.E.A.: Mapping uninterpreted schemes into entity-relationship diagrams: two applications to conceptual schema design. IBM Journal of Research and Development 28, 82–94 (1984). DOI http://dx.doi.org/10.1147/rd.281.0082

  18. Cerbah, F.: Learning highly structured semantic repositories from relational databases. The Semantic Web: Research and Applications pp. 777–781 (2008)

    Google Scholar 

  19. Codd, E.F.: A relational model of data for large shared data banks. Communications of the ACM 13, 377–387 (1970). ACM ID: 362685

    Google Scholar 

  20. Cullot, N., Ghawi, R., Yétongnon, K.: DB2OWL: A Tool for Automatic Database-to-Ontology Mapping, pp. 491–494 (2007)

    Google Scholar 

  21. d‘Aquin, M., Sabou, M., Dzbor, M., Baldassarre, C., Gridinoc, L., Angeletou, S., Motta, E.: Watson: A gateway for the semantic web (2007)

    Google Scholar 

  22. David, J.: AROMA results for OAEI 2009 (2009)

    Google Scholar 

  23. Do, H.H.: Schema matching and mapping-based data integration (2006). URL http://lips.informatik.uni-leipzig.de/?q=node/211

  24. Do, H.H., Rahm, E.: COMA: a system for flexible combination of schema matching approaches, pp. 610–621. VLDB ’02. VLDB Endowment (2002). URL http://portal.acm.org/citation.cfm?id=1287369.1287422. ACM ID: 1287422

  25. Du, H., Wery, L.: Micro: A normalization tool for relational database designers. Journal of Network and Computer Applications 22(4), 215–232 (1999). DOI 10.1006/jnca.1999.0096

    Article  Google Scholar 

  26. Erling, O., Mikhailov, I.: Rdf support in the virtuoso dbms. Networked Knowledge-Networked Media pp. 7–24 (2009) Percy Salas, José Viterbo, Karin Breitman, and Marco Antonio Casanova 6 StdTrip: Promoting the Reuse of Standard Vocabularies in OGD 133

    Google Scholar 

  27. Euzenat, J., Ferrara, A., Hollink, L., et al.: Results of the ontology alignment evaluation initiative 2009. In: Proc. 4th of ISWC Workshop on Ontology Matching (OM) (2009)

    Google Scholar 

  28. Euzenat, J., Shvaiko, P.: Ontology matching. Springer-Verlag, Heidelberg (DE) (2007)

    MATH  Google Scholar 

  29. Fahad, M.: Er2owl: Generating owl ontology from er diagram. Intelligent Information Processing IV pp. 28–37 (2008)

    Google Scholar 

  30. Heath, T., Bizer, C.: Linked Data. Morgan & Claypool Publishers (2011)

    Google Scholar 

  31. Heuser, C.A.: Projeto de banco de dados. Sagra Luzzatto (2004)

    Google Scholar 

  32. Kinsella, S., Bojars, U., Harth, A., Breslin, J.G., Decker, S.: An interactive map of semantic web ontology usage. In: IV ’08: Proceedings of the 2008 12th International Conference Information Visualisation, pp. 179–184. IEEE Computer Society, Washington, DC, USA (2008). DOI http://dx.doi.org/10.1109/IV.2008.60

  33. Leme, L.A.P., Casanova, M.A., Breitman, K., Furtado, A.L.: Owl schema matching. Journal of the Brazilian Computer Society 16(1), 21–34 (2010). DOI 10.1007/s13173-010-0005 3

    Article  MathSciNet  Google Scholar 

  34. Myroshnichenko, I., Murphy, M.C.: Mapping ER Schemas to OWL Ontologies, vol. 0, pp. 324–329. IEEE Computer Society (2009). DOI http://doi.ieeecomputersociety.org/10.1109/ICSC.2009.61

  35. Piccinini, H., Lemos, M., Casanova, M.A., Furtado, A.: W-Ray: A Strategy to Publish Deep Web Geographic Data. In: Proceedings of the 4th International Workshop on Semantic and Conceptual Issues in GIS (SeCoGIS 2010), to appear (2010)

    Google Scholar 

  36. Polfliet, S., Ichise, R.: Automated mapping generation for converting databases into linked data. Proc. of ISWC2010

    Google Scholar 

  37. Prud’hommeaux, E., Hausenblas, M.: Use cases and requirements for mapping relational databases to rdf. Retrieved December 18, 2010, from http://www.w3.org/TR/rdb2rdf-ucr/ (2010)

  38. Rahm, E., Bernstein, P.A.: A survey of approaches to automatic schema matching. The VLDB Journal 10(4), 334–350 (2001). DOI http://dx.doi.org/10.1007/s007780100057

  39. S., D., S., S., R., C.: R2rml: Rdb to rdf mapping language. w3c rdb2rdf working group. Retrieved December 15, 2010, from http://www.w3.org/TR/r2rml/ (2010)

  40. Sahoo, S.S., Halb, W., Hellmann, S., Idehen, K., Thibodeau Jr, T., Auer, S., Sequeda, J., Ezzat, A.: A survey of current approaches for mapping of relational databases to rdf. W3C RDB2RDF Incubator Group report (2009)

    Google Scholar 

  41. Sauermann, L., Cyganiak, R.: Cool uris for the semantic web. Retrieved January 18, 2010, from http://www.w3.org/TR/cooluris/ (2008)

  42. Seddiqui, M.H., Aono, M.: Anchor-Flood: Results for OAEI-2009

    Google Scholar 

  43. Sequeda, J.F., Depena, R., Miranker, D.P.: Ultrawrap: Using sql views for rdb2rdf. Proc. of ISWC2009

    Google Scholar 

  44. Sorrentino, S., Bergamaschi, S., Gawinecki, M., Po, L.: Schema normalization for improving schema matching. In: Proc. of the 28th International Conference on Conceptual Modeling(ER ’09), pp. 280–293. Springer-Verlag, Berlin, Heidelberg (2009). DOI http://dx.doi.org/10.1007/978-3-642-04840-1\_22

    Google Scholar 

  45. Tirmizi, S., Sequeda, J., Miranker, D.: Translating sql applications to the semantic web, pp. 450–464 (2008)

    Google Scholar 

  46. Wang, J., Wen, J.R., Lochovsky, F., Ma, W.Y.: Instance-based schema matching for web databases by domain-specific query probing. In: Proc. of the 13th international conference on Very large data bases (VLDB ’04), pp. 408–419. VLDB Endowment (2004)

    Google Scholar 

  47. Wang, P., Xu, B.: Lily: Ontology alignment results for OAEI 2009 (2009)

    Google Scholar 

  48. Wang, S.L., Shen, J.W., Hong, T.P.: Mining fuzzy functional dependencies from quantitative data, vol. 5, pp. 3600–3605 vol.5 (2000). DOI 10.1109/ICSMC.2000.886568

Download references

Author information

Authors and Affiliations

  1. Departamento de Informática, Pontifícia Universidade Católica do Rio de Janeiro, R. Mq. de S. Vicente, 225, Rio de Janeiro, RJ, 22451-900, Brazil

    Percy Salas, Karin Breitman & Marco Antonio Casanova

  2. Instituto de Computação, Universidade Federal Fluminense, R. Passo da Pátria, 156/Bloco E/3o andar, Niterói, RJ, 24210-240, Brazil

    José Viterbo

Authors
  1. Percy Salas
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. José Viterbo
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Karin Breitman
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Marco Antonio Casanova
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Percy Salas .

Editor information

Editors and Affiliations

  1. 3 Round Stones Inc., Fredericksburg, 20190, Virginia, USA

    David Wood

Rights and permissions

Reprints and permissions

Copyright information

© 2011 Springer Science+Business Media, LLC

About this chapter

Cite this chapter

Salas, P., Viterbo, J., Breitman, K., Casanova, M.A. (2011). StdTrip: Promoting the Reuse of Standard Vocabularies in Open Government Data. In: Wood, D. (eds) Linking Government Data. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-1767-5_6

Download citation

  • DOI: https://doi.org/10.1007/978-1-4614-1767-5_6

  • Published:

  • Publisher Name: Springer, New York, NY

  • Print ISBN: 978-1-4614-1766-8

  • Online ISBN: 978-1-4614-1767-5

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation