Sorting
Illustrates the difference in algorithm design when your data is not in main memory:
- Problem: sort 1Gb of data with 1Mb of RAM.
Arises in many places in database systems:
- Data requested in sorted order (ORDER BY)
- Needed for grouping operations
- First step in sort-merge join algorithm
- Duplicate removal
- Bulk loading of B+-tree indexes.