This article is one in a series that focuses on improving performance in Db2 Warehouse. The first part provides some background information and lays out the first and most important aspect of query optimization, namely, cardinality estimation or estimating the number of rows in an execution plan.
The IBM DB2 Analytics Accelerator (IDAA) has proven to be a big success in enabling analytics on DB2 z/OS data. Roberta Barnabè gave a well-received presentation at IDUG EMEA 2015 in Dublin on how her company implemented IDAA. Get practical advice to help have a successful implementation.
The Logical Data Warehouse is a data management architecture for analytics. It is a collection of data repositories and associated data services for management and access to data. IBM Fluid Query is a new software component that extends the concept of a federated query to Big Data.
DB2 has several new Cloud offerings. With DB2, you can get support for OLTP or Analytics. The database can be hosted or fully managed. This presentation by Kelly Schlamb at the 2015 IDUG Tech Conference in Australia details the three products, their differences and the use cases for each.
The video below is a presentation recorded at the IDUG DB2 North America Tech Conference in May 2015. Netezza is a Data Warehouse Appliance which provides high performance on large volumes of data. Abhik Roy presents the Netezza architecture from a DBA perspective by comparing its features to DB2.