Ammar Academy
INTRODUCTION TO DATABASE
Chapter 1 : Introduction To Database
- Database is simply an organized collection of related data, typically stored on disk, and accessible by possibly many concurrent users. It is designed to meet the information needs of an organization.
- A Database Management System (DBMS) is a set of programs that manages any number of databases. It enables users to define, create, maintain, and control access to the database.
- A DBMS is responsible for : accessing data, inserting, updating, and deleting data, security, application-defined rules, including triggers facilitating backups and recoveries, optimizing performance and maximizing availability.
- Components of DBMS :
a) Hardware
b) Software
c) Data
Disadvantages of DBMS
1. Complexity
2. Size
3. Cost of DBMS
4. Additional hardware costs
5. Cost of conversion
6. Performance
7. Higher impact of a failure
Advantages of DBMS
1. Balance conflicting requirements
2. Improved data accessibility and responsiveness
3. Increased productivity
4. Improved maintenance through data independence
5. Increased concurrency
6. Improved backup and recovery services