In-depth Comparison of IBM Smart Analytics System 7700,
Teradata Active Enterprise Data Warehouse and
Oracle Exadata Database Machine.
Data warehousing has emerged as one of the IT world’s fastest growth areas. New deployments continue to accelerate, and numbers of applications and users within organizations continue to expand. Demand for high-quality, current information and for tools to interpret and exploit it shows no signs of abating. High
double-digit growth in data volumes has become the norm.
The business benefits of data warehouse applications are clearly recognized. But, increasingly, users are faced with escalating expenditure not only on data warehouse solutions, but also on underlying platforms. At a time of budgetary pressures, questions are raised about the most cost-effective means of realizing
This is particularly the case for special-purpose platforms offered by IBM (Smart Analytics System, Netezza TwinFin), Oracle (Exadata Database Machine), Teradata (Active Enterprise Data Warehouse) and smaller players. Architectures and technologies of these systems are often unfamiliar to organizations that deploy them. Techniques for measuring comparative performance and cost are rudimentary.
Challenges are compounded by several factors. One is that the performance of different architectures depends on the workloads they execute. Another is that data warehouse usage tends to evolve rapidly – organizations that deploy platforms for specific applications may soon find that they must deal with significantly different environments. A third is that vendor pricing may vary widely between customers.
This report sets some parameters for comparisons. To do this, it takes into account types of workload – in particular, a key distinction is drawn between complex mixed workloads and queries involving large sequential table scans – compares overall three-year as well as acquisition costs, and bases platform calculation on “street” pricing (i.e., discounted prices paid by users).
The report focuses on three platforms: IBM Smart Analytics System 7700, Oracle Exadata Database Machine and Teradata’s flagship Active Enterprise Data Warehouse (Active EDW) 6650. Results are based on input from 46 users of these systems and their recent predecessors, on other industry sources, as well as on research and analysis conducted by the International Technology Group (ITG).
Two sets of cost comparisons, based on performance and user data, are presented.
Continue reading Report: Cost/Benefit of Enterprise Warehouse Solutions