Using SIOC
to Model the
Linked Data Web

• To validate a particular SIOC, RDF Data Set (in plain old RDF form), you can use the W3C RDF Validation Service
• You can actually create you own Data Spaces and then experiment with these queries by opening accounts at: http://demo.openlinksw.com/ods (for very temporary and volatile usage) or http://myopenlink.net:8890/ods (for less volatile usage)
• You can run most (if not all) of the queries with minimal modification using the following SPARQL Query Services: http://demo.openlinksw.com/sparql/ (using the 'demo' user account) and http://myopenlink.net:8890/sparql/ (assuming you have an account with this service)
• Default Graph URI value used in the queries of this presentation is: http://demo.openlinksw.com/dataspace

Weblog Data Space

The following query scans an entire ODS data space (collection of many application specific data spaces) for properties associated with Entities of Type: Weblog

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
SELECT DISTINCT ?attribute
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?blog  a                  sioct:Weblog
    ?blog  sioc:container_of  ?post
    ?post  ?attribute         ?o
  }
ORDER BY ?attribute

Dump of all Weblog Posts for a given ODS Member

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
PREFIX  xsd:    <http://www.w3.org/2001/XMLSchema#>
PREFIX  dct:    <http://purl.org/dc/elements/1.1/>
PREFIX  dcc:    <http://purl.org/dc/terms/>
SELECT DISTINCT ?forum_name
                ?post
                ?title
                ?cr
                ?url
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum  a                  sioct:Weblog                                     .
    ?forum  sioc:id            ?forum_name                                      .
    ?forum  sioc:scope_of      ?role                                            .
    ?role   sioc:function_of   <http://demo.openlinksw.com/dataspace/demo#this> .
    ?forum  sioc:container_of  ?post                                            .
    OPTIONAL
      { ?post  dct:title    ?title }  .
    OPTIONAL
      { ?post  dcc:created  ?cr    }  .
    OPTIONAL
      { ?post  sioc:link    ?url   }  .
  }
ORDER BY DESC (?cr)

List of Web Services (e.g., Atom Publishing [SOAP], Moveable Type [XML-RPC]) associated with Weblog Data Space Instances

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  svc:    <http://rdfs.org/sioc/services#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
SELECT ?endp
       ?proto
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum  a                     sioct:Weblog  .
    ?forum  svc:has_service       ?svc          .
    ?svc    svc:service_endpoint  ?endp         .
    ?svc    svc:service_protocol  ?proto
  }
ORDER BY ?proto

Dump of all Weblog Posts for a given ODS Member, including the blog post contents

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  xsd:    <http://www.w3.org/2001/XMLSchema#>
PREFIX  dct:    <http://purl.org/dc/elements/1.1/>
PREFIX  dcc:    <http://purl.org/dc/terms/>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
SELECT ?forum_name
       ?post
       ?title
       ?cr
       ?content
       ?url
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum  a                  sioct:Weblog                                     .
    ?forum  sioc:id            ?forum_name                                      .
    ?forum  sioc:scope_of      ?role                                            .
    ?role   sioc:function_of   <http://demo.openlinksw.com/dataspace/demo#this> .
    ?forum  sioc:container_of  ?post                                            .
    OPTIONAL
      { ?post  dct:title      ?title    }  .
    OPTIONAL
      { ?post  dcc:created    ?cr       }  .
    OPTIONAL
      { ?post  sioc:link      ?url      }  .
    OPTIONAL
      { ?post  sioc:links_to  ?links_to }  .
    OPTIONAL
      { ?post  sioc:content   ?content  }
  }

Dump of all Weblog Posts for a given ODS Member, including the blog post contents and all out-bound links

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
PREFIX  xsd:    <http://www.w3.org/2001/XMLSchema#>
PREFIX  dct:    <http://purl.org/dc/elements/1.1/>
PREFIX  dcc:    <http://purl.org/dc/terms/>
SELECT ?forum_name
       ?post
       ?title
       ?cr
       ?content
       ?url
       ?links_to
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum  a                  sioct:Weblog                                      .
    ?forum  sioc:id            ?forum_name                                       .
    ?forum  sioc:scope_of      ?role                                             .
    ?role   sioc:function_of   <http://demo.openlinksw.com/dataspace/demo#this>  .
    ?forum  sioc:container_of  ?post                                             .
    OPTIONAL
      { ?post  dct:title      ?title    }  .
    OPTIONAL
      { ?post  dcc:created    ?cr       }  .
    OPTIONAL
      { ?post  sioc:link      ?url      }  .
    OPTIONAL
      { ?post  sioc:links_to  ?links_to }  .
    OPTIONAL
      { ?post  sioc:content   ?content  }
}

Wiki Data Space

The following query scans an entire ODS data space (collection of many application specific data spaces) for properties associated with Entities of Type: Wiki

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
SELECT DISTINCT ?attribute
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum  rdf:type           sioct:Wiki  .
    ?forum  sioc:container_of  ?post       .
    ?post   ?attribute         ?o
  }
ORDER BY ?attribute

