The Essentials Series: Optimizing Database Connection Performance

by Mark Scott


Database connections are the lifeblood of enterprise applications, administrating the secure and steady flow of information between corporate applications and their persistent relational databases. Optimizing these connections can usher in widespread improvements in information management and improvements in server and network resource utilization.

The Essentials Series: Optimizing Database Connection Performance examines the architecture, resource utilization and scalability of the three most prevalent database connection technologies: Managed .Net, Open Database Connectivity and Java Database Connectivity. It examines the common point of optimization these technologies share and highlights the distinctive challenges that each technology faces to optimize the vital flow of information with the enterprise. These expert articles will help developers, software architects, IT professionals and technologist decipher the characteristics they require for their enterprise database connectivity requirements and provide a critical frame work for making informed choices when choosing and implementing database connectivity software.


Article 1: Managed .NET Connectivity

This article discusses the architectural distinctives of a well-designed .Net connectivity product. It looks at the features required to minimize resource utilization on the host system and provide optimal scalability within an enterprise ecosphere.

Article 2: Open Database Connectivity

This article looks at the characteristics of a efficient, well designed ODBC driver suites, such as communication strategies and compiled architectures. It addresses key areas of resource optimization in memory, cpu utilization and network bandwidth. It helps the reader consider the challenges of enterprise scalability.

Article 3: Java Database Connectivity

This article looks at JDBC drivers from the aspect of their ability to reach the full potential of their promise. It exposes the key factors that help a JDBC driver provide a full range of functionality and optimal performance while still managing on lean requirements of a constrained server environment. It discusses how to measure performance in terms of real world performance found in real production environments.