BigQuery vs IBM Db2 Warehouse comparison

"BigQuery allows for very fast access, and it is efficient in handling large datasets compared to other SQL databases."

"The most valuable features of this solution, in my opinion, are speed and performance, as well as cost-effectiveness."

"This solution is highly scalable."

"BigQuery excels at data analysis. It processes vast amounts of information using its advanced architecture and sophisticated querying capabilities, making it crucial for critical insights and safe for handling sensitive data."

"The product’s most valuable feature is its ability to manage the database on the cloud."

"The most valuable features of BigQuery is that it supports standard SQL and provides good performance."

"It stands out in efficiently handling internal actions without the need for manual intervention in tasks like building cubes and defining final dimensions."

"The initial setup process is easy."

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

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

"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."

"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 standout feature of IBM Db2 Warehouse, which is particularly valuable for large enterprises, is its ability to handle big data."

"IBM Db2 Warehouse is more resilient when dealing with business intelligence applications."

"IBM Db2 Warehouse is more resilient when dealing with business intelligence applications."

"The solution is stable."

"I understand that Snowflake has made some improvements on its end to further reduce costs, so I believe BigQuery can catch up."

"When it comes to queries or the code being executed in the data warehouse, the management of this code, like integration with the GitHub repository or the GitLab repository, is kind of complicated, and it's not so direct."

"As a product, BigQuery still requires a lot of maturity to accommodate other use cases and to be widely acceptable across other organizations."

"The solution hinges on Google patterns so continued improvement is important."

"There are many tools that you have to use with BigQuery that are different services also provided for by Google. They need to all be integrated into BigQuery to make the solution easier to use."

"The processing capability can be an area of improvement."

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

"The initial setup could be improved making it easier to deploy."

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

"In terms of improvement, IBM Db2 Warehouse should be more scalable."

"The primary challenges customers face with IBM Db2 Warehouse are related to its complexity in usage. It requires highly skilled professionals who understand Db2, and both training and support are challenging to obtain."

"The primary challenges customers face with IBM Db2 Warehouse are related to its complexity in usage. It requires highly skilled professionals who understand Db2, and both training and support are challenging to obtain."

"IBM Db2 Warehouse needs to improve its interface."

"Lacks sufficient documentation and particularly in Spanish."

"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."

"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."

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

"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."

"The solution is pretty affordable and quite cheap in comparison to PDP or Cloudera."

"The pricing is good and there are no additional costs involved."

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

"The pricing is adaptable, ensuring that organizations can tailor their usage and costs based on their specific requirements and configurations within the Google Cloud Platform."

"Price-wise, I think that is very reasonable."

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

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