WHAT IS DBMS?

DBMS stands for DATA BASE MANAGEMENT SYSTEM. It is a collection of programs which enable its users to access database manipulate data and representation of data.

"DBMS IS AN INTERMEDIATE LAYER BETWEEN PROGRAMS AND THE DATA."

for ex:- MySQL, SQL, Oracle, DB2 etc.

DATABASE

It is a systematic collection of data. Database supports storage and manipulation of database.
for ex:- IRCTC, Amazon, Facebook etc.

COMPONENTS OF DBMS

There are five components in the database are:

• Hardware.
• Software.
• Data.
• Database User.
• Procedure.

HARDWARE

It is the actual computer system used for keeping and accessing the database.

SOFTWARE

The software is the actual DBMS between the physical layer database itself and the users of the system is a layer of software, usually called the DBMS.

DATA

It is the most important component of DBMS environment from the end users point of view.

DATABASE USERS

There are number of users who can access or retrieve data on demand using the applications and interface provided by the DBMS.
the users can be:

• Naive Users/Native Users.
• Online Users.
• Application Programmers.
• Sophisticated User.
• Database Administrator(DBA.)

PROCEDURE

Procedures refers instructions and rules designing a datbase. Manage a dtabase with rules.
these rules are:

1. Log on to the DBMS.
2. Start and stop the DBMS.
3. Handle hardware or software failures.
4. Backup copy makes.

Advantages of DBMS

• Controlling Redundancy.
• Integrity can be enforced.
• Data can be stored.
• Concurrency control.
• Data model can be developed.

Disadvantages of DBMS

• Complexity.
• Memory Size.
• Performance.
• Higher impact of a failure.
• Cost of DBMS software.