Database Reference
In-Depth Information
Chapter 1
Data Warehouse Architecture:
Practices and Trends
Xuegang Huang
Danske Bank Group, Denmark
ABStrAct
The wide adoption of business intelligence applications has let more and more organizations to build
and maintain data warehouse systems. Concepts like “unified view of data” and “one version of the
truth” have been the main drive of creating data warehouses. The dynamics of the business world poses
the challenges of managing large volume, complex data in data warehouses while the real-time inte-
gration and master data needs are presented. This chapter summarizes the past and present patterns
of typical data warehouse architectures and describes how the concept of service-oriented architecture
influences the future evolvement of data warehouse architecture. The discussion takes many real world
requirements in data warehouse solutions and lists considerations on how architecture patterns can
solve these requirements.
IntroductIon
Specifically, starting with very few industry vendors
in the 80s such as Teradata, many IT companies like
Microsoft, IBM and Oracles are extending their
database management systems (DBMSs) to have
sufficient support on data warehouses. The early
years' data warehousing theory and engineering
practices have been well recorded in the publications
of Inmon (Inmon, 2005) and Kimball (Kimball &
Ross, 2002).
Academic research of data warehousing tech-
nologies started in the early 90s. The database
research community began with a focus on incor-
Over the past decades, the concept of data ware-
housing has been spread out to everywhere in the
business world. Organizations have been practic-
ing hard on achieving successful data warehouse
architectures. Lessons have been learnt from those
who have succeeded, as well as those who have not.
Several key developments in the data warehousing
industry denote the past and present of this discipline.
Search WWH ::




Custom Search