Database Connections and Connection Pooling

preview_player
Показать описание
A database connection allows client software to talk to database server. A connection pool is a cache of database connections maintained so that the connections can be reused when future requests to the database are required.

Database connections and connection pooling allow us too:
* Exchange data in both directions between a DBMS and an application program.
* Manage relationships in DBMS and how they translate into the programming languages in memory model.
* Manage differences in data type between programming language and SQL
* Increase system performance by decreasing overhead for CPU and memory by managing a connection pool.

Here are the videos broken down by topic in this series

Book used in this course: Garcia-Molina, Hector. Database systems: the complete book. Pearson Education India, 2008.
Рекомендации по теме
Комментарии
Автор

This is a great talk! Realized you have a whole playlist about databases. Definitely going to check it out.

roman_mf
Автор

This is really good! Your points on SQL are interesting, as you see the emergence of tools like DBT

pietergeerlen
Автор

Damn, this talk is gold, can't believe you only have 1k views and 23 likes... Anyways, thank you!

myspace
Автор

31:50 - Why not doing a try with resource on the Statement and ResultSet ?

Gitalien
Автор

Do you have any examples on to scale databases ? And performance

Cognitoman
Автор

Hi, Just found your channel. Thank you for this discussion. When you mention "the book", which book are you referencing?

BlvkIsMyVibe