System and method for automating data partitioning in a parallel database
US7562090B2 · kind B2 · utility
16Cited by
6References
7Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Dec 19, 2002 |
| Grant date | Jul 14, 2009 |
| Priority date | — |
| Expiry date | Jul 14, 2026 |
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.