Specifying complex correspondences between relational schemas and<i>RDF</i>models for generating customized<i>R2RML</i>mappings

Pequeno, Valéria Magalhães; Vidal, Vânia Maria Ponte; Casanova, Marco A.; Neto, Luís Eufrasio T.; Galhardas, Héléna

doi:10.1145/2628194.2628233

Cited by 9 publications

(2 citation statements)

References 8 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…It is the result of preliminary works held by the World Wide Web Consortium (W3C). Pequeno et al [13] proposed a semiautomated mapping generation procedure where R2RML mappings are produced based on a set of semantic correspondences (for classes and properties) defined by domain experts. Sengupta et al [14] present the GUI-based R2RML mapping editor for nondomain experts to generate and alter the mappings.…”

Section: Relational Data To Resource Description Frameworkmentioning

confidence: 99%

[Retracted] Schema‐Based Mapping Approach for Data Transformation to Enrich Semantic Web

Natarajan

Subramaniyaswamy

Teekaraman

et al. 2021

Wireless Communications and Mobile Computing

View full text Add to dashboard Cite

Modern web wants the data to be in Resource Description Framework (RDF) format, a machine-readable form that is easy to share and reuse data without human intervention. However, most of the information is still available in relational form. The existing conventional methods transform the data from RDB to RDF using instance-level mapping, which has not yielded the expected results because of poor mapping. Hence, in this paper, a novel schema-based RDB-RDF mapping method (relational database to Resource Description Framework) is proposed, which is an improvised version for transforming the relational database into the Resource Description Framework. It provides both data materialization and on-demand mapping. RDB-RDF reduces the data retrieval time for nonprimary key search by using schema-level mapping. The resultant mapped RDF graph presents the relational database in a conceptual schema and maintains the instance triples as data graph. This mechanism is known as data materialization, which suits well for the static dataset. To get the data in a dynamic environment, query translation (on-demand mapping) is best instead of whole data conversion. The proposed approach directly converts the SPARQL query into SQL query using the mapping descriptions available in the proposed system. The mapping description is the key component of this proposed system which is responsible for quick data retrieval and query translation. Join expression introduced in the proposed RDB-RDF mapping method efficiently handles all complex operations with primary and foreign keys. Experimental evaluation is done on the graphics designer database. It is observed from the result that the proposed schema-based RDB-RDF mapping method accomplishes more comprehensible mapping than conventional methods by dissolving structural and operational differences.

show abstract

Section: Relational Data To Resource Description Frameworkmentioning

confidence: 99%

[Retracted] Schema‐Based Mapping Approach for Data Transformation to Enrich Semantic Web

Natarajan

Subramaniyaswamy

Teekaraman

et al. 2021

Wireless Communications and Mobile Computing

View full text Add to dashboard Cite

show abstract

“…In this work, we focus on the RDB schema. Meanwhile, other researches introduced a semi-automatic mapping approach for generating R2RML mappings based on a set of correspondence assertions (mapping between relational metadata and the vocabulary of a domain ontology) defined by domain experts [24,25]. Therefore, the user still needs to draw correspondence assertions (CAs) from the input system (source RDB schema and target ontology/RDF schema) to specify the mapping between them.…”

Section: Related Workmentioning

confidence: 99%

An Approach for Automatically Generating R2RML-Based Direct Mapping from Relational Databases

Hazber

et al. 2016

Communications in Computer and Information Science

View full text Add to dashboard Cite

For integrating relational databases (RDBs) into semantic web applications, the W3C RDB2RDF Working Group recommended two approaches, Direct Mapping (DM) and R2RML. The DM provides a set of mapping rules according to RDB schema, while the R2RML allows users to manually define mappings according to existing target ontology. The major problem to use R2RML is the effort for creating R2RML mapping documents manually. This may lead to appearance of many mistakes in the R2RML documents and requires domain experts. In this paper, we propose and implement an approach to generate an R2RML mapping documents automatically from RDB schema. The R2RML mapping reflects the behavior of the DM specification and allows any R2RML parser to generate a set of RDF triples from relational data. The input of generating approach is DBsInfo class that automatically generated from relational schema. An experimental prototype is developed and shows the effectiveness of our approach algorithms.

show abstract

MIRROR: Automatic R2RML Mapping Generation from Relational Databases

Medeiros

Priyatna

Corcho

2015

Lecture Notes in Computer Science

View full text Add to dashboard Cite

Specifying complex correspondences between relational schemas andRDFmodels for generating customizedR2RMLmappings

Cited by 9 publications

References 8 publications

[Retracted] Schema‐Based Mapping Approach for Data Transformation to Enrich Semantic Web

[Retracted] Schema‐Based Mapping Approach for Data Transformation to Enrich Semantic Web

An Approach for Automatically Generating R2RML-Based Direct Mapping from Relational Databases

MIRROR: Automatic R2RML Mapping Generation from Relational Databases

Contact Info

Product

Resources

About