W3C home > Mailing lists > Public > public-xg-rdb2rdf@w3.org > January 2009

Re: Revised version of Proposed XG Recommendation

From: Kingsley Idehen <kidehen@openlinksw.com>
Date: Sun, 04 Jan 2009 19:36:44 -0500
Message-ID: <4961561C.7090104@openlinksw.com>
To: ashok.malhotra@oracle.com
CC: public-xg-rdb2rdf <public-xg-rdb2rdf@w3.org>

On 1/4/09 5:16 PM, ashok malhotra wrote:
> Kingsley:
> I don't see how these examples help make the case that the W3C should 
> start an effort to
> standardize a language for mapping from Relational data to RDF and OWL.
The examples below are about the issues relating to: What does Rdb2RDf 
deliver above and beyond SQL. Another way of articulating the value 
prop. to a SQL audience (e.g. Decision Makers looking at world from the 
SQL vantage point). This is about the collection of material required 
for answering the question posed by William Hayes at the last Semantic 
Web Gathering etc.
> The usecases make the point that such a standard will facilitate data 
> integration and publishing Relational
> data on the web.  I'm happy to add another usecase as long as it 
> illustrates how the solution of an an important problem will be 
> facilitated by this technology.
With regards to the above, I don't know how familiar SQL Schemas for 
each of the major DBMS engines, passed through the process of Rdb2Rdf 
using the examples below isn't a use case.

Here is my definition of a usecase re. the examples:
Demonstrating the data exploration, integration, and discovery prowess 
of RDF based Linked Data via DBMS realm specific demo / tutorial SQL 
> The survey document has pointers to several special-purpose 
> technologies that have been used to map Relational data to RDF and 
> OWL.  It includes a pointer to your webpage where I presume these 
> examples can be found.
As per above, my fundamental point is this: if we are trying to 
demonstrate the value / utility (via use-cases) of Rdb2Rdf to an RDBMS 
based audience, lets do so using SQL Schemas that are known across the 

I think simple examples provide simple mechanisms for exposing value. 
Try to put aside the fact that these demos exist using Virtuoso's Meta 
Schema Language, and orient thinking more towards how we articulate the 
value in the simplest possible way using the simplest anecdotal material :-)

> All the best, Ashok
> Kingsley Idehen wrote:
>> On 1/2/09 12:16 PM, ashok malhotra wrote:
>>> I did some work on this over the holidays which included adding the 
>>> two usecases.
>>> I'll be happy to add more usecases if folks want to write them.
>>> Please take a careful look.  We are getting close to the deadline so 
>>> you close scrutiny is important.
>> Ashok,
>> I think we should add a case study that is based on a well known 
>> RDBMS schema.
>> At the current time we have complete Rdf2Rdb examples for the sample 
>> databases associated with the following DBMS engines:
>> 1. 
>> http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtRDFViewsOracleHrDb 
>> - Oracle (HR DD)
>> 2. 
>> http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtRDFViewsDB2SampleDb 
>> - DB2 (Sample DB)
>> 3. 
>> http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtRDFViewNorthwind 
>> - SQL Server (Northwind DB)
>> 4. 
>> http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtRDFViewsInformixStoresDemo 
>> - Informix (Stores DB)
>> 5. 
>> http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtRDFViewsIngresTutDb 
>> - Ingres (Tutorial DB)
>> 6. 
>> http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtRDFViewsProgressSQ92ISports 
>> - Progress
>> 7. 
>> http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtRDFViewsSybasePubs2Db 
>> - Sybase (Pubs2)
>> As you know, the DBMS communities consistently use the default 
>> demonstration databases as ground-zero for all tutorial material. 
>> Thus, as part of a broader effort to engage the RDBMS community in 
>> general, we should include mappings examples based on each of the 
>> above. Ideally, their should be Triplify and D2RQ variants of what 
>> we've done to balance out this effort.
>> When a person from any of the DBMS realms above poses the question: 
>> What does Rdb2Rdf facilitate above and beyond what SQL currently 
>> offers, there should be a set of pages in place that demonstrate the 
>> fundamental point: record-level data access by reference using HTTP 
>> based Identifiers. An example of such pages:
>> 1. 
>> http://demo.openlinksw.com/about/html/http://demo.openlinksw.com/Northwind/Customer/ALFKI%23this 
>> - Page about "ALFKI" an Entity in the Northwind Database
>> 2. 
>> http://data.openlinksw.com/about/html/http://data.openlinksw.com/oplweb/product_release/virtuoso-uim-unisvr-ent/5.0/x86_64-sun-solaris2.10-64/virt50%23this 
>> - Page about a specific release of Virtuoso for the Solaris x86_64 
>> platform .
>> Happy New Year!



Kingsley Idehen	      Weblog: http://www.openlinksw.com/blog/~kidehen
President&  CEO
OpenLink Software     Web: http://www.openlinksw.com
Received on Monday, 5 January 2009 00:37:19 UTC

This archive was generated by hypermail 2.3.1 : Tuesday, 6 January 2015 19:51:39 UTC