Patent ID: 8224813

Claim:
A computer-implemented method of cost based analysis for fetching data in a database management system, comprising: identifying data to fetch; in response to the act of identifying the data to fetch, determining a first cost for a direct I/O storage access and a second cost for a cache access; performing, by using a processor, a comparison between the first cost and the second cost; fetching a first portion of the data based at least in part upon the comparison, in which a determination is made for whether a cache access to read a first portion of the data should be performed, and if the determination is made that the first portion of the data should be read without the cache access to read the first portion of the data, then performing direct I/O storage access to read the first portion of the data without looking up the data in the cache; and storing the first portion in a volatile or non-volatile computer usable medium or displaying the first portion on a display device.