A database is a collection of structured data stored in a computer that is easily approachable and manageable. The relevant purpose of the database is to operate a huge volume of information by storing, retrieving, and managing data.
In this fast-growing world of technology every organization has enormous data that needs to be preserved. Let’s consider a few simple examples.
A hospital can have N number of patients, doctors, nurses. They would need to store the reports of their patients as well as the details of their employees. How can they exactly store so much data? So here comes the concept of Database.
An online cell phone directory would use the database to store the contact details of people.
WhatsApp stores the information of all our contacts, their chats, status, their profile pictures, and a lot more.
What is a Database Management System (DBMS)?
A collection of programs that helps the users to access database, fetch data, update data, or represent data in the form of reports is called a Database Management System (DBMS).
Database Management system helps in improving data sharing and data security.
Types of Database Management System (DBMS)
The hierarchical model represents data into a tree-like-structure. It has its root and then the entire data is linked to it. It expands like a tree with its branches wide open. This is a relationship that can be defined as one: Many, which means each parent node consists of a child node. However in this model, a child node will only have a single parent node.
Network DBMS is an enhanced and improvised version of hierarchical DMBS.
Unlike hierarchical DBMS a Network database management system (Network DBMSs) are based on a network data model that allows a single record can have multiple parents and multiple child records. So we can understand this as a MANY TO MANY relationship.
One of the best advantages that can be counted as a part of Network DBMS is that it has greater flexibility as compared to the hierarchical DBMS.
A relational database management system (RDBMS) is a program that allows us to construct, update, manage, and administer a relational database where data is in the form of tables consisting of rows and columns.
Now the term relational signifies that there is a relationship that exists between values within each table. Tables within the same database can also be related to one another. Now at this point, it becomes very proximate to query the database and fetch relevant records from multiple tables.
In this example, both the tables have a common column called Department ID. So we can say that, these two tables are related based on Department ID column.
Object Oriented DMBS
An object-oriented database (OODBMS) is a database that is based on object-oriented programming (OOP). The representation and storage of data is done in the form of objects.
It is generally used to handle structured data and multimedia data such as Audio, Video, and Pictures, etc.
Want More SQL Deep Dives