Module 1

Page 1

MOD 1 - Databases and Database users

Database Administrators

In any organisation where many people use the same resources, there is a need for a chief admin to oversee and manage these resources. Administering these resources is the job of the DBA.

- The DBA is responsible for authorizing access to database, coordinating and monitoring its use and acquiring software and hardware resources as needed.- The DBA is accountable for problems such as breach of security or poor system response time.

Database Characteristics

- Self- describing nature of a Database system- Insulation between Programs and Data, and Data abstraction

- Support multiple Views of the Data- Sharing of Data and Multi user Transaction Processing.

Database advantages

- Controlling redundancy

- Restricting unauthorized Access

- Providing Persistent Storage for Program Objects

- Providing Storage Structures for Efficient Query Processing

- Providing Backup and recovery

- Providing Multiple User Interfaces

- Representing Complex Relationships among Data

- Enforcing Integrity Constraints.

- Permitting Inferencing And Actions Using Rules