In software-development & data architecture nirvana, the business analysts, database technologists, and application developers all speak the same language. Everyone agrees about what each user story means.
Data marts, data warehouses, and some operational datastores use dimension tables. A dimension table categorizes a fact table that joins to the dimension. At query time one filters the facts by values in the dimension table, and uses those values to label the query results
This post uses those concepts to survey the main types of relational architectures. These divide fundamentally into two types, the second having four sub-types: OLTP & BI.