Boosting Database Batch workloads using Flash Memory SSDs

Most of systems using a large DBMS have been using disk-based storages consisting of hard disk drives. Recently, flash memory storages have appeared, which have great advantages like low access latency, low power consumption, light weight and shock resistance. These flash memory storages have gradually been successes as an alternative storage of traditional hard disk drives. However, because it is still a big price gap between the hard disk and flash memory device, they're still using hard disk-based storages. Also systems to perform online transactions and batch jobs at the same time have performed batch jobs on a small online transaction time because of poor performance. Therefore, if we use flash memory devices and hard disk drivers with, it will be very efficient in terms of price, performance and reliability. In addition, it is possible to shorten the recovery time of DBMS. This paper proposes to move the REDO logs and ARCHIVE logs on flash memory storage device appropriately depending on the operating and working environments. By utilizing a small amount of flash memory devices, the performance of batch jobs has been increased to 40-80%, DBMS recovery time was reduced to 5-8%.