Skip to main content
Version: 24.3

Data Mart Schema

The Digital.ai Agility Data Mart schema implements the star schema data warehouse pattern. In this pattern facts, or measurements, are kept in tables which are classified along different dimensions. Dimension data is kept in a separate table. The database also uses Bridge tables for multi-relationships such as Workitem Owners and Tree tables for hierarchies.

Custom reporting and Data Mart