DBMS

DBMS

• is a system software for creating and managing databases

• provides users and programmers with a systematic way to create, retrieve, update, and manage data

• a software through which users and application programs interact with a database

Data

• smallest unit that may consists of bits or bytes

• stored in a system is partition into one or two databases

• can be collected orally or written

Hardware

• a major and primary part of database

• “which we can touch and see”, i.e. physical existence

• Storage devices: hard disk, floppy disk, magnetic disk, magnetic drum

Software

• a system that works together with hardware

System Software

• OS, all the languages and system packages

• designed to provide a platform for other software

• act as an intermediary of hardware and user

Application Software

• payroll, electricity billing, hospital management

• created to help users to perform specific tasks directly

Users

• individuals who interact with data to update, read, and modify information on a daily basis

• work together with hardware

• can access and retrieve data from database through DBMS applications and interfaces

Advantages of DBMS

1. Controlling Redundancy

2. Restricing Unauthorized Access

3. Inconsistency can be reduced

4. Shared Data

5. Standard can be endorced/maintaned

6. Security Maintenance

7. Integrity Maintanenance

8. Removed Confliction

9. Multiple User Interfaces

10. Complex Relationships of Data

11. Backup and Recovery

Disadvantage of DBMS

1. increased cost

2. Staff Cost

3. Complexity

4. Large Memory requirements

5. Database Failure

6. Difficult Backup and Recovery

7. Frequent Updates

Database Administrator (DBA)

• Responsible for installing, configuring, upgrading, and maintaining databases.

System Analyst (SA)

Researches problems, plans solutions, and coordinates development.

DBMS Developers

Skilled systems programmers who develop and enhance DBMSs.

USERS

People who use the application and its interfaces but don't need to understand the underlying DBMS.