FIT3002 Lecture Notes - Lecture 4: Data Warehouse, Database, Oracle Database
Data Warehousing
DW Architectures
Why Develop an Architecture
•Communication
–Helps justify costs to management
–Tells IS team where they fit in the process
•Planning
–To ensures that all components are compatible
•Flexibility
–Use tools and metatada to add more data sources
–Use tools and metadata to automate parts of WH for reuse
Data Warehousing 0910 2
Framework
•Data
–Dimensional models + metadata
•Technical
–Back Room
•Extracting data from outside sources
•Transforming it to fit operational needs (which can include quality
levels)
•Loading it into the end target (database or data warehouse)
–Front Room (data made usable for users)
•Infrastructure
–Where is data coming from and going to
–Capacity
Data Warehousing 0910 3
Document Summary
Tells is team where they fit in the process: planning. To ensures that all components are compatible: flexibility. Use tools and metatada to add more data sources. Use tools and metadata to automate parts of wh for reuse. Back room: extracting data from outside sources, transforming it to fit operational needs (which can include quality levels, loading it into the end target (database or data warehouse) Front room (data made usable for users) Where is data coming from and going to. Infrastructure: infrastructure includes hardware, network and security, examine the is infrastructure as wh may place an unexpected burden on it, has the organization got the resources to support the technology, need to consider hardware, operating systems and. Need to know: how much data the infrastructure needs to manage, how often we need to load data, how complex is the transformation process. Factors that determine requirements: business requirements are still the primary determinant.