MIS 325 Lecture Notes - Lecture 29: Data Warehouse, Computer Hardware, Business Analytics
MIS 325 – Why Data warehousing – 3.6
• ETL Process
o Extract – transform – load
o Operational data → transaction
• Separating operational and informational systems
o Operational system
▪ Used to run a business in real tie, based on current data
▪ Aka system of record
▪ Data: current representation of state of the nosiness
▪ Primary users: clerks, sales persons, administrators
▪ Scope of usage:
• Narrow
• Planned
• Simple updates and queries
▪ Design goal: performance – throughput and availability
▪ Volume: many constant updates and queries on one or a few table
rows
o Informational system
▪ Supports managerial decision making
▪ Works with historical point in time data (Snapshots) and predictions
▪ Primary users: managers, business analysts, customers
▪ Scope of usage
• Broad
• Ad hoc
• Complex queries
• Analysis
▪ Design goal: ease of flexible access and use
▪ Volume: periodic batch updates and queries requiring many or all
rows
• History leading to data warehousing
o Database tech improved, including relational DBMSs
o Advances made in computer hardware (mass storage, parallel
architecture, etc.)
o Emergence of end user computing with powerful interfaces and tools
▪ Moore’s law: power/capacity of a chip doubles every 18 months
o Advances in middle ware
▪ Enabling heterogeneous database connectivity
o Recognition of difference between operation and informational systems
• Need data warehousing
o Integrating, companywide view of high quality info from disparate
databases
find more resources at oneclass.com
find more resources at oneclass.com