Thursday, May 25, 2017
Home > Learn SQL > Oracle SQL Developer Tutorial For Beginners – 06 – Types of Clients

Oracle SQL Developer Tutorial For Beginners – 06 – Types of Clients

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.

Three Tier Architecture

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

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

OCI - Oracle Call Interface

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

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

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

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.

ProCOBOL precompiler

ProCOBOL precompiler

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 SQL Development For Beginners (53)

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.