SSD is the new disk, disk is the new tape
Tim Bray has some very interesting performance numbers for storage systems.
There is this saying that memory is the new disk, disk is the new tape. I think we have to insert something there - SSD is the new disk, disk is the new tape, and memory is somewhere between the CPU cache and the SSD.
The problem is then, how to benefit from these enhancements. If you have ye olde database system, you could simply put all of the data on SSD. This will be fast, but quite a bit of a waste. DBMSes currently manage the cache hierarchy on their own, having a memory cache for the really hot data, a disk storage for the not-so-hot, and tapes for backups.
It would be really nice if the DBMS was aware of the wildly different seek times of SSDs and disks, and if it thus could manage this aspect of the storage hierarchy, too. Ideally, it would lazily remember which data was accessed recently, and move the old stuff to disk. For example, in everyones favorite running performance example - called “Twitter” - presumably next to no one cares about tweets that are older than a month or so, so you could move them to
This is again a good example of a change in requirements for databases which as it is now requires developers to implement the smarts themselves. Let’s hope databases will learn this…