发明授权
US08838598B2 System and computer program product for automated design of range partitioned tables for relational databases
有权
用于关系数据库的范围分区表的自动设计的系统和计算机程序产品
- 专利标题： System and computer program product for automated design of range partitioned tables for relational databases
- 专利标题（中）： 用于关系数据库的范围分区表的自动设计的系统和计算机程序产品
-
申请号： US11948435申请日： 2007-11-30
-
公开(公告)号： US08838598B2公开(公告)日： 2014-09-16
- 发明人: Manish A. Bhide , Sam S. Lightstone , Laurent S. Mignet , Sumit Negi , Daniele C. Zilio
- 申请人： Manish A. Bhide , Sam S. Lightstone , Laurent S. Mignet , Sumit Negi , Daniele C. Zilio
- 申请人地址： US NY Armonk
- 专利权人： International Business Machines Corporation
- 当前专利权人： International Business Machines Corporation
- 当前专利权人地址： US NY Armonk
- 代理机构： Ryan, Mason & Lewis, LLP
- 主分类号： G06F17/30
- IPC分类号： G06F17/30
摘要：
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.