Computer Science

Computer Science ›› 2021, Vol. 48 ›› Issue (10): 145-151.doi: 10.11896/jsjkx.200800006

• Database & Big Data & Data Science • Previous Articles     Next Articles

Mapping Method from Object-relational Database to RDF(S)

LU Jia-wen, YAN Li   

  1. College of Computer Science and Technology,Nanjing University of Aeronautics and Astronautics,Nanjing 211106,China
  • Received:2020-08-01 Revised:2020-11-27 Online:2021-10-15 Published:2021-10-18
  • About author:LU Jia-wen,born in 1996,postgra-duate.Her main research interests include data and knowledge engineering.
    YAN Li,born in 1964,Ph.D,professor,is a member of China Computer Federation.Her main research interests include data and knowledge engineering.
  • Supported by:
    Basic Research Program of Jiangsu Province,China(BK20191274).

PDF (PC)

819

Abstract: With the development of intelligent information technology,knowledge graph has been widely used in intelligent search and other research area.The information in the knowledge map is generally represented by the data model of RDF(S).The construction of knowledge graph needs to extract information from different data sources and database is an important data source that cannot be ignored.Nowadays,object-relational databases are widely used and contain rich semantic information,but research on constructing RDF(S) from object-relational databases is few.This paper puts forward formal definitions of object-relational databases and RDF(S) data and proposes mapping rules for constructing RDF(S) data from object-relational databases.The mapping rules not only consider the object-oriented semantics of the database,but also consider constraints,which can fully extract semantic information contained in the database.Finally,a mapping tool named ORDB2RDF is implemented to verify the correctness of the mapping rules and the semantic integrity of the mapping results.

Key words: Information extraction, Object-relational database, PostgreSQL, RDF(S)

CLC Number: 

  • TP311.131
