Client and Web Applications - Design and Use of Relational Databases in Chemistry - page 40

Linux server Laptop client

Web
browser

Apache PHP

PostgreSQL
Oracle
MySql

application
ODBC, JDBC

psql, plsql, mysql

telnet

Figure 5.2 A typical client-server installation for an RDBMS.

Figure 5.3 Excel Data/Get External Data/New Database Query.

PgAdmin are available to be run on Linux, Windows, Mac, and other cli-
ents. Oracle users typically use Oracle's SQL Developer or Toad (Toad also
works with MySQL). SQL Developer 4 is a Java application that uses JDBC
to mediate the communication to the database. A typical user need not
be concerned with this, but a later chapter of this topic discusses ways to
construct new client applications using JDBC, ODBC, and other methods
to communicate with the RDBMS. Toad is a Windows only application
with a free version and a full-featured pay version. 5
It is also possible to use Excel to select data from an RDBMS using
ODBC. The ODBC connection is first set up using the server name, database
name, and user login information. Then a dialog window is used to select
the desired rows and columns from the database. The returned values are
inserted into the Excel table. Figure 5.3 show a sample session using Excel to