In this tutorial, We will study What is Database management system the difference between data and information, file system & advantages and disadvantages of the DBMS. So let us start.
Database management systems are a set of programs or we can say a software tool used for manipulation, updation, deletion, insertion, and retrieval of data from the database. The database management system (DBMS) contains information about a particular enterprise.
The database management system (DBMS) provides an environment that is both convenient and efficient to use. In the early days, database applications were built on file systems but as the requirements increased they prove to be less efficient.
Data is the facts that can be recorded or stored in the form of text, numbers, videos, speech, images, etc. Example: Mobile numbers, address, voter id number, etc.
Data in the database management system (DBMS) is stored in the form of tables that are organized into columns that contain the type of data specified.
The database is a collection of interrelated data that can be used to perform some specified task.
So, databases are a collection of interrelated data that represent real-world entities and are used to perform real-world problems. The database is used in banking, airlines, universities, sales, online retailers, etc. Databases touch all the aspects of our lives.
In this, there is only one centralized database that is accessed by multiple users.
In this multiple users will be accessing multiple databases concurrently.
It is maintained by a single user and it is for personal use.
In this, each user will have its own role and responsibilities and can access the database accordingly.
Users have to pay for accessing the database.
In this Relational database, the data will be represented in terms of tables in this, each table will contain rows and columns.
This data will be stored in the cloud and from there, users will be accessing the data.
Everything will be treated in terms of classes and objects.
In this database, the node represents the entity and edge represents relationship.
Information is a collection of data. These are the facts that are provided or learned about something.
|Data is raw information, facts that are not organized, that is which needs to be processed.||Information is organized facts that contain some meaning.|
|Every fact available is data.||Anything that is meaningful to us today is called information.|
File systems are used for the retrieval and storage of data. They are just like database management systems but a little less efficient. They are used in organizations in which less security and constraints are required. They are more often used in small scale firms.
Duplication of information in various files leading to inconsistent states.
A new program has to be written to carry out new tasks. Accessing the files are not convenient as well as efficient.
Multiple files and formats so programming becomes difficult.
The addition of new constraints is hard or changing the existing ones.
Even the slightest change in file affects the whole program and change is needed in all of them.
In case of any failure, there is no mechanism to switch back to the previous state. The file system does not guarantee atomicity.
In the case of file systems, concurrent access leads to incorrect data and hence leads to an inconsistent state.
It is hard to provide user access to some of the data rather than all.