Optimization of buffer pool sizes for data storage
Number of patents in Portfolio can not be more than 2000
United States of America Patent
Stats
-
Jan 20, 2009
Grant Date -
Dec 1, 2005
app pub date -
May 13, 2005
filing date -
May 14, 2004
priority date (Note) -
Expired
status (Latency Note)
Importance
Abstract
Sizes of buffer pools for temporarily storing data from a database are dynamically optimized. A database server includes: a dividing ratio setting unit for setting a dividing ratio for dividing a memory area of a predetermined size into a plurality of buffer pools used selectively according to a type of transaction or type of data; a response time measuring unit for measuring response time of transactions; a response time computation formula generating unit for calculating parameters of a response time calculation formula for calculating the response time based on the size of each of the plurality of buffer pools from the set dividing ratio and the measured response time; and a dividing ratio calculation unit for calculating the dividing ratio that minimizes the response time by using the response time calculation formula; wherein the dividing ratio setting unit sets the dividing ratio calculated by the dividing ratio calculating unit.
First Claim
Family
International Classification(s)
Cited Art Landscape
Patent Citation Ranking
Advertisement
Advertisement
Advertisement
Recipient Email Address
Recipient Email Address
Comment
Recipient Email Address
Add to Portfolio(s)
To add this patent to one, or more, of your portfolios, simply click the add button.
This Patent is in these Portfolios:
Add to additional portfolios:
Last Refreshed On:
Changes done successfully