Continuous, automated database-table partitioning and database-schema evolution
US9424287B2 · kind B2 · utility
Assignee
Inventor
Key dates
| Filing date | Dec 16, 2008 |
| Grant date | Aug 23, 2016 |
| Priority date | — |
| Expiry date | Sep 27, 2033 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/22
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Methods and apparatus are disclosed to provide continuous, automated database-table partitioning and database-schema evolution. In one example, the disclosed methods and apparatus for automatically partitioning a logical table include monitoring a database operation to detect a partition-invoking event associated with the logical table, wherein the monitoring of the database operation is initiated in response to a table creation command that includes a partition-by constraint specifying a column of the logical table or of a different table, and, when a partition-invoking event occurs and is detected by the monitoring of the database operation, creating the next partition for the logical table and storing the next partition in a computer-readable medium.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.