SGER: Flash Memory DBMS for Transactional Database Applications

闪存存储设备被认为是一种具有巨大潜力的新型存储介质，可以取代磁盘。然而，闪存存储器具有其自身的限制，例如更新前擦除，并且对于以随机顺序请求的小到中等大小的写入表现出较差的性能。该项目的目标是开发新的闪存感知设计和优化策略，使大型事务数据库应用程序能够在配备闪存存储设备作为主要存储介质的计算平台上高效运行。该项目通过以下方式实现其目标：（1）分析闪存上不同I/O工作负载的性能影响，以及闪存对数据库中不同类型表空间的适用性，（2）发明新的范例、设计、数据结构和算法、热点分离和写入优化技术，本项目的研究成果不仅可以克服闪存的局限性，而且可以利用闪存的优势，所开发的范例和处理策略可以应用于其他领域，例如需要在闪存存储系统上进行数据管理的基于健康护理和传感器网络的环境研究。该项目的调查结果和可交付成果将通过项目网站（http：//www.cs.arizona.edu/projects/fmdb）以软件包、研究文章、技术报告和数据集的形式广泛传播。

Flash memory storage devices are now considered to have tremendous potentialas a new storage medium that can replace magnetic disks. Flash memory, however, has its own limitations such as erase-before-update and exhibits poor performance for small-to-moderate sized writes requested in a random order. The goal of this project is to develop new flash-aware designs and optimization strategies that allow large-scale transactional database applications to run efficiently on computing platforms equipped with flash memory storage devices as a main storage medium. This project achieves its goal by (1) analyzing the performance implications of different I/O workloads on flash memory, and the applicability of flash memory to different types of tablespaces in databases, (2) inventing new paradigms, designs, data structures and algorithms, hot spot separation, and write optimization techniques, so that enterprise database servers can run on the target computing platforms efficiently.The findings from this project will not only overcome the limitations of flash memory but also exploit the advantages of flash memory for transactional database workloads exhibiting randomly scattered data access patterns.The paradigms and processing strategies developed can be applied to other areas such as health-care and sensor-network based environment study that require data management on flash memory storage systems. The findings and deliverables of the project will be disseminated broadly in the form of software packages, research articles, technical reports, and data sets via the project web site(http://www.cs.arizona.edu/projects/fmdb).