Building Making It Happen
Building Making It Happen
  Sign-in         Register
    
Principles and Rules Listing Page
Managing time-stamps across multiple time-zones
When you are recording events across multiple time-zones, its better to record both the local time as well as a common standard time (say GMT)
 
This page of 'Principles and Rules' is linked to:  Data Warehousing, Data Analysis/OLAP, BI platform Tools Evaluation, BI business intelligence end-to-end view,


When you are operating across multiple time-zones, one way is to record one time-stamp:

  • A common standard date along with the flag of the time-zone in which the event occurred, so that local time can be calculated at run-time.
  • The local time-stamp with the flag of the time-zone in which the event occurred so that the common reference time (say GMT) can be calculated.

This is not advisable, because it will put run-time load (as time dimension is most used dimension), and this run-time calculation may need to be plugged into various reports and queries that you are generating. Moreover sometimes the rules for calculating the local time given the GMT and vice-versa may not be that straight. Therefore it is advised to have both the time-stamps relating to two different time zone. However this should be done only for key time-zones for which you will need your reporting on. For the other time-zones, which could be used on occasional basis, one can do real time calculations.

   Access more details on this page   

Quick Feedback- Was this information helpful ?
Relevant Links to this page
TOPIC - Data Mart Business Theme Matrix in Data Warehouse Dimensional Model → Principles & Rules → Dimensional model has to be aligned to the Entity-Relationship → Principles & Rules → Always Use Conformed Dimensions → Principles & Rules → You may not be a able to have a perfect ETL → Practice Techniques → Handling Sparse Dimensional tables → Principles & Rules → Do not separate the parent and child line item data → Practice Techniques → Managing time-stamps across multiple time-zones → Practice Techniques → Recording events in multiple currencies → Practice Techniques → Handle different units of measure in the same fact table → Principles & Rules → Handling of Null foreign Keys in fact tables → Principles & Rules → Dimension Attributes as NULL → Principles & Rules → Don't rely too much on Meta Data Tools to enforce Business Intelligence → Principles & Rules → Don't wait for universal models for Data Marting → 
 
Back
Featured Pages
Business Intelligence link to business
Data Mart Fact Table Grain Matrix in DW
MDM-CDI Hub
Strategy & process in dimensional model

Make 'Executable' Strategy
Maximize Results
Maximize People
Manage Execution

Featured Pages
ROLAP- Relational OLAP architecture
Ask for dates instead of years
Data Warehouse Project Scoping and Planning
Data Correction Change Request