1 / 12

VisAVis: An Approach to an Intermediate Layer between Ontologies and Relational Database Contents

Explore an intermediate layer between ontologies and relational databases with the VisAVis plugin. Map between RDB and ontologies, execute RDQL queries, and bridge data automatically.

yatess
Download Presentation

VisAVis: An Approach to an Intermediate Layer between Ontologies and Relational Database Contents

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. Nikolaos Konstantinou, National Technical University of Greece VisAVis: An Approach to an Intermediate Layer between Ontologies and Relational Database Contents Web Information Systems Modeling Luxembourg, June 2006

  2. Web Information Systems Modeling Luxembourg, June 2006 Introduction VisAVis Protégé Plugin Features Map between RDB and Ontologies Execute queries expressed in RDQL

  3. Web Information Systems Modeling Luxembourg, June 2006 Motivation The Semantic Web Vision orders that web pages need to be annotated in terms of an ontology language What happens with Data stored in databases and is generated and retrieved automatically?

  4. Web Information Systems Modeling Luxembourg, June 2006 Definitions An Ontology can be defined as a model of a Knowledge Base Thus, we have the Terminological and the Assertional Box (ABox & TBox) Simplified point of view: TBox <-> Schema of the RDB ABox <-> Instance of the actual data

  5. Web Information Systems Modeling Luxembourg, June 2006 Mapping Process Capture Database Data Select an Ontology Class Validate the mapping Modify the resulting Ontology

  6. Web Information Systems Modeling Luxembourg, June 2006 Mapping Process • Validate the mapping • Disjoint classes cannot have mappings to common data. Common data includes data in tables with a foreign key relation • Maintain subclass hierarchy in the database

  7. Web Information Systems Modeling Luxembourg, June 2006 Query Execution Parse requests Instead of returning the class resources, we check if the mapping property exists Yes: redirect the query to the database No: No changes

  8. Web Information Systems Modeling Luxembourg, June 2006 Use-Case Scenario

  9. Web Information Systems Modeling Luxembourg, June 2006 Use-Case Scenario <owl:Class rdf:about="#Hiking"> <queryString>SELECT activities.description FROM activities, activities_types WHERE (activities.activity_type_id=activities_types.id) AND (activities_types.name = "Hiking") </queryString> <rdfs:subClassOf> <owl:Class rdf:about="#Sports"/> </rdfs:subClassOf> </owl:Class>

  10. Web Information Systems Modeling Luxembourg, June 2006 Implementation Java, version 1.5.0 or higher Jena framework, tested in versions 2.2 and 2.3 Protégé, tested in 3.0, 3.1, 3.1.1, 3.2beta MySQL and PostgreSQL, with JDBC connection

  11. Web Information Systems Modeling Luxembourg, June 2006 Future Work Richer SQL builder Support for more databases Return results from both the database and the ontology

  12. Web Information Systems Modeling Luxembourg, June 2006 Questions Thank you for your attention • VisAVis plugin available at http://www.cn.ntua.gr/~nkons/essays_en.html

More Related