Managing a computerized database using a volatile database table attribute
First Claim
1. A method for managing a computerized database, comprising the following executed by at least one computer system:
- storing at least one respective volatility attribute for each of at least one database table of said computerized database, each 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;
selectively determining whether to maintain at least one metadata structure describing data in at least a first database table of said at least one database table, the determining whether to maintain at least one metadata structure being performed using at least one volatility attribute expressing volatility of at least a portion of the first database table, wherein maintaining the at least one metadata structure comprises updating data in the at least one metadata structure responsive to changes to data in the at least a first database table; and
responsive to determining to maintain a first metadata structure of the at least one metadata structure, maintaining the first metadata structure.
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 in any of various aspects to (a) determine how table data is stored in a physical storage device; (b) regulate the use of a materialized query table using database table data; and/or (c) influence circumstances under which indexes are created or advised by database analytic software. 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.
58 Citations
6 Claims
-
1. A method for managing a computerized database, comprising the following executed by at least one computer system:
-
storing at least one respective volatility attribute for each of at least one database table of said computerized database, each 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; selectively determining whether to maintain at least one metadata structure describing data in at least a first database table of said at least one database table, the determining whether to maintain at least one metadata structure being performed using at least one volatility attribute expressing volatility of at least a portion of the first database table, wherein maintaining the at least one metadata structure comprises updating data in the at least one metadata structure responsive to changes to data in the at least a first database table; and responsive to determining to maintain a first metadata structure of the at least one metadata structure, maintaining the first metadata structure. - View Dependent Claims (2, 3, 4, 5, 6)
-
Specification