OMDB – Open Media Database

OMDB.org is a Wiki devoted to collect structured data about movie related information.
The OMDB triplification can be accessed at: http://triplify.org/omdb/triplify
The complete triples (1.2M) are available for download at: http://triplify.org/omdb/triplify/omdb.nt.bz2 (6MB)

<?php
$triplify['db']=new PDO('mysql:host=localhost;dbname=omdb','dbuser','dbpass');

$triplify['namespaces']=array(
        'vocabulary'=>'http://triplify.org/vocabulary/omdb#',
        'rdf'=>'http://www.w3.org/1999/02/22-rdf-syntax-ns#',
        'rdfs'=>'http://www.w3.org/2000/01/rdf-schema#',
        'owl'=>'http://www.w3.org/2002/07/owl#',
        'foaf'=>'http://xmlns.com/foaf/0.1/',
        'sioc'=>'http://rdfs.org/sioc/ns#',
        'sioctypes'=>'http://rdfs.org/sioc/types#',
        'dc'=>'http://purl.org/dc/elements/1.1/',
        'dcterms'=>'http://purl.org/dc/terms/',
        'skos'=>'http://www.w3.org/2004/02/skos/core#',
        'tag'=>'http://www.holygoat.co.uk/owl/redwood/0.1/tags/',
        'xsd'=>'http://www.w3.org/2001/XMLSchema#',
        'update'=>'http://triplify.org/vocabulary/update#',
);

function getContentSQL($type) {
        return "SELECT related_object_id id,data 't:unc',CONCAT(CONCAT_WS('-',type,name),'@\"',l.iso_639_1,'\"')
                FROM contents INNER JOIN globalize_languages l ON(l.id=language_id)
                WHERE related_object_type='$type'";

}
function getAliasSQL($type) {
        return "SELECT DISTINCT related_object_id id,name 't:unc',IF(l.id=1,'rdf:label',CONCAT('rdf:label@\"',l.iso_639_1,'\"')) FROM name_aliases
                        INNER JOIN globalize_languages l ON(l.id=language_id)
                WHERE related_object_type='$type'";
}
function getNameAliasSQL($type) {
        return "SELECT DISTINCT cn.name id,an.name 't:unc',CONCAT('rdf:label@\"',l.iso_639_1,'\"') FROM name_aliases cn
                        INNER JOIN name_aliases an USING(related_object_type,related_object_id)
                        INNER JOIN globalize_languages l ON(l.id=an.language_id)
                WHERE cn.related_object_type='$type'";
}

$triplify['queries']=array(
        'movie'=>array(
                "SELECT id,name,type,runtime,budget,revenue,status,homepage,created_at FROM movies",
                "SELECT movie_id id,id 'hasCast->cast' FROM casts",
                "SELECT related_object_id id,CONCAT('http://www.omdb.org/image/default/',id,'.jpeg') 'hasImage' FROM images WHERE related_object_type='Movie'",
                "SELECT movie_id id, english_name 'country' FROM movie_countries INNER JOIN globalize_countries gc ON(country_id=gc.id)",
                "SELECT DISTINCT movie_id id,name 'belongsToCategory->category' FROM movie_user_categories
                        INNER JOIN name_aliases ON(related_object_type='Category' AND related_object_id=category_id AND language_id=1819)",
                "SELECT movie_id id,CONCAT('http://www.youtube.com/watch?v=',`key`) 'hasTrailer' FROM trailers",
                "SELECT movie_id id, FROM movie_languages",
                getContentSQL('Movie'),
                getAliasSQL('Movie'),
        ),
        'cast'=>array(
                "SELECT id,movie_id 'ofMovie->movie',person_id 'hasActor->person',position,type,character_id 'playsCharacter->character',comment,job_id 'performesJob->job' FROM casts",
                getAliasSQL('Cast'),
        ),
        'job'=>array(
                "SELECT jn.name id,pn.name 'isSubJobOf->job' FROM jobs j
                                INNER JOIN name_aliases jn ON(jn.related_object_type='Job' AND jn.related_object_id=j.id AND jn.language_id=1819)
                        LEFT JOIN name_aliases pn ON(pn.related_object_type='Job' AND pn.related_object_id=parent_id AND pn.language_id=1819)",
                getContentSQL('Job'),
                getNameAliasSQL('Job'),
        ),
        'person'=>array(
                "SELECT id,name,birthday,homepage,birthplace FROM people",
                "SELECT person_id id,movie_id 'playsInMovie->movie' FROM casts",
                "SELECT related_object_id id,CONCAT('http://www.omdb.org/image/default/',id,'.jpeg') 'hasImage' FROM images WHERE related_object_type='Person'",
                getContentSQL('Person'),
                getAliasSQL('Person'),
        ),
        'category'=>array(
                "SELECT cn.name id,pn.name 'isSubCategoryOf->category' FROM categories c
                                INNER JOIN name_aliases cn ON(cn.related_object_type='Category' AND cn.related_object_id=c.id AND cn.language_id=1819)
                        LEFT JOIN name_aliases pn ON(pn.related_object_type='Category' AND pn.related_object_id=parent_id AND pn.language_id=1819)",
                getNameAliasSQL('Category'),
                getContentSQL('Category'),
        ),
        'company'=>array(
                "SELECT id,name,parent_id 'subsidiaryOf->company' FROM companies",
                "SELECT related_object_id id,CONCAT('http://www.omdb.org/image/default/',id,'.jpeg') 'hasImage' FROM images WHERE related_object_type='Company'",
                getContentSQL('Company'),
                getAliasSQL('Company'),
        ),
        'character'=>array(
                "SELECT id,name FROM characters",
                "SELECT character_id id,person_id 'playedBy->person',movie_id 'appearsInMovie->movie' FROM casts",
                "SELECT related_object_id id,CONCAT('http://www.omdb.org/image/default/',id,'.jpeg') 'hasImage' FROM images WHERE related_object_type='Character'",
                getContentSQL('Character'),
                getAliasSQL('Character'),
        ),
);

$triplify['objectProperties']=array(
);

$triplify['classMap']=array(
        'user'=>'foaf:person'
);

$triplify['license']='http://creativecommons.org/licenses/by/3.0/us/';

$triplify['metadata']=array(
        'dc:title'=>'',
        'dc:publisher'=>''
);

$triplify['register']=true;

$triplify['TTL']=0;

$triplify['cachedir']='cache/';

$triplify['LinkedDataDepth']='2';

$triplify['CallbackFunctions']=array(
);
?>
There are no files on this page. [Display files/form]
There is no comment on this page. [Display comments/form]
Information

Last Modification: 2008-08-02 03:16:09 by Elias Theodorou