<docbook><section><title>PHPBBSIOCRef</title><para> </para>
<bridgehead class="http://www.w3.org/1999/xhtml:h2">phpBB SIOC Reference</bridgehead>
<bridgehead class="http://www.w3.org/1999/xhtml:h3">What is it about?</bridgehead>
<para>Unobtrusive generation of RDF instance data from phpBB.
 You simply use phpBB as-is while reaping the benefit of &quot;RDF Views&quot; into your bulletin board data via the SIOC Ontology.
 In addition, you attain transparent integration between phpBB and NNTP such that phpBB data becomes accessible to NNTP aware applications.</para>
<bridgehead class="http://www.w3.org/1999/xhtml:h3">Why is it important?</bridgehead>
<para>Unified Storage of heterogenous data originating from a variety of applications and associated protocols that is exposed as RDF instance data.
 Thus, benefits include:</para>
<itemizedlist mark="bullet" spacing="compact"><listitem>SPARQL access to phpBB data via a SPARQL Endpoint </listitem>
<listitem>Dereferencable URIs (drill-down facilitating data pointers) for all data items (Entities) in the &quot;Discussion Forum&quot; / &quot;Bulletin Board&quot; domain (also referred to as Boardscape) </listitem>
<listitem>Coherent exploitation of conceptual similarities between phpBB and objects in the NNTP (Usenet / newsgroups) such as  two-way interaction with common date via NNTP news-reader utilities or web-based discussion forum clients bound to phpBB or NNTP.</listitem>
</itemizedlist><bridgehead class="http://www.w3.org/1999/xhtml:h3">How can one use this feature?</bridgehead>
 <itemizedlist mark="bullet" spacing="compact"><listitem>Obtain an Open Source of Commercial Edition of Virtuoso ( <emphasis>enable PHP Hosting Support during installation</emphasis>) </listitem>
<listitem>Run the virtuoso <emphasis>phpbb_hosting_dav|filesystem.vad package </emphasis></listitem>
<listitem>Go to http://<span style="color: red">
      UNKNOWN tag:
      http://www.w3.org/1999/xhtml:domain:[port]/phpBB </span></listitem>
<listitem>Use phpBB as per usual </listitem>
<listitem>Query SPARQL Data via the endpoint: http://<span style="color: red">
      UNKNOWN tag:
      http://www.w3.org/1999/xhtml:domain:[port]/phpBB using RDF Data Source URI (Named Graph): http://:[port]/phpbb_v (for Virtual Graphs) and http://:[port]/phpbb (for Physical Graphs)</span></listitem>
</itemizedlist><bridgehead class="http://www.w3.org/1999/xhtml:h3">Can I See This In Action Anywhere?</bridgehead>
 <itemizedlist mark="bullet" spacing="compact"><listitem>Available demo you can find at the following location: <ulink url="http://demo.openlinksw.com/phpBB2/">http://demo.openlinksw.com/phpBB2/</ulink> </listitem>
<listitem>You can run the queries below or your own created ones using the <ulink url="http://demo.openlinksw.com/sparql">Virtuoso SPARQL query page</ulink>.
</listitem>
<listitem>For the database located at <ulink url="http://demo.openlinksw.com/phpBB2/,">http://demo.openlinksw.com/phpBB2/,</ulink> you should use the following graph(s) URI: <itemizedlist mark="bullet" spacing="compact"><listitem>Virtual Graph URI: <ulink url="http://demo.openlinksw.com/phpBB2_v/">http://demo.openlinksw.com/phpBB2_v/</ulink> </listitem>
<listitem>Physical Graph URI: <ulink url="http://demo.openlinksw.com/phpBB2/">http://demo.openlinksw.com/phpBB2/</ulink> </listitem>
</itemizedlist></listitem>
</itemizedlist><bridgehead class="http://www.w3.org/1999/xhtml:h3">Key phpBB to SIOC Mappings</bridgehead>
 
