Database Management System (DBMS):-

➺ We must be known the following term before going on the introduction to the database management system (DBMS):-

◆ Data: It refers to raw facts and figures. ex:- number, video, audio, image, character, etc.

◆ Information: The processed data or organized data is called information.

◆ Database: A database is a collection of interrelated data which represent an aspect of the real world.

➺ There are two types of database

○ Structure Database: For Example -> IRCTC, Banking, University.

○ Unstructure Database: For Example -> No SQL, Website.

Introduction to DBMS (Database management system)

➺ Database management system is software that is used to create, store, and retrieve user data easily and efficiently with security measures.
➺ Its is software to organize a database and contains the number of programs that manage the whole database.
➺ There are different types of DBMS, ranging from small systems that run on personal computers to big systems that run on mainframes.
➺ Dbms provides an interface between the user and the database.
➺ Examples of DBMS - are Oracle, MySQL, SQL Server, MS Access, Filemaker, Clipper, Foxpro, RDBMS, Db2, etc.

➺ The main objective(goal) of DBMS is to store and retrieve database files in an efficient way.
➺ The secondary goal of DBMS is to maintain high system performance when data is retrieved from the database file.

➺Database allows users to access data, enter, view, and update with limited access permission granted to the user.
➺ Database can be used on a single machine by a single user only.
➺ Database can be accessed by multiple users at a time.

◆ Operations performed by database by using Database software are:-

➺ Database definition.
➺ Database creation.
➺ Retrieval.
➺ Database Update
➺ Performance monitoring.
➺ Database integrity control and security.
➺ Database revision and Restructuring.

1. Convenient - easy to use.
2. Efficient - Fast processing.
3. Handle a large amount of data.
4. Handle a large number of users.
5. Easily perform a query.
6. Provide data security.

➺ Application programmer:A programmer who develops an application for the end user.

➺ End Users: A Person who gets access database by using query Language

➺ Database Administrator (DBA): A person who manages and controls the entire Database.

You might like this :-

○Architecture of dbms
○Codd's_12_ Rules
○History of Computer
○DBMS vs RDBMS