SSAS Design question

This is a discussion on SSAS Design question within the sqlserver-olap forums in Data Warehousing category; Hi All, I have a design question . I got the requirement of 2 TB starting for enterprise dataware house in my project. I want to implement next generation warehousing technique. So want to have a near line storage layer in the design. If we seperate data such that current year and last year will be in SAS(Serial Attached SCSI) drive and next past 3 years will be in Near line. E.g. 2007 and 2008 will be in one cube which is located in SAS and 2006,2005 and 2004 will be in another cube stored in near line ...

Go Back   Database Forum > Data Warehousing > sqlserver-olap

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 08-26-2008, 02:38 AM
Default SSAS Design question

Hi All,
I have a design question . I got the requirement of 2 TB starting for
enterprise dataware house in my project. I want to implement next generation
warehousing technique. So want to have a near line storage layer in the
design.

If we seperate data such that current year and last year will be in
SAS(Serial Attached SCSI) drive and next past 3 years will be in Near line.
E.g. 2007 and 2008 will be in one cube which is located in SAS and 2006,2005
and 2004 will be in another cube stored in near line storage. Can we develop
such cubes seperately and how can we combine these for adhoc query option?
Another design is have only one cube and use partitions based on years. 2008
& 2007 partition can be stored in SAS drive and remaining on some other
drive.

Please help me in this.

Thanks,
RK


Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 05:49 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.