Please enable JavaScript.
Coggle requires JavaScript to display documents.
Database Administrator - Coggle Diagram
Database Administrator
Data
Raw material used to produce information
Valuable resource
Information
Timely and accurate data can trigger beneficial actions
Basis for knowledge
Used in decision making
Functional Organization
Operations
Implementation
Testing
Physical
Design
Logical
Conceptual
Training
Planning
Data Administrator (DA)
Broad scope
Long term
Sets policies and standards
Managerial orientation
Sets long term goals
DMBS - indpendant
Strategic Planning
Database Administrator (DBA)
Enforces programming standards
Short term (daily operations)
Enforces polices and standards
Technical operations
Executes plans to reach goals
DBMS - specific
Control and supervision
Narrow scope
Managerial skills
Analytical skills
Conflict resolution skills
Coordination skills
Communication skills (oral and written)
Broad business understanding
Negotiation skills
Technical skills
Structured methodolgies
Data flow diagrams
Structure charts
Programming languages
Database life cycle knowledge
Systems development life cycle knowledge
Database modelling and design skills
Conceptual
Logical
Physical
Broad data-processing background
Operational skills
Database implementation
Data dictionary management
Security
Security, Privacy and Integrity
Authorization management
User access management
View definition
DBMS utilities access control
DBMS usage monitoring
Corrupted integrity
Database must be recovered
Security
Preserved integrity
Data recovery may not be necessary
Data Backup and Recovery
Database security officer (DSO)
Disaster management
Periodic data and applications backups
Proper backup identification
Convenient and safe backup storage
Physical protection
Personal access control
Insurance coverage for the data in the database
Data recovery and contingency plans must be tested and evaluated
Backup and recovery may not cover all aspects of IS
Standards
More detailed and specific than policies
Describe minimum requirement of DBA activity
Procedures
Written instructions that describe steps for activity
Support and enhance work environment
policies
Communicate and support DBA goals
General statements of direction or action
Data Distribution and Use
Data useful in right hands at right time
Current philosophy makes authorized data access easier
Sophisticated query tools
Web front ends
Data democracy
Cautions due to improper use of data
End user support
User requirements gathering
Conflict and problem resolution
Finding solutions to information needs
Ensuring quality and integrity of applications and data
Building end-user confidence
Managing the training and support of DBMS users
Data Administration Strategy: Information Engineering
Information Engineering (IE) translates strategic goals of the company into data and applications
Focuses on description of corporate data instead of the processes
Output is Information Systems Architecture (ISA)