This HTML5 document contains 47 embedded RDF statements represented using HTML+Microdata notation.

The embedded RDF content will be recognized by any processor of HTML5 Microdata.

Subject Item

n5:this

foaf:made

n2:PHPBBSIOCRef

Subject Item

n10:this

sioc:creator_of

n2:PHPBBSIOCRef

Subject Item

n27:item

n28:services_of

n2:PHPBBSIOCRef

Subject Item

n15:this

sioc:creator_of

n2:PHPBBSIOCRef

Subject Item

n7:VOS

sioc:container_of

n2:PHPBBSIOCRef

atom:entry

n2:PHPBBSIOCRef

atom:contains

n2:PHPBBSIOCRef

Subject Item

n2:PHPBBSIOCRef

rdf:type

sioct:Comment atom:Entry

dcterms:created

2017-06-13T05:45:15.426088

dcterms:modified

2017-06-29T07:43:20.045783

rdfs:label

PHPBBSIOCRef

foaf:maker

n5:this n21:this

dc:title

PHPBBSIOCRef

opl:isDescribedUsing

n20:rdf

sioc:has_creator

n10:this n15:this

sioc:attachment

n9:sql

sioc:content

%VOSNAV% %TOC% ---++phpBB SIOC Reference ---+++What is it about? Unobtrusive generation of RDF instance data from phpBB. You simply use phpBB as-is while reaping the benefit of "RDF Views" 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. ---+++Why is it important? Unified Storage of heterogenous data originating from a variety of applications and associated protocols that is exposed as RDF instance data. Thus, benefits include: * SPARQL access to phpBB data via a SPARQL Endpoint * Dereferencable URIs (drill-down facilitating data pointers) for all data items (Entities) in the "Discussion Forum" / "Bulletin Board" domain (also referred to as Boardscape) * 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. ---+++How can one use this feature? * Obtain an Open Source of Commercial Edition of Virtuoso (*enable PHP Hosting Support during installation*) * Run the virtuoso _phpbb_hosting_dav|filesystem.vad package * Go to http://<domain|localhost>:[port]/phpBB * Use phpBB as per usual * Query SPARQL Data via the endpoint: http://<domain|localhost>:[port]/phpBB using RDF Data Source URI (Named Graph): http://<domain|localhost>:[port]/phpbb_v (for Virtual Graphs) and http://<domain|localhost>:[port]/phpbb (for Physical Graphs) ---+++Can I See This In Action Anywhere? * Available demo you can find at the following location: http://demo.openlinksw.com/phpBB2/ * You can run the queries below or your own created ones using the [[http://demo.openlinksw.com/sparql][Virtuoso SPARQL query page]]. * For the database located at http://demo.openlinksw.com/phpBB2/, you should use the following graph(s) URI: * Virtual Graph URI: http://demo.openlinksw.com/phpBB2_v/ * Physical Graph URI: http://demo.openlinksw.com/phpBB2/ ---+++Key phpBB to SIOC Mappings |phpBB | SIOC | Sample Value | | Instance | rdf:type | sioc:Container | | Instance Type | rdf:type | sioc:Forum | | Instance name | sioc:name | http://demo.openlinksw.com/phpBB2/viewforum.php?f=1 | ---+++Dump of all phpBB Forums <verbatim> 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/> PREFIX dcc: <http://purl.org/dc/terms/> SELECT * FROM <http://demo.openlinksw.com/phpBB2_v/> 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 }. } </verbatim> ---+++++Sample Data (Live Query Results) * Click [[http://demo.openlinksw.com/phpBB2/][*Here*]] for an Interactive-Web View of phpBB * Click [[http://demo.openlinksw.com/sparql?default-graph-uri=http%3A%2F%2Fdemo.openlinksw.com%2FphpBB2_v%2F&should-sponge=&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&format=text%2Fhtml&debug=on][*Here*]] for a live SPARQL Query (via SPARQL Protocol) against a phpBB collection of forums. ---++++Dump of phpBB Posts <verbatim> 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 * FROM <http://demo.openlinksw.com/phpBB2_v/> 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 </verbatim> ---+++++Sample Data (Live Query Results) * Click [[http://demo.openlinksw.com/phpBB2/][*Here*]] for an Interactive-Web View of phpBB * Click [[http://demo.openlinksw.com/sparql?default-graph-uri=http%3A%2F%2Fdemo.openlinksw.com%2FphpBB2_v%2F&should-sponge=&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&format=text%2Fhtml&debug=on][*Here*]] for a live SPARQL Query (via SPARQL Protocol) against a phpBB collection of posts. ---+++Dump of phpBB Groups and their members <verbatim> PREFIX sioc: <http://rdfs.org/sioc/ns#> SELECT ?grp ?username FROM <http://demo.openlinksw.com/phpBB2_v/> 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) </verbatim> ---+++++Sample Data (Live Query Results) * Click [[http://demo.openlinksw.com/phpBB2/][*Here*]] for an Interactive-Web View of phpBB * Click [[http://demo.openlinksw.com/sparql?default-graph-uri=http%3A%2F%2Fdemo.openlinksw.com%2FphpBB2_v%2F&should-sponge=&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+&format=text%2Fhtml&debug=on][*Here*]] for a live SPARQL Query (via SPARQL Protocol) against a phpBB collection of groups. ---+++Dump of phpBB Users details <verbatim> PREFIX sioc: <http://rdfs.org/sioc/ns#> SELECT * FROM <http://demo.openlinksw.com/phpBB2_v/> WHERE { ?user a sioc:User . optional{ ?user sioc:name ?name}. optional{ ?user sioc:id ?id}. optional{ ?user sioc:email ?email}. } </verbatim> ---+++++Sample Data (Live Query Results) * Click [[http://demo.openlinksw.com/phpBB2/][*Here*]] for an Interactive-Web View of phpBB * Click [[http://demo.openlinksw.com/sparql?default-graph-uri=http%3A%2F%2Fdemo.openlinksw.com%2FphpBB2_v%2F&should-sponge=&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&format=text%2Fhtml&debug=on][*Here*]] for a live SPARQL Query (via SPARQL Protocol) against a phpBB collection of users. ---++Reference ---+++See also * [[ODSSIOCRef][ODS SIOC reference]] * [[ODSAtomOWLRef][Query ODS Data Spaces using SPARQL and Atom OWL Ontology]] * [[ODSSKOSRef][Query ODS Data Spaces using SPARQL and SKOS Ontology]] * [[ODSFOAFRef][Query ODS Data Spaces using SPARQL and FOAF Ontology]] * [[VOSODSSparqlSamples][ODS SPARQL Samples]] * [[NorthWindREF][Northwind SPARQL Reference]] * [[SIOCRefTutorial][Query Virtuoso Tutorials using SPARQL]] * [[SIOCRefDocs][Query Virtuoso Documentation using SPARQL]] * [[WordPressSIOCRef][WordPress SIOC Reference]] * [[MediaWikiSIOCRef][MedaWiki SIOC Reference]] CategoryRDF CategorySIOC CategorySPARQL %VOSCOPY%

sioc:id

3f037fde5b2041e09e484e999c6d2e8f

sioc:link

n2:PHPBBSIOCRef

sioc:has_container

n7:VOS

n28:has_services

n27:item

atom:title

PHPBBSIOCRef

sioc:links_to

n4: n2:CategoryRDF n2:CategorySIOC n2:MediaWikiSIOCRef n11:on n12:on n13:1 n14:on n16: n17: n2:SIOCRefDocs n2:WordPressSIOCRef n22:on n2:SIOCRefTutorial n2:NorthWindREF n2:CategorySPARQL n26:sparql

atom:source

n7:VOS

atom:author

n5:this

atom:published

2017-06-13T05:45:15Z

atom:updated

2017-06-29T07:43:20Z

sioc:topic

n7:VOS