Statistics update of a database having a primary side and a standby side
US12174830B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Mar 7, 2022 |
| Grant date | Dec 24, 2024 |
| Priority date | — |
| Expiry date | Sep 9, 2042 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F2201/80
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Computer technology for use in a computer system including a database system including a database management sub-system, a primary database and a secondary database, with the secondary database being maintained at least approximately in synchronization with the primary database over time as changes are made to data of the primary database (for example, a database system that includes disaster recovery (DR) features). A statistics update is performed first on a standby database to determine whether query efficiency and/or query optimization really will be substantially improved by performance of the statistics update. If not, then statistics update on the primary database is postponed until a future time.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.