Page 121 -

120 Part II • Descriptive Analytics

No data marts option
Data Applic
App
Applic
Applic
App
A A App
Applic
Applicationstioatatacaliliclic ttataaaaaaaaaaccliccccccccccccccpp
Sources Access ( (Visualization)ataazazzziziillaVisua
ETL
R R R R R
Ro
Process Routineutuoooo
businessinsinsssssuuuuuuuuuuuuuuu
ERP b b b b b b b b b b b b b b b b b
Data mart reportsoppppppepepepeeeeeeeeeeeeeee
r r r r r r
Select (Marketing)
Legacy Metadata re re re r r r r
D D D D D D D D D D D D D
Data/text
D D D D D D D D D D D D D Da
D D D D D D Da
Daaaaaaaa
Extract Data mart war war war war war war war war w w w w w w w w w w w w w w D Da t a at a a a a
(Engineering) API/Middleware mining
POS Transform Enterprise
Data Data mart OLAP,
Integrate Warehouse (Finance) Dashboard,
Other Web
OLT/WEB
Load Data mart
External (. . .) Custom-built
applications
data Replication
figure 3.3 A Data Warehouse Framework and Views.
• Middleware tools. Middleware tools enable access to the data warehouse. Power
users such as analysts may write their own SQL queries. Others may employ a man-
aged query environment, such as Business Objects, to access data. There are many
front-end applications that business users can use to interact with data stored in the
data repositories, including data mining, OLAP, reporting tools, and data visualiza-
tion tools.
sectiOn 3.3 revieW QuestiOns
1. Describe the data warehousing process.
2. Describe the major components of a data warehouse.
3. Identify and discuss the role of middleware tools.

3.4 Data Warehousing arChiteCtures
There are several basic information system architectures that can be used for data ware-
housing. Generally speaking, these architectures are commonly called client/server or
n-tier architectures, of which two-tier and three-tier architectures are the most common
(see Figures 3.4 and 3.5), but sometimes there is simply one tier. These types of multi-tiered

Tier 1: Tier 2: Tier 3:
Client workstation Application server Database server
figure 3.4 Architecture of a Three-Tier Data Warehouse.

M03_SHAR9209_10_PIE_C03.indd 120 1/25/14 7:35 AM