BigQuery vs IBM Db2 Warehouse comparison

"BigQuery excels at structuring data, performing predictions, and conducting insightful analyses and it leverages machine learning and artificial intelligence capabilities, powered by Google's Duarte AI."

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

"BigQuery can be used for any type of company. It has the capability of building applications and storing data. It can be used for OLTP or OLAP. It has many other products within the Google space."

"The product is serverless. We only need to write SQL queries to analyze the data. We need to pay based on the number of queries. The retrieval time is very less. Even if you write large queries, the tool is able to bring back data in a few seconds."

"One of the most significant advantages lies in the decoupling of storage and compute which allows to independently scale storage and compute resources, with the added benefit of extremely cost-effective storage akin to object storage solutions."

"Its integration with other tools like Atlan through a Google Chrome extension is highly beneficial."

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

"We like the machine learning features and the high-performance database engine."

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

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

"Provides good security and reliability."

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

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

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

"The solution is stable."

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

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

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

"There is a good amount of documentation out there, but they're consistently making changes to the platform, and, like, their literature hasn't been updated on some plans."

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

"It would be beneficial if BigQuery could be made more affordable."

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

"The primary hurdle in this migration lies in the initial phase of moving substantial volumes of data to cloud-based platforms."

"The process of migrating from Datastore to BigQuery should be improved."

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

"IBM Db2 Warehouse needs to improve its interface."

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

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

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

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

"Lacks sufficient documentation and particularly in Spanish."

"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 product operates on a pay-for-use model. Costs include storage and query execution, which can accumulate based on data volume and complexity."

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

"I have tried my own setup using my Gmail ID, and I think it had a $300 limit for free for a new user. That's what Google is offering, and we can register and create a project."

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

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

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

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