. "3f037fde5b2041e09e484e999c6d2e8f" . "2017-06-13T05:45:15Z" . . "2017-06-13T05:45:15Z" . . . . . . . . . . . . . . . . . . . . . "2017-06-13T05:45:15.426088"^^ . . "2017-06-13T05:45:15.426088"^^ . . . "PHPBBSIOCRef" . . . . . . . " %VOSNAV%\n\n%TOC%\n\n---++phpBB SIOC Reference\n\n---+++What is it about?\n\nUnobtrusive 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. \n\n---+++Why is it important?\n\nUnified Storage of heterogenous data originating from a variety of applications and associated protocols that is exposed as RDF instance data. Thus, benefits include:\n\n * SPARQL access to phpBB data via a SPARQL Endpoint\n * Dereferencable URIs (drill-down facilitating data pointers) for all data items (Entities) in the \"Discussion Forum\" / \"Bulletin Board\" domain (also referred to as Boardscape) \n * 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. \n\n---+++How can one use this feature?\n * Obtain an Open Source of Commercial Edition of Virtuoso (*enable PHP Hosting Support during installation*)\n * Run the virtuoso _phpbb_hosting_dav|filesystem.vad package\n * Go to http://:[port]/phpBB\n * Use phpBB as per usual\n * 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)\n\n---+++Can I See This In Action Anywhere?\n * Available demo you can find at the following location: http://demo.openlinksw.com/phpBB2/\n * You can run the queries below or your own created ones using the [[http://demo.openlinksw.com/sparql][Virtuoso SPARQL query page]].\n * For the database located at http://demo.openlinksw.com/phpBB2/, you should use the following graph(s) URI:\n * Virtual Graph URI: http://demo.openlinksw.com/phpBB2_v/\n * Physical Graph URI: http://demo.openlinksw.com/phpBB2/\n---+++Key phpBB to SIOC Mappings\n|phpBB | SIOC | Sample Value |\n| Instance | rdf:type | sioc:Container |\n| Instance Type\t| rdf:type | sioc:Forum |\n| Instance name | sioc:name | http://demo.openlinksw.com/phpBB2/viewforum.php?f=1 |\n---+++Dump of all phpBB Forums\n\nPREFIX rdf: \nPREFIX sioc: \nPREFIX dct: \nPREFIX dcc: \nSELECT *\nFROM \nWHERE \n {\n ?forum rdf:type sioc:Forum.\n optional{ ?forum sioc:id ?id }.\n optional{ ?forum sioc:name ?name }.\n optional{ ?forum dct:description ?descr }.\n optional{ ?forum dct:title ?title }.\n }\n\n---+++++Sample Data (Live Query Results)\n * Click [[http://demo.openlinksw.com/phpBB2/][*Here*]] for an Interactive-Web View of phpBB\n * 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.\n---++++Dump of phpBB Posts\n\nPREFIX rdf: \nPREFIX sioc: \nPREFIX dct: \nSELECT *\nFROM \nWHERE \n {\n ?forum rdf:type sioc:Forum.\n optional{ ?forum sioc:name ?name }.\n optional{ ?forum sioc:container_of ?post } .\n optional{ ?post dct:title ?title } .\n optional{ ?post sioc:content ?content } .\n }\nLIMIT 10\n\n---+++++Sample Data (Live Query Results)\n * Click [[http://demo.openlinksw.com/phpBB2/][*Here*]] for an Interactive-Web View of phpBB\n * 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.\n---+++Dump of phpBB Groups and their members\n\nPREFIX sioc: \nSELECT ?grp ?username\nFROM \nWHERE \n {\n ?group a sioc:Usergroup .\n optional{ ?group sioc:name ?grp }. \n optional{ ?group sioc:has_member ?member} .\n optional{ ?member sioc:name ?username} .\n }\nORDER BY DESC (?grp) \n\n---+++++Sample Data (Live Query Results)\n * Click [[http://demo.openlinksw.com/phpBB2/][*Here*]] for an Interactive-Web View of phpBB\n * 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.\n\n---+++Dump of phpBB Users details\n\nPREFIX sioc: \nSELECT *\nFROM \nWHERE\n {\n ?user a sioc:User .\n optional{ ?user sioc:name ?name}.\n optional{ ?user sioc:id ?id}.\n optional{ ?user sioc:email ?email}.\n }\n\n---+++++Sample Data (Live Query Results)\n * Click [[http://demo.openlinksw.com/phpBB2/][*Here*]] for an Interactive-Web View of phpBB\n * 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.\n\n---++Reference\n\n---+++See also \n * [[ODSSIOCRef][ODS SIOC reference]]\n * [[ODSAtomOWLRef][Query ODS Data Spaces using SPARQL and Atom OWL Ontology]]\n * [[ODSSKOSRef][Query ODS Data Spaces using SPARQL and SKOS Ontology]]\n * [[ODSFOAFRef][Query ODS Data Spaces using SPARQL and FOAF Ontology]]\n * [[VOSODSSparqlSamples][ODS SPARQL Samples]]\n * [[NorthWindREF][Northwind SPARQL Reference]]\n * [[SIOCRefTutorial][Query Virtuoso Tutorials using SPARQL]]\n * [[SIOCRefDocs][Query Virtuoso Documentation using SPARQL]]\n * [[WordPressSIOCRef][WordPress SIOC Reference]]\n * [[MediaWikiSIOCRef][MedaWiki SIOC Reference]]\n\nCategoryRDF CategorySIOC CategorySPARQL\n\n%VOSCOPY%\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n" . . "PHPBBSIOCRef" . . . "PHPBBSIOCRef" . . .