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
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
