计算机工程与设计
計算機工程與設計
계산궤공정여설계
Computer Engineering and Design
2015年
10期
2706-2711
,共6页
闪存硬盘%随机读%随机写%顺序读%顺序写%表%索引
閃存硬盤%隨機讀%隨機寫%順序讀%順序寫%錶%索引
섬존경반%수궤독%수궤사%순서독%순서사%표%색인
flash disk%random read%random w rite%sequential read%sequential w rite%tables%indexes
在闪存硬盘和磁性硬盘组成的混合存储系统中，针对现有方法仅考虑存储介质的差异，没有考虑顺序读、顺序写、随机读和随机写4种访问操作对数据库系统性能贡献不同的问题，提出一种加权放置数据库对象的方法。区分不同的操作在不同存储介质上的差异，根据负载的不同赋予4种操作在性能提升上不同的权重，充分利用存储设备的性能优势和最大化性能提升为目标选择数据库对象的放置。以T PC‐C作为负载的实验结果表明，与现有的方法相比，该方法能提升数据库系统的性能并延长闪存硬盘的寿命。
在閃存硬盤和磁性硬盤組成的混閤存儲繫統中，針對現有方法僅攷慮存儲介質的差異，沒有攷慮順序讀、順序寫、隨機讀和隨機寫4種訪問操作對數據庫繫統性能貢獻不同的問題，提齣一種加權放置數據庫對象的方法。區分不同的操作在不同存儲介質上的差異，根據負載的不同賦予4種操作在性能提升上不同的權重，充分利用存儲設備的性能優勢和最大化性能提升為目標選擇數據庫對象的放置。以T PC‐C作為負載的實驗結果錶明，與現有的方法相比，該方法能提升數據庫繫統的性能併延長閃存硬盤的壽命。
재섬존경반화자성경반조성적혼합존저계통중，침대현유방법부고필존저개질적차이，몰유고필순서독、순서사、수궤독화수궤사4충방문조작대수거고계통성능공헌불동적문제，제출일충가권방치수거고대상적방법。구분불동적조작재불동존저개질상적차이，근거부재적불동부여4충조작재성능제승상불동적권중，충분이용존저설비적성능우세화최대화성능제승위목표선택수거고대상적방치。이T PC‐C작위부재적실험결과표명，여현유적방법상비，해방법능제승수거고계통적성능병연장섬존경반적수명。
In the hybrid storage systems with a combination of both flash and magnetic disks ,aiming at the problems that the existing method only considers differences of storage media which fails to consider different contributions made by four access operations including sequential read ,sequential write ,random read and random write for database systems performance ,a weighted place‐ment method for database objects was presented .The distinction was made between different operations on different storage media ,according to the different loads ,four operations different weights were given to the performance increase and the database object placement was selected with a goal of making full use of performance advantages of storage devices and maximized per‐formance increase .TPC‐C was used as a load in experiments .Experimental results show that compared with the existing me‐thod ,the method can enhance the performance of database system and prolong the life time of flash disks .
