A DBMS is a software that allows creation,
definition and manipulation of database. Dbms is actualy a tool used to perform
any kind of operation on data in database. Dbms also provides protection and
security to database(Manage the Data). It maintains data consistency in
case of multiple users. Here are some examples of popular dbms MySql, Oracle, Sybase, Microsoft Access and
IBM DB2 etc.
Function Of Database
Management System
Function Of Database
Management System
Database Management System (DBMS) performs several important functions that guarantee the integrity and consistency of the data in the database. The most important functions of Database Management System are
·
Data Dictionary Management
·
Data Storage Management
·
Data Transformation and Presentation
·
Security Management
·
Multi user Access Control
·
Backup and Recovery Management
·
Data Integrity Management
·
Database Access Languages
·
Application Programming Interfaces
·
Database Communication interfaces
Component Of
Database Management System
There are
five major components in the database system environment and their
interrelationship are.
1)
Hardware : Hardware is the one of
the most important component of the database system environment. It refers to
all of the system’s physical devices like computers (PCs, workstations,
servers, and supercomputers), storage devices, printers, network devices and
other devices .
2)
Software: The most readily identified
software is the DBMS itself, to make the database system function fully, three
types of software are needed: operating system software, DBMS software, and
application programs and utilities.
3)
Data: It is the most important component
of DBMS environment from the end users point of view. As shown in observes that
data acts as a bridge between the machine components and the user components.
The database contains the operational data and the meta-data, the 'data about
data'.
4)
Users: There are a number of users who
can access or retrieve data on demand using the applications and interfaces
provided by the DBMS. Various type of users DB administrator,
System developer and End users.
5)
Procedures:
Procedures refer to the instructions and rules that govern the
design and use of the database. The users of the system and the staff that
manage the database require documented procedures on how to use or run the
system.
Advantages
Of Database Management System(DBMS)
·
Improved data sharing:
·
Improved data security
·
Better data integration
·
Minimized data
inconsistency
·
Improved data access
·
Improved decision making
·
Increased end-user
productivity
Disadvantages
Of Database Management System(DBMS)
·
Complexity
·
Costly
·
Large in size
No comments:
Post a Comment