Fundamental -- <One>

Notes for Star Schema--The complete reference

1. Powerful and effective techniques for the design of analytic databases. These techniques unleash business analytics in a very simple way: they model the measurement of business processes.

2. The dimensional model of a business process is made up of two components: measurements and their context. Known as facts and dimensions, these components are organized into a database design that facilitates a wide variety of analytic usage. Implemented in a relational database, the dimensional model is called a star schema. Implemented in a multidimensional database, it is known as a cube.

posted on 2012-02-27 14:17  Jia  阅读(145)  评论(0)    收藏  举报