Adaptive Relational Database Access
AssigneeInternational Business Machines Corporation
InventorsRoy Antony Catterall, Allan Thomas Chandler, Alan David Place, Mark Andrew Shewell, Stephen James Yates
Life of this patent
Estimating the term…
Abstract
An approach is provided that receives an alteration request to mark a selected column in a database table as an unused column. A database control table is then updated to indicate that the selected column is unused. After the database control table is updated, when a read request is received for the selected column, the same data is returned for the selected column for each row being read and this data is not stored in the database table.
Claims25
A machine-implemented method comprising:
- receiving an alteration request to mark a selected column in a database table as an unused column;
- updating a database control table indicating that the selected column is unused;
- and
- after the database control table is updated, returning data not stored in the selected column in response to a read request corresponding to the selected column.
An information handling system comprising:
- one or more processors;
- The information handling system of claim 10 wherein the actions further comprise:
- a memory accessible by at least one of the processors;
- a nonvolatile storage medium accessible by at least one of the processors;
- a database management system including a set of instructions stored in the memory and executed by at least one of the processors in order to perform actions of:
- receiving an alteration request to mark a selected column in a database table as an unused column;
- updating a database control table indicating that the selected column is unused;
- and
- after the database control table is updated, returning data not stored in the selected column in response to a read request corresponding to the selected column.
A computer program product stored in a computer readable medium, comprising functional descriptive material that, when executed by an information handling system, causes the information handling system to perform actions comprising:
- receiving an alteration request to mark a selected column in a database table as an unused column;
- updating a database control table indicating that the selected column is unused;
- and
- after the database control table is updated, returning data not stored in the selected column in response to a read request corresponding to the selected column.
Dependencies are inferred from the claim text.