BigQuery vs IBM Db2 Warehouse comparison

"It's straightforward to set up."

"It has a proprietary way of storing and accessing data in its own data store and is 100% managed without you needing to install anything. There is no need to arrange for any infrastructure to be able to use this solution."

"The solution's reporting, dashboard, and out-of-the-box capabilities match exactly our requirements."

"The solution is very useful nowadays for keeping a huge number of records."

"The product's most valuable features include its scalability and the ability to handle complex queries on large datasets."

"The main thing I like about BigQuery is storage. We did an on-premise BigQuery migration with trillions of records. Usually, we have to deal with insufficient storage on-premises, but in BigQuery, we don't get that because it's like cloud storage, and we can have any number of records. That is one advantage. The next major advantage is the column length. We have some limits on column length on-premises, like 10,000, and we have to design it based on that. However, with BigQuery, we don't need to design the column length at all. It will expand or shrink based on the records it's getting. I can give you a real-life example based on our migration from on-premises to GCP. There was a dimension table with a general number of records, and when we queried that on-premises, like in Apache Spark or Teradata, it took around half an hour to get those records. In BigQuery, it was instant. As it's very fast, you can get it in two or three minutes. That was very helpful for our engineers. Usually, we have to run a query on-premises and go for a break while waiting for that query to give us the results. It's not the case with BigQuery because it instantly provides results when we run it. So, that makes the work fast, it helps a lot, and it helps save a lot of time. It also has a reasonable performance rate and smart tuning. Suppose we need to perform some joins, BigQuery has a smart tuning option, and it'll tune itself and tell us the best way a query can be done in the backend. To be frank, the performance, reliability, and everything else have improved, even the downtime. Usually, on-premise servers have some downtime, but as BigQuery is multiregional, we have storage in three different locations. So, downtime is also not getting impacted. For example, if the Atlantic ocean location has some downtime, or the server is down, we can use data that is stored in Africa or somewhere else. We have three or four storage locations, and that's the main advantage."

"We basically used it to store server data and generate reports for enterprise architects. It was a valuable tool for our enterprise design architect."

"It has a well-structured suite of complimentary tools for data integration and so forth."

"Some of the best features are stored procedures, parallelism, and different indexing strategies."

"The most valuable features of IBM Db2 Warehouse include its availability, easy integration, ability to deal with a large size of data, excellent performance with no delays, powerful security mechanisms, and effective support."

"The analytics engine is not bad at forecasting predictions."

"The standout feature of IBM Db2 Warehouse, which is particularly valuable for large enterprises, is its ability to handle big data."

"It can scale effectively as long as resources are available."

"It can be mounted on the cloud, which is a huge plus. If the client, for example, starts small with on-premise deployment and then it rapidly needs to grow, we can transfer this to the cloud easily."

"I think it scales really well and as long as you take enough time to learn a little bit about it, it works really well."

"Provides good security and reliability."

"I rate BigQuery six out of 10 for affordability. It could be cheaper."

"Sometimes, support specialists might not have enough experience or business understanding, which can be an issue."

"We would like to be able to calibrate the solution to run on top of a raw file."

"When I open many of the Google Cloud products, I am in an environment that I do not feel familiar with; it is a little overwhelming."

"Some of the queries are complex and difficult to understand."

"When I execute a query, the dashboard doesn't always present the output seamlessly. Troubleshooting requires opening each pipeline individually, which is time-consuming."

"I would like to see version-based implementation and a fallback arrangement for data stored in BigQuery storage. These are some features I'm interested in."

"BigQuery should integrate with other tools, such as Cloud Logging and Local Studio, to enhance its capabilities further and enable powerful and innovative analyses."

"The biggest challenge anyone could have with Db2 Warehouse is their references or online resources and documentation. They are very, very, very limited on the web."

"The areas of the solution that is needing the most improvement are separating compute from storage, elasticity, which means scaling up and then retracting."

"Lacks sufficient documentation and particularly in Spanish."

"It takes a long time to have a new version or release, similar to Oracle."

"IBM Db2 Warehouse needs to improve its interface."

"There were some initial challenges with IBM Db2 Warehouse about eight months ago when I worked in this environment. When I coordinated with IBM support, they mentioned that the memory was insufficient for our needs. Our business environment required significantly more memory than the previous cluster could provide. Consequently, we have worked closely with on-site IBM technical personnel to address this issue."

"There should be more material available for training and training should be free."

"The biggest problems we have is when the backup solution is failing or slow and we run out of log space, which has happened probably a couple of times in the last four years."

"The price is a bit high but the technology is worth it."

"The pricing appears to be competitive for the intended usage scenarios we have in mind."

"Its cost structure operates on a pay-as-you-go model."

"The tool has competitive pricing."

"The solution's pricing is cheaper compared to other solutions."

"The product’s pricing could be more flexible for end users."

"1 TB is free of cost monthly. If you use more than 1 TB a month, then you need to pay 5 dollars extra for each TB."

"BigQuery pricing can increase quickly. It's a high-priced solution."

"In a traditional on-prem database, in a data warehouse, the solution is probably on the expensive side."