The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Jan. 20, 2009
Filed:
May. 13, 2005
Junya Shimizu, Yokohama, JP;
Junya Shimizu, Yokohama, JP;
International Buisiness Machines Corporation, Armonk, NY (US);
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.