Database Administrators

1 Introduction

Database is any collection of data or information, that is specially organized for rapid search and retrieval by a computer. Databases are structured to facilitate the storage, retrieval, modification, and deletion of data in conjunction with various data-processing operations.

A database consists of a file or a set of files. The information in these files may be broken down into records, each of which consists of one or more fields. Fields are the basic units of data storage, and each field typically contains information pertaining to one aspect or attribute of the entity described by the database. Using keywords and various sorting commands, users can rapidly search, rearrange, group, and select the fields in many records to retrieve or create reports on particular aggregates of data.

A person who develops database is an database designer, but the person who maintains it, is an database administrator(DBA). This paper explains main duties and responsibilities of database administrator.

2 Source

2.1 Wikipedia, The Free Encyclopedia

A database administrator (DBA) is a person who is responsible for the environmental aspects of a database. In general, these include:

• Recoverability - Creating and testing Backups

• Integrity - Verifying or helping to verify data integrity

• Security - Defining and/or implementing access controls to the data

• Availability - Ensuring maximum uptime

• Performance - Ensuring maximum performance given budgetary constraints

• Development and testing support - Helping programmers and engineers to efficiently utilize the database.

Although not strictly part of a database administrator's duties, logical and physical design of databases is sometimes part of the job. These functions are traditionally thought of as being the duties of a database analyst or database designer.

2.2 Duties

The duties of a database administrator varies depending on job description, corporate and Information Technology (IT) policies and the technical features and capabilities of the database management systems (DBMSs) being administered. They nearly always include disaster recovery (backups and testing of backups), performance analysis and tuning, and some database design or assistance thereof.

2.3 Definition of Database

Before going on, we need to briefly define and describe “database.” A database is a collection of related information, accessed and managed by its DBMS. After experimenting with hierarchical and networked DBMSs during the 1970’s, the IT industry became dominated by relational DBMSs such as Oracle or MySQL.

A relational DBMS manages information about types of real-world things (entities) in the form of tables that represent the entities. A table is like a spreadsheet; each row represents a particular entity (instance), and each column represents a type of information about the entity (domain). Sometimes entities are made up of smaller related entities, such as orders and order lines; and so one of the challenges of a multi-user DBMS is provide data about related entities from the standpoint of an instant of logical consistency.

Properly managed relational databases minimize the need for application programs to contain information about the physical storage of the data they access. To maximize the isolation of programs from data structures, relational DBMSs restrict data access to the messaging protocol SQL, a nonprocedural language that limits the programmer to specifying desired results. This message-based interface was a building block for the decentralization of computer hardware, because a program and data structure with such a minimal point of contact become feasible to reside on separate computers.

2.4 Recoverability

Recoverability means that, if a data entry error, program bug or hardware failure occurs, the DBA can bring the database backward in time to its state at an instant of logical consistency before the damage was done. Recoverability activities include making database backups and storing them in ways that minimize the risk that they will be damaged or lost, such as placing multiple copies