XLWrap – Querying and Integrating Arbitrary Spreadsheets with SPARQL

Langegger, Andreas; Wöß, Wolfram

doi:10.1007/978-3-642-04930-9_23

Cited by 77 publications

(59 citation statements)

References 4 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…This challenging goal can be addressed through the use of controlled and widely accepted semantic references. In this context, the TAXREF [25] zoological and botanical taxonomy has been chosen to build a SKOS thesaurus 16 supporting the integration of these heterogeneous data sets. SKOS, the Simple Knowledge Organization System, is a W3C standard designed to represent controlled vocabularies, taxonomies and thesauri.…”

Section: Methodsmentioning

confidence: 99%

See 1 more Smart Citation

Translation of Heterogeneous Databases into RDF, and Application to the Construction of a SKOS Taxonomical Reference

Michel

Djimenou

Faron-Zucker

et al. 2016

Lecture Notes in Business Information Processing

View full text Add to dashboard Cite

Abstract. While the data deluge accelerates, most of the data produced remains locked in deep Web databases. For the linked open data to benefit from the potential represented by this huge amount of data, it is crucial to come up with solutions to expose heterogeneous databases as linked data. The xR2RML mapping language is an endeavor towards this goal: it is designed to map various types of databases to RDF, by flexibly adapting to heterogeneous query languages and data models while remaining free from any specific language. It extends R2RML, the W3C recommendation for the mapping of relational databases to RDF, and relies on RML for the handling of various data formats. In this paper we present xR2RML, we analyse data models of several modern databases as well as the format in which query results are returned, and we show how xR2RML translates any result data element into RDF, relying on existing languages such as XPath and JSONPath when necessary. We illustrate some features of xR2RML such as the generation of RDF collections and containers, and the ability to deal with mixed data formats. We also describe a real-world use case in which we applied xR2RML to build a SKOS thesaurus aimed at supporting studies on History of Zoology, Archaeozoology and Conservation Biology.

show abstract

Section: Methodsmentioning

confidence: 99%

“…Tools have been developed such as XLWrap [16] and RDF Refine 4 . The Linked CSV 5 format is a proposition to embed metadata in a CSV file, that makes it easy to link on the Web and eventually to translate to RDF or JSON.…”

Section: Related Workmentioning

confidence: 99%

Translation of Heterogeneous Databases into RDF, and Application to the Construction of a SKOS Taxonomical Reference

Michel

Djimenou

Faron-Zucker

et al. 2016

Lecture Notes in Business Information Processing

View full text Add to dashboard Cite

show abstract

“…In the same context, existing querying languages were also considered to describe the mappings, e.g., xsparql [2] which is a language that combines xquery and sparql or Tarql 25 . Due to the lack of query languages or other ways to refer to data in csv format or spreadsheets, different mapping languages were occasionally defined, e.g., the XLWrap's mapping language [22] that converts data in spreadsheets to rdf, or the declarative owl-centric mapping language Mapping Master's M 2 [26] that converts data from spreadsheets into the Web Ontology Language (owl). For relational databases, different mapping languages were defined [15], but the wc-standardized rrml prevailed.…”

Section: Related Workmentioning

confidence: 99%

Assessing and Refining Mappingsto RDF to Improve Dataset Quality

Dimou

Kontokostas

Freudenberg

et al. 2015

The Semantic Web - ISWC 2015

View full text Add to dashboard Cite

Abstract. rdf dataset quality assessment is currently performed primarily after data is published. However, there is neither a systematic way to incorporate its results into the dataset nor the assessment into the publishing workflow. Adjustments are manually -but rarely-applied. Nevertheless, the root of the violations which often derive from the mappings that specify how the rdf dataset will be generated, is not identified. We suggest an incremental, iterative and uniform validation workflow for rdf datasets stemming originally from (semi-)structured data (e.g., csv, xml, json). In this work, we focus on assessing and improving their mappings. We incorporate (i) a test-driven approach for assessing the mappings instead of the rdf dataset itself, as mappings reflect how the dataset will be formed when generated; and (ii) perform semi-automatic mapping refinements based on the results of the quality assessment. The proposed workflow is applied to diverse cases, e.g., large, crowdsourced datasets such as dbpedia, or newly generated, such as iLastic. Our evaluation indicates the efficiency of our workflow, as it significantly improves the overall quality of an rdf dataset in the observed cases.

show abstract

“…For CSV2RDF mappings, the XLWrap mapping language (Langegger & Wöss 2009), the Mapping Master's M2 (O'Connor et al 2010) and TARQL (Cyganiak 2014) can be used. For XML2RDF mapings, the GRDDL mechanism (GRDDL Working Group 2007), Krextor (Lange 2009), and ReDeFer (Garcia & Gil 2007) can be used.…”

Section: The Conversion Processmentioning

confidence: 99%

Making SimModel information available as RDF graphs

Pauwels¹,

Corry²,

O’Donnell³

2014

eWork and eBusiness in Architecture, Engineering and Construction

View full text Add to dashboard Cite

Many building energy performance Simulation (BEPS) on tools use custom schema definitions as opposed to standardised schema definitions (defined in XSD, EXPRESS, and so forth). A Simulation Domain Model (SimModel) was therefore previously developed and is representative of a new interoperable XML-based data model for the building simulation domain. In this paper we document our ongoing efforts to make building simulation data more interoperable with other building data. In order to better integrate SimModel information with other building information, the authors propose to represent this information in the Resource Description Framework (RDF). A specialised conversion service parses the SimModel ontology, which is in the form of linked XSD schemata, and output a SimModel ontology in OWL. In this article, we further outline how the conversion service now also parses input SimModel XML files and outputs SimModel instances as RDF graphs. We briefly indicated how those SimModel RDF graphs can subsequently be used.

show abstract

XLWrap – Querying and Integrating Arbitrary Spreadsheets with SPARQL

Cited by 77 publications

References 4 publications

Translation of Heterogeneous Databases into RDF, and Application to the Construction of a SKOS Taxonomical Reference

Translation of Heterogeneous Databases into RDF, and Application to the Construction of a SKOS Taxonomical Reference

Assessing and Refining Mappingsto RDF to Improve Dataset Quality

Making SimModel information available as RDF graphs

Contact Info

Product

Resources

About