Discuss about RDBMS and Object oriented DBMS with examples.

CS Professional · Information Technology and Systems Audit · PYQS · December 2021
Discuss about RDBMS and Object oriented DBMS with examples.

Answer & Explanation:

Relational DBMS: A database management system (DBMS) that incorporates the relational-data model, normally including a Structured Query Language (SQL) application programming interface. It is a DBMS in which the database is organized and accessed according to the relationships between data items. In a relational database, relationships between data items are expressed by means of tables. Interdependencies among these tables are expressed by data values rather than by pointers. This allows a high degree of data independence. There are 3 important keys terms: a. Relationship, b. Domain and c. Attributes. These are applied to the created tables - which contains sets of records with one to-many or any other type of relationships. A record is a row-column set of usually 2 dimensions and stored in the memory. At present, a number of RDBMS packages are available in market and some popular are: Oracle Microsoft SQL/Access, Sybase, Informix and Ingress. Object Oriented DBMS: These are able to handle varied data types, typically including graphics, text, audio, video etc. These uses network or hierarchical approach to handle structured and semi or unstructured data as well. Hence, these kind of DBMS are extensively used in web and multimedia applications and text and photograph sharing through social media - like flicker or Instagram and other.

Topics: Database Management Systems

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

Related Questions in this Topic