Flash Memory Database Systems and In-Page Logging.pptVIP

Flash News in the Market Sun Oracle Exadata Storage Server [Sep 2009] Each Exadata cell comes with 384 GB flash cache MySpace dumped disk drives [Oct 2009] Went all flash, saving power by 99% Google Chrome ditched disk drives [Nov 2009] SSD is the key to 7-sec boot time Gordon at UCSD/SDSC [Nov 2009] 64 TB RAM, 256 TB Flash, 4 PB Disks IBM hooked up with Fusion-io [Dec 2009] SSD storage appliance for System X server line Industry Response Common in Enterprise Class SSDs Multi-channel, inter-command parallelism Thruput than bandwidth, write-followed-by-read pattern Command queuing (SATA-II NCQ) Large RAM Buffer (with super-capacitor backup) Even up to 1 MB per GB Write-back caching, controller data (mapping, wear leveling) Fat provisioning (up to ~20% of capacity) Impressive improvement Question? For more Flash Memory work of Ours InLogging [SIGMOD’07] Logging, Sort/Hash, Rollback [SIGMOD’08] SSD Architecture and TPC-C [SIGMOD’09] InLogging for Indexes [CIKM’09] Even More? /~bkmoon Query details Transaction 1: full scan of C_STOCK table in serializable mode Run TPC-C workload for 240 sec and stop Transaction 1: re-scan of C_STOCK * * ASP: average selling price * * * * * * * KOCSEA’09, Las Vegas, December 2009 -*- *COMPUTER SCIENCE DEPARTMENT COMPUTER SCIENCE DEPARTMENT Flash Memory Database Systems and InLogging Bongki Moon Department of Computer Science University of Arizona Tucson, AZ 85721, U.S.A. bkmoon@ In collaboration with Sang-Won Lee (SKKU), Chanik Park (Samsung) Flash Talk COMPUTER SCIENCE DEPARTMENT COMPUTER SCIENCE DEPARTMENT Magnetic Disk vs Flash SSD Samsung FlashSSD 128 GB 2.5/1.8 inch Seagate ST340016A 40GB,7200rpm Champion for 50 years New challengers! Intel X25-M Flash SSD 80GB 2.5 inch COMPUTER SCIENCE DEPARTMENT Past Trend of Disk From 1983 to 2003 [Patterson, CACM 47(10) 2004] Capacity increased about 2500 times (0.03 GB ? 73.4 GB) Bandwidth improved 143.3 times (0.6 MB/s ? 86 MB/s) Latency improved 8.5 times (48.3 ms ? 5.7 ms) Year 1