In this post, we gonna talk about DBMS. We will talk about what is DBMS, the difference between DB DBMS, Most people are confused between the database and DBMS, So first let's see What is DBMS.
DBMS is Stands for Database Management System. As we can understand by its name Database Management System is used to manage the Database. Database Management System is used to create the database. Read the Database and Update the Database. Some popular databases in the world are
Database Management System
- Mongo DB
- Postgre SQL
- Oracle
- MySQL
- Microsoft SQL Server
These are some popular Database Management systems in the world. Which are mostly used by a multinational company in their project to manage the Database. Almost every Database management systems support only one language and that is SQL. SQL stands for the Structure Query Language.
Difference Between the DBMS and DB.
Basically, DB that stands for Database is subordinate to DBMS that stands for Database Management system. Because we manage our database through Database Management System. We have to right query to perform a task in our database. We can add the data into the database through this query. We can update the data into the database. we can delete the data into the data through this query. we have to write a query and give it to the Database management system and then the database management performs that task on our database which we mentioned in our query.
Types of Database Management System
Difference between relational and no-relational Database Management system
Relational Database Management System is Store the Data in the form of a table that is related to each other. RDBMS (Relational database management system) uses the tabular structure where the header names are the column name and row contains corresponding value by its name. Relational Database management system presents the data normalization. Basically, a Multinational company's first priority is RDBMS In their project. In RDBMS there is multilevel security regarding data manipulation.
Database Management System is considered as a no relational database management system. Database management systems store the data as a file. DBMS stores the data either in hierarchical or in a navigational form. DBMS does not present the data normalization. There is no relation between the data into the Database management system. In DBMS there is no security regarding data manipulation.
I hope this blog is helpful to you if you have any doubt you can comment. I will reply as soon as possible.
){kind=link}
0 Comments