DATABASE ADMINISTRATION ASSISTANT

THE OBJECTIVE OF THIS SBIR IS TO APPLY EXPERT SYSTEM AND ADVANCED DATA DICTIONARY TECHNOLOGY TO THE PROBLEM OF DATABASE ADMINISTRATION. PHASE I WILL RESULT IN THE DEFINITION AND SPECIFICATION OF A DATABASE ADMINISTRATION ASSISTANT (DBAA). A PROTOTYPE IMPLEMENTATION SHALL BE DEMONSTRATED AT THE END OF PHASE II. THE FOLLOWING TASKS WILL BE PERFORMED DURING PHASE I OF THIS SBIR: IDENTIFY TYPICAL DBA TASKS, EVALUATE TASK AUTOMATABILITY, DEVELOP THE OPERATIONAL CONCEPT AND THE SPECIFICATION FOR THE DBA ASSISTANT, AND DETERMINE THE FEASIBILITY OF DEVELOPING A SUCCESSFUL PRODUCT DURING PHASE II. THE RESULTING SPECIFICATION WILL BE THE BASIS FOR THE DEVELOPMENT OF THE PHASE II PROTOTYPE. AN INTELLIGENT DBAA WHICH INTERFACES TO A DATA DICTIONARY SYSTEM WILL REDUCE LABOR INTENSIVE ACTIVITIES IN LOGICAL DATABASE DESIGN, PHYSICAL DATABASE DESIGN, ENTITY NAME ANALYSIS/RECONCILIATION,PERFORMANCE TUNING, CAPACITY PLANNING, AND INTEGRITY CONTROL. THIS CAPABILITY WILL ALSO BE AN INVALUABLE TOOL FOR THE FAMILIARIZATION AND SUPPORT OF LESS EXPERIENCED DATABASE ADMINISTRATORS.