Dump of all Wikiwords for a given Wiki

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
PREFIX  xsd:    <http://www.w3.org/2001/XMLSchema#>
PREFIX  dct:    <http://purl.org/dc/elements/1.1/>
PREFIX  dcc:    <http://purl.org/dc/terms/>
SELECT DISTINCT ?forum_name
                ?post
                ?title
                ?link
                ?links_to
                ?cr
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum  rdf:type           sioct:Wiki   .
    ?forum  sioc:id            ?forum_name  .
    ?forum  sioc:container_of  ?post        .
    ?post   dct:title          ?title       .
    OPTIONAL
      { ?post  dcc:created    ?cr       }  .
    OPTIONAL
      { ?post  sioc:link      ?link     }  .
    OPTIONAL
      { ?post  sioc:links_to  ?links_to }  .
  }
ORDER BY ?title

Dump of all WikiWords for a given Wiki including content plus out-bound links

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
PREFIX  xsd:    <http://www.w3.org/2001/XMLSchema#>
PREFIX  dct:    <http://purl.org/dc/elements/1.1/>
PREFIX  dcc:    <http://purl.org/dc/terms/>
SELECT ?forum_name
       ?post
       ?title
       ?link
       ?links_to
       ?cr
       ?content
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum  rdf:type           sioct:Wiki   .
    ?forum  sioc:id            ?forum_name  .
    ?forum  sioc:container_of  ?post        .
    ?post   dct:title          ?title       .
    OPTIONAL
      { ?post  dcc:created    ?cr        }  .
    OPTIONAL
      { ?post  sioc:link      ?link      }  .
    OPTIONAL
      { ?post  sioc:links_to  ?links_to  }  .
    OPTIONAL
      { ?post  sioc:content   ?content   }  .
  }

List of Web Services (e.g., Atom Publishing [SOAP], Moveable Type [XML-RPC]) associated with Wiki Data Space Instances

PREFIX  svc:    <http://rdfs.org/sioc/services#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
SELECT ?endp
       ?proto
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum  a                     sioct:Wiki  .
    ?forum  svc:has_service       ?svc        .
    ?svc    svc:service_endpoint  ?endp       .
    ?svc    svc:service_protocol  ?proto      .
  }
ORDER BY ?proto

Calendar Data Space

The following query scans an entire ODS data space (collection of many application specific data spaces) for properties associated with Entities of Type: Calendar

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
SELECT DISTINCT ?attribute
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
     ?forum  rdf:type           sioct:Calendar  .
     ?forum  sioc:container_of  ?post           .
     ?post   ?attribute         ?o
  }
ORDER BY ?attribute

Dump of all Events for a given Calendar

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
PREFIX  dct:    <http://purl.org/dc/elements/1.1/>
PREFIX  dcc:    <http://purl.org/dc/terms/>
PREFIX  calr:   <http://www.w3.org/2002/12/cal#>
SELECT DISTINCT ?forum_name
                ?post
                ?title
                ?link
                ?cr
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum  rdf:type           sioct:Calendar  .
    ?forum  sioc:id            ?forum_name     .
    ?forum  sioc:container_of  ?post           .
    ?post   rdf:type           calr:vevent     .
    ?post   dct:title          ?title          .
    OPTIONAL
      { ?post  dcc:created  ?cr    }  .
    OPTIONAL
      { ?post  sioc:link    ?link  }  .
  }

Dump of all Events for a given Calendar including content

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
PREFIX  dct:    <http://purl.org/dc/elements/1.1/>
PREFIX  dcc:    <http://purl.org/dc/terms/>
PREFIX  calr:   <http://www.w3.org/2002/12/cal#>
SELECT ?forum_name
       ?post
       ?title
       ?link
       ?links_to
       ?cr
       ?content
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum  rdf:type           sioct:Calendar  .
    ?forum  sioc:id            ?forum_name     .
    ?forum  sioc:container_of  ?post           .
    ?post   rdf:type           calr:vevent     .
    OPTIONAL
      { ?post  dct:title      ?title     }  .
    OPTIONAL
      { ?post  dcc:created    ?cr        }  .
    OPTIONAL
      { ?post  sioc:link      ?link      }  .
    OPTIONAL
      { ?post  sioc:links_to  ?links_to  }  .
    OPTIONAL
      { ?post  sioc:content   ?content   }  .
  }

Dump of Events with details for a given Calendar

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
PREFIX  dct:    <http://purl.org/dc/elements/1.1/>
PREFIX  dcc:    <http://purl.org/dc/terms/>
PREFIX  calr:   <http://www.w3.org/2002/12/cal#>
SELECT DISTINCT ?forum_name
                ?post
                ?url
                ?summary
                ?descr
                ?location
FROM <http://demo.openlinksw.com/dataspace>
WHERE
    {
       ?forum  rdf:type           sioct:Calendar  .
       ?forum  sioc:id            ?forum_name     .
       ?forum  sioc:container_of  ?post           .
       ?post   rdf:type           calr:vevent     .
       OPTIONAL
         { ?post  dct:title         ?title     }  .
       OPTIONAL
         { ?post  calr:url          ?url       }  .
       OPTIONAL
         { ?post  calr:summary      ?summary   }  .
       OPTIONAL
         { ?post  calr:description  ?descr     }  .
       OPTIONAL
         { ?post  calr:dtstart      ?start     }  .
       OPTIONAL
         { ?post  calr:location     ?location  }  .
    }

Feeds / Subscriptions Data Space
(Feed Aggregation)

The following query scans an entire ODS data space (collection of many application specific data spaces) for properties associated with Entities of Type: SubscriptionList

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
SELECT DISTINCT ?attribute
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum    rdf:type           sioct:SubscriptionList  .
    ?forum    sioc:parent_of     ?parentf                .
    ?parentf  sioc:container_of  ?post                   .
    ?post     ?attribute         ?o
  }
ORDER BY ?attribute

Obtaining a dump of all Posts within an ODS-Feeds Data Space

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
PREFIX  dct:    <http://purl.org/dc/elements/1.1/>
PREFIX  dcc:    <http://purl.org/dc/terms/>
SELECT  ?forum_name
        ?channel
        ?item_title
        ?created
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum    a                  sioct:SubscriptionList                            ;
              sioc:id            ?forum_name                                       .
    ?forum    sioc:scope_of      ?role                                             .
    ?role     sioc:function_of   <http://demo.openlinksw.com/dataspace/demo#this>  .
    ?forum    sioc:parent_of     ?channel                                          .
    ?channel  sioc:container_of  ?post                                             .
    OPTIONAL
      { ?post  dct:title    ?item_title  }  .
    OPTIONAL
      { ?post  dcc:created  ?created     }  .
  }

Obtaining a dump of all Posts within an ODS-Feeds Data Space that includes feed content

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
PREFIX  dct:    <http://purl.org/dc/elements/1.1/>
PREFIX  dcc:    <http://purl.org/dc/terms/>
SELECT ?forum_name
       ?channel
       ?item_title
       ?url
       ?created
       ?content
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum    a                  sioct:SubscriptionList                            ;
              sioc:id            ?forum_name                                       .
    ?forum    sioc:scope_of      ?role                                             .
    ?role     sioc:function_of   <http://demo.openlinksw.com/dataspace/demo#this>  .
    ?forum    sioc:parent_of     ?channel                                          .
    ?channel  sioc:container_of  ?post                                             .
    OPTIONAL
      { ?post  dct:title      ?item_title  }  .
    OPTIONAL
      { ?post  sioc:links_to  ?url         }  .
    OPTIONAL
      { ?post  dcc:created    ?created     }  .
    OPTIONAL
      { ?post  sioc:content   ?content     }  .
  }

Bookmarks Data Space

The following query scans an entire ODS data space (collection of many application specific data spaces) for properties associated with Entities of Type: BookmarkFolder

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
SELECT DISTINCT ?attribute
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum  a                  sioct:BookmarkFolder  .
    ?forum  sioc:container_of  ?post                 .
    ?post   ?attribute         ?o
  }
ORDER BY ?attribute

Dump of all Bookmark Data Space entries for a given ODS Bookmarks Data Space

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
PREFIX  dct:    <http://purl.org/dc/elements/1.1/>
SELECT DISTINCT ?forum_name
                ?post
                ?title
                ?link
                ?url
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum  a                  sioct:BookmarkFolder                              .
    ?forum  sioc:id            ?forum_name                                       .
    ?forum  sioc:scope_of      ?role                                             .
    ?role   sioc:function_of   <http://demo.openlinksw.com/dataspace/demo#this>  .
    ?forum  sioc:container_of  ?post                                             .
    OPTIONAL
      { ?post  dct:title      ?title  }  .
    OPTIONAL
      { ?post  sioc:link      ?link   }  .
    OPTIONAL
      { ?post  sioc:links_to  ?url    }
  }
ORDER BY ?title

List of Web Services (e.g.,Atom Publishing (SOAP), Moveable Type (XML-RPC) etc.) associated with Bookmarks Data Space Instances

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  svc:    <http://rdfs.org/sioc/services#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
SELECT ?endp
       ?proto
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum  a                     sioct:BookmarkFolder  .
    ?forum  svc:has_service       ?svc                  .
    ?svc    svc:service_endpoint  ?endp                 .
    ?svc    svc:service_protocol  ?proto
  }
ORDER BY ?proto

AddressBook Data Space

The following query scans an entire ODS data space (collection of many application specific data spaces) for properties associated with Entities of Type: AddressBook

PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
SELECT DISTINCT ?attribute
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum  a                  sioct:AddressBook  .
    ?forum  sioc:container_of  ?post              .
    ?post   ?attribute         ?o
  }
ORDER BY ?attribute

Dump all AddressBook's members

PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
PREFIX  foaf:   <http://xmlns.com/foaf/0.1/>
SELECT ?member
       ?id
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?s       a                 sioct:AddressBook  ;
             sioc:scope_of     ?role              .
    ?role    sioc:function_of  ?member            .
    ?member  sioc:id           ?id
  }

Dump all AddressBook's members friends

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
PREFIX  foaf:   <http://xmlns.com/foaf/0.1/>
SELECT ?member
       ?knows
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?s       a                 sioct:AddressBook  ;
             sioc:scope_of     ?role              .
    ?role    sioc:function_of  ?member            .
    ?member  foaf:knows        ?knows
  }

Dump all AddressBook's contacts

PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
PREFIX  vcd:    <http://www.w3.org/2001/vcard-rdf/3.0#>
PREFIX  dct:    <http://purl.org/dc/elements/1.1/>
PREFIX  dcc:    <http://purl.org/dc/terms/>
SELECT ?FN
       ?nick
       ?address
       ?title
       ?created
       ?link
       ?topic
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum  a                  sioct:AddressBook  .
    ?forum  sioc:container_of  ?post              .
    OPTIONAL
      { ?post  vcd:FN        ?FN       }  .
    OPTIONAL
      { ?post  vcd:NICKNAME  ?nick     }  .
    OPTIONAL
      { ?post  vcd:ADR       ?address  }  .
    OPTIONAL
      { ?post  dct:title     ?title    }  .
    OPTIONAL
      { ?post  dcc:created   ?created  }  .
    OPTIONAL
      { ?post  sioc:link     ?link     }  .
    OPTIONAL
      { ?post  sioc:topic    ?topic    }
  }

List of Web Services (e.g.,Atom Publishing (SOAP), Moveable Type (XML-RPC) etc.) associated with AddressBook Data Space Instances

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  svc:    <http://rdfs.org/sioc/services#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
SELECT ?endp
       ?proto
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum  a                     sioct:AddressBook  .
    ?forum  svc:has_service       ?svc               .
    ?svc    svc:service_endpoint  ?endp              .
    ?svc    svc:service_protocol  ?proto
  }
ORDER BY ?proto

Dump all properties supported for members imported from Briefcase FOAF uploaded

PREFIX  sioct:  <http://rdfs.org/sioc/types#>
PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
SELECT DISTINCT ?attribute
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?s       a                 sioct:AddressBook  ;
             sioc:scope_of     ?role              .
    ?role    sioc:function_of  ?member            .
    ?member  ?attribute        ?o
  }

Polls Data Space

The following query scans an entire ODS data space (collection of many application specific data spaces) for properties associated with Entities of Type: ServeyCollection

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
SELECT DISTINCT ?attribute
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum  a                  sioct:SurveyCollection  .
    ?forum  sioc:container_of  ?post                   .
    ?post   ?attribute         ?o
  }
ORDER BY ?attribute

Dump of all Polls Posts for a given ODS Member

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
PREFIX  xsd:    <http://www.w3.org/2001/XMLSchema#>
PREFIX  dct:    <http://purl.org/dc/elements/1.1/>
PREFIX  dcc:    <http://purl.org/dc/terms/>
SELECT DISTINCT ?forum_name
                ?post
                ?title
                ?cr
                ?url
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum  a                  sioct:SurveyCollection                            .
    ?forum  sioc:id            ?forum_name                                       .
    ?forum  sioc:scope_of      ?role                                             .
    ?role   sioc:function_of   <http://demo.openlinksw.com/dataspace/demo#this>  .
    ?forum  sioc:container_of  ?post                                             .
    OPTIONAL
      { ?post  dct:title    ?title  }  .
    OPTIONAL
      { ?post  dcc:created  ?cr     }  .
    OPTIONAL
      { ?post  sioc:link    ?url    }  .
  }
ORDER BY DESC (?cr)

Photo Gallery Data Space

The following query scans an entire ODS data space (collection of many application specific data spaces) for properties associated with Entities of Type: ImageGallery

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
SELECT DISTINCT ?attribute
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum  rdf:type           sioct:ImageGallery  .
    ?forum  sioc:container_of  ?post               .
    ?post    ?attribute        ?o
  }
ORDER BY ?attribute

Dump of all Data Space entries for a given ODS Photo Gallery including content and out-bound links

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
PREFIX  xsd:    <http://www.w3.org/2001/XMLSchema#>
PREFIX  dct:    <http://purl.org/dc/elements/1.1/>
PREFIX  dcc:    <http://purl.org/dc/terms/>
SELECT ?forum_name
       ?post
       ?title
       ?link
       ?links_to
       ?cr
       ?content
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum  rdf:type           sioct:ImageGallery  .
    ?forum  sioc:id            ?forum_name         .
    ?forum  sioc:container_of  ?post               .
    OPTIONAL
      { ?post  dct:title      ?title     }  .
    OPTIONAL
      { ?post  dcc:created    ?cr        }  .
    OPTIONAL
      { ?post  sioc:link      ?link      }  .
    OPTIONAL
      { ?post  sioc:links_to  ?links_to  }  .
    OPTIONAL
      { ?post  sioc:content   ?content   }
  }

List of Web Services (e.g., Atom Publishing (SOAP), Moveable Type (XML-RPC), etc.) associated with Gallery Data Space Instances

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  svc:    <http://rdfs.org/sioc/services#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
SELECT ?endp
       ?proto
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum  a                     sioct:ImageGallery  .
    ?forum  svc:has_service       ?svc                .
    ?svc    svc:service_endpoint  ?endp               .
    ?svc    svc:service_protocol  ?proto              .
  }
ORDER BY ?proto

Community (Group Mode) Data Space

The following query scans an entire ODS data space (collection of many application specific data spaces) for properties associated with Entities of Type: Community

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
SELECT DISTINCT ?attribute
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum    rdf:type           sioc:Community  .
    ?forum    sioc:has_part      ?parentf        .
    ?parentf  sioc:container_of  ?post           .
    ?post     ?attribute         ?o
  }
ORDER BY ?attribute

Dump of all Data Space entries for a given ODS Community

