CODEWITHSUNDEEP
sqldatabasegenericsdatamodel
Jurre Sanders
Jurre Sanders

Reputation: 21

SQL - Alternatives to a generic datamodel

while studying, im struggling to find an answer to this question:

What is a generic datamodel?

Are there any alternatives to a generic datamodel, if so; which one would you recommend?

I've looked everywhere to find a decent answer, but i didn't find it. It might be just a very simple question, i just couldn't find these terms; 'generic datamodel'.

Upvotes: 0

Views: 599

Answers (3)

Jurre Sanders
Jurre Sanders

Reputation: 21

@ nick, this is the question:

  1. Advise in Chapter 5 of the people involved in your case about the application or not of a generic data model and optionally other alternatives. Motivate your opinion (10 points).

Upvotes: 0

Nick.Mc
Nick.Mc

Reputation: 19194

Perhaps by generic data model you mean an entity attribute value model: EAV on wikipedia

This data model has one table and three columns. It is usually burnt by fire if ever discovered by someone of a database (vs developer) persuasion.

The thing with a data model is that you are modeling something. You are applying your skills to build a database that is optimised to store and retrieve data about something (widgets in a factory, trades on a stock exchange, Facebook posts). A EAV can store all of this stuff but it causes many other problems down the line.

More info here: EAV

Upvotes: 1

Jurre Sanders
Jurre Sanders

Reputation: 21

It could be possible its an EAV mode. But that leaves me with the following question: are there any alternatives to this model?

Thanks.

Upvotes: 0

Related Questions