ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

Alright. on to some basic Data Warehousing... What is ER Model? What's the goal of such models?

user-image
تم إضافة السؤال من قبل مستخدم محذوف‎
تاريخ النشر: 2015/06/10
Mazen Hindi
من قبل Mazen Hindi , Director , Path Solutions

How would you describe what the contents of your data warehouse are and how it is designed into tables?

You will need an entity relationship diagram to draw out your different facts and relate them to their corresponding dimensions. The way to do that is in an ER model.

Michael McLean
من قبل Michael McLean , IT Manager , RASAN Software House LLC

The Entity Relationship model shows the relationships between your data structures. It also allow you to express the normality of the data in a visual manner. The trouble is, with a large relational data warehouse, an ER model can be extremely large and difficult to read. 

The goal is to understand the data in a visual sense, however, because of the size limitation it is best to concentrate on the tables you are interested in. This will make the diagram clearer and the reduce the running time of your model generation tool. 

The people who mostly use these models are the engineers themselves, there is very little upward reporting value to a non technical individual.

Madiha Zahoor
من قبل Madiha Zahoor , Teacher

Entity Relation Model To draw the scheme .

المزيد من الأسئلة المماثلة