PREFIX  rdf:   <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  sioc:  <http://rdfs.org/sioc/ns#>
PREFIX  dct:   <http://purl.org/dc/elements/1.1/>
SELECT ?post
       ?title
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum    rdf:type           sioc:Community  .
    ?forum    sioc:has_part      ?parentf        .
    ?parentf  sioc:container_of  ?post           .
    OPTIONAL
      { ?post  dct:title  ?title }  .
  }

Briefcase Data Space

The following query scans an entire ODS data space (collection of many application specific data spaces) for properties associated with Entities of Type: Briefcase

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
SELECT DISTINCT ?attribute
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum  rdf:type           sioct:Briefcase  .
    ?forum  sioc:container_of  ?post            .
    ?post   ?attribute         ?o
  }
ORDER BY ?attribute

List of Web Services (e.g.,Atom Publishing (SOAP), Moveable Type (XML-RPC) etc.) associated with Briefcase Data Space Instances

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  svc:    <http://rdfs.org/sioc/services#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
SELECT ?endp , ?proto
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum  a                     sioct:Briefcase  .
    ?forum  svc:has_service       ?svc             .
    ?svc    svc:service_endpoint  ?endp            .
    ?svc    svc:service_protocol  ?proto
  }
ORDER BY ?proto

Dump of all Briefcase Items from special "Public" folder

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
PREFIX  xsd:    <http://www.w3.org/2001/XMLSchema#>
PREFIX  dct:    <http://purl.org/dc/elements/1.1/>
PREFIX  dcc:    <http://purl.org/dc/terms/>
SELECT DISTINCT ?forum_name
                ?post
                ?title
                ?cr
                ?url
                ?links_to
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum  a                  sioct:Briefcase  .
    ?forum  sioc:id            ?forum_name      .
    ?forum  sioc:container_of  ?post            .
    OPTIONAL
      { ?post  dct:title      ?title     }  .
    OPTIONAL
      { ?post  dcc:created    ?cr        }  .
    OPTIONAL
      { ?post  sioc:link      ?url       }  .
    OPTIONAL
      { ?post  sioc:links_to  ?links_to  }  .
  }
ORDER BY DESC (?cr)

Discussion / Conversation Data Space

The following query scans an entire ODS data space (collection of many application specific data spaces) for properties associated with Entities of Type: MessageBoard

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
SELECT DISTINCT ?attribute
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum  rdf:type           sioct:MessageBoard  .
    ?forum  sioc:container_of  ?post               .
    ?post   ?attribute         ?o
  }
ORDER BY ?attribute

Discussion list

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
PREFIX  dct:    <http://purl.org/dc/elements/1.1/>
PREFIX  dcc:    <http://purl.org/dc/terms/>
SELECT DISTINCT ?forum_name
                ?post
                ?title
                ?mod_time
                ?create_time
                ?url
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum  a        sioct:MessageBoard  ;
            sioc:id  ?forum_name         .
    OPTIONAL
      { ?forum  sioc:container_of  ?post         }  .
    OPTIONAL
      { ?post   dct:title          ?title        }  .
    OPTIONAL
      { ?post   dcc:modified       ?mod_time     }  .
    OPTIONAL
      { ?post   dcc:created        ?create_time  }  .
    OPTIONAL
      { ?post   sioc:link          ?url          }  .
  }
LIMIT 10

Obtaining a dump of all Posts within a specific ODS-Discussion Data Space that includes discussion content

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
PREFIX  dct:    <http://purl.org/dc/elements/1.1/>
PREFIX  dcc:    <http://purl.org/dc/terms/>
SELECT ?forum_name
       ?post
       ?title
       ?mod_time
       ?create_time
       ?url
       ?content
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum  a        sioct:MessageBoard  ;
            sioc:id  ?forum_name
            FILTER REGEX
              ( ?forum_name , ".*demo*." ) .
    OPTIONAL
      { ?forum  sioc:container_of  ?post         }  .
    OPTIONAL
      { ?post   dct:title          ?title        }  .
    OPTIONAL
      { ?post   dcc:modified       ?mod_time     }  .
    OPTIONAL
      { ?post   dcc:created        ?create_time  }  .
    OPTIONAL
      { ?post   sioc:link          ?url          }  .
    OPTIONAL
      { ?post   sioc:content       ?content      }  .
  }

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
PREFIX  dct:    <http://purl.org/dc/elements/1.1/>
PREFIX  dcc:    <http://purl.org/dc/terms/>
SELECT DISTINCT ?forum_name
                ?post
                ?title
                ?mod_time
                ?create_time
                ?url
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum  rdf:type  sioct:MessageBoard  .
    OPTIONAL
      { ?forum  sioc:id            ?forum_name .
                  FILTER REGEX ( ?forum_name, ".*demo*." )
      } .
    OPTIONAL
      { ?forum  sioc:container_of  ?post         }  .
    OPTIONAL
      { ?post   dct:title          ?title        }  .
    OPTIONAL
      { ?post   dcc:modified       ?mod_time     }  .
    OPTIONAL
      { ?post   dcc:created        ?create_time  }  .
    OPTIONAL
      { ?post   sioc:link          ?url          }  .
  }
LIMIT 10

