Advantages And Disadvantages Of A Relational Database Management System

1355 Words6 Pages
1 Relational Database management system
A relational database management system is based many of the databases system based on relational database model.
A relational database’s use is organizing large amounts of data. Relationships database define the relationship between two points of tables and these database systems are linked by defining that relationship. Database is a well-maintained collection of data. The data are arranged to model particular part of reality in a way that supports process requiring information, such as availability and modelling of rooms in hotels in a way that supports finding a hotel with vacancies.
Number First Name Age Salary
1 Ali 42 1300
2 Umar 38 14000
3 Shoaib 70 13000
4 Umar 12 11020
…show more content…
complicated queries can be bring out. A language called SQL has been elaborate to allow programmers to Update, enter, remove, Create table records.
This SQL statement will remove record number 4 from the Customer table. Far more complicated problem can be written that can keep data from different tables at once.
3. effective. security. By divide data into tables, specific tables can be made confidential. When a human log on with their username and password, the system can then short access only to those tables whose record they are only authorized person to view.

1. Implementation: A important restriction and therefore disadvantage in the use of relational database system is machine performance. If the number of table between relationships to be create more larger and the table themselves more reaction, the performance in responding SQL queries.

2. inactive extraction of meaning from data: if the data is normally organized in a hierarchical the hierarchical may give efficient meaning for that data.
3. Data complication: Data in occupy in many tables, which are connect to each other through s key value. An RDBMS does not force database designer to impose a coherent table.

2 Object oriented database management
…show more content…
OODBMS has also over take the favored system for financial application. Similarly, the OODBMS market is same. The OODBMS continues to find out new application area, such as the www.
1 Recycle and Sharing: The important advantage of extending the Relational data come from Recycle and sharing. Recycle comes from the able to extend the DBMS to perform better functionality,
2 expand Productivity: ORDBMS provide expand productivity both developer and for the last user
3 Take of experience in developing RDBMS: Another useful advantage is that. the extended relational. The important body of knowledge that has gone into developing relational application. This is a better advantage, as many organization would find it too expensive to change. If the new function is designed appropriately, this kind of idea should allow organization to take advantage of the better extension.
The ORDBMS increased complexity and increased costs. Further, there are the proponents of the relational approach and the· essential simplicity' and clarity of the. relational model is lost with these different types of
Get Access