Open Link Virtuoso SQL RDF Views of SQL

Open. Link Virtuoso - SQL & RDF Views of SQL Data (Exposing SQL Data as RDF) Orri Erling Program Manager - Open. Link Virtuoso mailto: oerling@openlinksw. com © 2007 Open. Link Software, All rights reserved

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 © 2007 Open. Link Software, All rights reserved

Situation Analysis n Data Drives Everything n Data Heterogeneity is a fact of life n There is no Information without Data n The Era of Information Overload is Neigh n Information Processing drives Corporate & Individual Agility © 2007 Open. Link Software, All rights reserved

What We Hope Write The Final Chapter of the Information Integration Saga! © 2007 Open. Link Software, All rights reserved

Yes, if. . . n SPARQL to Match SQL for BI Queries n Tools and Training for the Information Architect n Successful Migration of Domain Specific XML Vocabularies to RDF © 2007 Open. Link Software, All rights reserved

An Ideal Solution © 2007 Open. Link Software, All rights reserved

Virtuoso’s RDF Views of SQL Data Functionality © 2007 Open. Link Software, All rights reserved

What are RDF Views? n Expose pre-existing relational data as virtual RDF graphs n Available for querying through SPARQL or SPASQL (SPARQL embedded in SQL) n No physical regeneration of relational data © 2007 Open. Link Software, All rights reserved

Virtuoso RDF Views Implementation n Quad Patterns Translate Relational Data to G, S, P, O n Map Local or Heterogeneous Remote Data To RDF n Map XML/Text/Web Services to RDF via Table Valued Functions n Sophisticated Query Transformations and Optimization © 2007 Open. Link Software, All rights reserved

Virtuoso SPARQL and SQL Extensions n Aggregates, Grouping, Full Text for SPARQL n SQL "Breakup" for Mapping Wide Rows to n. Triples n Freely Intermingle SQL and SPARQL © 2007 Open. Link Software, All rights reserved

Northwind Demo Database Tables include: Demo. demo. Customers Customer ID Company Name Contact Title Address City Postal Code Country Phone Fax varchar(5) varchar(40) varchar(30) varchar(60) varchar(15) varchar(10 ) varchar(15) varchar(24) ALFKI Alfreds Futterkiste Maria Anders Sales Representative Obere Str. 57 Berlin 12209 Germany 030 0074321 030 0076545 ANATR Ana Trujillo Emparedados y helados Ana Trujillo Owner Avda. de la Constitucion 2222 Mexico D. F. 05021 Mexico (5) 555 4729 (5) 555 3745 ANTON Antonio Moreno Taqueria Antonio Moreno Owner Avda. de la Constitucion 2222 Mexico D. F. 05023 Mexico (171) 555 7788 (171) 555 6759 Demo. demo. Orders Order ID Customer ID Employee ID Order Date Required Date Shipped Date Ship Via … 10643 ALFKI 6 1995 -09 -25 1995 -10 -23 1995 -10 -03 1 … 10692 ALFKI 4 1995 -11 -03 1995 -12 -01 1995 -11 -13 2 … … … … © 2007 Open. Link Software, All rights reserved

Northwind Demo Database: RDF View Definition Extract Demo. demo. Customers Customer ID Company Name Contact Title Address City Postal Code Northwind RDF View Definition prefix northwind: <http: //www. openlinksw. com/schemas/northwind#> … create iri class northwind: Customer <http: //^{URIQADefault. Host}^/Northwind/Customer/%U#this> (in customer_id varchar not null) … alter quad storage virtrdf: Default. Quad. Storage … from Demo. demo. Customers as customers from Demo. demo. Orders as orders … { create virtrdf: Northwind. Demo as graph iri (“http: //^{URIQADefault. Host}^/Northwind”) { … northwind: Customer(customers. Customer. ID) a foaf: Organization as virtrdf: Customer-Customer. ID ; northwind: company. Name customers. Company. Name as … ; … northwind: fax customers. Fax as virtrdf: Customer-fax. northwind: Customer(orders. Customer. ID) northwind: has_order northwind: Order(orders. Order. ID) as virtrdf: Order-has_order. … }} © 2007 Open. Link Software, All rights reserved Country Phone Fax

