Drupal Linked Data Views Script to set up your own instance use drupal; drop view poll_v; drop view forum_v; drop view blog_v; drop view blog_post_v; drop view forum_post_v; drop view poll_post_v; drop view aggregator_item_v; SPARQL prefix v: <http://www.openlinksw.com/schemas/drupal_v#> drop quad map virtrdf:Drupal . drop iri class v:user_iri . drop iri class v:iri . drop iri class v:feed_item_iri . drop iri class v:space_iri . drop iri class v:feed_iri . drop iri class v:poll_iri . drop iri class v:forum_iri . drop iri class v:blog_iri . drop iri class v:blog_post_iri . drop iri class v:forum_post_iri . drop iri class v:poll_post_iri . drop iri class v:mbox . ; use drupal; create procedure ts2date (in x int) { return dateadd ('second', x, stringdate ('1970-1-1')); }; create view poll_v as select n.*, u.name from poll p, node n, users u where n.nid = p.nid and n.uid = u.uid; create view forum_v as select n.*, u.name from forum f, node n, users u where n.nid = f.nid and n.uid = u.uid; create view blog_v as select u.*, u.name||'\'s blog' as title_v from users u; create view blog_post_v as select nr.*, u.name, drupal..ts2date (n.created) as created, drupal..ts2date (n.changed) as changed from node n, node_revisions nr, users u where nr.nid = n.nid and nr.vid = n.vid and n.uid = u.uid and n.type in ('blog', 'story'); create view forum_post_v as select nr.*, u.name, drupal..ts2date (n.created) as created, drupal..ts2date (n.changed) as changed from node n, node_revisions nr, users u where nr.nid = n.nid and nr.vid = n.vid and n.uid = u.uid and n.type = 'forum'; create view poll_post_v as select nr.*, u.name, drupal..ts2date (n.created) as created, drupal..ts2date (n.changed) as changed from node n, node_revisions nr, users u where nr.nid = n.nid and nr.vid = n.vid and n.uid = u.uid and n.type = 'poll'; create view aggregator_item_v as select *, drupal..ts2date(timestmp) as created from aggregator_item; grant select on poll_v to "SPARQL"; grant select on forum_v to "SPARQL"; grant select on blog_v to "SPARQL"; grant select on blog_post_v to "SPARQL"; grant select on forum_post_v to "SPARQL"; grant select on poll_post_v to "SPARQL"; grant select on aggregator_item_v to "SPARQL"; grant execute on ts2date to "SPARQL"; grant select on drupal..users to "SPARQL"; grant select on drupal..aggregator_feed to "SPARQL"; grant select on drupal..aggregator_item to "SPARQL"; SPARQL prefix sioc: <http://rdfs.org/sioc/ns#> prefix sioct: <http://rdfs.org/sioc/types#> prefix atom: <http://atomowl.org/ontologies/atomrdf#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix foaf: <http://xmlns.com/foaf/0.1/> prefix dc: <http://purl.org/dc/elements/1.1/> prefix dct: <http://purl.org/dc/terms/> prefix skos: <http://www.w3.org/2004/02/skos/core#> prefix geo: <http://www.w3.org/2003/01/geo/wgs84_pos#> prefix wikiont: <http://sw.deri.org/2005/04/wikipedia/wikiont.owl#> prefix aowl: <http://atomowl.org/ontologies/atomrdf#> prefix v: <http://www.openlinksw.com/schemas/drupal_v#> create iri class v:user_iri "http://^{URIQADefaultHost}^/drupal/user/%U#this" (in user_name varchar not null) . create iri class v:iri "http://^{URIQADefaultHost}^/drupal/proxy/%s#this" (in uri varchar not null) . create iri class v:feed_item_iri "http://^{URIQADefaultHost}^/drupal/feed/item/%d#this" (in iid integer not null) . create iri class v:space_iri "http://^{URIQADefaultHost}^/drupal/space/%s#this" (in uri varchar not null) . create iri class v:feed_iri "http://^{URIQADefaultHost}^/drupal/feed/%d#this" (in fid integer not null) . create iri class v:poll_iri "http://^{URIQADefaultHost}^/drupal/poll/%d#this" (in nid integer not null) . create iri class v:forum_iri "http://^{URIQADefaultHost}^/drupal/forum/%d#this" (in nid integer not null) . create iri class v:blog_iri "http://^{URIQADefaultHost}^/drupal/blog/%d#this" (in uid integer not null) . create iri class v:blog_post_iri "http://^{URIQADefaultHost}^/drupal/blog/%d/%d#this" (in uid integer not null, in nid integer not null) . create iri class v:forum_post_iri "http://^{URIQADefaultHost}^/drupal/forum/%d/%d#this" (in uid integer not null, in nid integer not null) . create iri class v:poll_post_iri "http://^{URIQADefaultHost}^/drupal/poll/%d/%d#this" (in uid integer not null, in nid integer not null) . create iri class v:mbox "mailto:%s" (in mail varchar not null) . alter quad storage virtrdf:DefaultQuadStorage from drupal.drupal.users as users from drupal.drupal.aggregator_feed as feed from drupal.DBA.aggregator_item_v as feed_item where (^{feed_item.}^.fid = ^{feed.}^.fid) from drupal.drupal.node as node from drupal.drupal.node_revisions as node_revisions from drupal.DBA.poll_v as poll from drupal.DBA.forum_v as forum from drupal.DBA.blog_v as blog from drupal.DBA.blog_post_v as blog_post from drupal.DBA.forum_post_v as forum_post from drupal.DBA.poll_post_v as poll_post { create virtrdf:Drupal as graph iri ("http://^{URIQADefaultHost}^/drupal_v") option (exclusive) { v:user_iri (users.name) a sioc:User as virtrdf:Drupal-User-cls ; sioc:name users.name as virtrdf:Drupal-User-name ; sioc:email v:mbox(users.mail) as virtrdf:Drupal-User-mail ; sioc:id users.uid as virtrdf:Drupal-User-sioc_id . v:feed_iri (feed.fid) a aowl:Feed as virtrdf:Drupal-Feed-cls ; aowl:title feed.title as virtrdf:Drupal-Feed-title ; aowl:link v:iri (feed.link) as virtrdf:Drupal-Feed-link ; dc:description feed.description as virtrdf:Drupal-Feed-desc . v:feed_iri (feed.fid) aowl:entry v:feed_item_iri (feed_item.iid) as virtrdf:Drupal-Feed-aowl-entry . v:feed_item_iri (feed_item.iid) a aowl:Entry as virtrdf:Drupal-FeedItem-cls ; aowl:title feed_item.title as virtrdf:Drupal-FeedItem-title ; aowl:link feed_item.link as virtrdf:Drupal-FeedItem-link ; sioc:id feed_item.iid as virtrdf:Drupal-FeedItem-sioc-id ; sioc:content feed_item.description as virtrdf:Drupal-FeedItem-sioc-content ; aowl:content feed_item.description as virtrdf:Drupal-FeedItem-aowl-content ; dct:created feed_item.created as virtrdf:Drupal-FeedItem-cr ; aowl:source v:feed_iri (feed.fid) as virtrdf:Drupal-FeedItem-aowl-src . v:poll_iri (poll.nid) a sioct:SurveyCollection as virtrdf:Drupal-Poll-cls ; sioc:id poll.nid as virtrdf:Drupal-Poll-sioc-id ; dc:title poll.title as virtrdf:Drupal-Poll-title ; dct:created poll.created as virtrdf:Drupal-Poll-cr ; dct:modified poll.changed as virtrdf:Drupal-Poll-mod ; sioc:has_owner v:user_iri (poll.name) as virtrdf:Drupal-Poll-owner. v:user_iri (poll.name) sioc:owner_of v:poll_iri (poll.nid) as virtrdf:Drupal-Poll-owner_of . v:blog_iri (blog.uid) a sioct:Weblog as virtrdf:Drupal-Blog-cls ; sioc:id blog.uid as virtrdf:Drupal-Blog-sioc-id ; dc:title blog.title_v as virtrdf:Drupal-Blog-title ; sioc:has_owner v:user_iri (blog.name) as virtrdf:Drupal-Blog-owner . v:user_iri (blog.name) sioc:owner_of v:blog_iri (blog.uid) as virtrdf:Drupal-Blog-owner_of . v:forum_iri (forum.nid) a sioc:Forum as virtrdf:Drupal-Forum-cls ; sioc:id forum.nid as virtrdf:Drupal-Forum-sioc-id ; dc:title forum.title as virtrdf:Drupal-Forum-title ; dct:created forum.created as virtrdf:Drupal-Forum-cr ; dct:modified forum.changed as virtrdf:Drupal-Forum-mod ; sioc:has_owner v:user_iri (forum.name) as virtrdf:Drupal-Forum-owner. v:user_iri (forum.name) sioc:owner_of v:forum_iri (forum.nid) as virtrdf:Drupal-Forum-owner_of . v:blog_post_iri (blog_post.uid, blog_post.nid) a sioct:BlogPost as virtrdf:Drupal-BlogPost-cls ; sioc:id blog_post.nid as virtrdf:Drupal-BlogPost-sioc-id ; dc:title blog_post.title as virtrdf:Drupal-BlogPost-dc-title ; sioc:content blog_post.body as virtrdf:Drupal-BlogPost-sioc-content ; dct:created blog_post.created as virtrdf:Drupal-BlogPost-cr ; dct:modified blog_post.changed as virtrdf:Drupal-BlogPost-mod ; sioc:has_container v:blog_iri (blog_post.uid) as virtrdf:Drupal-BlogPost-sioc-has_container ; sioc:has_creator v:user_iri (blog_post.name) as virtrdf:Drupal-BlogPost-owner . v:blog_iri (blog_post.uid) sioc:container_of v:blog_post_iri (blog_post.uid, blog_post.nid) as virtrdf:Drupal-BlogPost-container_of . v:user_iri (blog_post.name) sioc:creator_of v:blog_post_iri (blog_post.uid, blog_post.nid) as virtrdf:Drupal-BlogPost-creator_of . v:forum_post_iri (forum_post.uid, forum_post.nid) a sioc:Post as virtrdf:Drupal-ForumPost-cls ; sioc:id forum_post.nid as virtrdf:Drupal-ForumPost-sioc-id ; dc:title forum_post.title as virtrdf:Drupal-ForumPost-dc-title ; sioc:content forum_post.body as virtrdf:Drupal-ForumPost-sioc-content ; dct:created forum_post.created as virtrdf:Drupal-ForumPost-cr ; dct:modified forum_post.changed as virtrdf:Drupal-ForumPost-mod ; sioc:has_container v:forum_iri (forum_post.uid) as virtrdf:Drupal-ForumPost-sioc-has_container ; sioc:has_creator v:user_iri (forum_post.name) as virtrdf:Drupal-ForumPost-owner . v:forum_iri (forum_post.uid) sioc:container_of v:forum_post_iri (forum_post.uid, forum_post.nid) as virtrdf:Drupal-ForumPost-container_of . v:user_iri (forum_post.name) sioc:creator_of v:forum_post_iri (forum_post.uid, forum_post.nid) as virtrdf:Drupal-ForumPost-creator_of . v:poll_post_iri (poll_post.uid, poll_post.nid) a sioc:Poll as virtrdf:Drupal-PollPost-cls ; sioc:id poll_post.nid as virtrdf:Drupal-PollPost-sioc-id ; dc:title poll_post.title as virtrdf:Drupal-PollPost-dc-title ; sioc:content poll_post.body as virtrdf:Drupal-PollPost-sioc-content ; dct:created poll_post.created as virtrdf:Drupal-PollPost-cr ; dct:modified poll_post.changed as virtrdf:Drupal-PollPost-mod ; sioc:has_container v:poll_iri (poll_post.uid) as virtrdf:Drupal-PollPost-sioc-has_container ; sioc:has_creator v:user_iri (poll_post.name) as virtrdf:Drupal-PollPost-owner . v:poll_iri (poll_post.uid) sioc:container_of v:poll_post_iri (poll_post.uid, poll_post.nid) as virtrdf:Drupal-PollPost-container_of . v:user_iri (poll_post.name) sioc:creator_of v:poll_post_iri (poll_post.uid, poll_post.nid) as virtrdf:Drupal-PollPost-creator_of . } } . ; DB.DBA.URLREWRITE_CREATE_REGEX_RULE ( 'drupal_rule2', 1, '/drupal/([^#]*)', vector('path'), 1, '/sparql?query=DESCRIBE+%%3Chttp%%3A//^{URIQADefaultHost}^/drupal/%U%%23this%%3E+FROM+%%3Chttp%%3A//^{URIQADefaultHost}^/drupal_v%%3E&format=%U', vector('path', 'path', '*accept*'), null, '(text/rdf.n3)|(application/rdf.xml)', 2, null ); DB.DBA.URLREWRITE_CREATE_REGEX_RULE ( 'drupal_rule3', 1, '/drupal/(user|post|site|proxy|wiki|forum|poll|blog|feed|space)/([^#]*)', vector('obj', 'path'), 1, '/ode/index.html?uri=http%%3A//^{URIQADefaultHost}^/drupal/%U/%U%%23this', vector('obj', 'path'), null, '(text/html)|(\\*/\\*)', 2, 303 ); DB.DBA.URLREWRITE_CREATE_RULELIST ( 'drupal_rule_list1', 1, vector ( 'drupal_rule3', 'drupal_rule2' )); DB.DBA.VHOST_REMOVE (lpath=>'/drupal'); DB.DBA.VHOST_DEFINE (lpath=>'/drupal', ppath=>'/vad/vsp/drupal/', is_dav=>0, vsp_user=>'dba', is_brws=>1, def_page=>'index.php', opts=>vector ('url_rewrite', 'drupal_rule_list1')); References Drupal SIOC Reference Drupal Installation Guide