how can object -relational database be used to implement an SDBMS?

Expert Solution

An object-relational database (ORD) is a database management system (DBMS) that's composed of both a relational database (RDBMS) and an object-oriented database (OODBMS). ORD supports the basic components of any object-oriented database model in its schemas and the query language used, such as objects, classes and inheritance.

An object-relational database may also be known as an object relational database management systems (ORDBMS).

ORD is said to be the middleman between relational and object-oriented databases because it contains aspects and characteristics from both models. In ORD, the basic approach is based on RDB, since the data is stored in a traditional database and manipulated and accessed using queries written in a query language like SQL. However, ORD also showcases an object-oriented characteristic in that the database is considered an object store, usually for software that is written in an object-oriented programming language. Here, APIs are used to store and access the data as objects.

One of ORD’s aims is to bridge the gap between conceptual data modeling techniques for relational and object-oriented databases like the entity-relationship diagram (ERD) and object-relational mapping (ORM). It also aims to connect the divide between relational databases and the object-oriented modeling techniques that are usually used in programming languages like Java, C# and C++.

Traditional RDBMS products concentrate on the efficient organization of data that is derived from a limited set of data-types. On the other hand, an ORDBMS has a feature that allows developers to build and innovate their own data types and methods, which can be applied to the . DBMS. With this, ORDBMS intends to allow developers to increase the abstraction with which they view the problem area.

venereology answered 11 months ago

Describe what a database system is and how it is used. What is a relational database...

Describe what a database system is and how it is used. What is a relational database system and how used in a company to benefit an organization? What does it mean to run a query?

How/why can each type of database (relational, object-oriented, and multidimensional) be utilized in healthcare? Provide examples...

How/why can each type of database (relational, object-oriented, and multidimensional) be utilized in healthcare? Provide examples as support.

Design and implement a relational database application of your choice using MS Workbench on MySQL a)...

Design and implement a relational database application of your choice using MS Workbench on MySQL a) Declare two relations (tables) using the SQL DDL. To each relation name, add the last 4 digits of your Student-ID. Each relation (table) should have at least 4 attributes. Insert data to both relations (tables); (15%) b) Based on your expected use of the database, choose some of the attributes of each relation as your primary keys (indexes). To each Primary Key name, add...

Describe the functions provided by a relational database that could be used to record courses taken...

Describe the functions provided by a relational database that could be used to record courses taken by university students in order to manage scheduling and preparing transcripts. Please respond with 200-250 words. Thanks

What is Relational Database in healthcare? Provide examples and explain how it works.

What are some of the advantages of a relational database system?

Relational Operators For Cpp Discuss why relational operators can be used with enumeration types. Provide at...

Relational Operators For Cpp Discuss why relational operators can be used with enumeration types. Provide at least 2 examples of relational expressions with enumeration types. Explain your examples

• Relational Schema Create a relational database schema consisting of the four relation schemas representing various...

• Relational Schema Create a relational database schema consisting of the four relation schemas representing various entities recorded by a furniture company. Write CREATE TABLE statements for the following four relation schemas. Define all necessary attributes, domains, and primary and foreign keys. Customer(CustomerID, Name, Address) FullOrder(OrderID, OrderDate, CustomerID) Request(OrderID, ProductID, Quantity) Product(ProductID, Description, Finish, Price) You should assume the following: Each CustomerID is a number with at most three digits, each OrderID is a number with at most five digits,...

Define the four main types of relational constraints and use the example relational database (Figure 1)...

Define the four main types of relational constraints and use the example relational database (Figure 1) to illustrate each of these constraints. Figure 1 House(MLS, Addr, NumRooms, NumBedRooms, SellID, OfficeID, Price) Seller(SellID, Name) PotentialBuyer(BuyID, Name) REOffice(OffID, Name, Addr, Phone) Agent(AgID, OffID, Name) Showing(AgID, MLS, BuyID, Date)

The following tables form part of a database (Flights Database) held in a relational DBMS: employee...

The following tables form part of a database (Flights Database) held in a relational DBMS: employee (empNo, empName, empSalary, empPosition) aircraft (aircraftNo, acName, acModel, acFlyingRange) flight (flightNo, aircraftNo, fromAirport, toAirport, flightDistance, departTime, arriveTime) certified (empNo, aircraftNo) Where:  employee contains details of all employees (pilots and non-pilots) and empNo is the primary key;  aircraft contains details of aircraft and C is the primary key.  flight contains details of flights and (flightNo, aircraftNo) form the primary key.  certified...

Question