Systems and methods for redistributing data in a relational database
US8543538B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Jun 1, 2011 |
| Grant date | Sep 24, 2013 |
| Priority date | — |
| Expiry date | Aug 16, 2031 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/278
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Systems and methods for redistributing data in a relational database are disclosed. In one embodiment, the database includes a plurality of rows of data distributed across a plurality of slices of a table in the database. The database system is configured to distribute the rows of data across the slices according to a first function based on one or more columns of the database. The database system monitors at least one database statistic indicative of variation in a distribution of the rows of data across the slices and detects a redistribution condition based on the at least one monitored database statistic. The database system is further configured to respond to the detected redistribution condition by redistributing the rows of data across the slices according to a second function based on a different number of columns than the first function.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.