Get started with data models data-model

Last update: Wed Nov 13 2024 00:00:00 GMT+0000 (Coordinated Universal Time)

What is a data model data-model-start

A data model is a set of schemas, audiences, and the links between them. It is used to federate audiences with databases data.

Learn more about schemas.

Learn more about audiences.

For example, you can see below a representation of a data model : the tables with their name and the links between them.

{modal="regular"}

In Federated Audience Composition, it is possible to create many data models.

Their creation will be based on the use case : you choose the necessary tables, and you link them according to your needs.

To create a data model, follow these steps:

In the FEDERATED DATA section, go in the Models link, and browse to the Data model tab.

{modal="regular"}
Click on the Create data model button, to define the name your data model, and click on the Create button.

{modal="regular"}
Then add the schemas, the audiences and the links of your data model.

{modal="regular"}

To create links between tables of your datamodel, follow these steps:

Click on Create link menu of one of the table, or click on Create links button, and choose the 2 tables:

{modal="regular"}
Fill in the given form to define the link.

{modal="regular"}

Cardinality
- 1-N: one occurrence of the source table can have several corresponding occurrences of the target table, but one occurrence of the target table can have at most one corresponding occurrence of the source table.
- N-1: one occurrence of the target table can have several corresponding occurrences of the source table, but one occurrence of the source table can have at most one corresponding occurrence of the target table.
- 1-1: one occurrence of the source table can have at most one corresponding occurrence of the target table.