2
What are the differences between relational databases and object-relational databases?
1 answer
3
In essence the relational object database is a relational database, so it works with related tabular data in the physical model to form objects. The difference is in the logical model that tries to give an appearance of complete objects and interact better with programming languages that encourage the use of object orientation. So every model uses classes, inheritances, type creation and even some more sophisticated form of behavior creation.
As far as I know all attempts to make it work have failed (interestingly other attempts to make other models have succeeded even having more problems than this model, but our industry is like this, it depends on market forces more than is good or bad from an engineering point of view). Some products were left with traces of this, an example is Postgresql. Some ideas were eventually adopted in relational databases.
Browser other questions tagged sql database modeling relational-model
You are not signed in. Login or sign up in order to post.
This article presents an overview of the subject. https://www.devmedia.com.br/bancos-relateds/20401
– wagner silva