Database Management System (DBMS) – Meaning, Characteristics and Components

Posted on Aug 18 2017 - 1:40pm by admin

Database Management System (DBMS)

Topics covered :

  • Meaning
  • Characteristics and
  • Components

Database is a collection of related data organized in a way that data can be easily accessed, managed and updated. Any piece of information can be a data, for example name of your school. Database is actually a place where related piece of information is stored and various operations can be performed on it.

A DBMS is a software that allows creation, definition and manipulation of database. A database management system stores data in such a way that it becomes easier to retrieve, manipulate, and produce information.Here are some examples of popular DBMS, MySql, Oracle, Sybase, Microsoft Access and IBM DB2 etc.

Characteristics

  1. Data Persistence

Data persistence means that in a DBMS all data is maintained as long as it is not deleted explicitly. The life span of data needs to be determined directly or indirectly be the user and must not be dependent on system features. Additionally data once stored in a database must not be lost. Changes of a database, which are done by a transaction, are persistent. When a transaction is finished even a system crash cannot put the data in danger.

  1. Consistency

 Consistency is a state where every relation in a database remains consistent. There exist methods and techniques, which can detect attempt of leaving database in inconsistent state. A database management system can provide greater consistency as compared to earlier forms of data storing applications like file-processing systems.

  1. Isolation of data and application

It makes data independent of application programs. That is one can add, change, and delete fields from database without affecting existing programs.

  1. Multi-user and Concurrent Access

 Sharing of the data takes place amongst the different type of the users and the applications.  Database management system supports multi-user environment and allows them to access and manipulate data in parallel mode. Sometimes it is necessary to restrict the transactions, when multiple user attempts to access the same data items; because of an unawareness of transaction processing.

  1. Multiple views

 Database management system offers multiple views for different users. A user who is in the purchase department will have a different view of database than a person working in the sales department. This feature enables the users to have a concentrate view of the database according to their requirements.

  1. Query Language

 Database management system is equipped with query language, which makes it more efficient to retrieve and manipulate data. A user can apply as many and as different filtering options as required to retrieve a set of data. Traditionally it was not possible where file-processing system was used.

  1. Real-world entity

 A recent Database management system is more realistic and uses real-world entities to design its architecture. It uses the behaviour and attributes too. For example, a school database may use students as an entity and their age as an attribute.

  1. Relation-based tables

 Database management system allows entities and relations among them to form tables. A user can understand the architecture of a database just by looking at the table names.

  1. Reduce Redundancy

Database management system follows the rules of normalization, which splits a      relation when any of its attributes is having redundancy in values. Normalization is a mathematically rich and scientific process that reduces data redundancy.

  1. Security

Not all users of the system have the same accessing privileges.  DBMS should provide a security subsystem to create and control the user accounts.

Pages: 1 2
About the Author

3 Comments so far. Feel free to join this conversation.

  1. check uscis case status August 20, 2017 at 7:28 pm - Reply

    Thanks for your marvelous posting! I certainly enjoyed reading it, you can be a great author.I will remember to bookmark your blog and
    will often come back later on. I want to encourage continue
    your great job, have a nice weekend!

  2. Lutragen Anti Aging May 8, 2018 at 1:48 pm - Reply

    I am very happy to read this. This is the kind of manual that needs to be given and not the accidental misinformation that’s
    at the other blogs. Appreciate your sharing this best doc. http://perusdajepara.com/component/k2/itemlist/user/665808

  3. Arlena Surbella July 30, 2018 at 8:36 am - Reply

    Oh my goodness! an amazing article dude. Thank you However I am experiencing issue with ur rss . Don?t know why Unable to subscribe to it. Is there anyone getting identical rss problem? Anyone who knows kindly respond. Thnkx

Leave A Response