Type 4 driver is a pure java driver because it completely eliminates the translation process. JDBC is Java based technology and with the driver also written in Java it can directly invoke the driver program as if it were any other Java program. This is the driver that all the J2EE applications use to interact with databases. Because this is a Java to Java interaction this driver offers the best performance.
There are 4 types of drivers 1.JDBC-ODBC Bridge Driver (Type1) 2.Partially native and partially java driver (Type2) 3.Intermediate database access Driver server (Type3) 4. Pure java Driver. (Type4)
Connection sharing supported by the LDAP service provider is called connection pooling. When the instance is done with the connection or closed Then the connection returned to Pool for future use. Available for other resources.
Connection pooling is a technique of creating and managing a pool of connections that are ready for use by any thread that needs them and generally leads to more predictable resource usage under load.
Connection pooling greatly increases the performance of applications while reducing overall resource usage.
Database normalization sometimes referred to as canonical synthesis is a technique for designing relational database tables to minimize duplication of information and in so doing to safeguard the database against certain types of logical or structural problems namely data anomalies.
