Database partition management system
US11003651B2 · kind B2 · utility
0Cited by
0References
20Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Nov 28, 2018 |
| Grant date | May 11, 2021 |
| Priority date | — |
| Expiry date | Jun 6, 2039 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06Q10/1093
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
RI/ORASE history and current transaction data are stored in partitioned fact tables and aggregation tables based on business calendar. Most of associated indexes are locally partitioned indexes. In a typical RI customer environment, partitioned transaction data takes 85% or more of overall RI database space. The benefits of partitioning include easy management of data, enhanced performance, and assistance with backup and recovery. A partition management system provides the ability to create initial partitions and manage existing partitions in ways that allow the size of the partitioned database to exceed a backup limit size.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.