Which hardware and operating system platform(s) would you recommend for placing the actual data warehouse data on (one terabyte initially and then growing)?
Sid Adelmans Answer: You shouldn't limit your considerations just to the hardware and operating system. You should also consider the database as well. When you do your reference checks, ask for installations which have implemented tables that are at least as large as you intend your tables to be. Ask them what performance problems they have had and how they and the vendors dealt with those problems. Michael Jennings Answer: I have experiences with successful 1+ terabyte data warehousing projects on HP/HP-UX, NCR/NCR UNIX and Sun/Solaris. Most hardware and OS combinations today would probably meet this criteria (my home PC almost does!). Some other considerations I would include are:
Chuck Kelleys Answer: This depends on your companys standards. I would put it on a UNIX box, because I dont think that Win2000 is quite ready for the 1TB databases and the user community required to justify it (Please no hate e-mail this is my opinion! I will not be devastated if you think otherwise.).
Clay Rehms Answer: When considering data warehouse hardware and software, I always look at and assess what is already at the client site first. What hardware and software has your company standardized on? Will this hardware and/or software work for you? Why not? After you have identified the standards, you can ask the question that just because it is a standard at your company, is it still a viable tool? My advice is that you are always better off using what exists for your initial releases of the data warehouse. This gives you a chance to determine how big the DW will possibly become, how many users will be accessing it and how they may be accessing it. You may make the mistake of purchasing hardware and software early on only to discover it was not enough, it was overkill or it was completely the wrong choice.
Register or login for access to this item and much more
All Information Management content is archived after seven days.
Community members receive:
- All recent and archived articles
- Conference offers and updates
- A full menu of enewsletter options
- Web seminars, white papers, ebooks
Already have an account? Log In
Don't have an account? Register for Free Unlimited Access