Free resources parameter for improving performance of database alterations
US9189511B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Sep 7, 2011 |
| Grant date | Nov 17, 2015 |
| Priority date | — |
| Expiry date | Jan 26, 2032 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2308
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Altering tables in a database system may be difficult because the tables may only be altered when all connection to the tables have been released. A free resources parameter may be set on in a management system for the database system to specify that resources should be attempted to be released. Connections to the database may be closed earlier than conventionally closed. For example, connections that are idle may be released. Once the connections have been released the database may be altered and the free resources parameter turned off. The free resources parameter notifies the database system of a pending alteration and allows the database to gracefully close connections to provide an opportunity for the alteration to occur.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.