Skip to main content

Sheet2RDF: a Flexible and Dynamic Spreadsheet Import&Lifting Framework for RDF

  • Conference paper
  • First Online:
Current Approaches in Applied Artificial Intelligence (IEA/AIE 2015)

Abstract

In this paper, we introduce Sheet2RDF, a platform for the acquisition and transformation of spreadsheets into RDF datasets. Based on Apache UIMA and CODA, two wider-scoped frameworks respectively aimed at knowledge acquisition from unstructured information and RDF triplification, Sheet2RDF narrows down their capabilities in order to restrict the domain of acquisition to spreadsheets, thus taking into consideration their peculiarities and providing informed solutions facilitating the transformation process, while still exploiting their full potentialities. Sheet2RDF comes also bundled in the form of a plugin for two RDF management platforms: Semantic Turkey and VocBench. The integration with such platforms enhances the level of automatism in the process, thanks to a human-computer interface that can exploit suggestions by users and translate them into proper transformation rules. In addition, it strengthens this interaction by direct contact with the data/vocabularies edited in the platform.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

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. Berners-Lee, T., Hendler, J., Lassila, O.: The Semantic Web: A new form of Web content that is meaningful to computers will unleash a revolution of new possibilities. Scientific American 279(5), 34–43 (2001)

    Article  Google Scholar 

  2. Scharffe, F., Atemezing, G., Troncy, R., Gandon, F., Villata, S., Bucher, B., Hamdi, F., Bihanic, L., Képéklian, G., Cotton, F., Euzenat, J., Fan, Z., Vandenbussche, P.-Y., Vatant, B.: Enabling linkeddata publication with the datalift platform. In: AAAI Workshop on Semantic Cities (2012)

    Google Scholar 

  3. Prud’hommeaux, E., Seaborne, A.: SPARQL query language for RDF. In: World Wide Web Consortium - Web Standards, January 15 2008. http://www.w3.org/TR/rdf-sparql-query/

  4. Lebo, T., Williams, G.: Converting governmental datasets into linked data. In: Proceedings of the 6th International Conference on Semantic Systems, New York, NY, USA, pp. 38:1–38:3 (2010)

    Google Scholar 

  5. Han, L., Finin, T.W., Parr, C.S., Sachs, J., Joshi, A.: RDF123: from spreadsheets to RDF. In: Sheth, A.P., Staab, S., Dean, M., Paolucci, M., Maynard, D., Finin, T., Thirunarayan, K. (eds.) ISWC 2008. LNCS, vol. 5318, pp. 451–466. Springer, Heidelberg (2008)

    Chapter  Google Scholar 

  6. W3C: The RDF data cube vocabulary. In: World Wide Web Consortium (W3C), January 14 2014. http://www.w3.org/TR/vocab-data-cube/

  7. W3C Open Annotation Community Group: Open annotation data model. In: World Wide Web Consortium (W3C), February 08 2013. http://www.openannotation.org/spec/core/

  8. W3C: PROV-DM: the PROV data model. In: World Wide Web Consortium (W3C), April 30 2013. http://www.w3.org/TR/prov-dm/

  9. Ermilov, I., Auer, S., Stadler, C.: CSV2RDF: user-driven CSV to RDF mass conversion framework. In: Proceedings of the ISEM 2013, Graz, Austria, September 04–06 2013

    Google Scholar 

  10. Fiorelli, M., Pazienza, M.T., Stellato, A., Turbati, A.: CODA: Computer-aided ontology development architecture. IBM Journal of Research and Development 58(2/3), 14:1–14:12 (2014)

    Article  Google Scholar 

  11. Fiorelli, M., Gambella, R., Pazienza, M.T., Stellato, A., Turbati, A.: Semi-automatic knowledge acquisition through CODA. In: Ali, M., Pan, J.-S., Chen, S.-M., Horng, M.-F. (eds.) IEA/AIE 2014, Part II. LNCS, vol. 8482, pp. 78–87. Springer, Heidelberg (2014)

    Chapter  Google Scholar 

  12. Ferrucci, D., Lally, A.: Uima: an architectural approach to unstructured information processing in the corporate research environment. Nat. Lang. Eng. 10(3–4), 327–348 (2004)

    Article  Google Scholar 

  13. Pazienza, M.T., Stellato, A., Turbati, A.: PEARL: ProjEction of annotations rule language, a language for projecting (UIMA) annotations over RDF knowledge bases. In: LREC, Istanbul (2012)

    Google Scholar 

  14. Pazienza, M.T., Scarpato, N., Stellato, A., Turbati, A.: Semantic Turkey: A Browser-Integrated Environment for Knowledge Acquisition and Management. Semantic Web Journal 3(3), 279–292 (2012)

    Google Scholar 

  15. Caracciolo, C., Stellato, A., Rajbahndari, S., Morshed, A., Johannsen, G., Keizer, J., Jacques, Y.: Thesaurus maintenance, alignment and publication as linked data: the AGROVOC use case. International Journal of Metadata, Semantics and Ontologies (IJMSO) 7(1), 65–75 (2012)

    Article  Google Scholar 

  16. Stellato, A., Rajbhandari, S., Turbati, A., Fiorelli, M., Caracciolo, C., Lorenzetti, T., Keizer, J., Pazienza, M. T.: VocBench: a Web Application for Collaborative Development of Multilingual Thesauri. In : The Semantic Web: Trends and Challenges. Springer International Publishing (2015) (accepted for publication)

    Google Scholar 

  17. World Wide Web Consortium (W3C): SKOS simple knowledge organization system eXtension for labels (SKOS-XL). In: World Wide Web Consortium (W3C), August 18 2009. http://www.w3.org/TR/skos-reference/skos-xl.html

  18. Hodge, G.: Systems of Knowledge Organization for Digital Libraries: Beyond Traditional Authority Files. Council on Library and Information Resources, Washington, DC (2000)

    Google Scholar 

  19. World Wide Web Consortium (W3C): SKOS simple knowledge organization system reference. In: World Wide Web Consortium (W3C), August 18 2009. http://www.w3.org/TR/skos-reference/

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Armando Stellato .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2015 Springer International Publishing Switzerland

About this paper

Cite this paper

Fiorelli, M., Lorenzetti, T., Pazienza, M.T., Stellato, A., Turbati, A. (2015). Sheet2RDF: a Flexible and Dynamic Spreadsheet Import&Lifting Framework for RDF. In: Ali, M., Kwon, Y., Lee, CH., Kim, J., Kim, Y. (eds) Current Approaches in Applied Artificial Intelligence. IEA/AIE 2015. Lecture Notes in Computer Science(), vol 9101. Springer, Cham. https://doi.org/10.1007/978-3-319-19066-2_13

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-19066-2_13

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-19065-5

  • Online ISBN: 978-3-319-19066-2

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics