The relational database (RDB) to resource description framework (RDF) transformation is a major semantic information extraction method because most web data are managed by RDBs. Existing automatic RDB-to-RDF transformation methods generate RDF data without losing the semantics of original relational data. However, two major problems have been observed during the mapping of multi-column key constraints: repetitive data generation and semantic information loss. In this article, we propose an improved RDB-to-RDF transformation method that ensures mapping without the aforementioned problems. Optimised rules are defined to generate an accurate semantic data structure for a multi-column key constraint and to reduce repetitive constraint data. Experimental results show that the proposed method achieves better accuracy in transforming multi-column key constraints and generates compact semantic results without repetitive data.
HeBPatelMZhangZ, et al.Accessing the deep web. Commun ACM2007; 50(5): 94–101.
2.
De LabordaCPConradS. Database to semantic web mapping using RDF query languages. In: EmbleyDWOlivéARamS (eds) Proceedings of international conference on conceptual modeling. Berlin: Springer, 2006, pp. 241–254.
3.
SpanosDEStavrouPMitrouN. Bringing relational databases into the semantic web: a survey. Semant Web2012; 3(2): 169–209.
SequedaJFArenasMMirankerDP. On directly mapping relational databases to RDF and OWL. In: Proceedings of international conference on world wide web, Lyon, 16–20 April 2012, pp. 649–658. New York: ACM.
LimKBJunHGKimHJ. Semantics preserving MapReduce process for RDB to RDF transformation. Int J Metadata Semant Ontol2015; 10(4): 229–239.
8.
ManolaFMillerEMcBrideB. RDF 1.1 Primer. W3C Working Group Note, 25 February 2014.
9.
HayesJ. A graph model for RDF. Darmstadt: Darmstadt University of Technology/University of Chile, 2004.
10.
CoatesTConnollyDDackD, et al.URIs, URLs, and URNs: clarifications and recommendations 1.0. World Wide Web Consortium, Note NOTE-uri-clarification-20010921, 2001.
11.
MalleaAArenasMHoganA, et al.On blank nodes. In: AroyoLWeltyCAlaniH, et al. (eds) Proceedings of international semantic web conference. Berlin: Springer, 2011, pp. 421–437.
MichelFMontagnatJFaron-ZuckerC. A survey of RDB to RDF translation approaches and tools. PhD Thesis, I3S, Porto, 2014.
14.
ByrneK.Having triplets-holding cultural data as RDF. In: Proceedings of ECDL 2008 workshop on information access to cultural heritage, Aarhus, 18 September 2008.
15.
GreenJDolbearCHartG, et al.Creating a semantic integration system using spatial data. In: Proceedings of international conference on posters and demonstrations, vol. 401, 2008, pp. 70–71, CEUR-WS.org
16.
DasSSundaraSCyganiakR. R2RML: RDB to RDF mapping language, W3C Recommendation2012, http://www.w3.org/TR/r2rml/
17.
HertMReifGGallHC. A comparison of RDB-to-RDF mapping languages. In: Proceedings of 7th international conference on semantic systems, Graz, 7–9 September 2011, pp. 25–32. New York: ACM.
18.
BizerCSeaborneA. D2RQ-treating non-RDF databases as virtual RDF graphs. In: Proceedings of international semantic web conference (ISWC2004), Hiroshima, Japan, 7–11 November 2004.
19.
ErlingOMikhailovI. RDF support in the Virtuoso DBMS. In: PellegriniTAuerSTochtermannK, et al. (eds) Proceedings of networked knowledge-networked media. Berlin: Springer, 2009, pp. 7–24.
LiMDuXYWangS. Learning ontology from relational database. In: Proceedings of international conference on machine learning and cybernetics, Guangzhou, China, 18–21 August 2005, pp. 3410–3415. New York: IEEE.
AstrovaIKordaNKaljaA. Rule-based transformation of SQL Relational Databases to OWL Ontologies. In: Proceedings of international conference on metadata & semantics research, Corfu, 11–12 October 2007.
25.
CullotNGhawiRYetongnonK. DB2OWL: a tool for automatic database-to-ontology mapping. In: Proceedings of the 15th Italian Symposium on Advanced Database Systems (SEBD 2007), Torre Canne, 17–20 June 2007, pp. 491–494.
26.
CerbahF. Learning highly structured semantic repositories from relational databases. In: BechhoferSHauswirthMHoffmannJ, et al. (eds) Proceedings of European semantic web conference. Berlin: Springer, 2008, pp. 777–781.
27.
TirmiziSHSequedaJMirankerD. Translating SQL applications to the semantic web. In: BhowmickSSKüngJWagnerR (eds) Proceedings of international conference on database and expert systems applications. Berlin: Springer, 2008, pp. 450–464.
28.
BrickleyDGuhaRVMcBrideB. RDF Schema 1.1. W3C Recommendation 25 February 2014.
MalikKRAhmadTFarhanM, et al.Big-data: transformation from heterogeneous data to semantically-enriched simplified data. Multimed Tools Appl2016; 75(20): 12727–12747.
