Typical Architecture Warehouse mgr Load mgr Warehouse mgr Query manager DBMS Meta-data Highly summarized data Lightly summarized data Detailed data Mainframe operational n/w,h/w data Departmental RDBMS data Private data External data Archive/backup Reporting query, app development,EIS tools OLAP tools Data-mining tools Source: Connolly and Begg p1157 7. Comparison Source: Connolly and Begg p1153 6.
Decision makers require access to all data.range in size from megabytes to terabytes.OLTP (online transaction processing) systems.Data Warehousing and Data Mining May 2006