Computer Science & IT – B.Tech, BCA, BBA, MCA, M.Tech Best Online Coaching Institute

Schemas in Data Warehouse

Schema in Data Warehouse

The term schema means logical description of the entire database. It is a collection of database objects such as tables, views, sequences, synonyms and indexes. It includes the name, description of data types such as data items and aggregates. Database uses RDBMS on the other hand data warehouse uses schema such as star, snowflake and fact constellation.

Star Schema

It is the simplest data warehouse schema. It looks like a star with points radiating from a center that’s why it is called star schema. In star schema there are one fact table and multiple dimension tables containing a bulk of data with redundancy. It can be simple or complex, simple star schemas contain one fact table and complex contains multiple fact tables.

Fact Table

The fact table represents attributes such as time, products and suppliers. It has two types of columns-foreign key to dimension tables (more…)

This content is restricted to site members. If you are an existing user, please log in. New users may register below.

Existing Users Log In
 Remember Me