tailieunhanh - data warehousing architecture andimplementation phần 6

Các phương pháp tiếp cận kho dữ liệu thực hiện trình bày trong chương này mô tả các hoạt động liên quan đến thực hiện một triển khai các kho ngày. Các hoạt động thảo luận ở đây xây dựng trên kết quả của quy hoạch kho dữ liệu được mô tả trong chương trước. | Chapter 9. Data Warehouse Implementation The data Warehouse implementation approach presented in this chapter describes the activities related to implementing one rollout of the date warehouse. The activities discussed here build on the results of the data warehouse planning described in the previous chapter. The data warehouse implementation team builds or extends an existing warehouse schema based on the final logical schema design produced during planning. The team also builds the warehouse subsystems that ensure a steady regular flow of clean data from the operational systems into the data warehouse. Other team members install and configure the selected front-end tools to provide users with access to warehouse data. An implementation project should be scoped to last between three to six months. The progress of the team varies depending among other things on the quality of the warehouse design the quality of the implementation plan the availability and participation of enterprise resource persons and the rate at which project issues are resolved. User training and warehouse testing activities take place toward the end of the implementation project just prior to the deployment to users. Once the warehouse has been deployed the day-to-day warehouse management maintenance and optimization tasks begin. Some members of the implementation team may be asked to stay on and assist with the maintenance activities to ensure continuity. The other members of the project team may be asked to start planning the next warehouse rollout or may be released to work on other projects. Acquire and Set Up Development Environment Acquire and set up the development environment for the data warehouse implementation project. This activity includes the following tasks among others install the hardware the operating system the relational database engine install all warehousing tools create all necessary network connections and create all required user IDs and user access definitions. Note .