what is data modelling

[Former Member]

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_member182007]

Hi swari,

Data modeling is the process of creating a data model by applying a data model theory to create a data model instance. A data model theory is a formal data model description. See database model for a list of current data model theories.

When data modeling, we are structuring and organizing data. These data structures are then typically implemented in a database management system. In addition to defining and organizing the data, data modeling will impose (implicitly or explicitly) constraints or limitations on the data placed within the structure. Managing large quantities of structured and unstructured data is a primary function of information systems.

Data models describe structured data for storage in data management systems such as relational databases. They typically do not describe unstructured data, such as word processing documents, email messages, pictures, digital audio, and video.

A data model describes the structure of the data within a given domain and, by implication, the underlying structure of that domain itself. This means that a data model in fact specifies a dedicated grammar for a dedicated artificial language for that domain.

A data model represents classes of entities (kinds of things) about which a company wishes to hold information, the attributes of that information, and relationships among those entities and (often implicit) relationships among those attributes. The model describes the organization of the data to some extent irrespective of how data might be represented in a computer system.

It can also be more specific related with MDM at the time of profiling.

Hope it helps.

Rgds

Deepak

[Former Member]

Hi,

Data Modelling is a important concept in MDM.An optimized data model can increase performance

of an MDM repostiory while importing and syndicating.Take for example, an unoptimized data model

can have more time to import the records than optimized data model.

The following are the some key points to achieve optimized data model.

Keep tables and fields as low as possible in your repository.

Keep lookup table records as low as possible.

Avoid unwanted keyword searches for fields.

Avoid unwanted keymappings for tables.

Avoid unwanted languages in multilingual property of repository.

Thanks

Narendra

[Former Member]

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:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/80fc0a2e-6561-2910-839e-8ff3e36d... (data modelling)

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/eb7447b1-0c01-0010-8d90-a2e004ca... (data modelling)

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/d0d8aa53-b11d-2a10-aca2-ff2bd42a... (data modelling)

Hope It Helped

Thanks & Regards

Simona Pinto

[Former Member]

HI Swari,

Data Modeling is the base for any MDM implementation. You need to understand the business landscape and decide on the fields you want in MDM and also model them in particular tables in MDM. SAP has provided tables of different types and you need to decide which table will suit your requirement.

Also, there might be many systems to which you will be integrating the MDM systems. However, only the global fields are genearlly takein into MDM and included in the MDM repository.

For details, I am giving some links, which will throw some light on Data Modeling aspect.

How to Handle Data Modeling in Master Data Management 5.5:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/5d4211fa-0301-0010-9fb1-ef1fd917...

SAP Network Blog: Master Data Modeling for MDM Solution (part 1) (What is Master Data)

SAP NetWeaver - Demo Model: MDM Repositories

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/607beabe-950f-2b10-7687-8256ace1...

How to Avoid Problems with your Data Model in SAP NetWeaver MDM u2013 Dou2019s and Donu2019ts (NW7.0):

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/d0d8aa53-b11d-2a10-aca2-ff2bd42a...

You can use the Demo repositories for your understanding and also see the last link for performance efficiency as data modeling impacts performance.

Hope it helps.

Thanks and Regards

Nitin jain