Build a Logical Data Model

A logical data model (LDM) is an abstract view of your data in GoodData Cloud Native (GoodData.CN). The LDM is a set of logical objects (datasets) and their relationships that represent the data objects and their relationships in your database.

Create an LDM

You can create an LDM automatically. GoodData.CN scans your database schema, reads its metadata and suggests the LDM based on the tables and views in your database.

• The tables and views are converted to datasets.
• Attributes and facts in the datasets are derived from the table columns based on their data types.
• Primary keys and references between datasets are detected from referential integrity stored in the database.

To make sure that your data is interpreted correctly, learn what rules are applied when the LDM is created and make sure that your database follow them.

Steps:

1. Open the demo workspace.

2. Click the Data tab.

   The LDM Modeler opens.

   

3. Click Create model.

   The LDM Modeler is switched to edit mode. You can see the registered data sources in the left panel. If you connected the database with the demo data, you can see the demo-ds data source.

   

4. Click Scan now under the data source.

   The scan dialog opens.

   

5. Keep the predefined options as is, and click Scan.

   Your database schema is scanned and stored inside the data source entity as physical data model (PDM). You can see all scanned tables and views listed as datasets on the left panel, below your data source.

   

6. Open the menu on your data source and select Generate logical data model.

   The Generate LDM wizard dialog opens.

   

   Note

   Instead of using the wizard, you may drag and drop the datasets into the LDM manually. If you drag and drop a dataset into the LDM, any other datasets referenced by that dataset will be added as well.

7. Leave the settings as they are and click Generate.

   The LDM is generated.

   

   At this point, the LDM is not published to your workspace yet. You are going to publish it.

8. Click Publish in the top right corner.

   The publishing dialog opens.

9. Click Publish in the dialog.

   The publishing process starts. When the publishing completes, you see a message that the LDM has been published.

   

Once you have created the LDM, you can start building dashboards and insights.