Open Conf

OpenConf is a conference management software developed in PHP backed by a My SQL database. Google currently finds approx. 500 OpenConf installations online.

Triplify (with this configuration) makes this valuable meta-data about these conferences and workshops as well as their authors, publications and reviewers accessible. Five queries select relevant information from the Open Conf database schema regarding papers, authors, PC members, topics and paper-topics relationships.

Triplify Configuration for OpenConf 2.0


require_once("../include.php");
require_once("../db.php");

$triplify['namespaces']=array(
    'vocabulary'=>'http://triplify.org/vocabulary/OpenConf/',
    'foaf'=>'http://xmlns.com/foaf/0.1/',
    'dc'=>'http://purl.org/dc/elements/1.1/',
    'xsd'=>'http://www.w3.org/2001/XMLSchema#',
);

$triplify['queries']=array(
    'paper'=>array(
        "SELECT paperid id,title,keywords,abstract FROM ".OCC_TABLE_PAPER."
            WHERE accepted='T'",
        "SELECT paperid id,topicid hasTopic FROM ".OCC_TABLE_PAPERTOPIC." INNER JOIN
            ".OCC_TABLE_PAPER." USING(paperid) WHERE accepted='T'"
    ),
    'author'=>"SELECT CONCAT(paperid,'-',position) id,SHA(CONCAT('mailto:',email)) mbox_sha1sum,paperid isAuthorOf,
            name_first `foaf:firstName`,name_last `foaf:family_name`,organization,country
            FROM ".OCC_TABLE_AUTHOR." INNER JOIN ".OCC_TABLE_PAPER."
            USING(paperid) WHERE accepted='T'",
    'PCmember'=>"SELECT reviewerid id,SHA(CONCAT('mailto:',email)) mbox_sha1sum,'".$OC_confURL."' isPCmemberOf,
            name_first,name_last,url `foaf:homepage`,organization,country
            FROM ".OCC_TABLE_REVIEWER." WHERE onprogramcommittee='T'",
    'topic'=>"SELECT topicid id, topicname, short FROM ".OCC_TABLE_TOPIC,
);

$triplify['objectProperties']=array(
    'isAuthorOf'=>'paper',
    'isPCmemberOf'=>'',
    'hasTopic'=>'topic'
);

$triplify['TTL']=0;

$triplify['db']=new PDO('mysql:host='.OCC_DB_HOST.';dbname='.OCC_DB_NAME, OCC_DB_USER, OCC_DB_PASSWORD);

$triplify['classMap']=array(
    'author'=>'foaf:Person',
    'PCmember'=>'foaf:Person'
);

There are no files on this page. [Display files/form]

Comments [Hide comments/form]

Information

Last Modification: 2008-03-16 02:18:05 by Soeren Auer