NAS or SAN for data warehousing
I am using Oracle to build a data warehouse for an organization that has about 2 TB data at the moment, and most likely more in the future. I don't know how to manage storage for this system -- should I use SAN or NAS?

    Requires Free Membership to View

    Login

    When you register for SearchStorage.com, you’ll also receive targeted emails from my team of award-winning editorial writers. Our goal is to keep you informed on the hottest topics, the latest news and the biggest challenges you face as a storage professional today.

    Rich Castagna, Editorial Director

    By submitting your registration information to SearchStorage.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchStorage.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

It really depends a lot on your requirements. If there is a need for a high transaction rate, you might want to implement a SAN and work with your vendor of choice for the management of the SAN. If the transaction rate requirement is more modest, you could install a NAS system and the administration would be much less than with a SAN. Make sure that whatever solution you choice, the management software has some visibility for the Oracle database.

This was first published in October 2004