BigQuery vs IBM Db2 Warehouse comparison

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

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

"It's similar to a Hadoop cluster, except it's managed by Google."

"As a cloud solution, it's easy to set up."

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

"The features I have found most valuable in BigQuery include the query cache, which is good and scales well; it handles huge amounts of data quite well, and the multi-regions feature works well."

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

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

"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 solution is stable."

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

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

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

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

"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 process of migrating from Datastore to BigQuery should be improved."

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

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

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

"We'd like to have more integrations with other technologies."

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

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

"When I execute a query, the dashboard doesn't always present the output seamlessly."

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

"Lacks sufficient documentation and particularly in Spanish."

"Responding to support tickets takes a lot of time. It can range from two to four days, even for critical issues."

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

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

"IBM Db2 Warehouse needs to improve its interface."

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

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

"The price could be better. Usually, you need to buy the license for a year. Whenever you want more, you can subscribe to it, and you can use it. Otherwise, you can terminate the license. You can use it daily or monthly, and we use it based on a project's requirements."

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

"We are above the free threshold, so we are paying around 40 euros per month for BigQuery."

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

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

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

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