Functional Partitioning
Learned in SE464.
One of two main ways to partition data across databases (the other is data partitioning, i.e., sharding).
Functional partitioning divides by tables. You create multiple databases that store different categories or types of data.
Example: three separate databases for accounts, orders, and customers.
Cons
- Limits queries that join rows across tables in different DBs
- Only a few functional partitions are possible; not highly scalable