What is database management system? Why database management systems are used. Discuss the database system architecture.

Question

Suresh Chand · Accepted Answer

Database system is the software package for managing the databases. There are several database systems on the basis of how they manage the database. There are mainly two types of database forms Single-file Database Relational Database 1. Data Integrity Data integrity means data is consistent and accurate in the database. It is essential as there are multiple databases in DBMS. All these databases contain data which is visible to multiple users. Therefore, it is essential to ensure that data is consistent and correct in all databases for all users. 2. Data Security Data security is a vital concept in a database. Only users authorized must be allowed to access the database and their identity must be authenticated using username and password. Unauthorized users shouldn’t be allowed to access the database under any circumstances as it violets the integrity constraints. A DBMS provides a better platform for data privacy thus helping companies to offer an improved data security. 3. Better data integration Due to the database management system, we have access to well managed and synchronized form of data making it easy to handle. It also gives an integrated view of how a particular organization is working and keeps track of how one segment of the company affects another segment. 4. Minimized Data Inconsistency Data inconsistency occurs between files when various versions of the same data appear in different places. Data consistency is ensured in the database; there is no data redundancy. Besides, any database changes are immediately reflected by all users, and there is no data inconsistency. 5. Faster Data Access The database management system helps the users to produce quick answers to queries making data accessing accurate and faster 5. Simplicity DBMS allows us to understand data better with a clear and simple logical view. With dbms, many operations like deletion, insertion or creation of file or data, are easy to implement. 6. Recovery and Backup DBMS automatically takes care of recovery and backup. The users are not required to take periodical backup as this is taken care of by DBMS. Besides, it also restores a database after a system failure or crash to prevent its previous condition. This DBMS architecture has three levels: 1. External level 2. Conceptual level 3. Internal level 1. External level It is also called view level. The reason this level is called “view” is because several users can view their desired data from this level which is internally fetched from database with the help of conceptual and internal level mapping. The user doesn’t need to know the database schema details such as data structure, table definition etc. user is only concerned about data which is what returned back to the view level after it has been fetched from database (present at the internal level). External level is the “top level” of the Three Level DBMS Architecture. 2. Conceptual level It is also called logical level. The whole design of the database such as relationship among data, schema of data etc. are described in this level. Database constraints and security are also implemented in this level of architecture. This level is maintained by DBA (database administrator). 3. Internal level This level is also known as physical level. This level describes how the data is actually stored in the storage devices. This level is also responsible for allocating space to the data. This is the lowest level of the architecture.

What is database management system? Why database management systems are used. Discuss the database system architecture.

Leave your Answer:

Hits Counter

Question

What is database management system? Why database management systems are used. Discuss the database system architecture.

Leave your Answer: