Try our new research platform with insights from 80,000+ expert users

BigQuery vs Oracle Autonomous Data Warehouse comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

BigQuery
Ranking in Cloud Data Warehouse
5th
Average Rating
8.2
Reviews Sentiment
7.6
Number of Reviews
35
Ranking in other categories
No ranking in other categories
Oracle Autonomous Data Ware...
Ranking in Cloud Data Warehouse
9th
Average Rating
8.6
Reviews Sentiment
7.5
Number of Reviews
18
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of November 2024, in the Cloud Data Warehouse category, the mindshare of BigQuery is 9.3%, up from 6.7% compared to the previous year. The mindshare of Oracle Autonomous Data Warehouse is 6.1%, up from 4.2% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Cloud Data Warehouse
 

Featured Reviews

Sathishkumar Jayaprakash - PeerSpot reviewer
Efficient large dataset handling with seamless service integration
BigQuery allows for very fast access, and it is efficient in handling large datasets compared to other SQL databases. It integrates well with other GCP products, and creating subscriptions in the UI is straightforward. The whole ecosystem of GCP products makes BigQuery beneficial for our data-handling tasks. Additionally, it is more cost-effective compared to alternatives like AWS.
Kwajah Mohiuddin - PeerSpot reviewer
Provides self-repair features, but the setup is complex
We use the product for online applications. We use it in the financial industry The product has self-repair features. The tool tunes itself. It separates compute from storage. We can scale storage and compute separately. The setup is complex. Oracle is a complex tool. I have been using Oracle…

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"I like that we can synch and run a large query. I also like that we can work with a large amount of data. You don't need to work separately, as it's a ready-made solution. It also comes with a built-in machine-learning feature. Once we start inputting the data, it will suggest some things related to the data, and we can come up with nice dashboards and statistics from a vast amount of data."
"BigQuery is a powerful tool for managing and analyzing large datasets. The versatility of BigQuery extends to its compatibility with external data visualization tools like Power BI and Tableau. This means you not only get query results but can also seamlessly integrate and visualize your data for better insights."
"The initial setup is straightforward."
"It's pretty stable. It's fast, and it is able to go through large quantities of data pretty quickly."
"The feature called calibrating the capacity is valuable."
"The most valuable features of this solution, in my opinion, are speed and performance, as well as cost-effectiveness."
"The product’s most valuable feature is its ability to manage the database on the cloud."
"Even non-coders can review the data in BigQuery."
"Self-patching and runs machine-learning across its logs all the time"
"A very good integration feature that restricts access to unauthorized people."
"I loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW."
"The solution integrates well with Power BI."
"Oracle Autonomous Data Warehouse is used globally to deliver extreme performance on large Financial data sets."
"The product is easy to use."
"The solution has a self-backup, so you don't need a DBA (database administrator) to do a backup."
"It is a very stable tool...It is an extremely scalable tool."
 

Cons

"We'd like to see more local data residency."
"So our challenge in Yemen is convincing many people to go to cloud services."
"We'd like to have more integrations with other technologies."
"The main challenges are in the areas of performance and cost optimizations."
"The solution hinges on Google patterns so continued improvement is important."
"The price could be better. Compared to competing solutions, BigQuery is expensive. It's only suitable for enterprise customers, not small and medium-sized businesses, as they cannot afford this kind of solution. In the next release, it would be better if they improved their AI bot. Although machine learning and artificial intelligence are doing wonders, there is still a lot of room to enhance them."
"The product’s performance could be much faster."
"It would be beneficial to integrate additional tools, particularly from a business intelligence perspective."
"A lot of the tools that were previously there have now been taken away."
"There is a need for more storage to be allocated, but over a period of time, it becomes impossible to reduce it after using it."
"An improvement for us would be the inclusion of support for an internal IP, so we could use it directly with the VCN in Oracle Cloud."
"The solution lacks visibility options."
"The setup is complex."
"They should make the solution more user-friendly."
"It doesn't work well when you have unstructured data or you need online analytics. It is not as nice as Hadoop in these aspects."
"Oracle Autonomous Data Warehouse is not available as an on-premises solution."
 

Pricing and Cost Advice

"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."
"BigQuery pricing can increase quickly. It's a high-priced solution."
"BigQuery is inexpensive."
"The pricing is good and there are no additional costs involved."
"The tool has competitive pricing."
"The product operates on a pay-for-use model. Costs include storage and query execution, which can accumulate based on data volume and complexity."
"The product’s pricing could be more flexible for end users."
"The price is a bit high but the technology is worth it."
"Oracle Autonomous Data Warehouse's pricing is fair and reasonable compared to the other cloud vendors."
"In terms of architecture and pricing structure, I feel it is a little bit costly compared to Azure. It's fine compared to RedShift, but compared to Azure, it's a bit pricey when you calculate for one TB storage plus around five hours of reporting with the frequency of 1TB data. The cost adds up, making Oracle a bit expensive."
"On a scale from one to ten, where one is a low price and ten is a high price, I rate the pricing an eight."
"The licensing cost of the product can vary since you can integrate it very easily with other products or other cloud products...You pay as you use it, so it is not yearly or monthly payments to be made toward Oracle."
"The solution is expensive."
"The price depends on the configuration we choose."
"The solution's cost is reasonable."
"You pay as you go, and you don't pay for services that you don't use."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
816,636 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
16%
Financial Services Firm
14%
Manufacturing Company
12%
Retailer
7%
Educational Organization
49%
Financial Services Firm
7%
Computer Software Company
7%
Manufacturing Company
4%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about BigQuery?
The initial setup process is easy.
What is your experience regarding pricing and costs for BigQuery?
AWS has a large number of users and has built a model with high costs, whereas GCP offers cost-effective solutions.
What needs improvement with BigQuery?
There is a limitation when copying data directly from BigQuery; it only supports up to ten MB when copying data to the clipboard. For larger data, we have to download it as JSON or Excel files. Thi...
What do you like most about Oracle Autonomous Data Warehouse?
With Oracle Autonomous Data Warehouse, things are much simpler. Creating a structure, initializing the servers, extending the servers, those are all things that are very, very easy. That's the main...
 

Learn More

 

Overview

 

Sample Customers

Information Not Available
Hertz, TaylorMade Golf, Outront Media, Kingold, FSmart, Drop-Tank
Find out what your peers are saying about BigQuery vs. Oracle Autonomous Data Warehouse and other solutions. Updated: October 2024.
816,636 professionals have used our research since 2012.