%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://:[port]/phpBB * Use phpBB as per usual * Query SPARQL Data via the endpoint: http://:[port]/phpBB using RDF Data Source URI (Named Graph): http://:[port]/phpbb_v (for Virtual Graphs) and http://:[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 PREFIX rdf: PREFIX sioc: PREFIX dct: PREFIX dcc: SELECT * FROM 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 }. } ---+++++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 PREFIX rdf: PREFIX sioc: PREFIX dct: SELECT * FROM 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 ---+++++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 PREFIX sioc: SELECT ?grp ?username FROM 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) ---+++++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 PREFIX sioc: SELECT * FROM WHERE { ?user a sioc:User . optional{ ?user sioc:name ?name}. optional{ ?user sioc:id ?id}. optional{ ?user sioc:email ?email}. } ---+++++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%