System and method for automating data partitioning in a parallel database
US8001109B2 · kind B2 · utility
15Cited by
7References
20Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Apr 28, 2008 |
| Grant date | Aug 16, 2011 |
| Priority date | — |
| Expiry date | Jul 21, 2029 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99953
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A system for automating data partitioning in a parallel database includes plural nodes connected in parallel. Each node includes a database server and two databases connected thereto. Each database server includes a query optimizer. Moreover, a partitioning advisor communicates with the database server and the query optimizer. The query optimizer and the partitioning advisor include a program for recommending and evaluating data table partitions that are useful for processing a workload of query statements. The data table partitions are recommended and evaluated without requiring the data tables to be physically repartitioned.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.