Dump of Wiki Posts with "Conversation" Feature Enabled

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
PREFIX  dct:    <http://purl.org/dc/elements/1.1/>
PREFIX  dcc:    <http://purl.org/dc/terms/>
SELECT DISTINCT ?forum_name
                ?post
                ?title
                ?mod_time
                ?create_time
                ?url
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum  rdf:type  sioct:MessageBoard  ;
            sioc:id   ?forum_name               FILTER REGEX ( ?forum_name, ".*mywiki*." ) .
    OPTIONAL
      { ?forum  sioc:container_of  ?post         }  .
    OPTIONAL
      { ?post  dct:title           ?title        }  .
    OPTIONAL
      { ?post  dcc:modified        ?mod_time     }  .
    OPTIONAL
      { ?post  dcc:created         ?create_time  }  .
    OPTIONAL
      { ?post  sioc:link           ?url          }
  }

These SPARQL queries join data across serveral ODS data spaces.

Data for analyzing Tags associated with Posts; also demonstrates use of the SKOS ontology for describing Post topics (also known as tags)

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  skos:   <http://www.w3.org/2004/02/skos/core#>
PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
PREFIX  dc:     <http://purl.org/dc/elements/1.1/>
SELECT ?title
       ?tag
       ?topic
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?s      a               sioc:Item  .
    OPTIONAL
      { ?s      dc:title        ?title  }  .
    ?s      sioc:id         ?id        .
    OPTIONAL
      {
        ?s      sioc:topic      ?topic        .
        ?topic  rdf:type        skos:Concept  .
        ?topic  skos:prefLabel  ?tag
      }
  }

People Network Construction that integrates data from both the FOAF and SKOS ontologies

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
PREFIX  xsd:    <http://www.w3.org/2001/XMLSchema#>
PREFIX  dct:    <http://purl.org/dc/elements/1.1/>
PREFIX  dcc:    <http://purl.org/dc/terms/>
PREFIX  skos:   <http://www.w3.org/2004/02/skos/core#>
PREFIX  foaf:   <http://xmlns.com/foaf/0.1/>
SELECT DISTINCT ?forum_name
                ?post
                ?title
                ?cr
                ?url
                ?links_to
                ?tag
                ?nick
                ?gender
                ?org
                ?geodata
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum  a                  sioct:Weblog  .
    ?forum  sioc:id            ?forum_name   .
    OPTIONAL
      { ?forum  sioc:scope_of      ?role  }  .
    OPTIONAL
      { ?role   sioc:function_of   "<http://demo.openlinksw.com/dataspace/demo#this>"  }  .
    ?forum  sioc:container_of  ?post         .
    OPTIONAL
      { ?post   dct:title          ?title     .
        ?post   dcc:created        ?cr        .
        ?post   sioc:link          ?url       .
        ?post   sioc:links_to      ?links_to  .
        ?post   foaf:maker         ?maker       } .
    OPTIONAL
      { ?maker  foaf:nick          ?nick    }  .
    OPTIONAL
      { ?maker  foaf:name          ?fname   }  .
    OPTIONAL
      { ?maker  foaf:gender        ?gender  }  .
    OPTIONAL
      { ?maker  foaf:based_near    ?geodata }  .
    OPTIONAL
      { ?maker  foaf:organization  ?org     }  .
    OPTIONAL
      { ?post   sioc:topic         ?topic        .
        ?topic  rdf:type           skos:Concept  .
        ?topic  skos:prefLabel     ?tag       }
  }

People Network Construction using data from Post Comments

PREFIX  sioc:     <http://rdfs.org/sioc/ns#>
PREFIX  sioct:    <http://rdfs.org/sioc/types#>
PREFIX  foaf:     <http://xmlns.com/foaf/0.1/>
PREFIX  xsd:      <http://www.w3.org/2001/XMLSchema#>
PREFIX  rdfs:     <http://www.w3.org/2000/01/rdf-schema#>
PREFIX  rdf:      <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  dc:       <http://purl.org/dc/elements/1.1/>
PREFIX  dcterms:  <http://purl.org/dc/terms/>
SELECT DISTINCT ?post
                ?post_sioc
                ?post_author
                ?post_title
                ?post_date
                ?reply
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?post  sioc:has_creator  ?_x           .
    ?_x    sioc:id           ?post_author  .
    OPTIONAL
      { ?post  rdfs:seeAlso     ?post_sioc   }  .
    OPTIONAL
      { ?post  sioc:has_reply   ?reply       }  .
    OPTIONAL
      { ?post  dcterms:created  ?post_date   }  .
    OPTIONAL
      { ?post  dc:title         ?post_title  }
  }

CONSTRUCT based SPARQL queries are very useful when trying to expose RDF (via a SPARQL Endpoint) to RDF Data Set consumers that do not support SPARQL. In a sense, the SPARQL CONSTRUCT statements as part of a SPARQL Protocol payload deliver a Data Web (Web 3.0) Experience to Interactive-Web Clients (Web 1.0).

People Network returned as an RDF Graph

