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

Duy trì lịch trên Những điều khoản, Cho phép người sử dụng xem ngày 18 tháng tư năm 2002 thay vì 198 ngày, nhưng nội bộ, hệ thống này tiếp tục dựa trên số ngày làm việc và những ngày không làm việc. Bởi bản chất của họ, lịch nhà máy được địa phương hóa. Đó là, mỗi tháng cơ sở sản xuất nhà máy có lịch riêng của nó để phản ánh các ngày làm việc và thay đổi cơ sở | Modeling the Calendar 165 maintain calendars on these terms allowing the user to see April 18 2002 instead of day 198 and yet internally such systems continue to count days based on working and nonworking days. By their very nature factory calendars are localized. That is each production facility may have its own factory calendar to reflect the workdays and shifts within that facility. Whether you are developing your data warehouse for a manufacturer or not the idea of tracking workdays has wide applicability when performing analysis for a variety of businesses. The concept of the factory calendar has been expanded in modern usage to provide a calendar for consistently measuring the number of workdays between two events such as the beginning and end of a promotional period and for facilitating data access for an equal number of workdays regardless of the elapsed calendar days. The premise behind the factory calendar was to homogenize the timeline so that day calculations could be done using simple arithmetic. This homogeneity is also important when performing year-over-year and month-over-month analysis. If you have a sales force that works Monday through Friday and you need to compare this month s performance to date against last month s it makes sense to count the same number of selling days in each month otherwise the comparison can be skewed depending on where the weekend falls in relation to the start of the month. This concept will be discussed at length in the next section. Calendar Elements An effective calendar entity can significantly improve people s ability to perform analysis over time. There are three fundamental concepts that facilitate the analysis The day of the week particularly in Retail businesses Accounting for nonworking days to provide meaningful comparative analysis and elapsed-time calculations Defining time periods of interest such as holiday seasons for analysis Day of the Week The day of the week is probably the most commonly recognized