phpBB 3 SIOC Reference

What is it about?

Unobtrusive generation of RDF instance data from phpBB 3. You simply use phpBB 3 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 3 and NNTP such that phpBB 3 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 3 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 3 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 3 or NNTP.

How can one use this feature?

• Obtain an Open Source of Commercial Edition of Virtuoso ( enable PHP Hosting Support during installation)
• Install the virtuoso_phpbb_hosting_filesystem.vad package
• Go to http://:[port]/phpBB3
• Use phpBB 3 as per usual
• Query SPARQL Data via the endpoint: http://:[port]/phpBB3 using RDF Data Source URI (Named Graph): http://:[port]/phpbb_v (for Virtual Graphs) and http://:[port]/phpbb (for Physical Graphs)

What are the RDF Views supported?

• PHPBB3 rdf views_script.sql

Can I See This In Action Anywhere?

• Available demo you can find at the following location: http://demo.openlinksw.com/phpBB3/
• 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/phpBB3/, you should use the following graph(s) URI:
  • Virtual Graph URI: http://demo.openlinksw.com/phpBB3_v/
  • Physical Graph URI: http://demo.openlinksw.com/phpBB3/

Key phpBB 3 to SIOC Mappings

phpBB 3	SIOC	Sample Value
Instance	rdf:type	sioc:Container
Instance Type	rdf:type	sioc:Forum
Instance name	sioc:name	http://demo.openlinksw.com/phpBB3/viewforum.php?f=4

Dump of all phpBB 3 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/phpBB3_v/>
WHERE 
  {
    ?forum rdf:type sioc:Forum.
    optional{ ?forum sioc:id ?id }.
    optional{ ?forum sioc:name ?name }.
    optional{ ?forum sioc:description ?descr }.
    optional{ ?forum dct:title ?title }.
  }

Sample Data (Live Query Results)

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

Dump of phpBB 3 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/phpBB3_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 3
• Click *Here* for a live SPARQL Query (via SPARQL Protocol) against a phpBB 3 collection of posts.

Dump of phpBB 3 Groups and their members

PREFIX sioc: <http://rdfs.org/sioc/ns#>
SELECT ?grp ?username
FROM <http://demo.openlinksw.com/phpBB3_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 3
• Click *Here* for a live SPARQL Query (via SPARQL Protocol) against a phpBB 3 collection of groups.

Dump of phpBB 3 Users details

PREFIX sioc: <http://rdfs.org/sioc/ns#>
SELECT *
FROM <http://demo.openlinksw.com/phpBB3_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 3
• Click *Here* for a live SPARQL Query (via SPARQL Protocol) against a phpBB 3 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
• Query ODS Data Spaces using SPARQL and Annotea Ontology
• ODS SPARQL Samples
• Northwind SPARQL Reference
• Query Virtuoso Tutorials using SPARQL
• Query Virtuoso Documentation using SPARQL
• WordPress SIOC Reference
• MedaWiki SIOC Reference
• Drupal SIOC Reference