What is DBMS ?
Features of DBMS
Function of DBMS
Advantages of DBMS
Disadvantage of DBMS
Quality answer needed with long explaination.
Answers
Answer:
A Database Management System (DBMS) is software designed to store, retrieve, define, and manage data in a database.
A Database Management System (DBMS) is defined as the software system that allows users to define, create, maintain and control access to the database. DBMS makes it possible for end users to create, read, update and delete data in database.
The ten functions in the DBMS are: data dictionary management, data storage management, data transformation and presentation, security management, multiuser access control, backup and recovery management, data integrity management, database access languages and application programming interfaces, database communication
✯✯✯✯✯_________________________✯✯✯✯✯
✯✯✯✯✯_________________________✯✯✯✯✯
━━━━━━━━━━━━━━━━━━━
DBMS software primarily functions as an interface between the end user and the database, simultaneously managing the data, the database engine, and the database schema in order to facilitate the organization and manipulation of data.
Though functions of DBMS vary greatly, general-purpose DBMS features and capabilities should include: a user accessible catalog describing metadata, DBMS library management system, data abstraction and independence, data security, logging and auditing of activity, support for concurrency and transactions, support for authorization of access, access support from remote locations, DBMS data recovery support in the event of damage, and enforcement of constraints to ensure the data follows certain rules.
━━━━━━━━━━━━━━━━━━━━━━
There are several features that distinguish a Relational DBMS from a DBMS, including:
Structure: Where data is structured in hierarchical form in a DBMS, data is structured in tabular form in a RDBMS.
User capacity: A RDBMS is capable of operating with multiple users. DBMS can only manage one user at a time.
Software/hardware requirements: A RDBMS has greater software and hardware requirements.
Programs managed: DBMS maintains databases within the computer network and system hard disks. A RDBMS manages the relationships between its incorporated tables of data.
Data capacity: A DBMS is capable of managing small amounts of data and a RDBMS can manage an unlimited amount of data.
Distributed databases: A DBMS does not provide support for distributed databases while a RDBMS does.
ACID implementation: A RDBMS bases the structure of its data on the ACID (Atomicity, Consistency, Isolation, and Durability) model.
━━━━━━━━━━━━━━━━━━━━━━
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 andApplication Programming Interfaces and
Database Communication interfaces
━━━━━━━━━━━━━━━━━━━━━━
Data Redundancy
Data Inconsistency
Data Sharing
Data Searching
Data Security
Data Concurrency
Data Integration
Data Access
Decision making
Data Backup and Recovery
Data Migration
Low Maintenance Cost
Data Loss is almost eliminated
Data Atomicity
━━━━━━━━━━━━━━━━━━━━━━
High Cost.
Size.
Database Failure.
Database Failure
Increased Staff Cost.
Requirement of Technical Staff.
Cost of Data Conversion.
Performance.
━━━━━━━━━━━━━━━━━━━━━━