Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • DownloadDownload
  • PrintPrint

Days

For cube designs that store data at the daily level of detail, there are a number of different options such as using a three dimensional approach with year, week, and weekday.

Note

The maintenance using this approach is low; an additional year needs to be added to the year dimension once each year.

Lower than day detail

If your requirements for data are to capture and store data lower than a day (such as an hour or even a minute), an additional dimension should be added for that day's detail, along with appropriate aggregations or rollups.


  

You are currently reading a PREVIEW of this book.

                                                                                        

Get instant access to over
$1 million worth of books and videos.

  

Start a Free Trial