Skip to main content

What is DataBase Management System ?

DataBase Management System:

database related terms

Dbms stands for database management system.A system which is responsible for managing a database.A system which allows users to store and retrieve their precious data.By using a dbms system we can manipulate data from database.As well we can produce a meaning full data from database after filtering.

Mysql is an example of rDbms. Here 'r' represents relational database. It means data is organized in terms of table. There are various dbms software in the market. For example oracle , sql server , dbase , mysql , ms-access etc. A dbms application comes with it's query set. By using those query set you can do any interaction with database. For database operations like updating or inserting data a DBA is responsible. In a small organization there may not be a DBA position. But in all big companies there is always a dba person available to manage database of that company. 


A database is a collection of structured data. We can understand a database as a collection of related tables. A table is nothing but collection of columns and rows. A row or record is defined as it contains related columns or fields data. A record is also known as tuple of a table. A column or a field is a name which tells that what kind of data a record contains.


Mysql is an example of rdbms. Mysql is an open source software. You can use it freely. For accessing data from this(MySql) dbms we use sql queries. 


Sql stands for structured query language. This language contains various protocols to access data. This protocol known as query . Query is just like a qustion to dbms to work on that. A query is a instruction for dbms to insert , retrieve , edit or deleting a data. 




Comments