The good news is you are looking at the dominant players in what the Transaction Processing Performance Council calls Very Large Data Warehouse VLDW. According to independent TPC tests and research firms such as Gartner and The Winter Group, Teradata historically outperforms IBM and Oracle in the 3 TB plus sizes. Each year IBM and Oracle demonstrate more and more mission capability in the VLDW space and each year Teradata continues to raise the bar through expanded vision and performance. To give you a qualified opinion, I highly recommend a comprehensive DW assessment be performed. One would need to first understand the needs and the strategic direction of the organization, including things such as some of the following;
- the volumes of current users
- the access patterns and usage behaviors of the users
- the applications you want to enable (active DW, Data mining, score cards, BPM, BAM, etc, etc
- the latency requirements for posting data into to your DW
- your BI tool strategy
- your definition of "cost effective" over 24-36 month planning horizon
- the age and dormancy and access patterns to "old" data
- the current capital investment in technology (people, data management software, servers, storage and networks)
- your current and future plans for Operational Support Systems (OSS) and ERPs
Good Luck. Drop me line to let me know how you progress.
Dig Deeper on Oracle business intelligence and analytics
Related Q&A from Mike Lampa
When trying to design a data warehouse, we often try to model the database on the operational data model. Are there any guidelines in trying to ... Continue Reading
What is a surrogate key in a table? Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.