Database Reference
In-Depth Information
•
Perform the physical organization and implementation.
•
Authorize access to the database.
•
Monitor and coordinate database usage.
•
Perform ongoing maintenance functions.
•
Provide consultation to other practitioners.
•
Define backup and recovery mechanisms.
•
Improve performance.
Methods and Procedures
How do methods and procedures fit into the discussion of the components of
the database environment? These are not tangible components. Can methods
and procedures be really considered as components? Without proper methods and
procedures, any database environment will slip into confusion and chaos. Some
procedures are essential just for making the database stay up and running. Users
and practitioners both need good methods and procedures.
Procedures may be manual and automated. Here is a brief list of their purpose
and features.
Usage.
Users need clear and concise procedures on how to make use of the data-
base. They must have plain and understandable instructions on how to sign on, ini-
tiate the menus, navigate through submenus, and use the various functions provided
by the applications.
Queries and Reports.
Casual and regular users must have a list of available pre-
defined queries and reports along with instructions on how to supply the parame-
ters and run them. Power users require guidelines on how to format and print
reports.
Routine Maintenance.
Routine maintenance consists of monitoring usage of
storage, allocation of additional space whenever necessary, keeping track of access
patterns, and looking out for problem areas. The database administrators must have
proper procedures to perform the routine maintenance functions.
Structure Change Management.
Do not imagine that after the initial imple-
mentation of the database in your organization the data structures remain static.
Business conditions keep changing continuously, and the data structures must
change accordingly. Every organization must have detailed procedures on how to
initiate structure changes, review and approve the changes, and implement the
changes.
Backup and Recovery.
Your users cannot afford to be without the database for
long periods. In the event of a disaster, database administrators must be able to
recover from the malfunctions and restore the functioning of the database. Clearly
defined and tested procedures will resolve disruptions. Backup and recovery
procedures stipulate the type and frequency of backups, the planning and testing of
Search WWH ::
Custom Search