Introduction to DBMS.
Hello Developer’s, In this article we are going to learn about What is DBMS ? What is Database, Purpose / Need of DBMS and drawbacks of File System.
DBMS :
DBMS stands as DataBase Management System. Here Database is nothing but it is a shared collection of logically related data in systematic manner and Management system is a set of programs to store and retrieve data those present in the database. This is the combination of database management system.
Database :
Database is an organised collection of data. Database is a Collection of related or information that is stored in a Computer System.
Data is a small piece of information related to any People, Place and Object. For example Name, Age, height, Weight, Mobile Number, Address, Work and etc. this all data related to any people.
For more detailed information about Database watch this video :
DataBase Management System :
Database Management System is software which is used to manage the database. for example : MS SQL Server, ORACLE, MySQL, DB2, MongoDB, MS Access and etc.
Database management system provides various functionalities to perform operations on database like creation of database, storing data, updating data and creation of tables in single platform.
Database Management System provide Protection and data security facility to database. That's why multiple users can work and data consistency will maintain.
Purpose / Need of DBMS :
Previously data will store in files, but this file systems have some drawbacks.
Drawbacks :
- Data redundancy and data inconsistency (Duplication of data in different files and multiple file formats)
- Difficulty in accessing data(Sometimes need to write a new programs to carry out each new task)
- Data isolation(multiple files and formats)
- Data Security
- transaction Problems(transfer data from one source to another source transaction problem occurs)
Database system offer all the solutions to all this drawbacks of file system. database system solves all this problems thats we use database management system.
For more information please visit my video for better understanding about Database management System :
Please like, Share, Subscribe and Don’t miss to press the Bell icon.
In this article we know about What is DBMS ? What is Database, Purpose / Need of DBMS and drawbacks of File System.
Thanks for reading this article !!!…
