Please wait a minute...
Data Analysis and Knowledge Discovery  2018, Vol. 2 Issue (12): 89-97    DOI: 10.11925/infotech.2096-3467.2018.0423
Current Issue | Archive | Adv Search |
Converting STKOS Metathesaurus to RDF Triples with R2RML
Wang Ying1, Wu Sizhu2()
1National Science Library, Chinese Academy of Sciences, Beijing 100190, China
2Institute of Medical Information, Chinese Academy of Medical Sciences, Beijing 100020, China
Download: PDF (1107 KB)   HTML ( 3 ) 
Export: BibTeX | EndNote (RIS)      
Abstract  

[Objective] This paper aims to convert STKOS Metathesaurus from records of relational database to RDF triples. [Methods] First, we defined the semantic schema of the STKOS based on their storage features and data characteristics. Then, we mapped the scientific terms, standard concepts, categories, as well as source concepts and terms with the help of R2RML. Finally, we converted the documents stored in relational database to RDF datasets with the R2RML parser. [Results] The proposed method could process STKOS metathesaurus automatically and generated 190 million RDF triples. All new records were stored in the Virtuoso database and could be queried with SPARQL. [Limitations] Predicates in the R2RML lacks flexibily, therefore, more complex data sets need to be splited and transformed first. [Conclusions] The proposed model shed light on future research on converting other relational database records or thesaurus to RDF datasets.
Key words： R2RML      STKOS Metathesaurus      RDF     
Received: 20 April 2018      Published: 16 January 2019
ZTFLH:  TP393  
Service
E-mail this article
Add to my bookshelf
Add to citation manager
E-mail Alert
RSS
Articles by authors
Ying Wang
Sizhu Wu

Cite this article:

Wang Ying,Wu Sizhu. Converting STKOS Metathesaurus to RDF Triples with R2RML. Data Analysis and Knowledge Discovery, 2018, 2(12): 89-97.

URL:

https://manu44.magtech.com.cn/Jwk_infotech_wk3/EN/10.11925/infotech.2096-3467.2018.0423     OR     https://manu44.magtech.com.cn/Jwk_infotech_wk3/EN/Y2018/V2/I12/89

