Distinguish between the following: 'Relational DBMS' and 'object-oriented DBMS'.

CS Professional · Information Technology and Systems Audit · PYQS · June 2016
Distinguish between the following: 'Relational DBMS' and 'object-oriented DBMS'.

Answer & Explanation:

Basis of Distinction Relational Data Base Management System (RDBMS) Object-Oriented Data Base Management System (OODBMS) Meaning & structure It is based on the relational model and data is stored in the form of related tables. It provides support for object classes, class properties and method inheritance by sub classes and their objects. Data handling It contains a fundamental construct of sets or records designed to handle structured data. It supports modeling and creation of data and objects and can be used to handle unstructured data. Complex data handling RDBMS do not have enough efficiency in storing or handling large and complex data such as images, digital audio and video. OODBMS was developed to overcome the limita-tions of RDBMS in handling large and complex data. Examples Oracle, Sybase, Ingress, Informix, Microsoft SQL Server, and Microsoft Access. Gemstone, Versant, Object Store EyeDB. User friendliness It is easy for users to create /access and extend data in RDBMS. Using OODBMS can be complex due to the object oriented technology.

Topics: Database Management Systems (DBMS)

Open in Interactive Practice Hub · Full Practice Hub · Chapter Weightage · More in this subject

Related Questions in this Topic