MCA World :: Computer Application ::
Questions :  Answers : Solutions of TMA & Project Assignment  of  MCA courses of IGNOU, NIT & Other Universities.

::: RDBMS VS OODBMS



Home • Introduction to Software • Data Structures • System Engineering • Database Management System • Discrete Mathematics • Numerical & Statistical Computing • Software Engineering • Operation Research • Accounting & Finance • Computer Architecture • Operating Systems • Intelligent Systems • Relational Database • Obejct Oiented Systems

RDBMS VS OODBMS

Up • RDBMS VS OODBMS • Data Independence in DBMS • Data Redundancy • Functional Dependency • Entity Types & Relationship

Main Chapters

Home
Introduction to Software
Data Structures
System Engineering
Database Management System
Discrete Mathematics
Numerical & Statistical Computing
Software Engineering
Operation Research
Accounting & Finance
Computer Architecture
Operating Systems
Intelligent Systems
Relational Database
Obejct Oiented Systems

RDBMS VS OODBMS

 Problems Discussed in this chapter

Question 1: Discuss the advantages and disadvantages of object oriented database management system in comparison with RDBMS. Discuss types of applications suitable for object oriented DBMS and RDBMS.

Answer 1:    With an object-oriented database, the relationships between objects and the constraints on objects are maintained by the database management system, that is, the object themselves.  They enable support of complex application not supported well by the other   models. They enhance the programmability and performance, improve    navigational access, and simplify concurrency control. They lower the risks  associated with the referential integrity, and they provide a better user metaphor than the relational model. Object Oriented Database can store not only complex component but also larger structure. Object oriented database with large objects do not suffer a performance degradation because the objects do not need to be broken apart and reassembled by applications, regardless of the complexity of the properties of the application objects.

RDBMS were never designed to allow for the nested structure. These type of applications are extensively found in CAD/CAE, aerospace, etc.

OODBM can easily support these applications. Moreover it is much easier and natural to navigate through these complex structures in form of objects that model the real world in OODBMS rather than table, tuples and records in RDBMS. Relational database have a limited number of simple, built in data types, such as integer and string, and a limited number of built in operations that can handle these data types.

Relational database are adequate for accounting or other typical transaction-processing application where the data types are simple and few in number.

 Object-oriented databases are suitable for applications where the  relationships among elements in the database carry the key information.

 

Up ]

 

 

 
 


Home • Introduction to Software • Data Structures • System Engineering • Database Management System • Discrete Mathematics • Numerical & Statistical Computing • Software Engineering • Operation Research • Accounting & Finance • Computer Architecture • Operating Systems • Intelligent Systems • Relational Database • Obejct Oiented Systems



This is complete MCA study materials containing question, solutions, answers, programming, scripts, TMA, Project assignment solutions for aspiring MCA or BCA student. This website may be useful for all in general and IGNOU student in particulars. Disclaimer : Execution and correctness of programs/answers may be established by the users himself and the mcaworld.net shall not held responsible for any damage/loss caused due to the use of code over this site.



Dear Visitor, If you are not able to find what you have been looking for on this site, please do try your search once again with different combination of words in the following Google Tool Bar, Specially designed to provide enhanced search option. Thank you.
Google

Webmaster Bipin Bihari Pandey, An IT Expert of DotNet Technology, MCA from IGNOU
bipin9830@rediffmail.com or bipin9830@yahoo.com