首页 > 其他 > 详细

he time that it takes to bring a block from disk into main memory

时间:2016-12-20 20:33:20      阅读:227      评论:0      收藏:0      [点我收藏+]

DATABASE SYSTEM CONCEPTS, SIXTH EDITION

There is a trade-off that the system designer must make between access time
and space overhead. Although the decision regarding this trade-off depends on
the speci?c application, a good compromise is to have a sparse index with one
index entry per block. The reason this design is a good trade-off is that the
dominant cost in processing a database request is the time that it takes to bring
a block from disk into main memory. Once we have brought in the block, the
time to scan the entire block is negligible. Using this sparse index, we locate the
block containing the record that we are seeking. Thus, unless the record is on an
over?ow block (see Section 10.6.1), we minimize block accesses while keeping
the size of the index (and thus our space overhead) as small as possible.

 

he time that it takes to bring a block from disk into main memory

原文:http://www.cnblogs.com/yuanjiangw/p/6204052.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!