Skip to main content

What are the advantages of the object oriented database management system [OODBMS]?

What are the advantages of the object oriented database management system [OODBMS]?

Advantages of the Object oriented database

  • The object oriented database allows nested loop structure.
  • It is used in computer aided design.
  • It is also used in computer aided engineering.
  • It is most powerful database which is used in aerospace science and technology.
  • The object oriented database uses in data science and machine learning technology fields.
  • In this database there are so many data type uses rather than RDBMS. The data type uses in OODBMS are integer, char, text, etc.
  • The OODBMS allows arbitrary data type.
  • The OODBMS sub-classes with inheritance functions.


What do you mean by nested loop in oodbms?


The nested loop is a technique that is applied on the object database model to find the relationship of the objects in the database models. It is used to retrieve the data or information from the complex object or relationship from the database models.
In Object-Oriented Database Management Systems (OODBMS), a nested loop refers to a querying technique used to retrieve data from complex objects or relationships.

A nested loop involves iterating through a collection of objects (e.g., a list, array, or set) and, for each object, iterating where the iterating means (repeating the object for finding the db_employee) through another collection of objects related to it.
This process can be repeated multiple times, creating a "nested" loop structure.

For example, consider a database with the following structure:

- A "Office" object has a collection of "db_Employee" objects.
- Each "db_Employee" object has a collection of "Major Project" objects.

To retrieve all Major projects for all employees in a specific department, then the end user would use a nested loop:


1. Iterate through the "office" object's collection of "db_Employee" objects (outer loop).

2. For each "db_Employee" object, iterate through their collection of "Major Project" objects (inner loop).

This nested loop allows the user to cross the complex relationships between objects and retrieve the desired data which the user wants to find from the database models using the nested loop.

Nested loops are useful in OODBMS for:


- Querying complex object relationships
- Retrieving data from multi-level hierarchies
- Performing joins between related objects

However, nested loops can also lead to performance issues if not optimized properly, as they can result in a large number of iterations and database accesses.


-----------------------------------------------------------------------------------------------------------------------------

My latest post is here links below about the databases technology

What are the components of data model in [DBMS] Relational Database Management System?

There are five main components of data model... 👉 click here ðŸ‘ˆ

What is stability of the distributed database management system?

In the distributed database model there are.... 👉 click here👈

Labels:

Comments

Post a Comment

Popular posts from this blog

Discuss the role played by the various components of the CPU

Q Discuss the roles played by the various components of CPU? The CPU is the brain of the computer system. All major calculations, manipulations and comparisons are made by the CPU. The CPU is also responsible for activating and controlling the operations performed by all other units of the computer system. The major components of the CPU are: a) Arithmetic Logic Unit (A.L.U.) b) Control Unit (CU) c) Primary Memory Arithmetic Logic Unit (A.L.U.): What is ALU Arithmetic logic Unit? ALU is a part of the CPU. It is a part to calculate the logical term in the CPU where the term refers to an operation of logical type. It also calculates the arithmetic terms in the CPU where the term refers to an operation of arithmetic type. It is used to direct access through the processor controller. The ALU connected to the input and output peripheral system through the bus with the different types of bus. Such as control bus, data bus etc. ALU is a part of the CPU that can calculate the input...
Post a Comment
Read more

About the memory and its Classification of the computer Memory

What are the memories in the reference of computer system? What is Computer Memory?:- The memory is the essential for the computer to store the data, instruction and information. Without memory, computers are not be able to store data, instruction etc. The memory is an essential part of a computer system. It is require by the computer system to store information. Memory can be divided into the following two categories types: i) Primary or Main memory ii) Secondary Memory or Permanent memory In this figure I'll show the classification of the memory of computer system peripheral and architecture of organisations Primary Memory or Main memory:- i) Primary memory is the memory which is fastest memory of the computer. ii) It is a small but relatively fast storage unit that stores data and instruction which are used by the CPU (central processing unit). iii) This type or category of a memory is the main memory of the computer.It is a temporary memory and also we ...
Post a Comment
Read more

Comparing and limitation of the mouse and keyboard

Q 1. Compare the advantages and illuminations of a mouse and keyboard as data input devices? There are some points on the compare and limitations of the keyboard instead of the mouse following below: What is the definition of a keyboard in a computer as a peripheral device? “An input device that gives instructions to the computer in the text form is known as the keyboard of a computer”. The keyboard is also an operable  device of an operating system that is used in old times and today.  A cmd type operating system is operated by keyboard input device because cmd is known as command line interface operating system which is used to give the command in the text form by using keyboard input device. Keyboard is most important and popular input device where keyboard can do most of the task and work by using some keys and command on the operating system . Keyboard : i) Programs and data are entered into the computer through help of a keyboard which is attached to a CPU. ii) ...
Post a Comment
Read more