<table><title /><tgroup><thead /><tbody>
<row><entry>phpBB </entry><entry> SIOC </entry><entry> Sample Value </entry></row>
<row><entry> Instance  </entry><entry> rdf:type </entry><entry> sioc:Container </entry></row>
<row><entry> Instance Type	</entry><entry> rdf:type </entry><entry> sioc:Forum </entry></row>
<row><entry> Instance  name </entry><entry> sioc:name  </entry><entry> <ulink url="http://demo.openlinksw.com/phpBB2/viewforum.php?f=1">http://demo.openlinksw.com/phpBB2/viewforum.php?f=1</ulink> </entry></row>
</tbody></tgroup></table>
<para> </para>
<bridgehead class="http://www.w3.org/1999/xhtml:h3">Dump of all phpBB Forums</bridgehead>
 <programlisting>PREFIX rdf: &lt;http://www.w3.org/1999/02/22-rdf-syntax-ns#&gt;
PREFIX sioc: &lt;http://rdfs.org/sioc/ns#&gt;
PREFIX dct: &lt;http://purl.org/dc/elements/1.1/&gt;
PREFIX dcc: &lt;http://purl.org/dc/terms/&gt;
SELECT *
FROM &lt;http://demo.openlinksw.com/phpBB2_v/&gt;
WHERE 
  {
    ?forum rdf:type sioc:Forum.
    optional{ ?forum sioc:id ?id }.
    optional{ ?forum sioc:name ?name }.
    optional{ ?forum dct:description ?descr }.
    optional{ ?forum dct:title ?title }.
  }
</programlisting><bridgehead class="http://www.w3.org/1999/xhtml:h5">Sample Data (Live Query Results)</bridgehead>
 <itemizedlist mark="bullet" spacing="compact"><listitem>Click <ulink url="http://demo.openlinksw.com/phpBB2/">*Here*</ulink> for an Interactive-Web View of phpBB </listitem>
<listitem>Click <ulink url="http://demo.openlinksw.com/sparql?default-graph-uri=http%3A%2F%2Fdemo.openlinksw.com%2FphpBB2_v%2F&amp;should-sponge=&amp;query=PREFIX+rdf%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0D%0APREFIX+sioc%3A+%3Chttp%3A%2F%2Frdfs.org%2Fsioc%2Fns%23%3E%0D%0APREFIX+dct%3A+%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Felements%2F1.1%2F%3E%0D%0APREFIX+dcc%3A+%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Fterms%2F%3E%0D%0ASELECT+*%0D%0AFROM+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2FphpBB2_v%2F%3E%0D%0AWHERE+%0D%0A++%7B%0D%0A++++%3Fforum+rdf%3Atype+sioc%3AForum.%0D%0A++++optional%7B+%3Fforum+sioc%3Aid+%3Fid+%7D.%0D%0A++++optional%7B+%3Fforum+sioc%3Aname+%3Fname+%7D.%0D%0A++++optional%7B+%3Fforum+dct%3Adescription+%3Fdescr+%7D.%0D%0A++++optional%7B+%3Fforum+dct%3Atitle+%3Ftitle+%7D.%0D%0A++%7D&amp;format=text%2Fhtml&amp;debug=on">*Here*</ulink> for a live SPARQL Query (via SPARQL Protocol) against a phpBB collection of forums.
</listitem>
</itemizedlist><bridgehead class="http://www.w3.org/1999/xhtml:h4">Dump of phpBB Posts</bridgehead>
 <programlisting>PREFIX rdf: &lt;http://www.w3.org/1999/02/22-rdf-syntax-ns#&gt;
PREFIX sioc: &lt;http://rdfs.org/sioc/ns#&gt;
PREFIX dct: &lt;http://purl.org/dc/elements/1.1/&gt;
SELECT *
FROM &lt;http://demo.openlinksw.com/phpBB2_v/&gt;
WHERE 
  {
    ?forum rdf:type sioc:Forum.
    optional{ ?forum sioc:name ?name }.
    optional{ ?forum sioc:container_of ?post  } .
    optional{ ?post dct:title ?title } .
    optional{ ?post sioc:content ?content } .
  }
