Several comments I have read leads me to think many of you have made the
change to Eloquence to reduce code changes.
You can implement an RDBMS without changing the DBGET's to SQL.
We have a piece that sits between the program and the RDBMS to intercept
the database calls, convert them to the appropriate SQL calls to the
RDBMS.
I think there are a couple of others out there who do this as well.
We built it because of the simple fact many shops want to go to SQL
Server or Oracle. But the amount of code changes to go native SQL code
would be massive.
The product is called the Transoft Data Access Module (TDAM).
Robert Collins
U.S. Sales Consultant
Transoft, Business Solutions Division
Computer Software Group plc
2000 Riveredge Pkwy, Ste 450
Atlanta, GA 30328
Phone #: 706-265-4110
Cell #: 770-789-1462
fax #: 706-265-1621
www.transoft.com www.computersoftware.com
-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On
Behalf Of Jerry Finn
Sent: Friday, March 03, 2006 4:46 AM
To: [log in to unmask]
Subject: Re: [HP3000-L] Migration recommendations; PRELIMINARY INQUIRY
> -----Original Message-----
> Behalf Of Mark Wonsil
...
> The term relational comes from relational mathematics, i.e. set
> theory. This is why there are union and intersection (join)
functions.
...
> ImageSQL *is* an SQL interface for Image, so Adam's point stands that
> having an SQL interface does not a relational database make.
Excellent summary Mark.
Although SQL does not make a relational database, its development is
closely linked, and I think that's why they are confused so often. The
best explanation I've read of what a relational database is and how it
was derived from set theory was published in a series of articles from
Intelligent Enterprise magazine. Which starts at the link below
http://www.intelligententerprise.com/db_area/archives/1998/9810/feat4.jh
tml
At the link below it finally gets into how Edgar F Cobb wanted to
translate set theory in a computer language called Data Sublanguage
Alpha. It was never implemented but it provide the basis for SQL.
http://www.intelligententerprise.com/db_area/archives/1999/991602/online
2.jhtml
Jerry Finn
The Migration Factory
IBM Corporation
11400 Burnet Rd.
Austin, TX 78758
http://www-1.ibm.com/servers/eserver/migration/
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|