Patent · US Active

Method and system for optimizing data access in a database using multi-class objects

US9805077B2 · kind B2 · utility

1Cited by

7References

19Claims

0Family size

Assignee

International Business Machines Corporation · US

Inventors

Oliver Draese · Los Gatos, US
Benno Staebler · Holzgerlingen, DE
Torsten Steinbach · Eppelheim, DE
Knut Stolze · Jena, DE

Key dates

Filing date	Feb 13, 2009
Grant date	Oct 31, 2017
Priority date	—
Expiry date	Jan 30, 2033

Classification

Technology area (CPC G)Physics
CPC primaryG06F16/221
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

Methods for optimizing data access in a row-oriented relational database containing data sets having attributes using a computer are presented the method including: causing a computer to analyze a database workload to determine an access frequency for each of the attributes; causing the computer to assign each of the attributes to a priority classes corresponding with the access frequency, where the priority classes include a higher priority class and a lower priority class, and where a higher priority class corresponds with a higher access frequency and a lower priority class corresponds with a lower access frequency; causing the computer to store the attributes in accordance with the classes, where the attributes assigned to the higher priority class are stored in a high priority storage medium, and where the attributes assigned to a lower priority class are stored in a low priority storage medium.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.