Hi Lars, The commercial version of virtuoso has a 'virtual database' capability. You can create tables within virtuoso that are links to tables within other rdbms. It's then possible to create rdf views and either materialize the triples or query the rdbms data directly. Note that if you want to perform any sort of inferencing on the triples then you must materialize.
Here's a blog post from Kingsley on the subject - http://www.openlinksw.com/dataspace/[email protected]/weblog/[email protected]'s%20BLOG%20[127]/1608 cheers Mark On 16 December 2010 20:05, Lars Marius Garshol <[email protected]> wrote: > > Is there functionality in Virtuoso for doing ETL from relational data to > RDF? I looked at RDF Views, but it doesn't seem to be what we want, and > there don't appear to be any spongers for this purpose. I did find a blog > post about the subject that seemed to imply that ETL was not the preferred > approach in Virtuoso. > > The reason we want to do this is that we want to expose a big RDBMS as an > SDshare[1] feed, for aggregation on another server. So, basically, what we > need is an RDF view of the data (materialized or not) plus information about > what has been changed in the database recently. > > Theoretically, we could just add triggers and changelog tables to the > database and do it all ourselves, but I was wondering whether there was some > way to do this with Virtuoso. Anyone have any ideas? > > [1] http://www.egovpt.org/fg/CWA_Part_1b > > --Lars M. > http://www.garshol.priv.no/tmphoto/ > http://www.garshol.priv.no/blog/ > > > > > > ------------------------------------------------------------------------------ > Lotusphere 2011 > Register now for Lotusphere 2011 and learn how > to connect the dots, take your collaborative environment > to the next level, and enter the era of Social Business. > http://p.sf.net/sfu/lotusphere-d2d > _______________________________________________ > Virtuoso-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/virtuoso-users >
