This screencast is a step-by-step walk-through showing how to transform Excel tables to RDF data and then link that RDF data to external data sources. Google Refine is used for the transformation process. The goal is to show how to build a basic RDF structure, link particular tables, and explain the reconciliation process. The data is linked to the DBpedia and Europeana SPARQL endpoints.
Keywords: Google Refine, Google Refine Expression Language (GREL), Excel, Schema alignment
Author: Da, Ani
Publisher: Digital Enterprise Research Institute (DERI)
Date created: 2012-10-23 07:00:00.000
Time required: P15M
- Cleans a dataset by finding and correcting errors, removing duplicates and unwanted data.
- Knows methods for generating RDF data from tabular data in formats such as Comma-Separated Values (CSV).
- Recognizes that owl:sameAs, while popular as a mapping property, has strong formal semantics that can entail unintended inferences.
- Reuses published properties and classes where available.
- Uses available resources for named entity recognition, extraction, and reconciliation.