DBMS used to create, process and administer the database. DBMS receives request encoded in SQL and translates these requests into actions on the database. DBMS is the large, complicated program that is licensed software.
DBMS perform more common functions:
1. Create database
2. Create supporting structures
3. Read database
4. Maintain database structures
5. Enforce rules
6. Control concurrency
7.Provide security
8. Perform backup and Recovery
Organizational database system typically:
•support several users simultaneously
•include more than one application
•involve multiple computers
•are complex in design
•have many tables
•have many databases
Types of DBMS:
-
Sybase Management
-
IBM DB2 Management
-
PostgreSQL Management
-
Memcached Management
-
MongoDB Management
-
Redis Database Management
-
Oracle Management
-
MySQL Management
Advantages of DBMS:
-
Improved data consistency
-
Improved data sharing
-
Improved data quality
-
Increasing productivity of application development
-
Improved data accessibility
-
Reduced program maintenance
-
Minimal data redundancy
Disadvantages of DBMS:
-
A complex conceptual design process
-
need to hire database-related employees
-
High DBMS acquisition costs
-
A more complex programmer environment
-
complex, difficult, and time-consuming to design
-
Substantial hardware and software start-up costs
-
Initial training required for all programmers and users
