Build a Logical Data Model

How do I 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.

    New LDM

  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.

    Empty model

  4. Click Scan now under the data source.

    The scan dialog opens.

    Scan dialog

  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.

    PDM generated

  6. Click on the wand icon next to your data source.

    The Generate LDM wizard dialog opens.

    LDM wizard

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

    The LDM is generated.

    Demo model

    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.

    Demo model

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