Systems and methods for redistributing data in a relational database
US9477741B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Sep 23, 2013 |
| Grant date | Oct 25, 2016 |
| Priority date | — |
| Expiry date | Oct 12, 2033 |
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 table. 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.