Performance Characterization and Buffer Memory Optimization of Database

98 p.Thesis (Ph.D.)--University of Illinois at Urbana-Champaign, 2000.Past approaches to fine-granularity buffering have proposed buffering either data tuples alone or index entries alone. In this thesis, we propose a scheme to support fine-granularity buffering of both index and data entries in a unified manner. The scheme, which we call Hot-Entry buffering, can be used in combination with conventional page-level buffering. Through the experimental evaluation of a simple system, we demonstrate the benefits of our scheme over conventional page-level buffering, and over index-only and data-only fine-granularity buffering.U of I OnlyRestricted to the U of I community idenfinitely during batch ingest of legacy ETD