System and computer program product for automated design of range partitioned tables for relational databases
US8838598B2 · kind B2 · utility
3Cited by
3References
5Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Nov 30, 2007 |
| Grant date | Sep 16, 2014 |
| Priority date | — |
| Expiry date | Nov 2, 2029 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/22
- 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.