Patent ID: 8838598
Filing Date: 2014-09-16
Classification: G06F

Abstract:
1. A computer program product comprising a computer useable recordable medium including computer usable program code for recommending range-partitioned tables in a relational database, said computer program product including: computer usable program code for obtaining a workload specification for said database, said workload specification detailing specific queries and a frequency of execution of each of said queries; computer usable program code for obtaining a catalog specification for said database, said catalog specification detailing a definition of tables and columns within said tables; computer usable program code for obtaining a set of partitions for said database; computer usable program code for identifying, based at least in part on said obtaining steps, a plurality of candidate ones of said tables for said database, said candidate ones of said tables having a plurality of candidate ones of said columns, wherein said identifying comprises: computer usable program code for allocating at least one chosen column for each of said candidate ones of said tables, to obtain a set of partitioned tables and a set of appropriate partitions for each of said partitioned tables, wherein said allocation of said at least one chosen column for each of said candidate tables is based at least on extracting natural ranges present in said workload, and wherein said allocating comprises: