What is DBMS?

Posted in

What is DBMS?

Anmol Jain
Last updated on November 15, 2022

    Information is something that needs to be managed well and is a specific requirement of every company out there. In order to manage the same, the enterprise is requested to know its needs regarding information, acquire them, organize the same, check the quality and sources because the reliability of the same matters for sure, and the last comes making such information acquired to make available out there for the ones who might need it.

    What is DBMS?

    The database management system herein is like a record keeper, every data gets stored and retrieved from this place. They have well-managed files and are easier to use. The system also helps a person or a company out there to add a new file or delete the same, insert or edit the data in existing ones and also retrieve data at times of need from them. Some of the famous Database management systems out there are Oracle, SQL servers, DB2 , etc.

    When it comes to databases and the hierarchy, there is a database which is a collection of files. Then comes a file which is a collection of records, then comes a record, which is nothing more than a collection of fields, fields which a collection of characters, and characters are what can be called collections of Bits.

    Types of DataBase

    There are some database models which are famous out there. They are as follows:

    1. Hierarchical Database System - therein, the records get organized out in the hierarchy of relationships. They are arranged in an inverted tree pattern. The best example of the same is an equipment database wherein there are building records, room records, equipment records, and also repaid records. The hierarchy records are also known as nodes which in turn are related to others just like a parent-child relationship, just to say every parent might have more than one child, but every child will not have many parents. Herein the parent record is called the root record, and they work all in the hierarchy.
    2. Network database system - therein, the data differ from that of the hierarchical model, and there is more than one node. They are the best structure to show something which has a relationship of many to one or many to many relationships. Herein a child can have more than one parent node and is best used in a repair vendor or any such area out there. It allows the connection of also one-to-one relationships and allows one to create owner records without a member one.
    3. Relational database models - are a mixture of both hierarchy and also network-based database systems. They allow one data to be processed one record at a time. They have 3 main terms, which are relations, attributes, and also domains. The same network revolves around these 3 attributes and contains multiple tables. Herein lots of rules are also required to be followed.
    4. Object-Oriented DataBase model - they help programmers create objects in a programming language that behaves like a working object. Herein all objects function independently of each other and are assigned a specific task or some roles to perform.

    Advantages of Data Base Management system

    There are varied advantages and roles that a DataBase Management system plays in a company or an individual business. Some of them are mentioned below

    1. Data sharing- Data, once stored, can be used by anyone who got access to such a DataBase Management system. All they need is to specify their login ID and password, and things get simple. A person is allowed to log in and retrieve data as per their need.
    2. Minimization of Data redundancy- the same gets minimized or reduced and is also controlled so that no such issues arise. This reduction will decrease the cost of storage for the company and will make proper use of the same.
    3. Integrity- the data is consistent and reliable as the sources are checked beforehand so that no such issues arise as regards the same. The data is also kept up to date and is always tried to be mistake-free so that the issues don’t arise as regards the same.
    4. Consistency of information and file- there is a standard format for keeping data. This, in turn, will get the work consistent because the same type of rule, format, etc., are followed everywhere. Multiple programmers can use such data without an issue.
    5. User-friendly- the data stored is user-friendly as the access is simple, and the user can easily be get satisfied by the data they get.
    6. Security- as the data is stored in one place, security concerns for varied places are never a concern, and a person or a company just needs to use a security system in one place for the sensitive data stored out there. There will also be IDs and passwords for everyone out there so that no unauthorized access can be made, etc.

    Disadvantages

    Just like many advantages, there is also some disadvantage to Data Base Management system. They are mainly 2 concerns as regards the same, which are discussed below:

    1. Cost- to maintain such a huge database, a lot of cloud space is needed on the network, which will definitely be costly for sure and will add up to the expense of the company every month as a fixed cost.
    2. Security- the same is another concern because the same is used just in one place, and any issue with the same will lead to unwanted use of data. This can be very risky for huge companies whose data are very valuable to them and are not meant to be leaked out before time.

    Conclusion

    So, this is how a database functions with so many advantages and disadvantages out there which makes it more and more usable. This system has really made our life easier and will continue doing the same if it is used in a proper manner and is able to provide its services out there within and outside the organization to help people and all its users who rely on the same to get better records and data.

    People are also reading:

    FAQs


    DBMS stands for the database management system. It is a software tool for creating and managing databases. With DBMS, storing and manipulating a large amount of data becomes easy.

    There are four types of DBMS: 1. Hierarchical 2. Relational 3. Object-Oriented 4. Network.

    In DBMS, the primary key is a column of a table that uniquely identifies a record or row in that table. Every database table should have the primary key to insert, update, delete, and fetch data.

    Charles W. Bachman designed the first DBMS named Integrated Data StoreIDSwas. A small team at the General Electric Company created the first database management system.

    The three types of relationships in databases are one-to-one, many-to-one, and many-to-many.

    Leave a Comment on this Post

    0 Comments