28-08-2013, 02:28 PM
Database Management
Database Management.ppt (Size: 931 KB / Downloads: 21)
A database is a collection of related information and a DBMS is a software that provides you with a mechanism to retrieve, modify and add to the database. There are many DBMS/RDBMS products available.
eg- MS-Access, MS-SQL Server, Oracle, Sybase, Informix, Progress and Ingres.
Database Connectivity
Any application to communicate with the database, it needs to
have the following information:
The RDBMS/DBMS product using which database is created.
The location of the database.
The name of the database.
Here you could able to work with only one kind of database and difficult to code.
The above problem is solved by Microsoft’s standard for communication using Open Database Connectivity(ODBC).
JDBC consists of two parts :
-JDBC API, a purely
Java-based API
-JDBC Driver Manager, which communicates with
--Vendor-specific drivers that perform
the real communication with the
database.
--Point : translation to vendor format is
performed on the client
-No changes needed to server
-Driver needed on client
Database Management.ppt (Size: 931 KB / Downloads: 21)
A database is a collection of related information and a DBMS is a software that provides you with a mechanism to retrieve, modify and add to the database. There are many DBMS/RDBMS products available.
eg- MS-Access, MS-SQL Server, Oracle, Sybase, Informix, Progress and Ingres.
Database Connectivity
Any application to communicate with the database, it needs to
have the following information:
The RDBMS/DBMS product using which database is created.
The location of the database.
The name of the database.
Here you could able to work with only one kind of database and difficult to code.
The above problem is solved by Microsoft’s standard for communication using Open Database Connectivity(ODBC).
JDBC consists of two parts :
-JDBC API, a purely
Java-based API
-JDBC Driver Manager, which communicates with
--Vendor-specific drivers that perform
the real communication with the
database.
--Point : translation to vendor format is
performed on the client
-No changes needed to server
-Driver needed on client