the.com/data mart
the data warehouse's studio apartment — smaller, cheaper, and just for one department.
means a scaled-down, subject-specific database built for one team's reporting needs instead of the whole company's.
from emerged in 1990s data warehousing as architects realized giving every department a slice of the warehouse beat forcing everyone to query one giant, contested system.
scopeone department, not the whole enterprise
origin typebuilt from warehouse or straight from source
speedfaster queries, fewer joins, narrower data
risktoo many marts breeds inconsistent metrics