メダリオン建築 is a modern data architectural pattern commonly used in データレイク environments to organize data into progressively refined layers based on quality, transformation, and readiness for consumption. This structure is particularly valuable for supporting scalable analytics and ensuring that data pipelines are both traceable and governed.
The architecture typically consists of three layers—Bronze, Silver, そして Gold—each representing a distinct stage of data maturity. The Bronze layer stores raw, unprocessed data directly ingested from source systems. It captures detailed records in their original form, providing a historical and audit-ready foundation. The Silver layer contains data that has been cleaned, transformed, and enriched, making it suitable for further analysis and integration. This layer typically handles tasks like deduplication, type normalization, and joining across systems. The Gold layer holds curated, business-ready datasets optimized for reporting, dashboards, and advanced analytics. These datasets are often aggregated, filtered, and aligned with specific business use cases.
ER/Studio plays a valuable role in supporting the design, documentation, そして ガバナンス of such architectures. Using ER/Studio Data Architect, teams can model the structures of each layer—defining schemas, relationships, and metadata that describe how data flows from Bronze to Gold. This modeling helps ensure that lineage is clearly documented, governance policies are enforced, and stakeholders have visibility into the logic behind transformations. Through its metadata management capabilities and integration with data governance tools, ER/Studio helps maintain consistency and traceability across platforms.
By documenting the architecture and ensuring alignment between business definitions and technical models, ER/Studio supports organizations in managing Medallion-style data environments more effectively and transparently.
For a more detailed breakdown, including how these layers are modeled in practice, see how ER/Studio models each medallion layer.
