Archiving and purging old data In the end, if you want to seriously reduce the effective size of a database (after using all innovations on the infrastructure level) is to move data out of the database on to something else.…
Information Lifecycle Management and Oracle databases – part 2
Database compression Another technique that Oracle has improved as of version 11g is compression. In versions up to 10g you could only compress an entire table, and after that, random performance on a compressed table was poor. It…
Information Lifecycle Management and Oracle databases – part 1
This is an article I wrote a while ago (late 2009), a while after EMC introduced Enterprise Flash Drives (EFD’s). Although more tooling is available these days to automate the tiering of storage, the basic concepts are still very valid,…
Innovation with Flash Drives – part 2
Energy Efficiency of Flash Here is a comparison of power consumption of various current drive types: This picture shows the amount of energy to store 1 Terabyte of information. As this would only require one 1-Terabyte SATA drive, this is…
Innovation with Flash Drives – part 1
This is an article I wrote a while ago (mid 2009), a while after EMC introduced Enterprise Flash Drives (EFD’s) and albeit a bit outdated, it is a valid introduction to Enterprise Flash Drive technology. It also explains the differences…