Data base administrator at a engineering company with 11-50 employees
Real User
Top 20
2024-09-23T11:30:00Z
Sep 23, 2024
I use IBM Db2 Warehouse for analytics. We have a Cognos analytics tool, and I have built a Db2 Warehouse that collects data from various nodes that run on DB2. I gather all this information into one centralized Db2 Warehouse and create a star schema, which is then utilized by the Cognos Analytics Platform to produce dashboards and reports.
Data base 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.
InfoSphere Warehouse is a suite of products that combines the strength of DB2 with a data warehousing infrastructure from IBM. You can use InfoSphere Warehouse to build a complete data warehousing solution that includes a highly scalable relational database, data access capabilities, and front-end analysis tools.
I use IBM Db2 Warehouse for analytics. We have a Cognos analytics tool, and I have built a Db2 Warehouse that collects data from various nodes that run on DB2. I gather all this information into one centralized Db2 Warehouse and create a star schema, which is then utilized by the Cognos Analytics Platform to produce dashboards and reports.
We use the solution for data analysis.
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.