Database Administrator at a engineering company with 11-50 employees
Real User
Top 20
2022-11-11T17:05:05Z
Nov 11, 2022
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.
Solutions Architect at a tech services company with 201-500 employees
Reseller
2021-10-22T22:18:23Z
Oct 22, 2021
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.
Data Governance at a manufacturing company with 10,001+ employees
Real User
2021-03-20T14:21:00Z
Mar 20, 2021
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.
What is a data warehouse? A data warehouse, sometimes categorized as an Enterprise Data Warehouse, (DW or DWH) is a data analysis and reporting system. Data warehouses are fundamental storehouses of integrated data from single, or multiple sources, storing historical or current data in one location where data is utilized, creating reports for designated Enterprise users.
A DW is considered an integral component of business intelligence and describes a system used to analyze an...
I mostly use it in big data solutions.
I'm a salesperson.
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.
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.
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.
We use the solution for general data warehouse purposes, high volume data, and large selection queries.