Invention Grant
US08838598B2 System and computer program product for automated design of range partitioned tables for relational databases
有权
用于关系数据库的范围分区表的自动设计的系统和计算机程序产品
- Patent Title: System and computer program product for automated design of range partitioned tables for relational databases
- Patent Title (中): 用于关系数据库的范围分区表的自动设计的系统和计算机程序产品
-
Application No.: US11948435Application Date: 2007-11-30
-
Publication No.: US08838598B2Publication Date: 2014-09-16
- Inventor: Manish A. Bhide , Sam S. Lightstone , Laurent S. Mignet , Sumit Negi , Daniele C. Zilio
- Applicant: Manish A. Bhide , Sam S. Lightstone , Laurent S. Mignet , Sumit Negi , Daniele C. Zilio
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Ryan, Mason & Lewis, LLP
- Main IPC: G06F17/30
- IPC: G06F17/30
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.
Public/Granted literature
Information query
