[go: up one dir, main page]

CN110347736A - A kind of data self mapping method towards RDF triple - Google Patents

A kind of data self mapping method towards RDF triple Download PDF

Info

Publication number
CN110347736A
CN110347736A CN201910542461.4A CN201910542461A CN110347736A CN 110347736 A CN110347736 A CN 110347736A CN 201910542461 A CN201910542461 A CN 201910542461A CN 110347736 A CN110347736 A CN 110347736A
Authority
CN
China
Prior art keywords
mapping
data
r2rml
rdf
language
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN201910542461.4A
Other languages
Chinese (zh)
Inventor
刘家祥
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Central Mdt Infotech Ltd Of United States Of Xiamen
Original Assignee
Central Mdt Infotech Ltd Of United States Of Xiamen
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Central Mdt Infotech Ltd Of United States Of Xiamen filed Critical Central Mdt Infotech Ltd Of United States Of Xiamen
Priority to CN201910542461.4A priority Critical patent/CN110347736A/en
Publication of CN110347736A publication Critical patent/CN110347736A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/258Data format conversion from or to a database
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/284Relational databases
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/30Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
    • G06F16/36Creation of semantic tools, e.g. ontology or thesauri
    • G06F16/367Ontology
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90Details of database functions independent of the retrieved data types
    • G06F16/901Indexing; Data structures therefor; Storage structures
    • G06F16/9024Graphs; Linked lists

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Software Systems (AREA)
  • Life Sciences & Earth Sciences (AREA)
  • Animal Behavior & Ethology (AREA)
  • Computational Linguistics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

A kind of data self mapping method towards RDF triple, includes the following steps: Step 1: obtaining relational database data;Step 2: database table structure and data are directly output as RDF graph using Direct Mapping mapping language;Specific database structure and vocabulary are customized using R2RML mapping language, and data relationship library is exported as RDF data collection;Step 3: using Direct Mapping mapping language as default mapping scheme, using R2RML as personalized customization scheme.Direct Mapping mapping language provides the initial rules of machine automatic conversion in the present invention, R2RML provides artificial customized logical framework and syntax rule, two kinds of mapping modes complement one another, the data in relational database to be preferably converted to the triple data of RDF.

Description

A kind of data self mapping method towards RDF triple
Technical field
The present invention relates to technical field of data processing more particularly to a kind of data self mappings towards RDF triple Method.
Background technique
Resource description framework (Resource Description Framework) is a kind of for describing Web resource Markup language.RDF is XML (subset of the standard generalized markup language) application of a processing metadata, and so-called metadata is exactly " data of description data " or " information of description information ".
When the relational database containing structuring historical data to be dissolved into knowledge mapping, relation data is directly used Library is clearly inappropriate, demand when relational database is not able to satisfy applied to knowledge mapping, need to will be in relational database Data be converted to RDF triple data according to mapping relations, preferably to describe and apply data.Moreover, being reflected using single It penetrates mode and the data in relational database is converted into RDF triple data with certain limitation, it cannot be according to user's need Ask carry out personalized customization.
Summary of the invention
(1) goal of the invention
To solve technical problem present in background technique, the present invention proposes that a kind of data towards RDF triple are made by oneself Benefit film showing shooting method, Direct Mapping mapping language provide the initial rules of machine automatic conversion, and R2RML is provided manually certainly The logical framework and syntax rule of definition, two kinds of mapping modes complement one another, preferably to turn the data in relational database It is changed to the triple data of RDF.
(2) technical solution
To solve the above problems, the present invention provides a kind of data self mapping methods towards RDF triple, including Following steps:
Step 1: obtaining relational database data;
Step 2: database table structure and data are directly output as RDF using Direct Mapping mapping language Figure;Specific database structure and vocabulary are customized using R2RML mapping language, and data relationship library is exported as RDF data collection;
Step 3: using Direct Mapping mapping language as default mapping scheme, using R2RML as personalized customization Scheme.
Preferably, the raw material to be worked using " input database " as R2RML processor;Using R2RML mapped file as The foundation of R2RML processor work;" output database " output is addressable according to R2RML mapped file by R2RML processor Retrievable " output data set ".
Preferably, in " output data set " of R2RML, R2RML includes two kinds of processing modes to empty node, specifically such as Under:
The first: is when same empty node identifier comes across in multiple triples in same RDF graph, multiple ternary Group shares same empty node;
Second: when same empty node identifier comes across in multiple RDF graphs, which cannot be by different RDF Figure shares.
Preferably, R2RML is automatically generated according to the mapping mode of Direct Mapping using R2RML processor to map File, then follow the customized R2RML mapped file of R2RML grammer.
Preferably, in the frame that " logical table " is mapped as RDF by utilization " triple mapping ", utilize " main body mapping " fixed Adopted main body utilizes " mapping of predicate object " to define predicate and object.
Preferably, it is mapped using the RDB2RDF for including Direct Mapping mapping language and R2RML mapping language Language is on any one workbench in RDF-RDB2RDF, XSPARQL, Ultrawrap and db2triples by database Data output is RDF data collection.
Above-mentioned technical proposal of the invention has following beneficial technical effect: for that will contain the pass of structuring historical data It is that database is dissolved into knowledge mapping, data model is used as using resource description framework (RDF), by the data of relational database Be converted to the triple data of RDF.In specific conversion process, directly reflected using Direct Mapping mapping language Penetrate, in the RDF graph using the output of this kind of mapping mode, table name in term and relational database for indicating class and predicate and Field name is consistent;The mapping that personalized customization is carried out using R2RML mapping language is exported using this kind of mapping mode RDF data is concentrated, and the title of the term used such as class, predicate are both from existing vocabulary;Direct Mapping mapping Language provides the initial rules of machine automatic conversion, and R2RML provides artificial customized logical framework and syntax rule, and two kinds reflect The mode of penetrating complements one another, the data in relational database to be preferably converted to the triple data of RDF.
Detailed description of the invention
Fig. 1 is a kind of structure flow chart of the data self mapping method towards RDF triple proposed by the present invention.
Fig. 2 is the work of R2RML in a kind of data self mapping method towards RDF triple proposed by the present invention Mechanism structure schematic diagram.
Fig. 3 is to reflect " logical table " in a kind of data self mapping method towards RDF triple proposed by the present invention Penetrate the realization circuit theory schematic diagram for RDF.
Specific embodiment
In order to make the objectives, technical solutions and advantages of the present invention clearer, With reference to embodiment and join According to attached drawing, the present invention is described in more detail.It should be understood that these descriptions are merely illustrative, and it is not intended to limit this hair Bright range.In addition, in the following description, descriptions of well-known structures and technologies are omitted, to avoid this is unnecessarily obscured The concept of invention.
As shown in Figure 1-3, a kind of data self mapping method towards RDF triple proposed by the present invention, including such as Lower step:
Step 1: obtaining relational database data;
Step 2: database table structure and data are directly output as RDF using Direct Mapping mapping language Figure;Specific database structure and vocabulary are customized using R2RML mapping language, and data relationship library is exported as RDF data collection;
Step 3: using Direct Mapping mapping language as default mapping scheme, using R2RML as personalized customization Scheme.
In the present invention, for the relational database containing structuring historical data to be dissolved into knowledge mapping, using resource Describing framework (RDF) is used as data model, and the data of relational database are converted to the triple data of RDF.It is specific converted Cheng Zhong is directly mapped using Direct Mapping mapping language, in the RDF graph using the output of this kind of mapping mode, Table name in term and relational database and field name for indicating class and predicate are consistent;Utilize R2RML mapping language The mapping for carrying out personalized customization is concentrated using the RDF data of this kind of mapping mode output, the title of the term used such as class, Predicate is both from existing vocabulary;Direct Mapping mapping language provides the initial rules of machine automatic conversion, R2RML provides artificial customized logical framework and syntax rule, two kinds of mapping modes complement one another, preferably by relationship number The triple data of RDF are converted to according to the data in library.
In an alternative embodiment, the raw material to be worked using " input database " as R2RML processor;With The foundation that R2RML mapped file works as R2RML processor;R2RML processor will " output number according to R2RML mapped file According to library " it exports to may have access to retrievable " output data set ".
It should be noted that R2RML working mechanism includes " input database ", R2RML mapped file and R2RML processing Totally three elements, three elements provide the triple data that the data in relational database are converted to RDF to necessity for R2RML to device It supports.
In an alternative embodiment, in " output data set " of R2RML, R2RML includes two kinds to empty node Processing mode, specific as follows:
The first: is when same empty node identifier comes across in multiple triples in same RDF graph, multiple ternary Group shares same empty node;
Second: when same empty node identifier comes across in multiple RDF graphs, which cannot be by different RDF Figure shares.
It should be noted that according to two kinds of concrete conditions, using the different processing modes for empty node.
In an alternative embodiment, automatic according to the mapping mode of Direct Mapping using R2RML processor R2RML mapped file is generated, then follows the customized R2RML mapped file of R2RML grammer.
In an alternative embodiment, in the frame that " logical table " is mapped as RDF by utilization " triple mapping ", It utilizes " main body mapping " to define main body, " mapping of predicate object " is utilized to define predicate and object.
It should be noted that the RDF triple is shared same by " main when " logical table " is mapped as RDF triple The main body that body mapping " defines.
In an alternative embodiment, using including Direct Mapping mapping language and R2RML mapping language RDB2RDF mapping language in RDF-RDB2RDF, XSPARQL, Ultrawrap and db2triples any one work Database data is exported as RDF data collection on platform.
It should be noted that above-mentioned workbench can be implemented Direct Mapping and R2RML standard criterion, moreover, Implementation includes ETL mode and dynamic translation mode.It, can be according to mapping predetermined, by relation data for ETL mode Library generates static state RDF packet;It, can be according to foreground request and mapping predetermined, by relational database for dynamic translation mode RDF data made of data conversion is back to foreground.
It should be understood that above-mentioned specific embodiment of the invention is used only for exemplary illustration or explains of the invention Principle, but not to limit the present invention.Therefore, that is done without departing from the spirit and scope of the present invention is any Modification, equivalent replacement, improvement etc., should all be included in the protection scope of the present invention.In addition, appended claims purport of the present invention Covering the whole variations fallen into attached claim scope and boundary or this range and the equivalent form on boundary and is repairing Change example.

