Database sizing and diagnostic utility
First Claim
1. In a computer system, a method for building and sizing database tables comprising:
- obtaining data requirement information;
performing a diagnosis on at least one database table;
obtaining a new size for said at least one database table using a result from said diagnosis and said data requirement information;
building said at least one database table; and
performing maintenance on said at least one database table.
0 Assignments
0 Petitions
Accused Products
Abstract
A system for automated installation and maintenance of databases. One or more embodiments provide a user interface (or wizard) that obtains information from a user regarding aspects of the network environment and application data requirements. Using the information obtained from the user, a sizing process builds a database, or resizes an existing database, to efficiently match the needs of the user. An automated maintenance process self monitors, diagnoses, and fixes database problems, such as by rebuilding table keys and indexes. When the diagnostic cannot fix a problem, appropriate notification takes place. In one embodiment, the user information is processed using sizing formulas to obtain values for building the database. Database scripts and command files are generated which, when executed, build the appropriately configured database. Also, in accordance with the user information, scripts and command files may be generated that will implement a database backup process upon a user-specified schedule.
121 Citations
20 Claims
-
1. In a computer system, a method for building and sizing database tables comprising:
-
obtaining data requirement information;
performing a diagnosis on at least one database table;
obtaining a new size for said at least one database table using a result from said diagnosis and said data requirement information;
building said at least one database table; and
performing maintenance on said at least one database table. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20)
-
Specification