Invention Grant
- Patent Title: Cache configuration in a database system
- Patent Title (中): 数据库系统中的缓存配置
-
Application No.: US11734144Application Date: 2007-04-11
-
Publication No.: US07788449B2Publication Date: 2010-08-31
- Inventor: Holger Karn , Sven Miller
- Applicant: Holger Karn , Sven Miller
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Kunzler Needham Massey & Thorpe
- Priority: EP61209367 20060920
- Main IPC: G06F12/00
- IPC: G06F12/00

Abstract:
A computer-implemented method is disclosed. The method includes collecting cache-efficiency-indicator values of an at least one cache fragment during operation of a database system over a period of time. Providing approximation-function-parameter values for the collected, cache-efficiency-indicator values, an approximation function representing a relation between a cache-efficiency-indicator and the size of a respective cache fragment. The method continues by providing a set of workload windows based on the approximation-function-parameter values. Next, providing a workload-window information for the set of workload windows, the workload-window information including at least one approximation-function-parameter value representing each determined workload window. The method further includes storing the workload-window information for a comparison based on current, cache-efficiency-indicator values and the workload-window information.
Public/Granted literature
- US20080071987A1 Cache Configuration in a Database System Public/Granted day:2008-03-20
Information query