Lesson 6.3: Database Management and Administration Tools Flashcards
Database Administration
Database management and administration are important functions in any organization that is dependent on one or more databases. It refers to the whole set of activities that ensure all databases are highly available, secure, and scalable.
Scalability is the ability to accommodate increased demands while using existing resources (e.g., increasing memory capacity before being fully exhausted).
DBA Responsibilities
A majority of the database administration (DBA) responsibilities fall into these categories:
Database security—ensuring that only authorized users have access to the database and fortifying it against unauthorized access
Database tuning—optimizing performance of database systems
High availability—making replicas (copies) of databases available
from various locations; if one copy is unavailable due to outage, the alternate location can continue database services
Business continuity—continuing core business operations effectively, even with the disruption of some auxiliary services
Backup and recovery—planning for and executing adequate backup and recovery procedures
Reporting—writing complex queries and generating reports for users
Designing and developing database applications—writing code to interact with the database resources
The DBA needs a complex set of specialized skills, as well as current knowledge of database developments, acquired through intense professional development.