Zusammenfassung der Ressource
DBA + Database Administrator
- Scanning for this
- Skimming this
- What is?
- - Data remains consistent across the database;
- - Data is clearly defined;
- - Users access data concurrently, in a form that suits their needs;
- - There is provision for data security and recovery control
- - There is provision all data is retrievable in an emergency.
- Implications of this
- Brainstorming
- What to expect?
- - Establishing the needs of users and monitoring user access and security;
- - Monitoring performance and managing parameters to provide fast responses to front-end users;
- - Considering both back-end organization of data and front-end accessibility for end-users;
- - Further refining the physical design to meet system storage requirements;
- - Maintaining data standards, including adherence to the Data Protection Act;
- - Writing database documentation, including data standards, procedures
and definitions for the data dictionary (metadata);
- - Controlling access permissions and privileges;
- - Developing, managing and testing back-up and recovery plans;
- - Ensuring that storage and archiving procedures are functioning correctly;
- - Communicating regularly with technical, applications and operational staff
to ensure database integrity and security;