LIMIT 10
</programlisting><bridgehead class="http://www.w3.org/1999/xhtml:h5">Sample Data (Live Query Results)</bridgehead>
 <itemizedlist mark="bullet" spacing="compact"><listitem>Click <ulink url="http://demo.openlinksw.com/phpBB2/">*Here*</ulink> for an Interactive-Web View of phpBB </listitem>
<listitem>Click <ulink url="http://demo.openlinksw.com/sparql?default-graph-uri=http%3A%2F%2Fdemo.openlinksw.com%2FphpBB2_v%2F&amp;should-sponge=&amp;query=PREFIX+rdf%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0D%0APREFIX+sioc%3A+%3Chttp%3A%2F%2Frdfs.org%2Fsioc%2Fns%23%3E%0D%0APREFIX+dct%3A+%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Felements%2F1.1%2F%3E%0D%0ASELECT+*%0D%0AFROM+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2FphpBB2_v%2F%3E%0D%0AWHERE+%0D%0A++%7B%0D%0A++++%3Fforum+rdf%3Atype+sioc%3AForum.%0D%0A++++optional%7B+%3Fforum+sioc%3Aname+%3Fname+%7D.%0D%0A++++optional%7B+%3Fforum+sioc%3Acontainer_of+%3Fpost++%7D+.%0D%0A++++optional%7B+%3Fpost+dct%3Atitle+%3Ftitle+%7D+.%0D%0A++++optional%7B+%3Fpost+sioc%3Acontent+%3Fcontent+%7D+.%0D%0A++%7D%0D%0ALIMIT+10&amp;format=text%2Fhtml&amp;debug=on">*Here*</ulink> for a live SPARQL Query (via SPARQL Protocol) against a phpBB collection of posts.
</listitem>
</itemizedlist><bridgehead class="http://www.w3.org/1999/xhtml:h3">Dump of phpBB Groups and their members</bridgehead>
 <programlisting>PREFIX sioc: &lt;http://rdfs.org/sioc/ns#&gt;
SELECT ?grp ?username
FROM &lt;http://demo.openlinksw.com/phpBB2_v/&gt;
WHERE 
  {
    ?group a sioc:Usergroup .
    optional{ ?group sioc:name ?grp }.      
    optional{ ?group sioc:has_member ?member} .
    optional{ ?member sioc:name ?username} .
  }
ORDER BY DESC (?grp) 
</programlisting><bridgehead class="http://www.w3.org/1999/xhtml:h5">Sample Data (Live Query Results)</bridgehead>
 <itemizedlist mark="bullet" spacing="compact"><listitem>Click <ulink url="http://demo.openlinksw.com/phpBB2/">*Here*</ulink> for an Interactive-Web View of phpBB </listitem>
<listitem>Click <ulink url="http://demo.openlinksw.com/sparql?default-graph-uri=http%3A%2F%2Fdemo.openlinksw.com%2FphpBB2_v%2F&amp;should-sponge=&amp;query=PREFIX+sioc%3A+%3Chttp%3A%2F%2Frdfs.org%2Fsioc%2Fns%23%3E%0D%0ASELECT+%3Fgrp+%3Fusername%0D%0AFROM+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2FphpBB2_v%2F%3E%0D%0AWHERE+%0D%0A++%7B%0D%0A++++%3Fgroup+a+sioc%3AUsergroup+.%0D%0A++++optional%7B+%3Fgroup+sioc%3Aname+%3Fgrp+%7D.++++++%0D%0A++++optional%7B+%3Fgroup+sioc%3Ahas_member+%3Fmember%7D+.%0D%0A++++optional%7B+%3Fmember+sioc%3Aname+%3Fusername%7D+.%0D%0A++%7D%0D%0AORDER+BY+DESC+%28%3Fgrp%29+&amp;format=text%2Fhtml&amp;debug=on">*Here*</ulink> for a live SPARQL Query (via SPARQL Protocol) against a phpBB collection of groups.</listitem>
</itemizedlist><bridgehead class="http://www.w3.org/1999/xhtml:h3">Dump of phpBB Users details</bridgehead>
 <programlisting>PREFIX sioc: &lt;http://rdfs.org/sioc/ns#&gt;
