Hi Luka,
Have you read the following document on hosting PHP / LAMP applications in
Virtuoso:
http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtuosoPHP
We also have migrated popular LAMP applications like phpBB, WordPress,
MediaWIki & Drupal to be completed hosted in Virtuoso as detailed at:
http://ods.openlinksw.com/wiki/ODS/#Third-Party%20Platform%20Integration
In fact our phpBB3 support forum (http://boards.openlinksw.com/support) is
hosted entirely in Virtuoso in the cloud ...
As you say the open source product does not support the creation of RDF Views
to remote relational data stores, so you essentially will have to duplicate the
MySQL data in Virtuoso either as pure RDF triples or SQL data that is the
mapped to RDF Views of the now local SQL Data if you are to use it as a triple
store for querying the data. So you may as well host everything in Virtuoso if
there is no physical restriction on using MySQL and other LAMP components (
other then you are a FAN :)), there will be a learning curve to get up speed
with Virtuoso but it will be worth it in the end as you have an all in one
solution making deployment ( and re-deployment) a simple process (just copy
binary, config & db file to new location) ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 9 Dec 2010, at 10:59, Luka wrote:
> Hello everyone,
>
> I am working on a web application that would try to leverage the use of RDF
> data.
> Since, I am PhP/MySQL fan I have some questions regarding the organization of
> system.
>
> I'm using the open source version of Virtuoso.
>
> So, my application will be a CMS for a specific domain and I thought that the
> part
> of application that has to do with users login, ACL, static pages, blog
> components etc.
> should be stored the good old relational way in MySQL.
> Since this CMS will have a component that will enable visitors
> to browse a tree/list of products sold by a specific shop, I thought to
> keep some relationships between products, producers, sellers, shippers etc.
> in RDF format. I would
> try to create a simple ontology for this domain.
>
> My question is: how would you organize your project?
>
> I thought of Installing
> 1. Apache with PHP,
> 2. MySQL and
> 3. Virtuoso
>
> instead of hosting PHP directly in Virtuoso . [I am more comfortable with
> Apache :)]
>
> ...I would build my CMS on PHP/MySQL stack and as for that specific part
> where RDF
> data would be used I thought I could map existing MySQL tables that hold this
> information?
> I read about RDF views but I'm not so sure that open source version can
> import data from
> external DBMS?
> Do you think I should use RDF views (if even possible in o.s. version) or I
> should
> create a RDF quad store that would be a duplicate of what would already exist
> in MySQL tables?
> If you have any suggestions for reading (tutorials, manuals) please do share
> it with me...
>
> I am new to Virtuoso so please excuse me if I made a few mistakes in
> terminology :)
>
> Thank you very much.
>
> Luka
>
>
> ------------------------------------------------------------------------------
> This SF Dev2Dev email is sponsored by:
>
> WikiLeaks The End of the Free Internet
> http://p.sf.net/sfu/therealnews-com_______________________________________________
> Virtuoso-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
