VOS.PHPBBSIOCRef

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 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: <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 }.
  }

Sample Data (Live Query Results)

• Click *Here* for an Interactive-Web View of phpBB
• Click *Here* for a live SPARQL Query (via SPARQL Protocol) against a phpBB collection of forums.

Dump of phpBB Posts

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

Sample Data (Live Query Results)

• Click *Here* for an Interactive-Web View of phpBB
• Click *Here* for a live SPARQL Query (via SPARQL Protocol) against a phpBB collection of posts.

Dump of phpBB Groups and their members

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) 

Sample Data (Live Query Results)

• Click *Here* for an Interactive-Web View of phpBB
• Click *Here* for a live SPARQL Query (via SPARQL Protocol) against a phpBB collection of groups.

Dump of phpBB Users details

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}.
  }

Sample Data (Live Query Results)

• Click *Here* for an Interactive-Web View of phpBB
• Click *Here* for a live SPARQL Query (via SPARQL Protocol) against a phpBB collection of users.

Reference

See also

• ODS SIOC reference
• 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
• ODS SPARQL Samples
• Northwind SPARQL Reference
• Query Virtuoso Tutorials using SPARQL
• Query Virtuoso Documentation using SPARQL
• WordPress SIOC Reference
• MedaWiki SIOC Reference

CategoryRDF CategorySIOC CategorySPARQL