In this blog let us take a look at different types of Client Applications.
Three Tire Architecture
These days, it is common to have three tier architecture where there will be a Web Server facing the users.
The web server will interact with the Application Software and serve the web-enabled portion of the application as web pages. The application server will interact with the database server.
In some cases the Application Host runs both the Application Software as well as the Web Server software, which is the http server. Since I am calling the Accounting Software as a client, let me address this Database Client piece as Database Driver. So it is database driver now.
Now let us take look at various type of Database Clients available.
JDBC – Oracle Java Database Connectivity
If the Application is Java based, then it can use the Oracle Java Database Connectivity Driver also known as JDBC driver. This enables JAVA programs to send SQL statements to RDBMS systems such as Oracle Database.
OCI – Oracle Call Interface Driver
Or if the Application is C based application, then it can use the Oracle Call Interface Driver also known as OCI driver. This enables C programs to access Oracle Databases.
OCCI – Oracle C++ Call Interface Driver
Or if the Application is C++ based object-oriented application, then it can use the Oracle C++ Call Interface Driver also known as OCCI driver. This enables C++ programs to access Oracle Databases.
ODBC – Open Database Connectivity Driver
If the Application is ODBC based, then it can use the Open Database Connectivity Driver, also known as ODBC driver.
ODBC stands for Open Database Connectivity.
ODBC is designed to make applications independent of the Databases and Operating Systems, allowing them to be easily ported to different systems. And so they can access various data sources such as Spread Sheets, Comma Delimited files etc.
Pro C/C++ Precompiler
Or if you use, Pro C/Pro C++, you can then use Pro C/C++ precompiler.
This will allow you to insert the SQL codes within the source program. Then during the compilation, it will transform those SQLs into standard Oracle runtime calls.
If you use ProCOBOL, then you can use ProCOBOL precompiler. It will do the similar function as described above.
Oracle APEX – Oracle Application Express
Or you can create Web based applications using Oracle Application Express, which also called as APEX.
You can also use Hypertext, which is a server-side scripting language for Web based applications.
Microsoft .NET Framework
Oracle supports Microsoft’s .NET framework through various tools such as ODP.NET – Oracle Data Provider for .NET, ODT – Oracle Developer Tools for Visual Studio, .NET Stored Procedures, Oracle Providers for ASP.NET.