Disadvantages Of Dbms

1488 Words6 Pages
In Chapter 1: Databases and Database Users of the textbook The Fundamentals of Database Systems, Elmasri and Navathe discuss the characteristics, people involved, advantages, and history of database and database management system. To introduce briefly, an assemblage of data of any complexity and size is called a database and DBMS makes it easy for users to manage the database by providing functions like stipulating data types and structures, storing the data, retrieving and updating the stored data, and sharing between multiple users. DBMS has several characteristics. First of all, DBMS allows each user to manipulate just the file they are interested in in the part of a software application. This is called the file processing. Then there is…show more content…
First of all, it reduces redundancy of data and therefore saving storage space and helping with consistency. It provides an account subsystem and prevents people who should not be accessing the database from accessing it, contributing to the security. DBMS also converts back and forth between database systems and programming languages and therefore connecting them two, and allows data to be recaptured by other programs even after a program is terminated. Additionally, it provides cache for better efficiency and backup in case a transaction fails. Another advantage provided by DBMS is multiple user interfaces. These are essential as there are users with different technical experience and level of knowledge. DBMS also can show relationships between data and makes it easy to update and retrieve the associated data. It also lets users to set data types for data items and automatically detects if an entry does not follow the data type. Last but not least, it can analyze data stored in the database and guess new information from…show more content…
Conceptual data model is high level, as in it is easy to follow as it is similar to how people think about data. It uses entities, or object in real world, attribute, or property of an entity, and relationship of multiple entities. Physical data models is the way data is stored. Representational data model is in between conceptual and physical data models. It uses record structure for data and is used often in commercial DBMS. Also self-describing data models merge data description and data values. Database schema is details of database, ad schema diagram shows forms of database schema. Schema evolution is the modification of schema from the modification of the database
Open Document