1 / 8

Creating Semantic Metadata from Relational Database Using RDB2Onto

This paper presents a methodology for generating semantic metadata from relational databases, specifically through the RDB2Onto approach. As ontology-based information systems often require data translation from existing relational databases, this work evaluates various tools including D2RQ, RDQuery, and RDB2Onto itself. We discuss the advantages and disadvantages of each method, focusing on user-friendliness and the effectiveness of the automated mapping process. The evaluation is demonstrated with SQL queries and RDF/OWL XML templates, offering a practical example of RDB2Onto's application on 500 job offers.

trevor
Télécharger la présentation

Creating Semantic Metadata from Relational Database Using RDB2Onto

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. RDB2Onto: Approach for creating semantic metadata from relational database data Martin Šeleng, Michal Laclavík, Zoltán Balogh, Ladislav Hluchý Institute of Informatics, Slovak Academy of Sciences, Dúbravská cesta 9, 845 07 Bratislava, Slovakia e-mail: martin.seleng@savba.sk www: http://ikt.ui.sav.sk 9th International Conference June 21-22, 2007 Bratislava, Slovakia This work is supported by projects NAZOU SPVV 1025/2004, RAPORT APVT-51-024604, SEMCO-WS APVV-0391-06, VEGA 2/7098/27.

  2. Problem • Building ontology based information systems, it is frequently necessary to convert or replicate data from existing information systems such as databases to the ontology based information systems • Usually data in existing information systems are stored in a relational databases

  3. Approaches • Modeling languages • D2R MAP • R2O (not implemented yet) • Tools • D2RQ (using D2R MAP language) • RDQUERY (using SPARQL or RDQL queries) • RDB2Onto (using RDF/OWL XML templates and SQL queries)

  4. Advantages and Disadvantages of the tools approaches • Disadvantages • RDQuery - uses RDQL and its successor SPARQL language which most users are not familiar • D2RQ - uses own mapping language which users must learn but it is more intuitive than RDQL or SPARQL language (also automatic creation is possible by generate-mapping tool) • RDB2Onto – uses template RDF/OWL XML files which structure users must learn • Advantages • Better than hand made copying

  5. RDB2Onto Architecture

  6. Example of RDB2Onto usage: sql query and template RDF/OWL XML file SELECT id, url, original_doc_path, converted_doc_path, download_date, IF(lang = 'sk', 'Slovak', 'English') AS lang FROM document <?xml version="1.0" encoding="UTF-8"?> <rdf:RDF xmlns:jo="http://nazou.fiit.stuba.sk/nazou/ontologies/v0.6.17/offer-job#" xmlns:inst="http://nazou.fiit.stuba.sk/nazou/ontologies/v0.6.17/offer-job-inst#" xmlns:c="http://nazou.fiit.stuba.sk/nazou/ontologies/v0.6.17/classification#" xmlns:ofr="http://nazou.fiit.stuba.sk/nazou/ontologies/v0.6.17/offer#" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:owl="http://www.w3.org/2002/07/owl#" xmlns:rdfs="http://www.w3.org/2000/01/rdf-schema#"> <rdf:Description rdf:about="offer-job-inst:jo_{id}"> <rdf:type rdf:resource="offer-job:JobOffer"/> <ofr:hasSource rdf:resource="offer-job-inst:source_{id}"/> <ofr:hasOfferCreator rdf:resource="offer-job- inst:OfferCreator_NAZOU_RDB2Onto"/> </rdf:Description> <rdf:Description rdf:about="offer-job-inst:source_{id}"> <rdf:type rdf:resource="offer:OfferSource"/> <ofr:acquisitionDate>{download_date}</ofr:acquisitionDate> <ofr:originalURI>{url}</ofr:originalURI> <ofr:localURI>{original_doc_path}</ofr:localURI> <ofr:localConvertedURI>{converted_doc_path}</ofr:localConvertedURI> <ofr:language rdf:resource="region:{lang}"/> </rdf:Description> </rdf:RDF>

  7. Evaluation on 500 job offers

  8. Thank You For Your AttentionQuestions?

More Related