SELECT *
FROM &lt;http://demo.openlinksw.com/phpBB2_v/&gt;
WHERE
  {
    ?user a sioc:User .
    optional{ ?user sioc:name ?name}.
    optional{ ?user sioc:id ?id}.
    optional{ ?user sioc:email ?email}.
  }
</programlisting><bridgehead class="http://www.w3.org/1999/xhtml:h5">Sample Data (Live Query Results)</bridgehead>
 <itemizedlist mark="bullet" spacing="compact"><listitem>Click <ulink url="http://demo.openlinksw.com/phpBB2/">*Here*</ulink> for an Interactive-Web View of phpBB </listitem>
<listitem>Click <ulink url="http://demo.openlinksw.com/sparql?default-graph-uri=http%3A%2F%2Fdemo.openlinksw.com%2FphpBB2_v%2F&amp;should-sponge=&amp;query=PREFIX+sioc%3A+%3Chttp%3A%2F%2Frdfs.org%2Fsioc%2Fns%23%3E%0D%0ASELECT+*%0D%0AFROM+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2FphpBB2_v%2F%3E%0D%0AWHERE%0D%0A++%7B%0D%0A++++%3Fuser+a+sioc%3AUser+.%0D%0A++++optional%7B+%3Fuser+sioc%3Aname+%3Fname%7D.%0D%0A++++optional%7B+%3Fuser+sioc%3Aid+%3Fid%7D.%0D%0A++++optional%7B+%3Fuser+sioc%3Aemail+%3Femail%7D.%0D%0A++%7D&amp;format=text%2Fhtml&amp;debug=on">*Here*</ulink> for a live SPARQL Query (via SPARQL Protocol) against a phpBB collection of users.</listitem>
</itemizedlist><bridgehead class="http://www.w3.org/1999/xhtml:h2">Reference</bridgehead>
<bridgehead class="http://www.w3.org/1999/xhtml:h3">See also</bridgehead>
 <itemizedlist mark="bullet" spacing="compact"><listitem><ulink url="ODSSIOCRef">ODS SIOC reference</ulink> </listitem>
<listitem><ulink url="ODSAtomOWLRef">Query ODS Data Spaces using SPARQL and Atom OWL Ontology</ulink> </listitem>
<listitem><ulink url="ODSSKOSRef">Query ODS Data Spaces using SPARQL and SKOS Ontology</ulink> </listitem>
<listitem><ulink url="ODSFOAFRef">Query ODS Data Spaces using SPARQL and FOAF Ontology</ulink> </listitem>
<listitem><ulink url="VOSODSSparqlSamples">ODS SPARQL Samples</ulink> </listitem>
<listitem><ulink url="NorthWindREF">Northwind SPARQL Reference</ulink> </listitem>
<listitem><ulink url="SIOCRefTutorial">Query Virtuoso Tutorials using SPARQL</ulink> </listitem>
<listitem><ulink url="SIOCRefDocs">Query Virtuoso Documentation using SPARQL</ulink> </listitem>
<listitem><ulink url="WordPressSIOCRef">WordPress SIOC Reference</ulink> </listitem>
<listitem><ulink url="MediaWikiSIOCRef">MedaWiki SIOC Reference</ulink></listitem>
</itemizedlist><para><ulink url="CategoryRDF">CategoryRDF</ulink> <ulink url="CategorySIOC">CategorySIOC</ulink> <ulink url="CategorySPARQL">CategorySPARQL</ulink></para>
<para> </para>
</section></docbook>