Northwind Demo Database: RDF View Definition Extract Demo. demo. Orders Order ID Customer ID Employee ID Order Date Required Date Shipped Via Northwind RDF View Definition prefix northwind: <http: //www. openlinksw. com/schemas/northwind#> … create iri class northwind: Order <http: //^{URIQADefault. Host}^/Northwind/Order/%d#this> (in order_id integer not null). … alter quad storage virtrdf: Default. Quad. Storage … from Demo. demo. Customers as customers from Demo. demo. Orders as orders … { create virtrdf: Northwind. Demo as graph iri (“http: //^{URIQADefault. Host}^/Northwind”) { … northwind: Order (orders. Order. ID) a northwind: Order as virtrdf: Order-Order ; northwind: order. Date orders. Order. Date as virtrdf: Order-order_date ; northwind: required. Date orders. Required. Date as virtrdf: Order-required_date ; … northwind: has_customer northwind: Customer (orders. Customer. ID) as virtrdf: Order-order_has_customer northwind: has_employee northwind: Employee (orders. Employee. ID) as virtrdf: Order-order_has_employee ; … }} © 2007 Open. Link Software, All rights reserved …

Northwind Demo Database: Customer Table to RDF Entity Mapping Customer ID Company Name Contact Title Address City Postal Code Country Phone Fax ALFKI Alfreds Futterkiste Maria Anders Sales Representative Obere Str. 57 Berlin 12209 Germany 030 0074321 030 0076545 prefix <http: //demo. openlinksw. com/Northwind/> Customer/ALFKI#this has_order company. Name Alfreds Futterkiste contact. Name Order/10643#this Order/10692#this … has_customer … Maria Anders has_customer has_order fax 030 -0076545 contact. Title Postal. Code address Sales Representative city Berlin 12209 phone 030 -0074321 country Germany Obere Str. 57 © 2007 Open. Link Software, All rights reserved Orders Table Order ID Customer ID … 10643 ALFKI … 10692 ALFKI …

Facilitate Information at Your Finger Tips n Provide a Conceptual View of Logical Data n Make the Conceptual Views concrete focal points of Data Access n Identify Data Entities using URIs (Data Links) e. g http: //demo. openlinksw. com/Northwind/Customer/ALFKI#this n Identify Associations / Relationships with other Entities using URIs e. g http: //www. openlinksw. com/schemas/northwind#has_order © 2007 Open. Link Software, All rights reserved

SQL-RDF Mapping Experiences n Mapping is Non-Trivial n Problems Start When Many Tables Map to the Same Thing n Choice of URI Scheme Can Greatly Affect Optimization Possibilities © 2007 Open. Link Software, All rights reserved

What We Need n Interop of Necessary SPARQL Extensions n Visual Tools for SQL-RDF Mapping n SQL-RDF Mapping Syntax Standardization n Community Consensus on RDF Vocabularies © 2007 Open. Link Software, All rights reserved

It is NOT about RDF vs. XML vs. SQL n Web Services are for Transactions and App. Integration n RDF is for Disparate Data Meshing, Discovery, and Drill Down/Analysis n SQL is Forever © 2007 Open. Link Software, All rights reserved

SQL-RDF Integration Value n Enterprise: Alleviation of heterogeneous data integration challenges n Public: A Whole Economy of Discoverable Linked Data and Data Mesh-ups n Now: Full Text For All - Next: Analysis For All © 2007 Open. Link Software, All rights reserved

Open. Link Futures n Commercial Deployment of SQL to RDF Mapping n Towards Web-scale with Clustered RDBMS/Triple Store n Open. Link Data Spaces (ODS) for Bootstrapping Sem. Web Presence © 2007 Open. Link Software, All rights reserved

Additional Information n http: //virtuoso. openlinksw. com (general site) n http: //virtuoso. openlinksw. com/wiki/main/ (Open Source Edition Site) n http: //virtuoso. openlinksw. com/Whitepapers/index. htm (Open. Link Data Spaces) © 2007 Open. Link Software, All rights reserved

Thank You! © 2007 Open. Link Software, All rights reserved