IBM Db2 Warehouse Primary Use Case

KD
Data Governance at a manufacturing company with 10,001+ employees

We called our primary use case for this solution a data warehouse. It was data tapped from many, many different applications and mostly put into star schemas for historical reporting.

View full review »
MA
Database Administrator at a engineering company with 11-50 employees

We deployed Db2 Warehouse on the IBM Cloud backbone. We had a problem with our client because at first, they didn't want any warehousing in their solution. They wanted to generate reports and data analysis and predictions and forecast analysis for their company, but without any warehousing. They wanted to connect their ordinary relational database with IBM Cognos directly. The problem with that is that IBM Cognos Analytics doesn't work well with relational databases, so we suggested using some sort of warehousing database to make the Cognos engine work efficiently. They agreed and we started working with Db2 Warehouse.

The primary use case of this solution is reporting. Reporting doesn't work well with a relational database. Warehousing works with something called Star Schema or Snowflake Schema. Its structure is very different from the structure of a relational database. It consists of dimension tables and fact tables. All of your data is in your fact tables. It consists of one or two tables at most, but relational databases are not like that. Analytic engines don't work well with any relational data. Your report can be generated as fast as possible right now, but in three to five years, the report will perform poorly and there could be performance issues, so warehousing with reporting services instead is very good.

View full review »
Douglas Clarke - PeerSpot reviewer
Director at Bitanium Consulting

I mostly use it in big data solutions.

View full review »
Buyer's Guide
Data Warehouse
April 2024
Find out what your peers are saying about IBM, Oracle, Snowflake Computing and others in Data Warehouse. Updated: April 2024.
768,740 professionals have used our research since 2012.
BB
Principal Information Architect at a insurance company with 5,001-10,000 employees

We use the solution for general data warehouse purposes, high volume data, and large selection queries.

View full review »
AZ
Sales Manager at a tech services company with 51-200 employees

I'm a salesperson. 

View full review »
SR
Solutions Architect at a tech services company with 201-500 employees

We run POCs of the Db2 Warehouse for telecoms. We just created the databases, we set the environment to work with, and then the client uploads the data. The solution is primarily used for data analysis. I handle the provisioning.

View full review »
Buyer's Guide
Data Warehouse
April 2024
Find out what your peers are saying about IBM, Oracle, Snowflake Computing and others in Data Warehouse. Updated: April 2024.
768,740 professionals have used our research since 2012.