Buffer Management Tuned to Database Access Behavior

• Item type: JInfP(1)
• 公開日: 1981-11-05
• タイトル: Buffer Management Tuned to Database Access Behavior
• タイトル / 言語: en
• タイトル: Buffer Management Tuned to Database Access Behavior
• 言語: eng
• 資源タイプ / 資源タイプ識別子: http://purl.org/coar/resource_type/c_6501
• 資源タイプ: journal article
• 著者所属: C & C Systems Research Laboratories Nippon Electric Co. Ltd.
• 著者所属: C & C Systems Research Laboratories Nippon Electric Co. Ltd.
• 著者所属(英): en
• 著者所属(英): C & C Systems Research Laboratories, Nippon Electric Co., Ltd.
• 著者所属(英): en
• 著者所属(英): C & C Systems Research Laboratories, Nippon Electric Co., Ltd.
• 著者名: Mamoru, Umemura; Katsuya, Hakozaki
• 著者名(英): Mamoru, Umemura; Katsuya, Hakozaki
• 論文抄録 / 内容記述タイプ: Other
• 論文抄録 / 内容記述: A database buffer management method tuned to database access behavior is described. Generally buffer management takes advantage of access locality. However it is anticipated that database access has little locality. Therefore database buffer management should be somewhat different from that of virtual memory systems. In this paper at first the measurement results on real database access environment are described. Then the results are analyzed and characteristics for database access behavior are extracted. The examined characteristics suggest that it is not efficient to give databases large buffer spaces in addition the buffer size should be determined according to individual application program access patterns. Following this fact a new database buffer management method is proposed which determines the buffer size given to individual program depending on each program access behavior. By the proposed method I/O device access frequency can be limitted or lowered to a low value using small database buffer space as compared to a conventional method. The I/O frequency reduction leads to a great performance improvement even if the degree of reduction is small because the access time gap between I/O device and main-memory is great. The proposed method can be efficiently applied to back-end type database machines.
• 論文抄録(英) / 内容記述タイプ: Other
• 論文抄録(英) / 内容記述: A database buffer management method tuned to database access behavior is described. Generally, buffer management takes advantage of access locality. However, it is anticipated that database access has little locality. Therefore, database buffer management should be somewhat different from that of virtual memory systems. In this paper, at first, the measurement results on real database access environment are described. Then, the results are analyzed and characteristics for database access behavior are extracted. The examined characteristics suggest that, it is not efficient to give databases large buffer spaces in addition the buffer size should be determined according to individual application program access patterns. Following this fact, a new database buffer management method is proposed, which determines the buffer size given to individual program depending on each program access behavior. By the proposed method, I/O device access frequency can be limitted or lowered to a low value using small database buffer space as compared to a conventional method. The I/O frequency reduction leads to a great performance improvement even if the degree of reduction is small, because the access time gap between I/O device and main-memory is great. The proposed method can be efficiently applied to back-end type database machines.
• 書誌レコードID / 収録物識別子タイプ: NCID
• 書誌レコードID / 収録物識別子: AA00700121
• 書誌情報: Journal of Information Processing; 巻 4, 号 3, p. 142-146, 発行日 1981-11-05
• ISSN / 収録物識別子タイプ: ISSN
• ISSN / 収録物識別子: 1882-6652
• 出版者 / 言語: ja
• 出版者: 情報処理学会