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

What hardware should be purchased for data warehousing?

Are there formulas for deciding what hardware to purchase for a data warehousing? We are trying to write requirements for multiple CP's, controllers, RAID ARRAY but we're having a hard time finding general guides for building a warehouse with certain hardware.
Unfortunately there are no guides to help in defining the hardware that is required for data warehouses. Generally we look at the following components to determine hardware.

1) Disks
- Data storage needs (tables, indexes, temp space, etc.)
- Data landing space (for inbound files and archives)
- Software needs (database, ETL and BI software)
- BI software space requirements

2) Memory
- Database needs (database working memory and dynamic memory)
- ETL tool requirements
- BI tool needs (report requirements)

3) CPU's
- Depends on database size and implementation approach
- Can the ETL use multiple CPUs

4) RAID
- Evaluate performance requirements versus RAID approach
- Generally we want to avoid RAID 5 due to its performance impact.

5) Growth
- Ensure hardware is expandable
- Assume that growth will exceed expectations

I know that these factors are the basic factors, but at the end of the day, you will understand the performance requirements for your hardware and based on an extrapolation of your current hardware configurations, you should be able to judge how to be utilizing your hardware. The key is to buy hardware that can be expanded. You may find that what appears to be the right formula upfront does not always serve you in the long term. So no silver bullet for hardware, but by working with the hardware team you should be able to determine a hardware spec for your environment that satisfies your initial needs and prepares you for the future.

Dig Deeper on Oracle business intelligence and analytics

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.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close