PREFIX  sioc:     <http://rdfs.org/sioc/ns#>
PREFIX  sioct:    <http://rdfs.org/sioc/types#>
PREFIX  foaf:     <http://xmlns.com/foaf/0.1/>
PREFIX  xsd:      <http://www.w3.org/2001/XMLSchema#>
PREFIX  rdfs:     <http://www.w3.org/2000/01/rdf-schema#>
PREFIX  rdf:      <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  dc:       <http://purl.org/dc/elements/1.1/>
PREFIX  dcterms:  <http://purl.org/dc/terms/>
CONSTRUCT
  {
    ?post  sioc:has_creator  ?_x           .
    ?_x    sioc:id           ?post_author  .
    ?post  rdfs:seeAlso      ?post_sioc    .
    ?post  sioc:has_reply    ?reply        .
    ?post  dcterms:created   ?post_date    .
    ?post  dc:title          ?post_title
  }
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?post  sioc:has_creator  ?_x           .
    ?_x    sioc:id           ?post_author  .
    OPTIONAL
      { ?post  rdfs:seeAlso     ?post_sioc   }  .
    OPTIONAL
      { ?post  sioc:has_reply   ?reply       }  .
    OPTIONAL
      { ?post  dcterms:created  ?post_date   }  .
    OPTIONAL
      { ?post  dc:title         ?post_title  }
  }
LIMIT 10

Discussions posts details returned as an RDF Graph

PREFIX  sioc:     <http://rdfs.org/sioc/ns#>
PREFIX  sioct:    <http://rdfs.org/sioc/types#>
PREFIX  rdf:      <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  dcterms:  <http://purl.org/dc/terms/>
CONSTRUCT
  {
    ?post  dcterms:created  ?created  .
    ?post  sioc:link        ?link     .
    ?post  sioc:title       ?title    .
  }
FROM <http://demo.openlinksw.com/dataspace>
WHERE
    {
       ?forum  a                   sioct:MessageBoard  .
       ?post   sioc:has_container  ?forum              .
       OPTIONAL
         { ?post  dcterms:created  ?created  }  .
       OPTIONAL
         { ?post  sioc:link        ?link  }  .
       OPTIONAL
         { ?post  sioc:title       ?title  }
    }
LIMIT 10

List of all registered Dataspace members's home pages URLs returned as an RDF Graph

PREFIX  foaf:   <http://xmlns.com/foaf/0.1/>
PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
CONSTRUCT
  {
    ?x  rdf:type  sioc:User
  }
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
     ?x  rdf:type  sioc:User
  }
LIMIT 10

Gallery images details for user "demo" returned as an RDF Graph

PREFIX  rdf:      <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  sioc:     <http://rdfs.org/sioc/ns#>
PREFIX  sioct:    <http://rdfs.org/sioc/types#>
PREFIX  skos:     <http://www.w3.org/2004/02/skos/core#>
PREFIX  xsd:      <http://www.w3.org/2001/XMLSchema#>
PREFIX  dc:       <http://purl.org/dc/elements/1.1/>
PREFIX  dcterms:  <http://purl.org/dc/terms/>
CONSTRUCT
  {
     ?post  dc:title         ?title     .
     ?post  sioc:link        ?link      .
     ?post  sioc:links_to    ?links_to  .
     ?post  sioc:topic       ?topic     .
     ?post  dcterms:created  ?cr
  }
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
     ?post    rdf:type            sioc:Item  .
     OPTIONAL
       { ?post   dc:title         ?title     }  .
     OPTIONAL
       { ?post   sioc:link        ?link      }  .
     OPTIONAL
       { ?post   sioc:links_to    ?links_to  }  .
     OPTIONAL
       { ?post   dcterms:created  ?cr        }  .
     OPTIONAL
       { ?post   sioc:topic       ?topic     }  .
     OPTIONAL
       { ?topic  skos:prefLabel   ?tag       }  .
     ?post    sioc:has_container  ?forum              .
     ?forum   a                   sioct:ImageGallery  .
     ?forum   sioc:scope_of       ?role               .
     ?role    sioc:function_of    ?member             .
     ?member  sioc:id             "demo"
  }

Community posts title and date details returned as an RDF Graph

PREFIX  rdf:      <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  sioc:     <http://rdfs.org/sioc/ns#>
PREFIX  sioct:    <http://rdfs.org/sioc/types#>
PREFIX  xsd:      <http://www.w3.org/2001/XMLSchema#>
PREFIX  dc:       <http://purl.org/dc/elements/1.1/>
PREFIX  dcterms:  <http://purl.org/dc/terms/>
CONSTRUCT
  {
    ?post  dc:title         ?title  .
    ?post  dcterms:created  ?date
  }
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum    rdf:type           sioc:Community  .
    ?forum    sioc:has_part      ?parentf        .
    ?parentf  sioc:container_of  ?post           .
    OPTIONAL
      { ?post  dc:title         ?title  }  .
    OPTIONAL
      { ?post  dcterms:created  ?date   }
  }

Describe all Weblog Data Spaces

PREFIX  rdf:    <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
DESCRIBE ?forum
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?forum  rdf:type  sioct:Weblog
  }

INSERT into Graph

DEFINE  input:default-graph-uri  <http://mygraph.com>
INSERT
  { <http://myopenlink.net/dataspace/Kingsley#this>
    <http://www.w3.org/1999/02/22-rdf-syntax-ns#type>
    <http://rdfs.org/sioc/ns#User>
  }

INSERT with expressions to calculate fields of new triples

