Database sizing and diagnostic utility

• US 20070162514A1
• Filed: 12/13/2006
• Published: 07/12/2007
• Est. Priority Date: 02/25/2000
• Status: Abandoned Application

• Current Assignee: Inna Brovman, Isabel Espina, Steve Fabian, Vincent Civetta
• Original Assignee: Inna Brovman, Isabel Espina, Steve Fabian, Vincent Civetta
• Inventors: Civetta, Vincent, Espina, Isabel, Fabian, Steve, Brovman, Inna
• Time in patent office: 0 Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures

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.

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.

2. The method of claim 1 wherein said obtaining said data requirement information further comprises obtaining user input.

3. The method of claim 2 wherein said obtaining said user input further comprises providing at least one user interface for obtaining said data requirement information.

4. The method of claim 1 wherein said obtaining said data requirement information further comprises obtaining network environment information.

5. The method of claim 1 wherein said obtaining said data requirement information further comprises obtaining information about storage devices available to support said at least one database table.

6. The method of claim 1 wherein said obtaining said data requirement information further comprises obtaining a backup method.

7. The method of claim 1 wherein said obtaining data requirement information further comprises obtaining a backup schedule.

8. The method of claim 1 wherein said obtaining data requirement information further comprises obtaining at least one requirement of at least one application.

9. The method of claim 1 wherein said performing a diagnosis on said at least one database table further comprises checking performance measures.

10. The method of claim 9 wherein said checking performance measures comprises generating a table of current performance.

11. The method of claim 9 wherein said checking performance measures comprises looking up performance criteria.

12. The method of claim 11 wherein said looking up performance criteria comprises checking an error level.

13. The method of claim 12 wherein said checking said error level comprises writing at least one error message to an error log.

14. The method of claim 9 wherein said checking performance measures comprises checking whether performance is above a warning level.

15. The method of claim 14 further comprising writing a warning message to a warning log when said performance is above said warning level.

16. The method of claim 9 wherein said checking said database performance further comprises determining a minimum space available for data.

17. The method of claim 1 wherein said performing said diagnosis on said at least one database table further comprises analyzing a plurality of objects contained in said at least one data base table.

18. The method of claim 17 wherein said analyzing said plurality of objects further comprises building a list of high-risk objects.

19. The method of claim 17 wherein said analyzing said plurality of objects further comprises building a list of objects that can be fixed.

20. The method of claim 1 wherein said performing said diagnosis on said at least one database table further comprises generating at least one report on internals of said at least one database table.