advertisement

Virtuoso's SQL to RDF Technology (W3C RDF & DBMS )

50 %
50 %
advertisement
Information about Virtuoso's SQL to RDF Technology (W3C RDF & DBMS )
Science-Technology

Published on November 15, 2007

Author: rumito

Source: authorstream.com

advertisement

OpenLink Virtuoso - SQL & RDF:  OpenLink Virtuoso - SQL & RDF RDF Views of SQL Data (Exposing SQL Data as RDF) Orri Erling Program Manager - OpenLink Virtuoso mailto:oerling@openlinksw.com Virtuoso Universal Server:  Virtuoso Universal Server Native SQL & XML DBMS Federated / Hybrid Data Server (Virtual Database Engine) Web Services Platform SQL to RDF Mapping Native RDF Quad Store (with SPARQL support) In-built RDF Middleware (“Sponger”) RDF Linked Data Deployment Platform Situation Analysis:  Situation Analysis Data Drives Everything Data Heterogeneity is a fact of life There is no Information without Data The Era of Information Overload is Neigh Information Processing drives Corporate & Individual Agility What We Hope:  What We Hope Write The Final Chapter of the Information Integration Saga! Yes, if...:  Yes, if... SPARQL to Match SQL for BI Queries Tools and Training for the Information Architect Successful Migration of Domain Specific XML Vocabularies to RDF An Ideal Solution:  An Ideal Solution Slide7:  Virtuoso’s RDF Views of SQL Data Functionality What are RDF Views?:  What are RDF Views? Expose pre-existing relational data as virtual RDF graphs Available for querying through SPARQL or SPASQL (SPARQL embedded in SQL) No physical regeneration of relational data Virtuoso RDF Views Implementation:  Virtuoso RDF Views Implementation Quad Patterns Translate Relational Data to G, S, P, O Map Local or Heterogeneous Remote Data To RDF Map XML/Text/Web Services to RDF via Table Valued Functions Sophisticated Query Transformations and Optimization Virtuoso SPARQL and SQL Extensions:  Virtuoso SPARQL and SQL Extensions Aggregates, Grouping, Full Text for SPARQL SQL "Breakup" for Mapping Wide Rows to n-Triples Freely Intermingle SQL and SPARQL Northwind Demo Database:  Northwind Demo Database Tables include: Demo.demo.Orders Demo.demo.Customers Northwind Demo Database: RDF View Definition Extract:  Northwind Demo Database: RDF View Definition Extract prefix northwind: <http://www.openlinksw.com/schemas/northwind#> … create iri class northwind:Customer <http://^{URIQADefaultHost}^/Northwind/Customer/%U#this> (in customer_id varchar not null) … alter quad storage virtrdf:DefaultQuadStorage … from Demo.demo.Customers as customers from Demo.demo.Orders as orders … { Demo.demo.Customers Northwind RDF View Definition create virtrdf:NorthwindDemo as graph iri (“http://^{URIQADefaultHost}^/Northwind”) { … northwind:Customer(customers.CustomerID) a foaf:Organization as virtrdf:Customer-CustomerID ; northwind:companyName customers.CompanyName as … ; … northwind:fax customers.Fax as virtrdf:Customer-fax . … } } northwind:Customer(orders.CustomerID) northwind:has_order northwind:Order(orders.OrderID) as virtrdf:Order-has_order . Northwind Demo Database: RDF View Definition Extract:  Northwind Demo Database: RDF View Definition Extract prefix northwind: <http://www.openlinksw.com/schemas/northwind#> … create iri class northwind:Order <http://^{URIQADefaultHost}^/Northwind/Order/%d#this> (in order_id integer not null) . … alter quad storage virtrdf:DefaultQuadStorage … from Demo.demo.Customers as customers from Demo.demo.Orders as orders … { Demo.demo.Orders Northwind RDF View Definition create virtrdf:NorthwindDemo as graph iri (“http://^{URIQADefaultHost}^/Northwind”) { … northwind:Order (orders.OrderID) a northwind:Order as virtrdf:Order-Order ; northwind:orderDate orders.OrderDate as virtrdf:Order-order_date ; northwind:requiredDate orders.RequiredDate as virtrdf:Order-required_date ; … … } } northwind:has_customer northwind:Customer (orders.CustomerID) as virtrdf:Order-order_has_customer northwind:has_employee northwind:Employee (orders.EmployeeID) as virtrdf:Order-order_has_employee ; Northwind Demo Database: Customer Table to RDF Entity Mapping:  Northwind Demo Database: Customer Table to RDF Entity Mapping Orders Table Facilitate Information at Your Finger Tips:  Facilitate Information at Your Finger Tips Provide a Conceptual View of Logical Data Make the Conceptual Views concrete focal points of Data Access Identify Data Entities using URIs (Data Links) e.g http://demo.openlinksw.com/Northwind/Customer/ALFKI#this Identify Associations / Relationships with other Entities using URIs e.g http://www.openlinksw.com/schemas/northwind#has_order SQL-RDF Mapping Experiences:  SQL-RDF Mapping Experiences Mapping is Non-Trivial Problems Start When Many Tables Map to the Same Thing Choice of URI Scheme Can Greatly Affect Optimization Possibilities What We Need:  What We Need Interop of Necessary SPARQL Extensions Visual Tools for SQL-RDF Mapping SQL-RDF Mapping Syntax Standardization Community Consensus on RDF Vocabularies It is NOT about RDF vs. XML vs. SQL:  It is NOT about RDF vs. XML vs. SQL Web Services are for Transactions and App. Integration RDF is for Disparate Data Meshing, Discovery, and Drill Down/Analysis SQL is Forever SQL-RDF Integration Value:  SQL-RDF Integration Value Enterprise: Alleviation of heterogeneous data integration challenges Public: A Whole Economy of Discoverable Linked Data and Data Mesh-ups Now: Full Text For All - Next: Analysis For All OpenLink Futures:  OpenLink Futures Commercial Deployment of SQL to RDF Mapping Towards Web-scale with Clustered RDBMS/Triple Store OpenLink Data Spaces (ODS) for Bootstrapping SemWeb Presence Additional Information:  Additional Information http://virtuoso.openlinksw.com (general site) http://virtuoso.openlinksw.com/wiki/main/ (Open Source Edition Site) http://virtuoso.openlinksw.com/Whitepapers/index.htm (OpenLink Data Spaces) Slide22:  Thank You!

