2) The architecture of data warehouse includes:

Data source, data storage and management, OLAP (on-line transaction processing) server, front-end tools. 3) Design and development of data warehouse development and implementation steps of data warehouse: business demand analysis, logical model design, physical model design, data extraction, cleaning, integration, loading and other data warehouse management, data analysis, report, query and other data performance, data warehouse performance optimization and release