Dimensional schemas

A database is comprised of one or more tables, and the relationships among all the tables in the database is collectively called the database schema. Although there are many different schema designs, databases that query historical data usually use a dimensional schema design.

Dimensional modeling in the workbench is done at both the logical and physical level. The dimensional modeling concepts apply to both logical and physical data models. Dimensional modeling adds another layer to your data models, which work with many database manager vendors.

Use dimensional modeling to achieve the following benefits:

A dimensional schema physically separates the measures that quantify the business from the descriptive elements (also called dimensions) that describe and categorize the business. The dimensional schema is a physical or logical schema. A physical dimensional schema is typically represented in the form of a star or snowflake schema, where the objects in the star or snowflake schema are actually database tables. The dimensional schema can even take the form of a single table or view, where all the facts and dimensions are simply in different columns of that table or view. In a logical dimensional schema, the fact, measures, and dimensions are represented as entities and attributes that are independent of a database vendor and can therefore be transformed to a physical dimensional schema for any database vendor.


Feedback