Skip to Main Content
  • Questions

  • Can we use EVA Data Model design in Oracle RDBMS?

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, John.

Asked: October 28, 2020 - 9:02 pm UTC

Last updated: November 02, 2020 - 4:50 am UTC

Version: 12.2.0.3

Viewed 1000+ times

You Asked

Hello,

Can we use EVA (Entity, Attribute, Value)  Data Model design in Oracle RDBMS? If yes, is there Oracle documentation that provides examples and best practices for this?

Will be as good in Oracle RDBMS as in say a NoSQL DBMS like MongoDB?

Thank you,

John

and Connor said...

Some good reading here on why it can be a bad idea

https://asktom.oracle.com/pls/apex/asktom.search?tag=data-models
https://asktom.oracle.com/pls/apex/asktom.search?tag=query-on-design

Having said that, this is not dismissing the value of a *flexible* data model where its appropriate to do so. The above links are about the folly choosing generic *across the board*.

One of our key advantages is that you can have the best of both worlds ... the flexible structures where you need it, and the more rigorously defined structures where you need them as well...all in the same database. That means

- no replication issues
- no synchronization issues
- no loss of transactions

A good white paper on our converged model here

https://www.oracle.com/a/otn/docs/database/oracle-converged-database-technicalbrief.pdf

and an excellent panel discussion on the SQL vs NoSQL here



Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Design

New to good database design? Check out Chris Saxon's full fundamentals class.