This is part 2 in the series that focuses on improving performance in Db2 Warehouse databases. The first part gave some background and discussed some basic concepts relevant to query optimization in the context of the Db2 column engine.
Part 2 : Identifying Costly Operations + Improving Joins
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.