Why dbms

Not recommended when you do not have the budget or the expertise to operate a DBMS. Skip to content. What is DBMS? Characteristics of Database Management System Here are the characteristics and properties of Database Management System: Provides security and removes redundancy Self-describing nature of a database system Insulation between programs and data abstraction Support of multiple views of the data Sharing of data and multiuser transaction processing Database Management Software allows entities and relations among them to form tables.

DBMS supports multi-user environment that allows users to access and manipulate data in parallel. Airlines For reservations and schedule information. Universities For student information, course registrations, colleges and grades. Telecommunication It helps to keep call records, monthly bills, maintaining balances, etc.

Finance For storing information about stock, sales, and purchases of financial instruments like stocks and bonds. Manufacturing It is used for the management of supply chain and for tracking production of items. Inventories status in warehouses. HR Management For information about employees, salaries, payroll, deduction, generation of paychecks, etc. A DBMS must allow users to organize information in a database in a clear hierarchical structure.

It means all objects, records, and tables can be arranged systematically, like a catalog, so the records can easily be accessed and retrieved. In addition, you must also look for various features and functionality depending on your use case.

For example, a DBMS should offer easy database customization options, support multi-user access, and contain a metadata library. These can be broadly classified into four types. The most popular types of database management systems with examples include:. A hierarchical DBMS stores data in a parent-children relationship node — each of which represents a particular entity. This type of DBMS allows one-to-one and one-to-many relationships, i.

A network DBMS is a model that supports many-to-many relationships, which helps store real-life relationships between entities. It is an extension of the hierarchical DBMS that allows modelers to design a more flexible model. In this type of DBMS model, the child nodes are represented by arrows.

A relational DBMS is a model where relationships are based on the data of the entities. Compared to hierarchical and network models, it offers greater flexibility and allows for more simplified relationships between entities, making it a popular choice among data modelers. Data stored in fixed structures can be organized efficiently using SQL.

Figure 3. A DBMS is concerned with the manipulation of data in a database. A data model is an abstract model that organizes elements of data, documents the way data is stored and retrieved, standardizes how different data elements relate to one another and to the properties of real-world entities, and designs the responses needed for information system requirements.

There are three main types of DBMS data models: relational, network, and hierarchical. Other data models include entity-relationship, record base, object-oriented, object relation, semi-structured, associative, context, and flat data models. Database system architecture in DBMS is categorized as either single tier, in which the DBMS is the only entity where the user directly sits on the DBMS and uses it, or multi-tier, in which nearly all components are independent and can be changed independently.

A distributed database is a collection of related data in multiple interconnected databases that are logically interrelated, but physically stored across multiple physical locations. DBMS Quiz. Table of Contents. Save Article. Improve Article. Like Article. Recommended Articles. Article Contributed By :.

Easy Normal Medium Hard Expert.