Usually data is stored in two forms in an organization
1operational system : where we put data in
2data warehouse : where we get data out
Goals of a data warehouse: data warehouse must consider the needs of business
We're a hybrid DBA/MBA as data warehouse managers
Components that make up a complete warehousing environment
1 Operational Source Systems
2 Data Staging Area:everything between the operational source systems and the data presentation area
Services:Clean, combine,and standardize Conform dimensions NO USER QUERY SERVICES
Data Store:Flat files and relational tables
Processing: Sorting and sequential processing
3 Data Presentation Area:is where data is organized, stored, and made available for direct querying by users, report writers, and other analytical applications.
summary data Based on a single business process
Conformed facts & dimensions
4 Data Access Tools
5 Additional Considerations
Metadata is all the information in the data warehouse environment that is not the actual data itself.