1 / 11

Suggestions for Semantic Web Interfaces to Relational Databases

This presentation discusses the desirable characteristics of a semantic web interface for relational databases, including support for common patterns, query decomposition, semantic bridge, data access, and more.

earlh
Download Presentation

Suggestions for Semantic Web Interfaces to Relational Databases

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. Suggestions forSemantic Web Interfacesto Relational Databases Mike Dean mdean@bbn.com W3C Workshop on RDF Access to Relational Databases Cambridge, MA 26 October 2007

  2. Outline • Our Experience • Desirable Semantic Web Characteristics • Support for Common Patterns • Other Issues • Potential Areas for Standardization

  3. SOAP WS RDBMS Asio Scout Architecture 1 Query: SPARQL Snoggle 6 Query Result Set Query Decomposition 2 Semantic Query Decomposition (SQD) Backwards Rule Chaining 5 Generation ofSub Queries 3 Automapper Semantic Bridge Database Semantic Bridge Web Service Semantic Bridge SPARQL Endpoint 4 Data Access KB

  4. Semantic Web Characteristics • Publishing each data model as an OWL ontology • Use of resolvable URIs • Favoring the use of object properties over datatype properties • Use of datatypes • Use of accepted conventions such as camelCaseNames and singular class names • Reuse of or mappings to existing vocabularies such as FOAF and Dublin Core

  5. Evolution of Approaches Custom Data source ontology SWRL Translation rules Domain ontology DBMS Custom servlet translation application • Expose each data source with an OWL representation of its native data model • Use SWRL to represent structural transformations, unit conversions, etc. • Support cross-product of producers and consumers • Gold standard in terms of output quality • Labor-intensive

  6. Evolution of Approaches Optional mapping directives AutoMapper Generic Data source ontology SWRL Translation rules Data source ontology SWRL Translation rules Domain ontology DBMS Generic servlet translation “Nice” SW data translation application • Get the data into Semantic Web format quickly and then apply Semantic Web tools • Much less labor to achieve similar results • How “nice” can we make the first stage output?

  7. Evolution of Approaches Optional mapping directives AutoMapper Generic Data source ontology SWRL Translation rules Data source ontology SWRL Translation rules Domain ontology “Busness Rules” DBMS Generic servlet translation “Nice” SW data translation application inference application • Domain ontology is often augmented with domain-specific business rules • A domain ontology may become someone else’s data source • N-level approach

  8. Support for Common Patterns • Most databases are now designed from an ER or OO model – this higher-level model should be exposed • Parent and child tables for inheritance • Implicit class hierarchies (“type” column) • N-ary relations

  9. Other Issues • Use of resolvable URIs • Support HTTP GET as well as SPARQL • Ensure that returned URIs can be used in subsequent SPARQL queries • “External foreign keys” – links to open data • Security • Non-public data sources require authentication • Performance • Update

  10. Potential Areas for Standardization • Table and column to class and property mappings • SQL datatype to XML Schema datatype mappings • SPARQL to SQL translation • Web service interfaces (including authentication)

  11. More Information • http://asio.bbn.com • SemTech 2007 presentation/demo

More Related