数据表 字段 logicalTable rr:subjectMap rr:predicate rr:objectMap
stkos_concept AUI [rr:tableName “stkos_concept”] [rr:template “http://www.nstl.gov.cn/stkos/
concept/{CUI}”;
rr:class stkos:concept;]		 iso25964:hasPreferred
Term		 [rr:column “http://www.nstl. gov.cn/stkos/term/{AUI}”]
TUI stkos:LinktoCategory
Class		 [rr:column “http://www.nstl. gov.cn/stkos/category/{TUI}”]
stkos_concept_def DEF [rr:sqlQuery “““select CUI,
DEF, ISPREF from stkos_
concept_def where ISPREF=’
YES’ “““]		 [rr:template “http://www.nstl.gov.cn/stkos/
concept/{CUI}”;]		 iso25964:hasPreferred
Definition		 [rr:column “DEF”]
stkos_concept_def DEF [rr:sqlQuery “““ select CUI,
DEF, ISPREF from stkos_
concept_def where ISPREF=’
NO’ “““]		 [rr:template “http://www.nstl.gov.cn/stkos/
concept/{CUI}”;]		 iso25964:Definition [rr:column “DEF”]
数据表 字段 logicalTable rr:subjectMap rr:predicate rr:objectMap
stkos_category LABEL [rr:tableName “stkos_category”] [rr:template “http://www.nstl.gov.cn/stkos/
categoryClass/{TUI}”;
rr:class stkos:categoryClass;]		 skos:prefLabel [rr:column “LABEL”; rr:language “zh”]
LABEL_T skos:altLabel [rr:column “LABEL_T”; rr:language “en”]
CSAB_ID skos:inScheme [rr:column “http://www.nstl.gov.cn/stkos/ thesaurus/{CSAB_ID}”]
PTUI skos:broader [rr:column “http://www.nstl.gov.cn/stkos/ categoryClass/{PTUI}”]
数据表 字段 logicalTable rr:subjectMap rr:predicate rr:objectMap
stkos_atom LABEL [rr:sqlQuery “““ select LABEL,
SAUI, SCUI, SAB_ID from
stkos_atom“““]		 [rr:template “http://www.nstl.gov.cn/stkos/
term/{SAUI}”; rr:class stkos:
sourceTerm;]		 iso25964:lexicalValue [rr:column “LABEL”; rr:language “en”]
SAB_ID skos:inScheme [rr:column “http://www.nstl.gov.cn/stkos/thesaurus/
{SAB_ID}”]
stkos_attribute ID [rr:sqlQuery “““select ID, SAUID,
STYPE, SAB_ID from stkos_attribute
where STYPE=’TERM “““];		 [rr:template “http://www.nstl.
gov.cn/stkos/sourceTerm/{SA
UID}”; ]		 stkos: hasAttribute [rr:column “http://www.nstl.gov.cn/stkos/attribute_
{ID}”]
ATN_C [rr:sqlQuery “““ select ID, ATN_C,
AN, ATN_S, ATV from
stkos_attribute “““]		 [rr:template “http://www.nstl.gov.cn/stkos/
attribute_{ID}”; rr:class
stkos: attribute;]		 stkos: ATN_C [rr:column “ATN_C”]
ATN stkos: ATN [rr:column “ATN”]
ATN_S stkos: ATN_S [rr:column “ATN_S”]
ATV stkos: ATV [rr:column “ATV”]
stkos_hierarchies PSCUI [rr:sqlQuery “““ select ID, SCUI,
PSCUI from stkos_hierarchies “““]		 [rr:template “http://www.nstl.gov.cn/stkos/
sourceConcept/{SCUI}”;
rr:class stkos: sourceConcept;];		 skos: broader [rr:column “http://www.nstl.gov.cn/stkos/sourceConcept/{PSCUI}”]
stkos_relationship SACID2 [rr:sqlQuery “““ select SACID1,
STYPE1, SACID2, STYPE2, REL from
stkos_relationship where STYPE1=’
TERM’ and STYPE2=’ TERM’ and
REL=’用’ “““];		 [rr:template “http://www.nstl.gov.cn/stkos/
sourceTerm/{SACID1}”;
];		 stkos: rel/used [rr:column “http://www.nstl.gov.cn/stkos/sourceTerm/{SACID2}”]
[1] NCI Enterprise Vocabulary Services[EB/OL]. [2015-03-24]. .
[2] Medical Subject Headings (MeSH) RDF Linked Data (beta)[EB/OL]. [2017-04-24]
[3] AGROVOC Multilingual Agricultural Thesaurus [EB/OL]. [2017-04-24]. .
[4] 孙坦, 刘峥. 面向外文科技文献信息的知识组织体系建设思路[J]. 图书与情报, 2013(1): 2-7.
doi: 10.3969/j.issn.1003-6938.2013.01.001
[4] (Sun Tan, Liu Zheng.Methodology Framework of Knowledge Organization System for Scientific & Technological Literature[J]. Library and Information,2013(1): 2-7.)
doi: 10.3969/j.issn.1003-6938.2013.01.001
[5] Das S, Sundara S, Cyganiak R. R2RML: RDB to RDF Mapping Language[EB/OL]. [2015-03-12]. .
[6] 中国科学院文献情报中心. STKOS超级科技词表发布元数据规范[R]. 北京: 中国科学院文献情报中心, 2012: 6-7.
[6] (National Science Library, Chinese Academy of Sciences. Publishing Metadata Specification for Scientific & Technological Literature[R]. Beijing: National Science Library, Chinese Academy of Sciences, 2012: 6-7.)
[7] Konstantinou N, Spanos D E, Kouis D, et al.Mitrou N: An Approach for the Incremental Export of Relational Databases into RDF Graphs[J]. International Journal on Artificial Intelligence Tools, 2015, 24(2): 1-15.
doi: 10.1142/S0218213015400138
[8] Konstantinou N, Kouis D, Mitrou N.Incremental Export of Relational Database Contents into RDF Graphs[C]// Proceedings of the 4th International Conference on Web Intelligence, Mining and Semantics, Thessaloniki, Greece. 2014.
[9] OpenLink Virtuoso(Version:07.10.3207) [CP/OL]. [2014-02-17].
[1] Hao Jiashu. Enriching Personal Name Authority with Open Semantic Resources:FOAF for Schema Design[J]. 现代图书情报技术, 2016, 32(2): 75-82.
[2] Chen Tao, Zhang Yongjuan, Chen Heng. Implementation of the Framework for Converting Web-data to RDF (W2R)[J]. 现代图书情报技术, 2015, 31(2): 1-6.
[3] Liu Zhen, Zhang Zhixiong. Survey of Technical Methods and Tools of RDB-to-RDF[J]. 现代图书情报技术, 2014, 30(11): 17-23.
[4] Yu Bengong, Gu Jiawei. Information Organization and Representation Based on Folksonomy and RDF[J]. 现代图书情报技术, 2014, 30(11): 24-30.
[5] Xia Cuijuan. Research on RDB2RDF Standards and Applications[J]. 现代图书情报技术, 2013, (4): 10-17.
[6] Hong Na, Qian Qing, Fan Wei, Fang An, Wang Junhui. Visualization Implementation of Relation Discovery Based on Linked Data[J]. 现代图书情报技术, 2013, 29(2): 11-17.
[7] Xu Lei. The Optimization of SPARQL Query[J]. 现代图书情报技术, 2012, (10): 42-48.
[8] Wang Sili, Ma Jianxia, Zhu Zhongming, Zhang Xiuxiu, Ma Jianling. Study on the Linked Method of the Integrated Resources in Semantic Web Patterns[J]. 现代图书情报技术, 2011, 27(6): 32-38.
[9] Wang Sili, Zhu Zhongming. Study on the Semantic Expansion of Institutional Repository Based on Linked Data[J]. 现代图书情报技术, 2011, (11): 17-23.
[10] Li Feng. Study on Technologies of Semantic Mashup[J]. 现代图书情报技术, 2010, 26(1): 46-50.
[11] Ed Summers,Antoine Isaac,Clay Redding,Dan Krech. LCSH, SKOS and Linked Data[J]. 现代图书情报技术, 2009, 3(3): 8-14.
[12] Martin Malmsten. Making a Library Catalogue Part of the Semantic Web[J]. 现代图书情报技术, 2009, 3(3): 3-7.
[13] Sun Wandong,Yue Jun,Zhang Jing. Literatures Supply Chain Knowledge Representation and Reasoning Based on Ontology Theory[J]. 现代图书情报技术, 2007, 2(12): 34-38.
[14] Situ Junfeng . An Ontology-based Procedure of Interpreting the Semantics of XML Document[J]. 现代图书情报技术, 2006, 1(11): 55-60.
[15] Cui Lei,Zhao Peng . Developing a Practical Clinical Medication Ontology with Protégé[J]. 现代图书情报技术, 2006, 1(11): 77-80.
  Copyright © 2016 Data Analysis and Knowledge Discovery   Tel/Fax:(010)82626611-6626，82624938   E-mail:jishu@mail.las.ac.cn