ODBC support for BaseX?
Friday, 20 May 2022 · 7 messages
ME
Markus Elfring20 May 2022 10:56 #
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
MH
Martin Honnen20 May 2022 12:11 #
Quoted text · Markus Elfring · 7 lines
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?
ME
Markus Elfring20 May 2022 12:27 #
Quoted text · Martin Honnen · 6 lines
> > 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
EF
ETANCHAUD Fabrice20 May 2022 13:12 #
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 Documentation<https://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
Quoted text · BaseX-Talk · 17 lines
De : BaseX-Talk <basex-talk-bounces at mailman.uni-konstanz.de> de la part de Markus Elfring <Markus.Elfring at web.de> Envoyé : vendredi 20 mai 2022 12:27 À : Martin Honnen <martin.honnen at gmx.de>; basex-talk at mailman.uni-konstanz.de <basex-talk at 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
MS
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
Quoted text · BaseX-Talk · 17 lines
Von: BaseX-Talk <basex-talk-bounces at mailman.uni-konstanz.de> im Auftrag von Markus Elfring <Markus.Elfring at web.de> Datum: Freitag, 20. Mai 2022 um 12:28 An: Martin Honnen <martin.honnen at gmx.de>, basex-talk at mailman.uni-konstanz.de <basex-talk at 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
ME
Markus Elfring20 May 2022 14:12 #
Quoted text · Michael Seiferle · 1 line
> 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
IL
Imsieke, Gerrit, le-tex20 May 2022 14:37 #
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.
Quoted text · Markus Elfring · 11 lines
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
Written for BaseX 9.7. BaseX may have changed since: please check the current documentation.
⚡Generated with XQuery