Claims (6)

1. a kind of data self mapping method towards RDF triple, which comprises the steps of:
Step 1: obtaining relational database data;
Step 2: database table structure and data are directly output as RDF graph using Direct Mapping mapping language;It utilizes R2RML mapping language customizes specific database structure and vocabulary, and data relationship library is exported as RDF data collection;
Step 3: using Direct Mapping mapping language as default mapping scheme, using R2RML as personalized customization side Case.
2. a kind of data self mapping method towards RDF triple according to claim 1, which is characterized in that with The raw material that " input database " works as R2RML processor;It works using R2RML mapped file as R2RML processor Foundation;" output database " output may have access to retrievable " output data according to R2RML mapped file by R2RML processor Collection ".
3. a kind of data self mapping method towards RDF triple according to claim 2, which is characterized in that In " output data set " of R2RML, R2RML includes two kinds of processing modes to empty node, specific as follows:
The first: when same empty node identifier comes across in multiple triples in same RDF graph, multiple triple is total With same empty node;
Second: when same empty node identifier comes across in multiple RDF graphs, which cannot be total to by different RDF graphs With.
4. a kind of data self mapping method towards RDF triple according to claim 2, which is characterized in that benefit R2RML mapped file is automatically generated according to the mapping mode of Direct Mapping with R2RML processor, then follows R2RML language The customized R2RML mapped file of method.
5. a kind of data self mapping method towards RDF triple according to claim 1, which is characterized in that It utilizes " triple mapping " that " logical table " is mapped as in the frame of RDF, " main body mapping " is utilized to define main body, utilize " predicate Object mapping " defines predicate and object.
6. a kind of data self mapping method towards RDF triple according to claim 1, which is characterized in that benefit With include Direct Mapping mapping language and R2RML mapping language RDB2RDF mapping language RDF-RDB2RDF, Database data is exported as RDF data on any one workbench in XSPARQL, Ultrawrap and db2triples Collection.
CN201910542461.4A 2019-06-21 2019-06-21 A kind of data self mapping method towards RDF triple Pending CN110347736A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201910542461.4A CN110347736A (en) 2019-06-21 2019-06-21 A kind of data self mapping method towards RDF triple

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201910542461.4A CN110347736A (en) 2019-06-21 2019-06-21 A kind of data self mapping method towards RDF triple

