Patent · US Active

Method for automated design of range partitioned tables for relational databases

US7917512B2 · kind B2 · utility

25Cited by

2References

6Claims

0Family size

Assignee

International Business Machines Corporation · US

Inventors

Manish Anand Bhide · Hyderabad, IN
Sam S. Lightstone · Toronto, CA
Laurent S. Mignet · New Delhi, IN
Sumit Negi · Bengaluru, IN
Daniele Costante Zilio · Georgetown, CA

Key dates

Filing date	Nov 30, 2007
Grant date	Mar 29, 2011
Priority date	—
Expiry date	Feb 20, 2029

Classification

Technology area (CPC Y)Emerging Cross-Sectional Technologies
CPC primaryY10S707/972
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

A workload specification, detailing specific queries and a frequency of execution of each of the queries, and a set of partitions, are obtained for the database, as inputs. A number of candidate tables are identified for the database, the tables having a plurality of attributes. A chosen attribute is allocated for each of the tables, to obtain a set of tables and a set of appropriate partitions for each of the tables.

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