Relational Database Management Systems - Design and Use of Relational Databases in Chemistry - page 35

4.5 Compatibility
There are many client programs available that allow one to access data in
an RDBMS. Some work properly only with one particular RDBMS, while
others strive for compatibility various RDBMS. Sometimes there are dif-
ferent versions of the same program, each intended for use with a differ-
ent RDBMS. Many computer languages have modules that allow access to
data in an RDBMS. Most have modules that include an abstraction layer
that allows programming without regard to the exact RDBMS being used.
An underlying layer then implements the particulars of interfacing with
each RDBMS. These issues are discussed more fully in Chapters 5 and 12,
along with examples using various computer languages.
References
1. Fermilab Computing Division. 2005. Comparison of Oracle, MySQL and
PostgreSQL DBMS. http://www-css.fnal.gov/dsg/external/freeware/
mysql-vs-pgsql.html (accessed April 21, 2008).
2. O'Donnell, T.J. 2005. CHORD extension to PostgreSQL. http://www.gnova.
com (accessed April 21, 2008).
3. Schmid , E. 2004. Pgchem::tigress extension to PostgreSQL. http://pgfoundry.
org/projects/pgchem/ (accessed April 21, 2008).
4. Landrum, G. 2006. RDKit: Cheminformatics and Machine Learning Software.
http://rdkit.sourceforge.net/ (accessed April 22, 2008).
5. Daycart. 2008. http://www.daylight.com (accessed April 21, 2008); Jchem car-
tridge. http://www.chemaxon.com (accessed April 21, 2008); CambridgeSoft
Oracle cartridge. http://www.cambridgesoft.com (accessed April 21, 2008);
MDL Isentris. http://www.symyx.com (accessed April 21, 2008)
6. Kumar, T. 2005. Small molecules database cartridge. http://www.unm.
edu/~tharun/smdb.html (accessed April 21, 2008).
7. Kline, K. 2004. SQL in a Nutshell, 2nd Edition , Sebastopol, CA: O'Reilly.
8. PostgreSQL 8.2 documentation. 2008. C-language functions. http://www.
postgresql.org/docs/8.2/static/xfunc-c.html (accessed April 21, 2008).