Prepared Statements, Connection Pooling, Sharding, Partitioning and Serverless Workloads with Oracle Database
airhacks.fm podcast with adam bien
00:00
Database Parsing and Sharding Dynamics
This chapter examines the differences between hard and soft parsing in database operations, focusing on query optimization and caching mechanisms. It discusses the intricacies of sharding and partitioning in various databases, including Oracle, NoSQL databases, and their impact on data management practices. Additionally, the chapter highlights the evolutionary journey of data organization techniques, such as 'group changing' and the relevance of historical systems like Berkeley DB.
Transcript
Play full episode
