Project Data Model

Basically which data model do we use in the project?

Questions by Aloka   answers by Aloka

Showing Answers 1 - 1 of 1 Answers

Pavan Kumar

  • Jul 5th, 2016

Hi alok
It totally depends on the project.
1) Entity Relation model or ER model is used when the data source is small as the number of joins are less.
2) Dimention model
a) Star : Used for large data comparitively less no. of joins faster execution.
b) Snow flake : Used of very large data, has many joins, comparitively slower execution.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions