R2RS: schema-based relational databases mapping to linked datasets

  • Authors

    • Ju Ri Kim
    • Sung Kook Han
    2018-06-08
    https://doi.org/10.14419/ijet.v7i2.33.13868
  • RDF, Linked Data, Direct Mapping, RDB-to-RDF, SPARQL, SQL.

  • Background/Objectives: The vast amounts of high-quality data stored in relational databases (RDB) is the primary resources for Linked Open Data (LOD) datasets. This paper proposes a schema-based mapping approach from RDB to RDF, which provides succinct and efficient mapping.

    Methods/Statistical analysis: The various approaches, languages and tools for mapping RDB to LOD have been proposed in the recent years. This paper surveys and analyzes classic mapping approach and language such as Direct Mapping and R2RML. The mapping approaches can be categorized by means of their data modeling. After analyzing the conventional RDB-RDF mapping methods, this paper proposes a new mapping method and discusses its typical features and applications.

    Findings: There are two types of mapping approaches for the translation of RDB to RDF: instance-based and schema-based mapping approaches. The instance-based mapping approaches generate large amounts of RDF graphs by means of mapping rules. These approaches causes data redundancy since the same data is stored in two ways of RDB and RDF. It is very easy to bring the data inconsistence problem when data update operations occur. The schema-based mapping approaches can effectively avoid data redundancy since the mapping can be accomplished in the conceptual schema level.

    The architecture of SPARQL endpoint based on schema mapping approach consists of five phases:

    • Generation of mapping description based on mapping rules.
    • SPARQL query statements for RDF graph patterns.
    • Translation of SPARQL query into SQL query.
    • Execution of SQL query in RDB.
    • Interpretation of SQL query result into JSON-LD format.

    Experiments show the schema-based mapping approach is a straightforward, succinct and efficient mapping method for RDB2RDF.

    Improvements/Applications: This paper proposes a schema-based mapping approach called R2RS, which shows better performance than the conventional mapping methods. In addition, R2RS also provides the efficient implementation of SPARQL endpoint in RDB.

     

     

  • References

    1. [1] Bizer, C.: The emerging web of linked data. IEEE Intelligent Systems, 2009, 24 (5), pp. 87–92.

      [2] Smith Yoshimura, K.: Analysis of International Linked Data Survey for Implementers. Dâ€Lib Magazine, 2016, 22, pp. 7-8.

      [3] BÅ«mans G, ÄŒerÄns K. RDB2OWL: a practical approach for transforming RDB data into RDF/OWL[C]//Proceedings of the 6th International Conference on Semantic Systems. ACM, 2010, pp. 25.

      [4] Sitharamulu V, Babu B R. A Novel Proposal for Bridging Gap between RDB-RDF Semantic Web using Bidirectional Approach [J]. International Journal of Applied Engineering Research, 2016, 11(6), pp. 4456-4460.

      [5] Malik K R, Ahmad T. Technique for Transformation of Data from RDB to XML Then to RDF [M]//Web Semantics for Textual and Visual Information Retrieval. IGI Global, 2017, pp. 70-91.

      [6] Sequeda, J., et al.: Relational Database to RDF Mapping Patterns. Proceedings of the third International Conference on Ontology Patterns (WOP'12), 2012, 929(3), pp. 97-108.

      [7] Hert M, Reif G, Gall H C. A comparison of RDB-to-RDF mapping languages[C]//Proceedings of the 7th International Conference on Semantic Systems. ACM, 2011, pp. 25-32.

      [8] Das S, Sundara S, Cyganiak R. R2RML: RDB to RDF mapping language [J]. 2012.

      [9] ÄŒerÄns K, BÅ«mans G. RDB2OWL: a RDB-to-RDF/OWL mapping specification language [J]. Information Systems, 2011, pp. 139-152.

      [10] Neto L E T, Vidal V M P, Casanova M A, et al. R2RML by assertion: A semi-automatic tool for generating customised R2RML mappings[C]//Extended Semantic Web Conference. Springer, Berlin, Heidelberg, 2013, pp. 248-252.

      [11] Hert, M., Reif, G., Gall, H.C.: A Comparison of RDB-to-RDF Mapping Languages. In Proceedings of the seventh International Conference on Semantic Systems, ACM, New York, 2011, pp. 25-32.

      [12] A Survey of Current Approaches for Mapping of Relational Databases to RDF, W3C RDB2RDF Incubator Group January 08 2009. Technical report, 2009.

      [13] Michel F, Montagnat J, Faron-Zucker C. A survey of RDB to RDF translation approaches and tools [D]. I3S, 2014.

  • Downloads

  • How to Cite

    Ri Kim, J., & Kook Han, S. (2018). R2RS: schema-based relational databases mapping to linked datasets. International Journal of Engineering & Technology, 7(2.33), 119-123. https://doi.org/10.14419/ijet.v7i2.33.13868