| 基于固态硬盘数据库在OLTP应用中的优化研究 |
| |
| 引用本文： | 姜承尧,陈庆奎. 基于固态硬盘数据库在OLTP应用中的优化研究[J]. 计算机时代, 2010, 0(8): 37-39 |
| |
| 作者姓名： | 姜承尧 陈庆奎 |
| |
| 作者单位： | 上海理工大学光电信息与计算机工程学院,上海,200093 |
| |
| 摘 要： | 基于磁盘数据库系统的瓶颈主要在于磁盘速度。固态硬盘的出现，使磁盘的速度得到了极大的提高。传统的数据库底层设计主要面向磁盘I／O性能极低的传统机械硬盘。文章通过比较和分析固态硬盘的优势，提出了基于固态硬盘数据库的底层性能优化的方法。通过实验比较了基于固态硬盘数据库性能优化前后的差异。
|
| 关 键 词： | 数据库 固态硬盘 在线事务处理 优化 |
Research on SSD-based Database Optimization in OLTP Application |
| |
| JIANG Cheng-yao,CHEN Qing-kui. Research on SSD-based Database Optimization in OLTP Application[J]. Computer Era, 2010, 0(8): 37-39 |
| |
| Authors: | JIANG Cheng-yao CHEN Qing-kui |
| |
| Affiliation: | (School of Optical-Electrical Information and Computer Engineering, University of Shanghai for Science and Technology, Shanghai 200093, China) |
| |
| Abstract: | The bottleneck of disk-based database system mainly depends on the disk speed. The emergence of solid state drive （SSD） improves disk speed greatly. The traditional bottom layer design of database mainly aims at the traditional mechanical hard disks with very low I/O performance. Comparing and analyzing the advantages of SSD, the method for the bottom layer performance optimization of SSD-based database is presented. The differences of SSD-based database performance before and after optimization are compared by experiments. |
| |
| Keywords: | database solid state drive OLTP optimization |
| 本文献已被 维普 万方数据 等数据库收录！ |
