Advantages and disadvantages of relational database management system.
The database management systems are warehouses of Information, where large amount of data can be stored. The common examples in commercial applications are inventory data, personnel data, etc. It often happens that a common man uses a database management system, without even realizing, that It Is being used. The best examples for the same, would be the address book of a cell phone, digital diaries, etc. Both these equipments store data in their internal database. Defining Attributes The unique data field in a table is assigned a primary key. The primary key helps in the Identification of data.
It also checks for duplicates within the same table, thereby reducing data redundancy. There are tables, which have a secondary key in addition to the primary key. The secondary key is also called ‘foreign key. The secondary key refers to the primary key of another table, thus establishing a relationship between the two tables. Systematic Storage The data is stored in the form of tables. The tables consists of rows and columns. The primary and secondary key help to eliminate data redundancy, enabling systematic storage of data. Changes to Schema The table schema can be changed and It is not platform dependent.
Therefore. The tables in the system can be edited to add new columns and rows without hampering the applications, that depend on that particular database. No Language Dependence The database management systems are not language dependent. Therefore, they can Table Joins The data in two or more tables can be integrated into a single table. This enables to reduce the size of the database and also helps in easy retrieval of data. Multiple Simultaneous Usage The database can be used simultaneously by a number of users. Various users can retrieve the same data simultaneously.
The data in the database can also be edified, based on the privileges assigned to users. Data Security Data is the most important asset. Therefore, there is a need for data security. Database management systems help to keep the data secured. Privileges Different privileges can be given to different users. For example, some users can edit the database, but are not allowed to delete the contents of the database. Abstract View of Data and Easy Retrieval DB’S enables easy and convenient retrieval of data. A database user can view only the abstract form of data; the complexities of the internal structure of the database re hidden from him.
The data fetched is in user friendly format. Data Consistency Data consistency ensures a consistent view of data to every user. It includes the accuracy, validity and integrity of related data. The data in the database must satisfy certain consistency constraints, for example, the age of a candidate appearing for an exam should be of number data type and in the range of 20-25. When the database is updated, these constraints are checked by the database systems. The commonly used database management system is called relational database management system (READS).
The most important advantage of database management systems is the systematic storage of data, by maintaining the relationship between the data members. The data is stored as tepees in a READS. The advent of object oriented programming gave rise to the concept of object oriented database management systems. These systems combine properties like inheritance, encapsulation, polymorphism, abstraction with atomicity, consistency, isolation and durability, also called ACID properties of DB’S. Database management systems have brought about systemization in data storage, along with data security.