DOMAIN APEX
   job order image NAK-CSO
Home

XSQL

20 Fruits, 4707 公元 Thu 23:10:30 EDT

XSQL, in my space, means my unified relational database abstraction. Today, I reviewed what remains of the original mentioned below. Of the Smalltalk code only the module currently on the code samples section remains. The C code of the XSQLDBMS CLI with the cursor caching feature was salvaged and may be restored in a new XSQL, not sure. If I do resurect the XSQL Browser will code from scratch in Squeak. Probably could¹ find the complete Smalltalk/V sources of the original but with both it and the C code, even if it weren't for the dependencies on OS/2, AS/400, and Smalltalk/V 16 years is just too long, and everything will need to be rewritten with at most guidance from some of my original C code and reimplementation of the key concepts.
¹Did find 10 days later and intend to eventually put in public source archives.

c. 4700


The Original ST/V OS/2 based XSQL Browser
(Click on thumbnails for full size screen images)

Ancient XSQL
c. 4691

Historical Context

There is more than one project by this name ...

Three of these are of interest here:

  1. That of Kifer, Kim, and Sagiv published in SIGMOD 92. This effort has theoretic import, but didn't result in any implementations. Although I subscribed to SIGMOD before ACM compeleted it's digitization, I think SIGMOD 92 would have been in a gap in my stacks and I don't remember seeing it until recently on the ACM web site.

  2. The line of development we began about the same time which was all implementation in Smallktalk-V (OS/2 Version) and IBM RDBMS (now as then called DB/2, except on AS/400 which OS/400 presents as one big relational database).

    The components were:

    1. the XSQL Browser, a developer oriented Smalltalk app which was a generic interface to ...

    2. a common simplified cacheing CLI library (XSQLDBMS). This was originally compatible with the Q+E, (AKA DataDirect, now InterSolv, I think) libraries. The main feature was the cursor caching mechanism which could dramatically improve performance in typical client server apps.

    3. DMBS specific drivers, mostly for IBM RDBMS, (AS/400 PC Support Remote SQL, DB2/DDCS, etc). This was pre or early ODBC and long before JDBC.

  3. The nominal X project which is simply a packaging context for our integration and extension of K/RDBMS packages and projects.
I have also seen something called XSQL in Oracle 8 about which I know nothing (the pkg, not Oracle), but which probably has nothing to do with any of the above.

c. 4704
Login Nodelet
Login:
Password

No account?
Create a new user
Forgot password?

Other Users
Other domain users:
no users logged in
workspace info
4722 黄帝紀年 C 月
14 Sat 01:42:36 UTC

Not in workspace

  Maintained by root 
American Kybernetik,  1994,2004,2013,2019