[1]Resource Description Framework (RDF):Concepts and Ab-stract Syntax [OL].[2020-06-24].https://www.w3.org/TR/2004/REC-rdf-concepts-20040210/.
[2]TOMASZUK D,HYLAND-WOOD D.RDF 1.1:KnowledgeRepresentation and Data Integration Language for the Web [J].Symmetry,2020,12(1):1-33.
[3]JUNIOR A C,ORLANDI F,O'SULLIVAN D,et al.UsingMapping Languages for Building Legal Knowledge Graphs from XML Files[C]// Proceedings of the Contextualized Knowledge Graphs (CKG) Workshop co-located with the 18th International Semantic Web Conference.2019:1-12.
[4]TONG Q,ZHANG F,CHENG J.Construction of RDF(S) from UML Class Diagrams [J].Journal of Computing and Information Technology,2015,22(4):237-250.
[5]MARTINEZ-RODRIGUEZ J L,LOPEZ-AREVALO I,RIOS-ALVARADO A B,et al.Extraction of RDF Statements from Text [M]//Knowledge Graphs and Semantic Web.Cham:Springer,2019:87-101.
[6]ALZAHRANI H.Evolution of Object-Oriented Database Sys-tems [J].Global Journal of Computer Science and Technology,2016,16(3):33-36.
[7]BARONI A L,CALERO C,ABREU F B E,et al.Object-Relational Database Metrics Formalization[C]// International Conference on Quality Software.IEEE,2006:30-37.
[8]Object-relational database[OL].[2020-06-25].http://taggedwiki.zubiaga.org/new_content/135b89a028bb29a3c3654fbe3a821bcc.
[9]GREGORY V.Lessons in Persisting Object Data Using Object-Relational Mapping [J].IEEE Software,2019,36(6):43-52.
[10]KHANDUJA V,CHAKRAVERTY S.A generic watermarking model for object relational databases [J].Multimedia.Tools and Applications,2019,78(19):28111-28135.
[11]A Direct Mapping of Relational Data to RDF[OL].[2020-06-25].https://www.w3.org/TR/2012/REC-rdb-direct-mapping- 20120927/.
[12]R2RML:RDB to RDF Mapping Language [OL].[2020-06-25].https://www.w3.org/2001/sw/rdb2rdf/r2rml/Overview.html.
[13]SEQUEDA J F,ARENAS M,MIRANKER D P.On directlymapping relational databases to RDF and OWL[C]//Procee-dings of the 21st International Conference on World Wide Web.Association for Computing Machinery,2012:649-658.
[14]UNBEHAUEN J,STADLER C,AUER S.Optimizing SPARQL-to-SQL rewriting[C]//IEEE International Conference on Semantic Computing.2013:324-330.
[15]EISENBERG V,KANZA Y.D2RQ/Update:Updating Relatio-nal Data via Virtual RDF [C]//Proceedings of the 21st International Conference on World Wide Web.2012:497-498.
[16]CALVANESE D,COGREL B,KOMLAEBRI S,et al.Ontop:answering sparql queries over relational databases [J].Semantic Web,2017,8(3):471-487.
[17]ZHANG F,MA Z M,YAN L.Construction of Ontologies from Object-Oriented Database Models[J].Integrated Computer-Aided Engineering,2011,18(4):327-347.
[18]AGGOUNE A,NAMOUNE M S.A Method for Transforming Object-relational to Document-oriented Databases[C]// 2020 2nd International Conference on Mathematics and Information Technology (ICMIT).IEEE,2020:154-158.
[19]AUZINS A,EIDUKS J,VASILEVSKA A,et al.Object-Relational Database Structure Model and Structure Optimisation[J].Applied Computer Systems,2018,23(1):28-36.
[20]PEREZ J,ARENAS M,GUTIERREZ C.Semantics and complexity of SPARQL [J].ACM Transactions on Database Systems,2009,34(3):1-45.
[1] WANG Jian, PENG Yu-qi, ZHAO Yu-fei, YANG Jian. Survey of Social Network Public Opinion Information Extraction Based on Deep Learning [J]. Computer Science, 2022, 49(8): 279-293.
[2] LI Xiao-wei, SHU Hui, GUANG Yan, ZHAI Yi, YANG Zi-ji. Survey of the Application of Natural Language Processing for Resume Analysis [J]. Computer Science, 2022, 49(6A): 66-73.
[3] DING Ling, XIANG Yang. Chinese Event Detection with Hierarchical and Multi-granularity Semantic Fusion [J]. Computer Science, 2021, 48(5): 202-208.
[4] ZUO Xian-yu, ZHANG Zhe, SU Yue-han, LIU Yang, GE Qiang, TIAN Jun-feng. Extraction Algorithm of NDVI Based on GPU Multi-stream Parallel Model [J]. Computer Science, 2020, 47(4): 25-29.
[5] SHI He, YANG Qun, LIU Shao-han, LI Wei. Study on Information Extraction of Power Grid Fault Emergency Pre-plans Based on Deep Learning [J]. Computer Science, 2020, 47(11A): 52-56.
[6] GAO Li-zheng, ZHOU Gang, LUO Jun-yong, LAN Ming-jing. Survey on Meta-event Extraction [J]. Computer Science, 2019, 46(8): 9-15.
[7] YUAN Ren-jin, CHEN Gang. Research on News Recommendation Methods Considering Geographical Location of News [J]. Computer Science, 2018, 45(11A): 462-467.
[8] LI Ying, HAO Xiao-yan and WANG Yong. N-ary Chinese Open Entity-relation Extraction [J]. Computer Science, 2017, 44(Z6): 80-83.
[9] Munina YUSUFU and Gulina YUSUFU. Repetitive Pattern Recognition Algorithms and Applications in Web Information Extraction and Clustering Analysis [J]. Computer Science, 2017, 44(Z11): 39-45.
[10] YANG Jun-wen, WANG Hai, PENG Xin and ZHAO Wen-yun. Web Resource Recommendation Based on Analysis of Developer’s Behavior [J]. Computer Science, 2017, 44(7): 147-150.
[11] BO Shu-kui and JING Yong-ju. One-class Information Extraction from Remote Sensing Imagery Based on Nearest Neighbor Rule [J]. Computer Science, 2016, 43(Z6): 217-218.
[12] WANG Ya-pu, WANG Zhi-jian and YE Feng. Research of Improved Tree Path Model in Web Page Clustering [J]. Computer Science, 2015, 42(5): 109-113.
[13] ZHANG Yu-xiang, GAO Xu-yang, WANG Ting, ZHANG Le-fei and DU Bo. Background Self-learning Framework for Bio Information Extraction from Hyperspectral Images [J]. Computer Science, 2015, 42(4): 292-296.
[14] GUO Xi-yue and HE Ting-ting. Survey about Research on Information Extraction [J]. Computer Science, 2015, 42(2): 14-17.
[15] LIU Shu-qin and PENG Jin-ye. Extraction of Nighttime Images with Time Frequency Weighted and Constrained Optimization Evolutionary Algorithm [J]. Computer Science, 2014, 41(6): 295-298.
Viewed
Full text


Abstract

Cited
  Shared   
  Discussed   
No Suggested Reading articles found!
渝ICP备16013121号-4
Add:18# Honghu West Rd., Yubei ,Chongqing,China    Post Code: 401121
Tel: 023-63500828/023-67039612/023-67039623
E-mail: jsjkx12@163.com
Powered by Beijing Magtech Co., Ltd.