Use SQL Queries to RDF

RDF query language is a computer language that can be able to retrieve and manipulate data stored in resource Description Framework  format, it is a standard model for data interchange on the web. And SQL is also standard language for relational database. We can use SQL query in RDF in only using some methods like.

RDF query after converted in SQL.

 namespace '(a http://localhost/SqlDB#)
    attach '(\"W3C::Rdf::SqlDB\" (\"properties:/usr/local/perl/modules/Conf/chacl.prop\" \"name:a::W3Cacls\"))       
    ask '(a::W3Cacls
     (a::uris.uri ?uri0 http://www.w3.org/Member/Overview.html)
     (a::uris.acl ?uri0 ?t1)
     (a::acls.acl ?acl0 ?t1)
     (a::acls.access ?acl0 ?access)
     (a::ids.value ?id0 \"eric\")
     (a::ids.info ?id0 ?info)
     (a::idInclusions.id ?idInc0 ?id0)
     (a::acls.id ?acl0 ?t0)
     (a::idInclusions.groupId ?idInc0 ?t0)
    )

is translated to SQL like

SELECT
  b.acl as acl0_acl,b.id as acl0_id,b.access as acl0_access,
  a.id as uri0_id,
  c.id as id0_id,
  b.access as access,
  b.id as t0,
  d.id as idInc0_id,d.groupId as idInc0_groupId,
  a.acl as t1
 FROM uris AS a,acls AS b,ids AS c,idInclusions AS d
 WHERE (a.uri="http://www.w3.org/Member/Overview.html")
   AND (a.acl=b.acl)
   AND (c.value="eric")
   AND (c.id=d.id)
   AND (b.id=d.groupId);

In exporting an RDF view of a relational database (or business process), it is rare that one would choose to export the actual implementation details. It is more likely that the exporter would have an abstract model of the data that would represent the interface provided by the exporter. Agents outside of the exporter's administrative control would be invited to use this interface. The back end database would be mapped to the exported interface. For instance, W3C's access control system exports an RDF interface that exports RDF data and accepts Posted RDF data in a particular schema.

Once the data is translated from the exported interface is translated to the internal implementation-specific RDF schema, it must be translated to actually SQL queries.

Dear Pritan,

You gave an awesome solution. Thanks a lot for it. I am also thankful to techyv for their great management of solving the problems. I praise you all.