Database Connections and Connection Pooling

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 Introduction and Client-Server: https://youtu.be/S6QaNMIS14Q Software architectures: https://youtu.be/GL6B7wK2PKk Database Connections: https://youtu.be/jDk95_C5I1s (this video!) Prepared Statements and Avoiding SQL Injection: https://youtu.be/2eC8-9EnBPE his video is part of a full semester course given on databases and application integration: https://www.youtube.com/playlist?list=PL0_aoTs5sGaT_Wt2rVDcnADcHphvI40Co If you learning computer science, you might also find this playlist interesting where we explore exactly how your programs run on a real computer: https://www.youtube.com/playlist?list=PL0_aoTs5sGaRUsK_z3xe3_CjKtvRCD_HI Like this video and subscribe and would like to see more like it! https://www.youtube.com/channel/UC8fdekVhEilBTuBK322WjVw?sub_confirmation=1 Link to slides used in this presentation: https://drive.google.com/file/d/196ttNZbP7v4Evcz1AdlXqELmAC2ySWKP/view?usp=sharing Book used in this course: Garcia-Molina, Hector. Database systems: the complete book. Pearson Education India, 2008. https://www.amazon.com/Database-Systems-Complete-Book-2nd/dp/0131873253/ref=sr_1_2?crid=38MK4U2O16QLU&dchild=1&keywords=database+systems+the+complete+book%2C+2nd+edition&qid=1597852607&sprefix=database+systems+the+compl%2Caps%2C155&sr=8-2