---
title: Data Model Description
slug: ikea-summer-2025-hol/data-model-description
docTags: 
createdAt: 2025-06-27T11:22:13.108Z
---

### Overview

This section describes the Luma Datawarehouse Model that has been exposed to the Adobe Experience Platform users; a data engineer has declared the schemas (\~tables) and the relationships between schemas (\~tables) to provide a data model to marketers.

### Data model description

In the menu of the left side:

- Click on** Federated Data** > **Models** menu
- Click on** the Data model **tab
- Click on **Luma Datawarehouse Model v2** 
- Click on **Canvas view** to discover schemas and links
  - A schema is a representation of a table of your database. It is an object within the application that defines how the data are tied to database tables. 
  - A link is a join between 2 schemas

![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/qk3aCUqhl951gnhH-oWCn_image.png)

This data model is composed by 3 schemas and 2 links:

- 1 record in LUMAORDER is linked to **1..N** records in LUMAORDERDETAILS
  - Join definition: `LUMAORDER.UORDERID = LUMAORDERDETAIL.UORDERORDERID`

![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/WmLtRKFR0pFPxu0Kg5Dza_image.png)

- 1 record in LUMAORDERDETAIL is linked to 1..1 record in LUMAPRODUCT
  - Join definition: `LUMAORDERDETAIL.UPRODUCTPRODUCTID = LUMAPRODUCT.UPRODUCTID`

Click on the  **...** button to describe its content:

::Image[]{src="https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/8PJ8pSBSEZDwN3ZOCXjuL_image.png" size="42" width="311" height="195" position="center" showCaption="false"}

It's possible to refresh the schema and also to edit it in order to improve labels of columns or hide columns.

![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/EhwnLMKXMuI5LA4hE75Rr_image.png)

Then go to the Data section and click on <font color="#197de5">calculate </font>link to count the number of records; it should count 50 000 000 records:

![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/Ltd1hNOdLw3UgJdqzOvVV_image.png)

:::hint{type="success"}
A subset of the datawarehouse has been exposed to the marketers to let them leverage data. It's possible to declare the links between tables, either **1..1** or **1..N** links.&#x20;
:::

:::hint{type="info"}
Note that a **1..N** link enables aggregate features in the composition flow as you will see in the next exercise.
:::