What is difference between RDBMS and ADBMS

Tejas Makwana

Feb 12th, 2007

DBMS includes the theoretical part that how datas are stored in a table. It does not relate tables with another. While RDBMS is the procedural way that includes SQL syntaxes for relating tables with another and handling datas stored in tables. 1)rdbms is object based database management system while dbms 2)rdbms can maintain at many users at same time while dbms not 2)in rdbms is relation is more important than object itself while dbms entity is more important The main advantage of an RDBMS is that it checks for referential integrity (relationship between related records using Foreign Keys). You can set the constraints in an RDMBS such that when a paricular record is changed, related records are updated/deleted automatically. A database has to be persistent, meaning that the information stored in a database has to continue to exist even after the application(s) that saved and manipulated the data have ceased to run. A database also has to provide some uniform methods that are not dependent on a specific application for accessing the information that is stored inside the database. the difference between dbms and rdbms is that it doesn't show the relation while rdbms show the relation and moreover dbms is for small organisations where rdbms for large amount of data In DBMS all the tables are treated as different entities. There is no relation established among these entities. But the tables in RDBMS are dependent and the user can establish various integrity constraints on these tables so that the ultimate data used by the user remains correct. In DBMS there are entity sets in the form of tables but relationship among them is not defined while in RDBMS in each entity is well defined with a relationship set so as retreive our data fast and easy. DBMS : - Set of data and tools to manage those data. - Will not support RELATION SHIP between data. - Ex : - Foxpro data files and earlier Ms Access. RDBMS : - Same as DBMS - Will Support RELATION SHIP between Tables. - Ex : - ORACLE,SQL 2000,DB 2 dbms support 6 rules which were proposed by the developer of dbms and where as rdbms follows 8 rules which were proposed by the developer of rdbms. 1. dbms is a single user system rdbms is a multiuser system 2. dbms stores do not store data in the form of tables while rdbms stores it in the form of tables. 3. most of dbms are not supporting client/server architecture as it is supported by rdbms. 4. most dbms do not support distributed databases