Designing and Implementing Online Analytical Processing (OLAP) Architecture – (Part 2)

This is the two part article series on designing and implementing online analytical processing (OLAP) architecture. In the part-1 of this article series, you learned OLAP database design, options for data warehouse schema design, and key considerations for designing relational data warehouse schema for OLAP applications.

Checkout the part-2 of this article series here, in which I discussed the key considerations for designing facts and dimensions for your OLAP solution. Then, I discussed the guidelines for designing time dimension table. Finally, I discussed about changing dimensions.

This article is published on

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s