Hi everyone, we are developing a plugin that wants add semantics to wordpress CMS, and we are thing about integrate jena with wordpress to store the metadata.
For example, we have a wordpress MU of music artistis. The artistic, musics, albuns, etc are represent with posts. So custom post is similar a "class", the post simiiliar a instance, and custom fields similiar a atributes. Here we can ser more about custom posts: http://vimeo.com/32661608 http://vimeo.com/10187055 And here we can see the wordpress ER: http://www.inqbation.com/wp-content/uploads/2011/05/WP3.0-ERD.png So we can aloud user to create semantic relations beetween posts, links, terms...any resource in wordpress. We acctually created a oblivous triple table to store the statments like this: +----+---wp_posts---+-----------------------+ +-id-+---post_title---+---post_author---+ | 11 | car | 12 | | 14 | fusca | 32 | | 23 | my fusca | 43 | +----+---wp_images----+-----------------+ +-id-+---------title--------+-----url---------+ | 9 | fusca photo1 | ../fusca1.jpg | +----+-wp_nodes-+-------------------------------------------------+-literal-+ +-id-+---wp_id-----+-----value-------------------------------------+---------+ | 1 | 11 | posts | 0 | | 2 | 14 | posts | 0 | | 3 | 23 | posts | 0 | | 4 | 9 | images | 0 | | 5 | | http://purl.org/dc/terms/creator | 0 | | 6 | | http://www.w3.org/2000/01/rdf-schema#subClassOf | 0 | | 7 | | http://www.w3.org/1999/02/22-rdf-syntax-ns#type | 0 | | 8 | | has_photo | 0 | | 9 | | mileage | 0 | | 10 | | 1981 | 1 | | 11 | 43 | users | 0 | when wp_id not null, then value is a wordpress resource (table or table-field) when literal equal 1, then value is literal +----+--wp_spo---+-----+ +-id-+--s--+--p---+--o--+ | 1 | 2 | 6 | 1 | | 1 | 3 | 7 | 2 | | 1 | 3 | 5 | 11 | | 1 | 3 | 8 | 4 | | 1 | 3 | 9 | 10 | The question is: 1.has this model a good performance ? 2.how store this using Jena SDB? The new documentation is incomplete (dont have an explanation for each field, datatype, and how works) : http://incubator.apache.org/jena/documentation/sdb/database_layouts.html This one is more detailed: http://jena.sourceforge.net/DB/layout.html But its the old one. So, how does jena sdb store namespace, literals, graphs? Id like any documentation, could be an article, that explain why this model is better than previous models (like in Efficient RDF Storage and Retrieval in Jena2 article) Maybe someone could send a mysql dump with a litle rdf graph stored. If we dont use, it could help us to improve our model. This could be used in many applications like: - a simple semantic annoations tool with a familiar interface - semantic portals or knowledge management system - rdf explorer (to wiki.dbpedia.org/Downloads for example) You could say, but there is already many semantic tools. Ye, but which one has more than 70 million sites around the world ? http://en.wordpress.com/stats/ Should I send this issue to dev mailling list ? Thanks in advance, Marcel -- Marcel Ferrante Silva "The Power of Ideas" skype: marcelferrante msn/gtalk: [email protected]
