On 6/13/19 7:55 PM, Stas Malyshev wrote:
Hi!
Data living in an RDBMS engine distinct from Virtuoso is handled via the engines Virtual Database module i.e., you can build powerful RDF Views over ODBC- or JDBC- accessible data using Virtuoso. These view also have the option of being materialized etc..
Yes, but the way the data are stored now is JSON blob within a text field in MySQL. I do not see how RDF View over ODBC would help it any - of course Virtuoso would be able to fetch JSON text for a single item, but then what? We'd need to run queries across millions of items, fetching and parsing JSON for every one of them every time is unfeasible. Not to mention this JSON is not an accurate representation of the RDF data model. So I don't think it is worth spending time in this direction... I just don't see how any query engine could work with that storage. -- Stas Malyshev smalyshev@wikimedia.org
The point I am trying to make is that Virtuoso can integrate data from external DBMS systems in a variety of ways.
ODBC and JDBC are simply APIs for accessing external DBMS systems.
What you really need here is a clear project definition and a discussion with us about how it would be implemented.
Despite the fact that Virtuoso is a hardcore DBMS, its also a hardcore Data Virtualization platform for handling relations represented in a variety of ways using a plethora of protocols.
I am email away if you want to explore this further.