Adjusting extension size of a database table using a volatile database table attribute
First Claim
Patent Images
1. A method for managing a computerized database, comprising the following executed by at least one computer system:
- storing at least one respective database table volatility attribute for each of at least one database table of said computerized database, each database table volatility attribute expressing volatility of at least a portion of a respective database table of said computerized database, said volatility of at least a portion of a respective database table being a property of the respective database table that is a function of changes to data recorded in said at least a portion of the respective database table with respect to time;
determining an extension file size of at least a portion of a first database table of said at least one database table of said computerized database using the at least one database table volatility attribute corresponding to the first database table;
responsive to a need to increase the file size allocation of the at least a portion of the first database table, increasing the file size allocation of the at least a portion of the first database table by the amount of the extension file size determined by said determining an extension file size of at least a portion of a first database table.
1 Assignment
0 Petitions
Accused Products
Abstract
A respective volatility attribute associated with each of one or more tables of a computerized database is used to adjust an extension file size value associated with a database table file space. Various optional additional uses of a volatility attribute to manage a database are disclosed. Preferably, database parameters are automatically monitored over time and database table volatility state is automatically determined and periodically adjusted.
51 Citations
18 Claims
-
1. A method for managing a computerized database, comprising the following executed by at least one computer system:
-
storing at least one respective database table volatility attribute for each of at least one database table of said computerized database, each database table volatility attribute expressing volatility of at least a portion of a respective database table of said computerized database, said volatility of at least a portion of a respective database table being a property of the respective database table that is a function of changes to data recorded in said at least a portion of the respective database table with respect to time; determining an extension file size of at least a portion of a first database table of said at least one database table of said computerized database using the at least one database table volatility attribute corresponding to the first database table; responsive to a need to increase the file size allocation of the at least a portion of the first database table, increasing the file size allocation of the at least a portion of the first database table by the amount of the extension file size determined by said determining an extension file size of at least a portion of a first database table. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A computer-executed method, comprising:
-
determining a volatility state of at least a portion of a database table of a computerized database, said volatility state being a property of the database table that is a function of changes to data recorded in the at least a portion of the database table with respect to time; recording a database table volatility attribute expressing said volatility state; and determining an extension file size of the at least a portion of the database table of the computerized database using the database table volatility attribute, the extension file size being an increment by which the at least a portion of the database table is increased responsive to a need for additional file size allocation of the at least a portion of the database table. - View Dependent Claims (12, 13, 14, 15, 16, 17, 18)
-
Specification