.NET Hawa

Schema Modeling Techniques

A Schema is a collection of Database objects such as Tables, views, Indexes, stored procedures etc.

Querying historical data from databases we use Dimensional Modeling Schema Design.  Dimensional Modeling can be done from both physical and logical levels.  A Dimensional Schema may be logical or physical Schema.  Dimensional Schema can take data from any table or view because it only contains facts and dimensions that have in different columns of the table.   They are 4 – types of Data Modeling Schemas:

  1. Star Schema Read the rest of this entry »
Leave a comment »