A database is a place to hold and manage huge volumes of data in an organized manner. What is a DBMS? A DBMS or Database Management system allows users to access a database easily and safely, without jeopardizing data security. It provides users with an efficient working environment to work with the database.

A DBMS helps in storing and manipulating information and can be used for managing large files. It protects data from being lost when the system crashes, data from being tampered with by unauthorized users and shared data from being corrupted. There are many features of a DBMS that makes it a very convenient and sensible interface for users; data can be effectively organized even before being put into the database. Some of the key features include – the ability to process queries, the facility to backup and replicate files, the possibility for users to attach rules on data attributes, securing the attributes and computing them.

A distributed database is a DBMS model in which data is distributed across multiple computers in the same or different locations instead of being stored on a single computer. All these computers are interconnected and the DBMS handles the data as if it is from a single storage so that no difference is perceived by the user. Distributed databases make way for perpetual data availability and improved data management. When a distributed database is being used, care must be taken to ensure data transaction and distribution transparency which in turn ensures data consistency.

Rate this topic:

(No Ratings Yet)

 Loading ...