DataBase_Intro4 |
Objective: DBMS VS RDBMS: DBMS : dBase, Access, IBM's IMS |
A RDBMS uses inter-related collections of Tables, and each table has
a reference point to, one or more, other tables. http://www.differencebetween.info/difference-between-dbms-and-rdbms A DBMS is used to store data in files, some relations among the files can be established. A RDBMS is a DBMS which stores data in tables DBMS can be used for simple applications whereas its next generation design i.e. RDBMS can be used for complex business applications. IBM's Information Management System (IMS) is an example of DBMS and Microsoft SQL Server is an example of RDBMS. RDBMS imposes integrity constraints (ACID) and normalization of tables, and DBMS does not support either of these. DBMS contains flat data, whereas RDBMS maintains some relation between the entities. DBMS support single user, and RDBMS supports multiple users. DBMS used for small amount of data, slows down with complex and large amount of data, RDBMS is comparatively faster than DBMS. Data redundancy is common in DBMS, with key-constraints and indexes in tables RDBMS avoids the data redundancies. |
Dr.E.F.Codd proposed the following rules for a DBMS to qualify as a
RDBMS; however the rules 6,9,10,11,12 are difficult to satisfy.
Rule 0: Foundation Rule: The system must fulfill the condition of
being relational as a database and also as a management system. |
Codd, E. (1985). "Is Your DBMS Really Relational?" and "Does Your DBMS Run By the Rules?" ComputerWorld, October 14 and October 21. Elmasri, R., & Navathe, S. (1994). Fundamentals of Database Systems. 2nd ed. Redwood City, CA: The Benjamin/Cummings Publishing Co. pp. 283 – 285. |