Hello,
The software “BaseX” is providing direct support for document databases.
Is any support available for data management by interfaces like the following?
* Open Database Connectivity * Java Database Connectivity
How are corresponding drivers evolving?
Regards, Markus
Am 20.05.2022 um 10:56 schrieb Markus Elfring:
The software “BaseX” is providing direct support for document databases.
Is any support available for data management by interfaces like the following?
- Open Database Connectivity
- Java Database Connectivity
Are you just looking for https://docs.basex.org/wiki/SQL_Module?
Is any support available for data management by interfaces like the following?
- Open Database Connectivity
- Java Database Connectivity
Are you just looking for https://docs.basex.org/wiki/SQL_Module?
No. (Not for related use cases at the moment.)
This module is useful for accessing relational databases from XQuery using SQL.
I became curious also for data exchange in the other direction according to such a programming interface. Can any BaseX databases be represented as ODBC (or JDBC) data sources?
Regards, Markus
Hi Markus, I don't think basex provides such a thing, MarkLogic has something approaching : https://docs.marklogic.com/guide/sql SQL Data Modeling Guide — MarkLogic 10 Product Documentationhttps://docs.marklogic.com/guide/sql MarkLogic is the only Enterprise NoSQL Database. This guide includes the following chapters: SQL on MarkLogic Server; SQL on MarkLogic Server Quick Start docs.marklogic.com
What do you want to achieve ?
IMHO, you will not find a better solution than XQuery to transform xml/json documents. Couchbase (json) invented its own SQL based N1QL language... not sure this is a total success.
To obtain something similar to MarkLogic SQL with BaseX you could simply :
* define flat (tabular) views of your xml data in XQuery * export them to csv or json files * plug on these exports any SQL engine working directly on files (dremio?)
Best regards, Fabrice
________________________________ De : BaseX-Talk basex-talk-bounces@mailman.uni-konstanz.de de la part de Markus Elfring Markus.Elfring@web.de Envoyé : vendredi 20 mai 2022 12:27 À : Martin Honnen martin.honnen@gmx.de; basex-talk@mailman.uni-konstanz.de basex-talk@mailman.uni-konstanz.de Objet : Re: [basex-talk] ODBC support for BaseX?
Is any support available for data management by interfaces like the following?
- Open Database Connectivity
- Java Database Connectivity
Are you just looking for https://docs.basex.org/wiki/SQL_Module?
No. (Not for related use cases at the moment.)
This module is useful for accessing relational databases from XQuery using SQL.
I became curious also for data exchange in the other direction according to such a programming interface. Can any BaseX databases be represented as ODBC (or JDBC) data sources?
Regards, Markus
Hi Markus, Hi Martin,
as both JDBC and ODBC are SQL based or at least tailored for the relational database model (for all I know) I think it would be tedious to implement something that complies with those standards. And in the end, probably not very useful per-se, as we have XQuery for querying XML and while I like SQL for relational data I could not imagine me using it to query complex XML structures.
For the sake of completeness: there is a standard, XQJ, that is neither widely used nor under active maintenance http://xqj.net/ and only Supports XQuery 1.0. I don’t think you would want to use that.
I think a more modern and more document-resource-oriented approach to a standard API might be the https://de.wikipedia.org/wiki/Open_Data_Protocol and I once or twice thought about implanting it with RestXQ but I guess this would be full-time job 😊
Maybe I am missing the point, so it would be interesting to know more about your motivation 😊
Best Michael
Von: BaseX-Talk basex-talk-bounces@mailman.uni-konstanz.de im Auftrag von Markus Elfring Markus.Elfring@web.de Datum: Freitag, 20. Mai 2022 um 12:28 An: Martin Honnen martin.honnen@gmx.de, basex-talk@mailman.uni-konstanz.de basex-talk@mailman.uni-konstanz.de Betreff: Re: [basex-talk] ODBC support for BaseX?
Is any support available for data management by interfaces like the following?
- Open Database Connectivity
- Java Database Connectivity
Are you just looking for https://docs.basex.org/wiki/SQL_Module?
No. (Not for related use cases at the moment.)
This module is useful for accessing relational databases from XQuery using SQL.
I became curious also for data exchange in the other direction according to such a programming interface. Can any BaseX databases be represented as ODBC (or JDBC) data sources?
Regards, Markus
Maybe I am missing the point, so it would be interesting to know more about your motivation 😊
Report generators are available which can handle selected formats as data sources. https://en.wikipedia.org/wiki/List_of_reporting_software
The chosen formats influence how challenging or convenient the desired data processing would be for advanced reports and further data analyses.
Regards, Markus
My reporting software for XML is called XSLT. The XML data it processes is sometimes saved from an XQuery result. Or I invoke the transformation to HTML with https://docs.basex.org/wiki/XSLT_Module#xslt:transform-report directly from a RestXQ-annotated XQuery function.
On 20.05.2022 14:12, Markus Elfring wrote:
Maybe I am missing the point, so it would be interesting to know more about your motivation 😊
Report generators are available which can handle selected formats as data sources. https://en.wikipedia.org/wiki/List_of_reporting_software
The chosen formats influence how challenging or convenient the desired data processing would be for advanced reports and further data analyses.
Regards, Markus
basex-talk@mailman.uni-konstanz.de
-
ETANCHAUD Fabrice -
Imsieke, Gerrit, le-tex -
Markus Elfring -
Martin Honnen -
Michael Seiferle