Publications (1)

Publication Number Publication Date
CN110347736A true CN110347736A (en) 2019-10-18

Family

ID=68182732

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201910542461.4A Pending CN110347736A (en) 2019-06-21 2019-06-21 A kind of data self mapping method towards RDF triple

Country Status (1)

Country Link
CN (1) CN110347736A (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111813798A (en) * 2020-07-10 2020-10-23 中国医学科学院医学信息研究所 Mapping method, device, device and storage medium based on R2RML standard
CN116304217A (en) * 2023-03-31 2023-06-23 易智瑞信息技术有限公司 Geospatial data query method, apparatus, electronic device, and readable storage medium

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20140310235A1 (en) * 2013-04-11 2014-10-16 Oracle International Corporation Seasonal trending, forecasting, anomaly detection, and endpoint prediction of java heap usage
CN105138526A (en) * 2014-05-30 2015-12-09 国际商业机器公司 Method and system used for automatically generating semantic mapping for relational databases
CN108509420A (en) * 2018-03-29 2018-09-07 赵维平 Gu spectrum and ancient culture knowledge mapping natural language processing method

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20140310235A1 (en) * 2013-04-11 2014-10-16 Oracle International Corporation Seasonal trending, forecasting, anomaly detection, and endpoint prediction of java heap usage
CN105138526A (en) * 2014-05-30 2015-12-09 国际商业机器公司 Method and system used for automatically generating semantic mapping for relational databases
CN108509420A (en) * 2018-03-29 2018-09-07 赵维平 Gu spectrum and ancient culture knowledge mapping natural language processing method

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
夏翠娟: "RDB2RDF标准及应用研究", 《现代图书情报技术》 *

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111813798A (en) * 2020-07-10 2020-10-23 中国医学科学院医学信息研究所 Mapping method, device, device and storage medium based on R2RML standard
CN111813798B (en) * 2020-07-10 2023-06-23 中国医学科学院医学信息研究所 Mapping method, device, equipment and storage medium based on R2RML standard
CN116304217A (en) * 2023-03-31 2023-06-23 易智瑞信息技术有限公司 Geospatial data query method, apparatus, electronic device, and readable storage medium
CN116304217B (en) * 2023-03-31 2024-04-26 易智瑞信息技术有限公司 Geospatial data query method, apparatus, electronic device, and readable storage medium

Similar Documents

Publication Publication Date Title
EP3789900B1 (en) Data protection method and device and storage medium
CN104133772B (en) Automatic test data generation method
CN109857801B (en) Intelligent irrigation area e platform based on four-layer architecture and data processing method
CN108038045B (en) Android user behavior data acquisition method based on non-buried point
CN111078702A (en) SQL sentence classification management and unified query method and device
EP1302867A2 (en) Efficient web page localization
CN103218402B (en) General database data structure and data mover system and method thereof
CN101617292A (en) Producer graph oriented programming and execution
CN109815283A (en) A kind of heterogeneous data source visual inquiry method
CN106873974A (en) Smart code generates automotive engine system and method
CN109408493A (en) A kind of moving method and system of data source
CN110222110A (en) A kind of resource description framework data conversion storage integral method based on ETL tool
Schleicher et al. Beyond stereotyping: Metamodeling approaches for the UML
CN108959496A (en) Integration across database access method and abstract data access method based on dynamic proxy
CN112491943A (en) Data request method, device, storage medium and electronic equipment
CN110347736A (en) A kind of data self mapping method towards RDF triple
CN106815027A (en) A kind of high resiliency calculating platform for power network multidimensional business composite computing
CN105718601A (en) Business dynamic integration model and application method thereof
CN113094039A (en) Automatic code generation system based on database table
CN116414801A (en) Data migration method, device, computer equipment and storage medium
CN109116828A (en) Model code configuration method and device in a kind of controller
CN105681100A (en) Multi-protocol acquiring and scheduling method for comprehensive network management
CN113778348B (en) Log coloring method, device, electronic device and computer-readable storage medium
CN109343835A (en) A kind of rapid build business scaffold code instrumentation based on template
CN108984156A (en) A kind of software auto generating method and system for exempting from code development based on template

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
RJ01 Rejection of invention patent application after publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20191018