Deciding a suitable architecture is very important activity in the data warehouse life cycle. Finding the way through the confounding array of architectural choices and the various approaches is critical in setting up the abilities and the limitations of a data warehouse.

The paper reviews and summarizes the basic types of architectures, their pros and cons, and discusses the various approaches to build a data warehouse system, concentrating on the two main options, top down and bottom up.