Problem solve Get help with specific problems with your technologies, process and projects.

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.


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

Dig Deeper on Database storage