what is data modelling

Former Member · ‎2008 Nov 07

hi All,

please anyone tell me wat is modelling?

is there any techniques for data modeling?

how to i learn data modelling?

Thank u

Swari

Former Member · ‎2008 Nov 10

Hi Swari,

Data Modelling in simple language means Design of the Repository.

The term Data modelling is given, as Master data needs to be modellied in a specific and correct manner in the MDM repository.

Many factors needs to be considered when you are modelling the data.

In the MDM perspective you need to consider the fields which will be part of the main tabel and which will be part of the look up tables.

Also some fields data are better modelled as a hierarchy or taxonomy or Qualifeid table.

Besides making these decisions you also need to decide on every field property while modelling the data.

Each field has some 15 to 20 properties and each of them need to be carefully determined when modelling the master data in MDM Repository.

As every field property and the number of record stored in the tables will all effect the speed and performance of the MDM system.

Also The data model though can be changed whenever required.

It is not desirable to change the model once designed.As there are many system which will be accessing the MDM system.

And unloading and loading the MDM repository often is not feasible.

So the Data modelling is the first step towards designing and must be done with care.

You can refer the below helpful links which will guide you futher on this topic:

Hope It Helped

Thanks & Regards

Simona Pinto