Star schema
Star schema is the simplest form of data warehouse schema. A star schema consists of at least one fact table and a number of dimension tables. These tables are relational database tables, often stored in SQL Server. The star schema source tables are not required to be stored in SQL Server. In fact, many OLAP solutions use other relational database management system (RDBMS) platforms, to hold source star data. It is called a star schema because the entity-relationship diagram between dimensions and fact tables resembles a star where one fact table is connected to multiple dimensions.
A star schema fact table consists of at
least two types of columns: keys and measures.
Keys are
foreign key (FK) values that relate rows in the fact table to rows in the
dimension tables. Measures
are numeric values—usually, but not always, additive—that express the business
metrics.
Mukesh KumarPosted Jun 16, 2011, 2:16 PM
Learning is a treasure that will follow its owner everywhere
Mahesh ChandPosted Jun 16, 2011, 11:13 AM
Everyday you learn something.