The amount of data stored in relational databases is growing exponentially every year. Customers are collecting more data, and processing and retaining it for a longer amount of time. We, as database professionals, are working with databases that have become larger over time.
From a development standpoint, database size is not that critical. Non-optimized queries time out regardless of the database size. However, from a database administration standpoint, management of the large databases introduces additional challenges. Data partitioning helps to address some of these challenges.
In this chapter, we will discuss ...