The DataBase Manageent System(DBMS) is a software that allows
creating and managig databases.It provides users a systemetic way
to create update retrieve and manage data.
DBMS essentially serves as an interface between the databases and
end users or application programs,ensuring that data is
consistently organised and easily available.
Principle components of DBMS
- Software
- Hardware
- Data
- Procedures
- Database Access Language
- Users
- Software:
It's the main component of DBMS.It's a set of programs that allows
to handle the database and to control and manage the overall
database.
Operating System including network software being used in network
to share data of database among everal users.
- Hardware
Hardware consists of set of physical electronic devices such as set
of computers,storage devices,I/O channels etc.
It's impossible to implement the DBMS without such hardwares.
In a network a computer with efficient processing speed , large
storage capacity is used as database server.
- Data
The main pupose od the DBMS is to process data.
In DBMS,databases are defined then created and data is
stored,updated,retrieved to and from the databases.
The databases contains both the actual data and the metadata.
- Procedures
Procedures refer to instructions and rules that help in designing
the database and to use the DBMS.The users that operate and manage
the DBMS require documented procedures on hot use or run the
database management system.
Here are some examples of procedures
- Procedure to install new DBMS
- to log on to the DBMS.
- To use the DBMS or application programs.
- To make backup copies of databases.
- to generate the reports of data retrieved from databases.
- DataBase Access Language
Database access language is used to access the data to and from the
database.
The users use the database access language to enter new data,
change the existing data in database and to retrieve required data
from databases.
The database engine generates a set of results according to the
commands submitted by user, converts these into a user readable
form called an Inquiry Report and then displays them on the
screen.
The administrators may also use the database access language to
create and maintain the databases.
The most commonly used language is SQL(Structured Query
Language).
- Users
The users are those who manage the databases and perform different
operations on databases in the DBMS.
There are three kind of users
- Application Programmers
- End Users
- database Administrators
- Application Programmers
The people who write application programs in any programming
language(like C++,java,Visual Basic etc) to interact with databases
are calle application Programmers.
- End Users
The end-users are those people who interact with the database and
perform different operations on the databas such as
inserting,updating,retrieving the data to and from databases.
- Database Administrator
A person who is responsible for managing the whole database
management system is known as database Administrator or DBA.