对象关系数据库到RDF(S)的映射方法

doi:10.11896/jsjkx.200800006

计算机科学 ›› 2021, Vol. 48 ›› Issue (10): 145-151.doi: 10.11896/jsjkx.200800006

• 数据库&大数据&数据科学 • 上一篇下一篇

对象关系数据库到RDF(S)的映射方法

鲁佳文, 严丽

南京航空航天大学计算机科学与技术学院南京211106

收稿日期:2020-08-01 修回日期:2020-11-27 出版日期:2021-10-15 发布日期:2021-10-18
通讯作者: 严丽(yanli@nuaa.edu.cn)
作者简介:lu_jiawen@163.com
基金资助:
江苏省基础研究计划(BK20191274)

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

LU Jia-wen, YAN Li

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).

摘要/Abstract

摘要： 随着智能信息技术的发展,知识图谱已被广泛应用于智能搜索等各个领域。知识图谱中的信息一般采取RDF(S)的数据模型来表示。知识图谱的构建需要从大量的数据源抽取信息,而数据库是不可忽视的重要数据源。近几年,对象关系数据库得到了广泛的应用,且其中存储着丰富的语义信息,而基于对象关系数据库自动构建RDF(S)的研究却较少。因此,文中给出了对象关系数据库与RDF(S)的形式化定义,根据形式化定义将对象关系数据库中的语义信息进行抽取,提出了构建RDF(S)数据的映射规则。该映射规则不仅考虑了数据库的面向对象的语义,还考虑了数据库的约束,可以充分抽取数据库中包含的语义信息。最后实现了一个名为ORDB2RDF的映射工具,验证了该映射规则的正确性与映射结果的语义完整性。

关键词: PostgreSQL, RDF(S), 对象关系数据库, 知识抽取

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)

中图分类号:

TP311.131

鲁佳文, 严丽. 对象关系数据库到RDF(S)的映射方法[J]. 计算机科学, 2021, 48(10): 145-151. https://doi.org/10.11896/jsjkx.200800006

LU Jia-wen, YAN Li. Mapping Method from Object-relational Database to RDF(S)[J]. Computer Science, 2021, 48(10): 145-151. https://doi.org/10.11896/jsjkx.200800006

参考文献

[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.

Metrics

Viewed

Full text

Abstract

Cited

Shared

Discussed

对象关系数据库到RDF(S)的映射方法

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

PDF (PC)

摘要/Abstract

引用本文

使用本文

参考文献

相关文章 7

Metrics

本文评价

推荐阅读 0

[1]	杭婷婷, 冯钧, 陆佳民. 知识图谱构建技术:分类、调查和未来方向 Knowledge Graph Construction Techniques:Taxonomy,Survey and Future Directions 计算机科学, 2021, 48(2): 175-189. https://doi.org/10.11896/jsjkx.200700010
[2]	陈晓军, 向阳. 企业风险知识图谱的构建及应用 Construction and Application of Enterprise Risk Knowledge Graph 计算机科学, 2020, 47(11): 237-243. https://doi.org/10.11896/jsjkx.191000015
[3]	周琦,陆叶,李婷玉,王亚,张再跃,曹存根. 基于语义文法的地理实体位置关系的获取 Acquiring Relationships Between Geographical Entities Based on Semantic Grammar 计算机科学, 2016, 43(7): 208-216. https://doi.org/10.11896/j.issn.1002-137X.2016.07.038
[4]	. 一个面向OLAP的多维层次聚簇存储模式计算机科学, 2007, 34(9): 110-113.
[5]	胡巧巧王建民叶晓俊. PostgreSQL数据库预取算法研究计算机科学, 2006, 33(3): 138-139.
[6]	刘长浩程伟孙玉芳. XPostgreSQL对XML支持的策略计算机科学, 2005, 32(5): 91-94.
[7]	刘长浩孙玉芳. PostgreSQL请求优化机制研究计算机科学, 2005, 32(4): 163-167.