Semantic Web Company

Recently the SWC took a thorough look at Triplify, a tool for mapping the contents of a relational DB to RDF, in the course of which we could convince ourselves of Triplify’s ease of use and its potent capabilities.
We take this opportunity to given an account of the philosophy behind Triplify, how it is used and also had the chance to interview the creator Sören Auer.

A common objection from critics of the semantic web is that regular users or webmasters won’t go to the trouble of marking up their content or whole web sites with RDF.
While it is obvious that nobody is going to decorate their web pages with hand-carved RDF triples, it is also apparent that a lot of the current web’s pages are generated by transforming information from relational databases to HTML pages, which are perfectly suited for human consumption, but which suffer from a big loss of machine-readable semantics.

As the information in the relational databases is highly structured and contains rich semantics, it is only natural to also use the already existing structured data to generate RDF representations of the same information.

Triplify is all about this approach of bootstrapping data for the semantic web. It does this for web applications which are built on PHP and MySQL.
Triplify consists of a lightweight PHP script and a configuration file. The latter is used to do the mapping of the columns of an application’s relational database to appropriate RDF classes and properties.

In many cases a site administrator who wants to export her site’s content as RDF, only has to save Triplify with a premade configuration file for her site’s application into the right folder, as for many popular applications like Wordpress, Joomla! or phpBB all the work has already been done.
Once installed, Triplify can be used to generate a dump of the site’s complete RDF graph, or to generate Linked Data, as each of the site’s main concepts’ RDF graph is provided under its own URL, e.g. the semantic description of a user with the ID 123 can be accessed under http://yoursite.com/triplify/user/123.

If no configuration for an application exits, it is fairly easy to create one by yourself.
All one has to do is to look at the app’s database schema, find appropriate classes and properties from well known ontologies and create MySQL queries that grab the data from the relational database and map them to RDF classes or properties.
An example for a query that takes the data from a table describing the user of a CMS:
"SELECT id, name AS 'foaf:name', url AS 'foaf:homepage', short_description AS 'dc:abstract' FROM user_table",

Triplify’s creator Sören Auer kindly gave us the opportunity for an interview:

Triplify is very easy to configure for web developers. For which scenarios would you recommend to use Triplify, and in which situations other approaches of semantifying your data might be more suitable?

As you already mentioned Triplify was primarily developed for Web applications developed in PHP. These usually have a relatively small and simple set of tables. Triplify creates complete RDF exports, Linked Data or JSON, but does not include SPARQL endpoint functionality. When SPARQL is required you are better off with D2R Server or Virtuosos RDF views.

Triplify creates semantic representations of the data in relational databases. Do you think there would also be benefit in the inverse approach i. e. creating an application that parses triples and writes it to a relational DB according to a mapping file?

In certain scenarios this might make sense, but for the most cases I think the database schema has to be developed separately. Database schemata contain more storage and retrieval oriented information, such as for example about data indexing. Vocabularies and ontologies on the other hand represent information on a conceptually higher level and are more flexible with regard to evolution of the information structures than databases.

Are there plans for further development of Triplify?

Sure. We want to add SPARQL support and possibly port Triplify to other scripting languages such as Ruby and Python.

Thank you Sören, we will stay tuned about the news from your great application and look forward to the Triplification Challenge 2009!

The nominees for the LOD Triplification Challenge are up! The challenge was organized as part of the preparations for the I-SEMANTICS 2008 conference and asked for submissions in the form of applications of Linked Open Data tools, RDF and Linked Data exporters, adoptions of configurations of Triplify for standard web applications, portings of the triplify script into other languages (e.g. Python, Ruby, Perl, ASP) and for applications showcasing the benefits of Linked Data to end-users.

Triplify itself is a small web application plugin – its crucial parts consisting of roughly 200 lines of code – currently only implemented in PHP. It is based on the definition of relational database queries for a specific web application in order to retrieve valuable information and to convert the results of these queries into RDF, JSON and Linked Data. More information about Triplify can be found here.

On to the nominees: Eight of the submissions were nominated and can now be voted on using the poll widget on the nominations page. The nominees are:

1. Automatic Generation of a Content Management System from an OWL ontology and RDF import and export by Alastair Burt, Brigitte Jörg.
   URL: www.lt-world.org/triplify
2. Integrating Triplify into the Django web application framework and discover some math by Martin Czygan.
   URL: pcai042.informatik.uni-leipzig.de:9103
3. Linked Movie Data Base by Oktie Hassanzadeh, Mariano Consens.
   URL: www.linkedmdb.org
4. Interlinking Multimedia Data by Michael Hausenblas, Wolfgang Halb.
   URL: sw.joanneum.at/CaMiCatzee
5. Showcases of light-weight RDF syndication in Joomla! by Danh Le Phuoc, Nur Aini Rakhmawati.
   URL: swm.deri.org/jsyndication
6. Semantic Web Pipes Demo by Danh Le Phuoc.
   URL: pipes.deri.org
7. DBTune by Yves Raimond.
   URL: dbtune.org
8. Triplification of the Open-Source Online Shop System osCommerce by Elias Theodorou.
   URL: triplify.org/vocabulary/oscommerce

Detailed information can be found in PDF outlines on the nomination page – and don’t forget to vote! The final decision about the winners of the challenge will be made by the organizing committee.

The prizes will be awarded at I-SEMANTICS 2008, 3–5 September 2008, Graz, Austria, which is part of TRIPLE-I, a joint venture of three conferences (I-SEMANTICS, I-KNOW, I-MEDIA).

Related post:
Sören Auer: Triplification Challenge Nominations

Together with this year’s I-Semantics conference, the Agile Knowledge Engineering and Semantic Web Research Group (AKSW) in Leipzig is organizing a Linking Open Data Triplification Challenge. Submission deadline is in three weeks (30th of June).

The challenge aims at expediting the process of revealing and exposing structured (relational) representations, which already back most of the existing Web sites, as well as raising awareness in the Web Developer community and showcasing best practices.

The challenge awards attractive prices (MacBook Air, EeePC, iPod) to the most innovative and promising semantifications. The prizes are kindly sponsored by OpenLink Software [2], Punkt.NetServices [3] and InfAI [4].

More Information about the challenge can be found at:
http://triplify.org/Challenge

The challenge at this year´s I-Semantics is not only going to award a MacBook Air and other nice prizes (sponsored by OpenLink Software and punkt. netServices; a 3rd sponsor is still needed) but is also going to help to overcome the chicken-and-egg dilemma of missing semantic representations and search facilities on the Web.

“Triplify tackles this dilemma by leveraging relational representations behind existing Web applications. A large part of web content is generated by database driven web applications. The structure and semantics encoded in relational database schemes, however, unfortunately was not accessible to web search engines, mashups etc.”

Generating data for the semantic web has never been so easy before. Start to expose your data on the web, become more visible, become part of cool and interesting mashups and win a Mac Book Air! More details about the challenge found here.