Please enable JavaScript.
Coggle requires JavaScript to display documents.
Database Administration and Security (Data (Dirty data (Data that suffer…
Database Administration and Security
Data
Dirty data
Data that suffer from inaccuracies and inconsistencies
Data quality
Data that suffer from inaccuracies and inconsistencies
Data profiling software
Determine data patterns and compare them against standards defined by the organization
Master data management (MDM) software
Helps prevent dirty data by coordinating across multiple systems
Tablespace
SYSTEM
Stores the data dictionary data
USERS
Stores the table data created by the end users
TEMP
Stores the temporary tables and indexes created during the execution of SQL statements
UNDOTBS
Stores database transaction recovery information
Role of Databases in an Organization
top management level
Provide feedback
Enable strategic decision making and planning
Identify growth opportunities
Define and enforce organizational policies
Reduce costs and boost productivity
middle management level
Evaluate performance
Enforce security and privacy of data in the database
Monitor the use of resources
Deliver the data required for tactical planning
operational management level
Represent and support company operations
Produce query results within specified performance levels
Enhance the company’s short-term operations
DBA’s Managerial Role
Provide end-user support
Enforce policies, procedures, and standards for correct data creation, usage, and distribution within the database
Manage data security, privacy, and integrity
Manage data backup and recovery
Fully recover data in case of data loss
Database security officer (DSO)
Disaster management
Full backup \ database dump
Incremental backup
Concurrent backup