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)
Related Questions in this Topic
- Explain in detail the various functions performed by DBMS to ensure the integrity and consistency of the data in the dat...
- What are the functions and responsibilities of Database Administrator regarding database management ?
- M/s ABC Ltd. is a consumer electronics item manufacturing company. The management of the company wants to use advanced I...
- Explain in detail the various functions, which can be achieved through the use of Database Management System (DBMS).
- Distinguish between the following: Data Model and Data Structure.