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.
1. The database management system (DBMS) offers freedom from all the problems faced in the case of file systems.
2. It is efficient for larger pieces of data and helps in improving the updating speed which in turn reduces redundancy and hence removes inconsistency helping the database to remain in a consistent state.
3. It allows concurrent access which is much needed in today's world. Plus it allows the addition of security constraints to a specific as well to the whole database.
4. The database management system (DBMS) considers each transaction as an atomic entity therefore each and every transaction can be performed independently of each other.
5. In addition in case of failure during the execution of a transaction, the entire transaction executes or doesn’t execute at all, this helps in maintaining consistency of the database.
6. The decision-making ability is much more efficient making it much easier to generate good quality information.
1. The cost increases due to the cost of hardware and software as highly trained people are required for maintenance and the cost of converting data is high. With the addition to so many features in database management systems (DBMS).
2. The complexity also increases.
3. Maintenance cost is high as frequent updates are required.
4. Database management systems (DBMS) are not that efficient in case of usage in small scale firms as the speed is slow.
The conclusion is that both the database management system (DBMS) and the file system can prove to be efficient and reliable depending upon the user requirement.
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, 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.
1. Regardless of the disadvantages of file systems, there are many advantages of file systems like they are less complex and can be easily used by any individual without having much technical knowledge.
2. Data retrieval is easy and efficient.
3. Data can be stored in a compact form. In the file system, the backup system is automatic and fast.
4. Data retrieval can be done from remote locations which means data can be accessed from any location around the globe.