Star Schema

[mikeahmarani]

Proposal

Mermaid.js should add star schema support.

Use Cases

A star schema is used to denormalize business data into dimensions (like time and product) and facts (like transactions in amounts and quantities).

Screenshots

Syntax

starSchema
	class FactTable {
		product_id: int
		time_id: int
		promotion_id: int
		customer_id: int
		revenue: BigDecimal
		units_sold: int
	}
	class ProductDim {
		product_id: int
		product_name: string
		unit_price: BigDecimal
		product_line: string
	}
	class CustomerDim {
		customer_id: int
		name: string
		city: string
		zip: string
	}
	class TimeDim {
		time_id: int
		order_date: date
		month: int
		quarter: int
		year: int
	}
	class PromotionDim{
		promotion_id: int
		promo_name: string
		ad_type: string
		coupon_type: string
		price_reduction_type: string
	}
	
	FactTable --> ProductDim
	FactTable --> CustomerDim
	FactTable --> TimeDim
	FactTable --> PromotionDim
	
	---- Alternative, Simpler ----
	
starSchema
	FactTable [product_id, time_id, promotion_id, customer_id, revenue, units_sold] --> ProductDim [product_id, product_name, unit_price, product_line]
	FactTable --> TimeDim [time_id, order_date, month, quarter, year]
	FactTable --> CustomerDim [customer_id, name, city, zip]
	FactTable --> PromotionDim [promotion_id, promo_name, ad_type, coupon_type, reduction_type]

Implementation

This is a proposal which I'd love to see built into mermaid by the wonderful community.

[tah96]

I second this! My team is running into an issue where Star schema would be very helpful

[r-mcmaster-cp]

Agreed, this would be great to have.