Q

Using SAN or NAS for data warehousing

Hi Christopher,

Can you please advise if there are any and how many organizations are opting to use NAS or SAN technology for data warehousing? Is this a sound architecture for this type of application?

Many thanks.

Using NAS for data warehousing would be determined by the actual database you are planning on using. Microsoft, I believe, pulled support for NAS on SQL Server so that's out. Oracle does support the use of NAS for databases but you need to be careful on how it is set up and be sure your network connections are robust enough to handle the load. As for DB2, Sybase, Ingress, Informix, etc., I'm not sure of support so you should ask them directly.

Remember that NAS uses file based I/O rather than block based I/O so the maximum frame sizes for any write operation must conform to IP standards. Block based I/O using SCSI protocol can have a varying payload size. Data warehouse applications tend to be more "high throughput" rather than "high IOPS" in nature, which means the ability to move a large quantity of data is important. SCSI (over Fibre in a SAN or standalone) tends to be the better method for these environments.

As for how many organizations are using SAN or NAS to do data warehousing, well, I have been involved with MANY implementations, using all the various flavors of databases and have yet to see a single data warehouse solution done via NAS. I'm sure they are out there but in my personal experience, I've yet to be involved in one.

Chris

Editor's note: Do you agree with this expert's response? If you have more to share, post it in one of our .bphAaR2qhqA^0@/searchstorage>discussion forums.

This was first published in May 2002
This Content Component encountered an error

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchSolidStateStorage

SearchVirtualStorage

SearchCloudStorage

SearchDisasterRecovery

SearchDataBackup

Close