Database Administration Tasks

Written by Genevieve Hawkins
Bookmark and Share

Depending on the nature of the information being relayed, database administrators can perform an almost infinite number of activities with the information presented. Whether the needs are for data analysis, better security, greater integrity or higher performance, there is something that will work for just about any business. Some of the more common task components are presented below.

Major Features of a Database Administrator

There are many ways that a database administrator can go about it's job--most of the major features can be sorted as design, relational, and security tasks. Design features relate to how the information is set up--is it by the type of order, chronological, by the amount, in alphabetical order? Depending on the needs of business, setting up the database in a way that makes sense and creates ease of finding information is essential.

Another key component of database tasks involves the relational components of the information. Initially, most business accounts were set up hierarchically, that is, as a direct relationship between the customer and the order. However, this procedure did not allow for linking of related information, so now many systems are set up on network structure, easing in making predictions later.

A third component of DBMS tasks involves security features--who is allowed into the site and when. Depending on design, the database may have encrypted answers that only allow certain people access, or that only allow certain people some access. Deciding what is right for your business may take some careful thought, and possibly some trial and error. In the long run, however, finding a system that works will eliminate any problems with growth and usage.

Bookmark and Share