Introduction to Database Management Systems And Their Advantages

Asked By 30 points N/A Posted on -
qa-featured

What is the use of a Database Management System and what are the advantages of DBMS over the File System? Also, state the drawbacks of a File System.

SHARE
Answered By 50 points N/A #182539

Introduction to Database Management Systems And Their Advantages

qa-featured

Hi

A File System is a manual storage of files. A Database Management System is a collection of similar data stored in some manner. The drawbacks of a file system are: Data Redundancy and Inconsistency, Concurrent data access, Atomicity problems, Security issues, Data Isolation, etc.

The advantages of DBMS are: -Decreased data redundancy, higher consistency, increased integrity, and data independence, reduced updating errors, etc.
 

Answered By 566795 points N/A #182540

Introduction to Database Management Systems And Their Advantages

qa-featured

DBMS is an acronym used for Database Management System. In simple words, it is a system that manages or handles databases. Examples of this system are SQL Server and Oracle. These are systems that can be utilized to handle transactional databases like banking systems, HR systems, and others. These are usually optimized for executing transactions.

DBMS gives programmers and users with an efficient method of retrieving, creating, managing, and updating data. It makes it possible for end users to update, create, read, and delete data in a database. It basically acts as an interface between end users or applications and the database making sure that data is regularly organized and continues to be easily accessible. The DBMS manages three vital things:

  • * The data.
  • * The database engine that permits data to be modified, accessed, and locked.
  • * The database schema which describes the database’s logical structure.

These three foundational elements help in providing security, uniform administration procedures, concurrency, and data integrity.

Login/Register to Answer

Related Questions