Question

Technically, MS Access and many other databases are “object-relational”. What does this mean and what advantages does this hybrid technology provide?

Answer 1

An Object relational model is a blend of an Object arranged database model and a Relational database model. In this way, it bolsters objects, classes, legacy and so on simply like Object Oriented models and has support for information types, even structures and so forth. like Relational information model. One of the significant objectives of Object relational information model is to close the hole between relational databases and the object arranged practices as often as possible utilized in many programming dialects, for example, C++, C#, Java and so forth.

Points of interest of Object Relational model-

1-Inheritance

The Object Relational information model permits its clients to acquire objects, tables and so forth with the goal that they can broaden their usefulness. Acquired objects contains new qualities just as the properties that were acquired.

2-Complex Data Types

Complex information types can be shaped utilizing existing information types. This is helpful in Object relational information model as mind boggling information types permit better control of the information.

3-Extensibility

The usefulness of the framework can be reached out in Object relational information model. This can be accomplished utilizing complex information types just as cutting edge ideas of object situated model, for example, legacy.

Weaknesses of Object Relational model

The object relational information model can get very muddled and hard to deal with now and again as it is a blend of the Object situated information model and Relational information model and uses the functionalities of them two.