| |
GeekInterview.com > Interview Questions > Data Warehousing > Basics
| Print | |
Question: What is a Star Schema
Answer:
Answer posted by Chintan on 2005-05-22 18:34:55: A relational database schema organized around a central table (fact table) joined to a few smaller tables (dimension tables) using foreign key references. The fact table contains raw numeric items that represent relevant business facts (price, discount values, number of units sold, dollar value, etc.) |
| April 04, 2008 09:59:20 |
#7 |
| chnadra |
Member Since: April 2008 Total Comments: 1 |
RE: What is a Star Schema
|
| A data warehouse design that enhances the performance of multidimensional queries on traditional relational databases. One fact table is surrounded by a series of related tables. Data is joined from one of the points to the center, providing a so-called "star query." |
| |
Back To Question | |