INSERT
  INTO GRAPH <http://mygraph.com>
    {
      ?s  <http://rdfs.org/sioc/ns#id>  `iri (bif:concat (str (?o), "Idehen") )`
    }
WHERE
  { ?s  <http://rdfs.org/sioc/ns#id>    ?o };

'Modify graph' may be used as a sort of 'update' operation.

MODIFY
  GRAPH <http://mygraph.com>
  DELETE
    {
      ?s  <http://www.w3.org/1999/02/22-rdf-syntax-ns#type>  ?o
    }
  INSERT
    {
      ?s  <http://www.w3.org/1999/02/22-rdf-syntax-ns#type1> ?o
    }
  WHERE
    {
      ?s  <http://www.w3.org/1999/02/22-rdf-syntax-ns#type>  ?o
    };

DELETE   FROM GRAPH <http://mygraph.com>
    {
      <http://myopenlink.net/dataspace/Caroline#this>  
      <http://www.w3.org/1999/02/22-rdf-syntax-ns#type1>  
      <http://rdfs.org/sioc/ns#User>
    };

PREFIX  dct:    <http://purl.org/dc/elements/1.1/>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  rdfs:   <http://www.w3.org/2000/01/rdf-schema#>
SELECT *
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?f  a                  sioct:WishList  .
    ?f  sioc:container_of  ?s              .
    ?s  dct:description    ?descr          .
    ?s  dct:title          ?title          .
    ?s  sioc:has_creator   ?creator        .
    ?s  rdfs:label         ?label
  }

PREFIX  dct:    <http://purl.org/dc/elements/1.1/>
PREFIX  sioct:  <http://rdfs.org/sioc/types#>
PREFIX  sioc:   <http://rdfs.org/sioc/ns#>
PREFIX  rdfs:   <http://www.w3.org/2000/01/rdf-schema#>
SELECT *
FROM <http://demo.openlinksw.com/dataspace>
WHERE
  {
    ?f  a                  sioct:OfferList  .
    ?f  sioc:container_of  ?s               .
    ?s  dct:description    ?descr           .
    ?s  dct:title          ?title           .
    ?s  sioc:has_creator   ?creator         .
    ?s  rdfs:label         ?label           .
    ?s  sioc:link          ?link
  }

Social Connections a la LinkedIn

Show the people a person directly or indirectly knows. Sort by distance and count of connections of the known person:

SELECT ?o
       ?dist
       ((
          SELECT COUNT (*)
          WHERE { ?o  foaf:knows  ?xx }
       ))
WHERE
  {
    {
      SELECT ?s
             ?o
      WHERE
        {
          ?s  foaf:knows  ?o
        }
    }
    OPTION
      (
        TRANSITIVE                    ,
        T_DISTINCT                    ,
        T_IN ( ?s )                   ,
        T_OUT ( ?o )                  ,
        T_MIN ( 1 )                   ,
        T_MAX ( 4 )                   ,
        T_STEP ( 'step_no' ) as ?dist
      ) .
    FILTER
      (
        ?s = <http://myopenlink.net/dataspace/person/kidehen#this>
      )
  }
ORDER BY ?dist
DESC 3
LIMIT 50

Connection Between

Given two people, find what chain of acquaintances links them together. For each step in the chain, show the person linked to, the graph linking this person to the previous person, the number of the step, and the number of the path. Note that there may be many paths through which the people are linked.

SELECT ?link
       ?g
       ?step
       ?path
WHERE
  {
    {
      SELECT ?s
             ?o
             ?g
      WHERE
        {
          GRAPH ?g
            {
              ?s  foaf:knows  ?o
            }
        }
    }
    OPTION
      (
        TRANSITIVE                    ,
        T_DISTINCT                    ,
        T_IN ( ?s )                   ,
        T_OUT ( ?o )                  ,
        T_NO_CYCLES                   ,
        T_SHORTEST_ONLY               ,
        T_STEP ( ?s ) as ?link        ,
        T_STEP ( 'path_id' ) as ?path ,
        T_STEP ( 'step_no' ) as ?step ,
        T_DIRECTION 3 )  .
    FILTER
      (
        ?s = <http://myopenlink.net/dataspace/person/kidehen#this>
        &&
        ?o = <http://www.advogato.org/person/mparaz/foaf.rdf#me>
      )
  }
LIMIT 20

References

• Query ODS Data Spaces using SPARQL and Atom OWL Ontology
• Query ODS Data Spaces using SPARQL and SKOS Ontology
• Query ODS Data Spaces using SPARQL and FOAF Ontology
• Query ODS Data Spaces using SPARQL and Annotea Ontology
• ODS SPARQL Samples
• Northwind SPARQL Reference
• Query Virtuoso Tutorials using SPARQL
• Query Virtuoso Documentation using SPARQL
• WordPress SIOC Reference
• MedaWiki SIOC Reference
• PHPBB SIOC Reference
• Drupal SIOC Reference

• SPARQL - Query Language
• SPARQL - Protocol
• SPARQL - XML based Results Format

• Virtuoso SPARQL OAuth Tutorial
• SPARQL Tutorial - Clark+Prasia & University of Manchester Tutorial
• Jena SPARQL Tutorial

• Virtuoso SPARUL
• Virtuoso SPARQL