Invention Grant
- Patent Title: Autonomically defining hot storage and heavy workloads
-
Application No.: US14018052Application Date: 2013-09-04
-
Publication No.: US09336294B2Publication Date: 2016-05-10
- Inventor: Kevin L. Beck , Kevin J. Cherkauer
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: North Shore Patents, P.C.
- Agent Michele Liu Baillie
- Main IPC: G06F12/00
- IPC: G06F12/00 ; G06F17/30

Abstract:
In defining database objects for storage in a storage hierarchy, frequencies of accesses of a plurality of database objects over a predetermined time period are observed. A mean and standard deviation for the plurality of database objects are computed based on the observed frequencies of accesses of the plurality of database objects. A z-score for a given database object is determined based on a comparison of the frequency of access for the given database with the mean and standard deviation computed for the plurality of database objects by the computing processor; and a level in the storage hierarchy corresponding to the z-score of the given database object is determined. The given database object may then be stored at the level in the storage hierarchy corresponding to the z-score of the given database object.
Public/Granted literature
- US20150066960A1 AUTONOMICALLY DEFINING HOT STORAGE AND HEAVY WORKLOADS Public/Granted day:2015-03-05
Information query