Database Administration

Database Administration is a collection of allied information which is managed by DBMS. Database Administration is tables that store data in a systematic way. Oracle, Sybase, and Microsoft SQL Server are some of the database management systems. The earliest RDBMS were UBM and Oracle. Many other followed in the later years, but the best was SQL.

Database Administration in technical aspect could be defined as “Truly Relational Model Database Management System.” The desktop personal computer DBMS with Visual FoxPro was marketed at that time which was far less compliant with Codd's Rules.

A Database Administration stores data in the tables for future reference. The table is like a spreadsheet, which is divided into rows and columns. Every row represents a well defined entity and the columns a type of information about the entity. The entities are sometimes made up of smaller entities like orders and order lines.

The database administration is operated by a database administrator. He is responsible for taking care of the environmental aspects of a database which are: Integrity – To verify or help to verify data integrity Recoverability – To create and test Backups Availability – To ensure maximum uptime Security – To define and implement access controls to the data Performance – To ensure maximum performance given budgetary constraints Development and testing support – To help the programmers and engineers to efficiently utilize the database Today the role of the database administrator keeps changing according to the needs and demands mainly designed for the database analysts or database designers.