Hi Lars, What are the remote database(s) you are seeking to virtualize data into Virtuoso from ?
The docs page you found below details whats happening at the lower level, but the materialization of the views can also be performed using the Virtuoso conductor with the following steps : • Link remote database tables into Virtuoso, which is a requirement for the creation of incremental snapshot replicated local tables. (http://docs.openlinksw.com/virtuoso/qsvdbsrv.html#lnktabvirt) • Create incremental snapshot replicated local copies of the required database tables in Virtuoso (Remote to Local). (http://docs.openlinksw.com/virtuoso/htmlconductorbar.html#replicationandsynchronization) • Create RDFViews for the incrementally replicated table objects using the Conductor RDF -> RDFView tab, by selecting the "Generate via Wizard button" to create a custom set of RDFViews, and selecting the "Generate RDB2RDF triggers" and "Enable Data Syncs with Physical Quad Store" radio button options. (http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtRdb2RDFViewsGeneration) 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 16 Dec 2010, at 12:20, Lars Marius Garshol wrote: > > * Mark James >> >> 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. > > Thank you for this! It sounds like exactly what I need. After digging through > the documentation for a while it seems that this the bit that's needed to > materialize the views. > > http://docs.openlinksw.com/virtuoso/rdfperformancetuning.html#rdb2rdftriggers > > And, I guess, to keep track of what changes in the resulting RDF we create a > snapshot log of RDF_QUAD using this: > > http://docs.openlinksw.com/virtuoso/SNAPSHOT.html#COMMANDS > > Based on that I think we can use SQL on the snapshot table to see what the > changes are and produce an Atom feed of changes, plus fragments for > individual changes. > > Does this sound reasonable, or am I barking up the wrong tree? > > --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 > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users