SGER: Flash Memory DBMS for Transactional Database Applications

SGER：用于事务数据库应用程序的闪存 DBMS

• 批准号: 0848503
• 负责人: Bongki Moon
• 金额: $ 14万
• 依托单位: University of Arizona
• 依托单位国家: 美国
• 项目类别: Standard Grant
• 财政年份: 2008
• 资助国家: 美国
• 起止时间: 2008-09-01 至 2010-02-28
• 项目状态: 已结题
• 来源: https://www.nsf.gov/awardsearch/showAward?AWD_ID=0848503&HistoricalAwards=false
• 关键词: SGER; Flash; Memory; DBMS; Transactional

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).

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