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

A system of computer hardware for optimizing data access in a row-oriented relational database, the row-oriented relational database including a plurality of data sets each dataset having a plurality of attributes, the system comprising:

• a processor;
• an access monitoring system for monitoring database workload to determine an access frequency for each of the plurality of attributes, wherein each of the plurality of attributes corresponds with a column, wherein the plurality of data sets correspond with a plurality of rows, and wherein the monitoring is executed inside a database engine where column data associated with the column is accessed;
• a classification system for assigning the plurality of attributes to a plurality of classes corresponding with the access frequency, wherein the plurality of classes include at least a high priority class and a low priority class;
• and wherein a higher priority class corresponds with a higher access frequency and a lower priority class corresponds with a lower access frequency;
• an attribute storage system for storing the plurality of attributes in a plurality of modified datasets in accordance with the plurality of priority classes, wherein the plurality of attributes assigned to the higher priority class are stored in a high priority storage media, wherein the plurality of attributes assigned to a lower priority lass are stored in a low priority storage media, and wherein rows corresponding with the plurality of modified datasets in the row-oriented relational database are broken up into multiple row fragments for storage in different pages by column corresponding with the plurality of attributes such that the row-oriented relational database is reorganized and data access to the database is optimized.

A computer program product for optimizing data access in a row-oriented relational database containing a plurality of data sets having a plurality of attributes using a computing device, the computer program product comprising:

• a non-transitory computer readable medium;
• first program instructions for analyzing a database workload to determine an access frequency for each of the plurality of attributes wherein each of the plurality of attributes corresponds with a column, wherein the plurality of data sets correspond with a plurality of rows, and wherein the analysis is executed inside a database engine where column data associated with the column is accessed;
• second program instructions for assigning each of the plurality of attributes to a plurality of priority classes corresponding with the access frequency, wherein the plurality of priority classes includes at least a higher priority class and a lower priority class, and wherein a higher priority class corresponds with a higher access frequency and a lower priority class corresponds with a lower access frequency;
• third program instructions for storing the plurality of attributes in a plurality of modified datasets in accordance with the plurality of classes, wherein the plurality of attributes assigned to the higher priority class are stored in a high priority storage medium, and wherein the plurality of attributes assigned to a lower priority class are stored in a low priority storage medium, wherein rows corresponding with the plurality of modified datasets in the row-oriented relational database are broken up into multiple row fragments for storage in different pages by column corresponding with the plurality of attributes such that the row-oriented relational database is reorganized and data access to the database is optimized.