ODBC API contains set of ‘C’ language
functions.
ODBC API
|
SQL
connect();
SQL
disconnect();
SQL
execute();
SQL
fetch();
|
MS ODBC API functions
Once in the API’s released any body
can provide the implementation. The implementation is called as ODBC software
or ODBC Driver.
|
MS ODBC
API
|
|
XYZ
Company ODBC IMP
|
|
MS ODBC
IMP
|
|
LINUX
ODBC IMP
|
MS ODBC DRIVER LINUX ODBC DRIVER XYZ ODBC DRIVER
The following Architecture of ‘C’ program which uses
ODBC API.
|
ODBC
Driver
(Actual
code to interact with any database)
|
|
SQL
connect()
SQL
disconnect()
SQL
execute()
|
C
Programming code
|
IBM DB2
|
|
SYBASE
|
|
MYSQL
|
|
ORACLE
|
DB Server DB Server DB Server DB Server
Sun
Micro System released JDBC API to develop a java program to communicate with
any database server without changing the java code.
The
database server stores the data into files. These files are called as DBF
files.
|
Client
Program
|
|
Oracle
DB Server
|
|
DBF files
|
When the client and the database
server. Server takes the request and encrypts the data and store the data into
DBF files. If required the server program reads the data from DBF files and
decrypt the data and send to the clients.
Oracle
database server released in the form of two versions. They are:
1.
Enterprise edition (XE)
2.
Express edition
As
part of enterprise edition the service name port number of database server are
fixed. They are
Service Name: XE
Port No: 1521
The following Architecture of JDBC
Applications.
|
Java
Application
|
|
JDBC
Driver
|
|
DB
Server
|
0 comments:
Post a Comment