tailieunhanh - Mastering Data Warehouse DesignRelational and Dimensional Techniques phần 4

Để kết thúc đó, Chương này giới thiệu các từ ngữ và thuật ngữ của mô hình dữ liệu quan hệ. Nó Sau đó tiếp tục với một tổng quan về các quy tắc và kỹ thuật bình thường cho các cấp, bình thường hóa khác nhau (ví dụ, đầu tiên, thứ hai, và thứ ba bình thường | eveloping the Model 119 Step 3 Add Derived Data The third step in developing the data warehouse model is to add derived data. Derived data is data that results from performing a mathematical operation on one or more other data elements. Derived data is incorporated into the data warehouse model for two major reasons to ensure consistency and to improve data delivery performance. The reason that this step is third is the business impact to ensure consistency performance benefits are secondary. If not for the business impact this would be one of the performance related steps. One of the common objectives of a data warehouse is to provide data in a way so that everyone has the same facts and the same understanding of those facts. A field such as net sales amount can have any number of meanings. Items that may be included or excluded in the definition include special discounts employee discounts and sales tax. If a sales representative is held accountable for meeting a sales goal it is extremely important that everyone understands what is included and excluded in the calculation. Another example of a derived field is data that is in the date entity. Many businesses such as manufacturers and retailers for example are very concerned with the Christmas shopping season. While it ends on the same date December 24 each year the beginning of the season varies since it starts on the Friday after Thanksgiving. A derived field of Christmas Season Indicator included in the date table ensures that every sale can quickly be classified as being in or out of that season and that year-to-year comparisons can be made simply without needing to look up the specific dates for the season start each year. The number of days in the month is another field that could have multiple meanings and this number is often used as a divisor in calculations. The most obvious question is whether or not to include Saturdays and Sundays. Similarly inclusion or exclusion of holidays is also an option. .