TAILIEUCHUNG - Data Warehouse Design

Data Warehouse Design consists in collecting and filtering the user requirements. It involves the designer, end-users of DW and produces the specifications concerning. Data Warehouse Design includes Requirement Specification, Conceptual Design, Logical Design, Conclusions, Case study. | Data Warehouse Design by Duong Tuan Anh Faculty of Computer Science and Engineering, HCM City University of Technology. Sept. 2011 Outline Requirement Specification Conceptual Design Logical Design Conclusions Case study (M. Golfarelli, 1998) 1. Requirement Specification This phase consists in collecting and filtering the user requirements. It involves the designer, end-users of DW and produces the specifications concerning the choice of facts preliminary indications of the workload The choice of facts is based on the documentation of the operational information system. Facts are concepts of main interest for the decision making process, and correspond to events occurring in the enterprise world. If the operational information system is documented by ER schemes, a fact can be represented by an entity or an n-ary relationship. If it is documented by relational schemes, facts correspond to relation schemes. In general, entities or relationships representing frequently .

• Cơ sở dữ liệu
• Data Warehouse Design
• Requirement Specification
• Conceptual Design
• Logical Design
• Conceptual Design of Data Warehouse
• IT Architecture
• Data Warehouse
• Technology
• Warehouse Schema Design
• Warehousing Strategy
• Warehousing Software
• Warehouse Management
• Database design
• Database development
• Relational databases
• Database environments
• Data warehouse technology
• Business architectures
• Microsoft SQL Server 2005
• system design and architecture
• Administrators Companion
• performance tuning
• troubleshooting
• information technology
• curriculum
• database administrators
• Oracle Database