What Is DBA?

DBA stands for database administrator; he is a person who is responsible for the features of a database like database recovery, integrity, availability, security and so on. DBA has to check these features in order to maintain the data base. These features are mentioned as follows:

• Recoverability (disaster recovery): Make recovery plans, generate backups as well as test these Backups.
• Integrity: Confirming or assisting to make sure that the data is reliable, integrated and correct.
• Security: Defining or implementing the access control to the database and check that there is no unauthorized access to database.
• Availability: Make sure that the data is available all the time to the users i.e. maximize visibility.
• Performance: Make sure that the data does not consume more online response times and it does not make unattended programs to run for an unusable time.
• Development and testing support: Assisting programmers and engineers to efficiently make use of the database.

The role of a database administrator has altered with respect to the expertise and technology of database management systems as well as the requirements of the database owners.

Add Comment

Report

A database administrator (DBA) is a person who is responsible for the ecological feature of a database. In universal, these consist of: Data Recovery – making import and export Backups, reliability - Verifying or helping to verify data integrity, Security - Defining and/or implementing access controls to the data , Availability - Ensuring maximum uptime, presentation - Ensuring maximum presentation given budgetary constraints , Development and testing support - Helping programmers and engineers to efficiently utilize the database.

The responsibility of a database administrator has distorted according to the knowledge of database management systems (DBMSs) as well as the requirements of the proprietor of the databases. For example, although rational and bodily database design is conventionally the duties of a database analyst or database designer, a DBA may be tasked to perform those duties
Recoverable data means that, if a data entry error, program bug or hardware breakdown occurs, the DBA can transport the database toward the back in time to its state at an immediate of logical reliability before the harm was done. Recover ability actions comprise making database backups and stock up them in ways that reduce the risk that they will be spoiled or missing, such as insertion numerous copies on detachable media and storing them external the precious area of a predictable disaster. Recovery of the damage data is the DBA's most significant fear.

Add Comment

Report