ABSTRACT
The existing data on the web is growing increasingly diverse and extensive. Unfortunately, most of the current data is not semantic web friendly. The relational database (RDB) is considered one of the most popular structured data models. This work aims to automatically migrate from an imperfect RDB to a resource description framework (RDF). This issue has been ignored by previous work. Imperfectness means the lack of constraints in RDB. We attempt to construct an algorithm to migrate the RDB (including imperfect ones) to RDF. Results and evaluation showed that the proposed algorithm has succeeded in finding the relationship in RDB and migrating the RDB to RDF.
- M AG Hazber, Bing Li, Guandong Xu, M AS Mosleh, Xiwu Gu, and Yuhua Li. 2020. An approach for generation of SPARQL query from SQL algebra based transformation rules of RDB to ontology. Journal of Software (2020).Google Scholar
- Marcelo Arenas, Alexandre Bertails, Eric Prud’hommeaux, Juan Sequeda, 2012. A direct mapping of relational data to RDF. W3C recommendation 27(2012), 1–11.Google Scholar
- Christian Bizer and Andy Seaborne. 2004. D2RQ-treating non-RDF databases as virtual RDF graphs. In Proceedings of the 3rd international semantic web conference (ISWC2004), Vol. 2004. Springer Hiroshima.Google Scholar
- Iovka Boneva, Slawomir Staworko, and Jose Lozano. 2019. ShERML: mapping relational data to RDF. In Proceedings of the ISWC 2019 Satellite Tracks (Posters & Demonstrations, Industry, and Outrageous Ideas) co-located with 18th International Semantic Web Conference (ISWC 2019).Google Scholar
- Guntars Būmans and Kārlis Čerāns. 2010. RDB2OWL: a practical approach for transforming RDB data into RDF/OWL. In Proceedings of the 6th International Conference on Semantic Systems. 1–3.Google ScholarDigital Library
- YING Chen, XIAOMING Zhao, and Shiqing Zhang. 2013. Publishing rdf from relational database based on d2R improvement. WSEAS Transactions on Information Science and Applications 10, 8(2013), 241–248.Google Scholar
- Edgar F Codd. 1970. A relational model of data for large shared data banks. Commun. ACM 13, 6 (1970), 377–387.Google ScholarDigital Library
- Cristian Pérez de Laborda and Stefan Conrad. 2005. Relational. OWL: a data and schema representation format based on OWL. In Proceedings of the 2nd Asia-Pacific conference on Conceptual modelling-Volume 43. Citeseer, 89–96.Google ScholarDigital Library
- Oussama El Hajjamy, Hajar Khallouki, Larbi Alaoui, and Mohamed Bahaj. 2021. Semantic integration of traditional and heterogeneous data sources (UML, XML and RDB) in OWL2 triplestore. International Journal of Data Analysis Techniques and Strategies 13, 1-2(2021), 36–58.Google ScholarDigital Library
- Mohamed AG Hazber, Ruixuan Li, Xiwu Gu, and Guandong Xu. 2016. Integration mapping rules: Transforming relational database to semantic web ontology. Appl. Math 10, 3 (2016), 1–21.Google Scholar
- Valentina Janev and Sanja Vraneš. 2011. Applicability assessment of Semantic Web technologies. Information Processing & Management 47, 4 (2011), 507–517.Google ScholarDigital Library
- Ju-Ri Kim. 2022. Uplifting Relational Data to Knowledge Graphs using RDF. Mathematical Statistician and Engineering Applications 71, 3(2022), 611–623.Google Scholar
- Michal Laclavık. 2007. RDB2Onto: Relational database data to ontology individuals mapping. In Proceeding of ninth international conference of informatics.Google Scholar
- Franck Michel, Johan Montagnat, and Catherine Faron Zucker. 2014. A survey of RDB to RDF translation approaches and tools. Ph. D. Dissertation. I3S.Google Scholar
- Petros Papapanagiotou, Polyxeni Katsiouli, Vassileios Tsetsos, Christos Anagnostopoulos, and Stathes Hadjiefthymiades. 2006. RONTO: Relational to ontology schema matching. AIS Sigsemis Bulletin 3, 3-4 (2006), 32–36.Google Scholar
- Juan F Sequeda. 2017. Integrating relational databases with the semantic web: A reflection. In Reasoning Web International Summer School. Springer, 68–120.Google Scholar
- Juan F Sequeda, Marcelo Arenas, and Daniel P Miranker. 2012. On directly mapping relational databases to RDF and OWL. In Proceedings of the 21st international conference on World Wide Web. 649–658.Google ScholarDigital Library
- Dimitrios-Emmanuel Spanos, Periklis Stavrou, and Nikolas Mitrou. 2012. Bringing relational databases into the semantic web: A survey. Semantic Web 3, 2 (2012), 169–209.Google ScholarCross Ref
- Anamaria Szekely, Anita Hejja, and Robert Andrei Buchmann. 2011. Mapping a relational database into a RDF repository. In 2011 13th International Symposium on Symbolic and Numeric Algorithms for Scientific Computing. IEEE, 175–182.Google ScholarDigital Library
- Dewi Wardani. 2022. Complete W3C-Semantic’s Interpretations of AP-RDF.IAENG International Journal of Computer Science 49, 3 (2022).Google Scholar
- Dewi W Wardani and Josef Küng. 2015. Property Hypergraphs as an Attributed Predicate RDF. In OTM Confederated International Conferences" On the Move to Meaningful Internet Systems". Springer, 329–336.Google ScholarDigital Library
- Dewi Wisnu Wardani and Josef Küng. 2015. Semantic mapping relational to a directed property hypergraph model. In 2015 IEEE International Conference on Computer and Information Technology; Ubiquitous Computing and Communications; Dependable, Autonomic and Secure Computing; Pervasive Intelligence and Computing. IEEE, 152–159.Google Scholar
- Ran Zhang, Pengkai Liu, Xiefan Guo, Sizhuo Li, and Xin Wang. 2019. A unified relational storage scheme for RDF and property graphs. In International Conference on Web Information Systems and Applications. Springer, 418–429.Google ScholarDigital Library
- Shufeng Zhou. 2010. Exposing relational database as RDF. In 2010 2nd International Conference on Industrial and Information Systems, Vol. 2. IEEE, 237–240.Google ScholarCross Ref
Index Terms
- Automatic Migration From Imperfect Relational Database To Resource Description Framework
Recommendations
Migration of data from relational database to graph database
ICIST '18: Proceedings of the 8th International Conference on Information Systems and TechnologiesRelational databases have been widely used in many applications until today and they have met needs for data-intensive domains and transactions, but today data is growing faster than ever and extracting information from this huge data is becoming more ...
Migration of Relational Database to Document-Oriented Database: Structure Denormalization and Data Transformation
CICSYN '15: Proceedings of the 2015 7th International Conference on Computational Intelligence, Communication Systems and NetworksRelational databases remain the leading data storage technology. Nevertheless, many companies want to reduce operating expenses, to make scalable applications that use cloud computing technologies. Use of NoSQL database is one of the possible solutions, ...
Hierarchical to Relational Database Migration
Although database migration has not yet been extensively researched, three predominant software solutions have evolved: language interfaces, source-code conversion, and data propagation. The authors consider how Swiss Bank and IBM designed and developed ...
Comments