Affordable Access

Publisher Website

Generic Database Cost Models for Hierarchical Memory Systems-Chapter 18

DOI: 10.1016/b978-155860869-6/50025-1
  • Computer Science


Publisher Summary This chapter proposes a generic technique to create accurate cost functions for database operations. Accurate prediction of operator execution time is a prerequisite for database query optimization. Although extensively studied for conventional disk-based DBMSs, cost modeling in main memory DBMSs is still an open issue. Recent database research has demonstrated that memory access is more and more becoming a significant—if not the major—cost component of database operations. If used properly, fast but small cache memories—usually organized in cascading hierarchy between CPU and main memory—can help to reduce memory access costs. However, they make the cost estimation problem more complex. Database cost models provide the foundation for query optimizers to derive an efficient execution plan. Such models consist of two parts, a logical and a physical component. The former is geared toward estimation of the data volumes involved. Usually, statistics about the data stored in the database are used to predict the amount of data that each operator has to process. The underlying assumption is that a query plan that has to process less data will also consume less resource and/or take less time to be evaluated. The logical cost component depends only on the data stored in the database, the operators in the query, and the order in which these operators are to be evaluated (as specified by the query execution plan). Hence, the logical cost component is independent of the algorithm and/or implementation used for each operator.

There are no comments yet on this publication. Be the first to share your thoughts.