Most data warehouses don’t have one naming standard – they have five, stacked on top of each other. Here’s the layer-contract framework and four real naming approaches (Kimball, domain-driven, prefix-based, catalog-driven), with the honest trade-offs between them.
BI Visualized 