Database Security

Database Security

  • Submitted By: plodman
  • Date Submitted: 11/05/2008 1:36 AM
  • Category: Technology
  • Words: 1898
  • Page: 8
  • Views: 824

Data and Database Administration

Introduction
Data is a corporate Asset, just as personnel, physical resources, and financial resources are corporate assets. Data administration activities have been developed to help organisation to manage this asset effectively and protect it from unauthorised use. Effective data administration provides support for managerial decision making at all levels of the organisation. (I.e. convert raw data into information). Ineffective data administration can lead to:

Multiple definitions of the same data
Missing key data elements

Poor or no security measures
Poor backup and recovery services

Low quality data / unreliably data leading to bad decision making

The role of the Administrator --- DBA

This role involves a more hands on physical involvement with the management of the database. The DBA deals with technical issues such as security enforcement, daily performance, backup and security issues and administration (i.e. the issuing of user id and passwords, granting accesses etc). HE/she enforces the standards and procedures laid out by the Data administrator.

The characteristics of a good DBA include:

A board technical background
A solid knowledge of hardware and software
An understanding of data processing
Strong Data modelling skills at conceptual, logical and physical levels
Manage other IS personnel
Provide training and support fir end users
Understand the DB development cycle

Overview - Database Administrator functions
Planning
Data policies procedures and standards
Data conflict resolution
Internal marketing
Managing Data repository
Selection of hardware and software
Managing data security
Privacy of user information
Data backup and recovery


Detailed Discussion of Database Administrator functions

Planning
The proposed system should be carefully considered from the viewpoint of the enterprise architecture. The proposed system should meet...

Similar Essays