July 2024
Intermediate to advanced
306 pages
7h 3m
English
Databases are a key component of large software systems. These systems constantly retrieve and update data using database connections and queries. The scale of data in modern systems is extremely large, resulting in more data to query, update, and display. This increased scale can result in negative performance issues for our Java application, underscoring the significance of ensuring our databases and queries are optimized.
This chapter examines critical database design concepts, including database schemas, indexing strategies, and data partitioning techniques. Database queries are also examined, with a specific focus on Structured Query Language (SQL) queries. Our coverage of query optimizations ...
Read now
Unlock full access