Feature #95

IDEA - Universal SQL sub-system

Added by Madars Vitolins over 1 year ago. Updated 3 months ago.

Status:NewStart date:02/04/2017
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:-
Target version:-

Description

It could be possible to send queries to some XATMI server with standard UBF and receive responses from database. For example, we could send:

EX_DB_QUERY ="select data1, data2, data3 from sometable where data4=:EX_DB_COL1"
EX_DB_COL1="abc"

tpcall("SQLSRV"...)

on response we could get:
EX_DB_COL1=data1
EX_DB_COL2=data2
EX_DB_COL3=data3
EX_DB_RESULT=0 (succeed, or DB code/mapped)

The support for XA transactions will come out of the box.

The target driver could use java jdbc system. We could offer using standard dialect, for example https://blog.jooq.org/2013/09/09/crazy-translations-of-simple-sql-expressions-to-various-sql-dialects/ so that developer could use one language for any of the databases.

Some kind of clustering also could be possible with making journal logs and pushing the changes to DBs later... (just idea).

ldbc.jar (273 KB) Madars Vitolins, 04/27/2018 01:57 PM

ldbc.zip (504 KB) Madars Vitolins, 04/27/2018 01:57 PM

ldbc-doc.7z (26.4 KB) Madars Vitolins, 04/27/2018 02:00 PM

History

#1 Updated by Madars Vitolins 10 months ago

Then for this case we will need XA driver which will keep the transaction in ATMI context (maybe internal driver/switch symbol). Thus we can run transaction in full multi-thread/go-routine mode and still be in global transactions. And the Java end will roll the transactions with JDBC.

#3 Updated by Madars Vitolins 3 months ago

Would have option for multiple database replication. One database would be primary, and second db would be replicated via journal files.

Also available in: Atom PDF