Method, system and article of manufacture for improving execution efficiency of a database workload

Disclosed is a data processing system implemented method, a data processing system and an article of manufacture for improving execution efficiency of a database workload to be executed against a database. The database includes database tables, and the database workload identifies at least one of th...

Full description

Saved in:
Bibliographic Details
Main Authors Bhattacharjee, Bishwaranjan, Lightstone, Sam Sampson, Malkemus, Timothy Ray, Padmanabhan, Sriram K, Storm, Adam J, Zilio, Daniele Costante
Format Patent
LanguageEnglish
Published 20.03.2012
Online AccessGet full text

Cover

More Information
Summary:Disclosed is a data processing system implemented method, a data processing system and an article of manufacture for improving execution efficiency of a database workload to be executed against a database. The database includes database tables, and the database workload identifies at least one of the database tables. The data processing system includes an identification module for identifying candidate database tables being identifiable in the database workload, the identified candidate database tables being eligible for organization under a clustering schema, a selection module for selecting the identified candidate tables according to whether execution of the database workload is improved if the selected identified candidate table is organized according to the clustering scheme, and an organization module for organizing the clustering schema of the selected organized identified candidate tables prior to the database workload being execution against the database.