Add a comment

Related presentations

Related pages

VirtuosoUniversalServer - W3C Wiki - World Wide Web ...

VirtuosoUniversalServer. From W3C Wiki. Jump to: navigation, search. ... Virtuoso's SQL to RDF Technology Presentation ...
Read more

OpenLink Virtuoso: SQL & RDF

Native SQL & XML DBMS; Federated / Hybrid Data Server (Virtual Database Engine) Web Services Platform; SQL to RDF Mapping; ... Virtuoso RDF Views ...
Read more

How RDF Databases Differ from Other NoSQL Solutions - The ...

This started out as an answer at Semantic Overflow on how RDF database systems differ from other ... W3C's Linked Data technology ... DBMS implementation ...
Read more

Rdb2RdfXG/StateOfTheArt - W3C Wiki - World Wide Web ...

Rdb2RdfXG/StateOfTheArt/Table. ... Virtuoso maps Tables, Views, SQL Stored ... Virtuoso's SQL to RDF Technology Presentation (W3C RDF & DBMS Integration ...
Read more

Virtuoso White Papers Collection - OpenLink Virtuoso Home Page

White Papers. General: 500 Billion ... Deploying RDF Linked Data via Virtuoso Universal ... Virtuoso's SQL to RDF Technology Presentation (W3C RDF & DBMS ...
Read more

Relational Technologies, Metadata and RDF

Relational Technologies, Metadata and RDF on ResearchGate, the professional network for scientists. Article . Relational Technologies, Metadata and RDF ...
Read more

RDF in the Database: Enabling Semantically Rich Business ...

Enabling Semantically Rich Business Applications ... Applying DBMS Technology to the Challenge ... (W3C) support SQL-level access to RDF data
Read more

RDF Overview

... (W3C) RDF Primer at http://www.w3.org/TR ... The PL/SQL subprograms for working with RDF are in the SDO_RDF ... RDF statements are expressed in ...
Read more