[83] in Athena_Backup_System
Results of Database Support Discussion
daemon@ATHENA.MIT.EDU (Tim McGovern)
Fri Mar 10 17:37:55 1995
Date: Fri, 10 Mar 1995 17:35:10 -0500
To: athena-backup@MIT.EDU
From: tjm@MIT.EDU (Tim McGovern)
The following table shows the results of the athena backup system team's
review of potential ASD database services... This is a FIRST DRAFT, and
needs to be reviewed further within DCNS, and with ASD, for sanity.
Comments welcome.
Tim
------
ASD DCNS Database Support Service
S- P 1. Plan and implement data security mechanisms appropriate
to the application
S P 2. Plan and implement audit trails appropriate to the
application, for example, logs of database messages,
records of data field changes, database usage statistics
P S- 3. Plan and implement database backups in addition to system
backups where appropriate to the application
P S 4. Plan and test corresponding recovery procedures
P 5. Plan, implement, and test business continuity plans
appropriate to the database applications.
Q: How will we verify that db backups are valid?
P S 6. Maintain currency of both the database and related database
software to facilitate support for problem resolution.
Q: Who handles bug reports to Oracle?
Q: Does this cover operating system updates as well?
N/A 7. Write and maintain jobs to warehouse data and/or provide
data extracts
P 8. Monitor usage and performance and work with systems person
to use system performance measurement tools and database
tools to tune
P S 9. Track changes and plan with customers growth and needs in
hardware and software related to their application
= = 10. Design or review designs of database tables with appropriat
indices and accesses looking at global access issues rather
than the single program
N/A 11. Design or review designs of application access strategies
N/A 12. Train analysts and programmers in appropriate database
strategies
P 13. Train operations and production support staff in appropriate
database operating procedures.
Q: Can ASD mentor DCNS personnel in the care and feeding
of Oracle databases for emergency duty?
14. Write database documentation
P --Programmer How-to
P --Operations How-to
P --System User How-to
N/A 15. Help encourage standards or good practice
N/A 16. Write tools to automate database tasks.
Q: What are examples of such tools/tasks?
P 17. Generate and review periodically database status
reports and integrity checks and do maintenance as required
P S+ 18. Generate and review database/operating system parameters
and performance data and reorganize, redesign, or tune
as indicated
P 19. Consult with programmers and analysts on database
application and database problems.
Q: Can this support be provided on an incident basis,
rather than on a flat fee retainer?
N/A 20. Evaluate and recommend databases, related database products,
and DBA tools
S P 21. Handle daily maintenance such as table changes and data loads
Key: P=Primary responsibility
S=Secondary responsibility
+ means responsiility may increase over time
- means responsibility may decrease over time
= means task is shared equally between groups.
