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
Related Questions in this Topic
- Distinguish between the following: Hierarchical and network DBMS
- Write short notes on the following: Distributed Database
- Describe the various types of files that can be created in SQL Server databases.
- In spite of the advantages of using a Database Management System (DBMS), there are a few situations or circumstances in ...
- What are the salient features of Hierarchical database ? Describe briefly.