BigQuery vs Oracle Autonomous Data Warehouse comparison

Google and Oracle are both solutions in the Cloud Data Warehouse category. Google is ranked #5 with an average rating of 8.3, while Oracle is ranked #10 with an average rating of 8.4. Google holds a 9.2% mindshare in CDW, compared to Oracle’s 5.9% mindshare. Additionally, 100% of Google users are willing to recommend the solution, compared to 100% of Oracle users who would recommend it.

BigQuery

Read 34 BigQuery reviews

4,500 Views
3,458 Comparison Views

100% willing to recommend

Oracle Autonomous Data Ware...

Read 18 Oracle Autonomous Data Warehouse reviews

2,715 Views
1,819 Comparison Views

100% willing to recommend

BigQuery

Oracle Autonomous Data Ware...

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between BigQuery and Oracle Autonomous Data Warehouse based on real PeerSpot user reviews.

Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.

To learn more, read our detailed BigQuery vs. Oracle Autonomous Data Warehouse Report (Updated: October 2024).

Buyer's Guide

BigQuery vs. Oracle Autonomous Data Warehouse

October 2024

Download the complete report

Helped 813,418 peers since 2012

Categories and Ranking

BigQuery

Ranking in Cloud Data Warehouse

5th

Average Rating

8.2

Number of Reviews

Ranking in other categories

No ranking in other categories

Oracle Autonomous Data Ware...

Ranking in Cloud Data Warehouse

10th

Average Rating

8.6

Number of Reviews

Ranking in other categories

No ranking in other categories

Mindshare comparison

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

Cloud Data Warehouse

Featured Reviews

VikashKumar1

Tech lead at Ford Motor Company

Aug 23, 2024

Easy to maintain and provides high availability

Since I used BigQuery over the GCP cloud environment, I'm not sure whether we can go through internal IDEAs like IntelliJ or DBeaver that we use to connect with databases. Instead of connecting directly to BigQuery, we connect to GCP, Cloud Run, and then to BigQuery, which is a long process. Sometimes, we face some issues, bugs, and defects. We must first connect with a VPN to check data issues while working from home. Then, it allows you to connect to the cloud. After logging into the cloud, it searches for the service we are looking for, and then we go to BigQuery. This is a long process. After that, we analyze the issues in a table. Instead, it would be very helpful if it could provide a tool that we can install on our MacBook or Windows system. Once we open this tool, we can connect directly to the BigQuery server and easily perform tasks.

Read full review

Kwajah Mohiuddin

Global Head of Architecture at a financial services firm with 1,001-5,000 employees

Aug 15, 2024

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…

Read full review

Quotes from Members

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

Pros

"The integrated data storage features are good."

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

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

"What I like most about BigQuery is that it's fast and flexible. Another advantage of BigQuery is that it's easy to learn."

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

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

"It's pretty stable. It's fast, and it is able to go through large quantities of data pretty quickly."

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

More BigQuery pros

"One advantage is that if you already have an Oracle Database, it easily integrates with that."

"The analytics have been very good. We've found them to be quite useful."

"It is an extremely scalable solution since you can dynamically change the resources as some other cloud solutions."

"The solution integrates well with Power BI."

"Self-patching and runs machine-learning across its logs all the time"

"Oracle Autonomous Data Warehouse is used globally to deliver extreme performance on large Financial data sets."

"It provides Transparent Data Encryption (TDE) capabilities by default to address data security issues."

"It is a stable and scalable solution."

More Oracle Autonomous Data Warehouse pros

Cons

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

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

"It would be helpful if they could provide some dashboards where you can easily view charts and information."

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

"We'd like to see more local data residency."

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

"With other columnar databases like Snowflake, you can actually increase your VM size or increase your machine size, and you can buy more memory and it will start working faster, but that's not available in BigQuery. You have to actually open a ticket and then follow it up with Google support."

More BigQuery cons

"I would like to see Application Express and Oracle R Enterprise fully supported, and I would like to see Oracle Data Mining supported as a front end."

"One of the major problem is creating custom tablespace. The ADB serverless option doesn't support custom tablespace creation, which could cause issues during on-premise database migration that requires specifically named tablespace. There should be an option to create customized tablespace."

"They should make the solution more user-friendly."

"The solution could be improved by allowing for migration tools from other cloud services, including migration from Amazon Redshift, RDS, and Aurora."

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

"It is very important the integration with other platforms be made to be as easy as it is with an on-premises deployment."

"Oracle Autonomous Data Warehouse is not available as an on-premises solution."

"I would like to see an on-premise solution in the future."

More Oracle Autonomous Data Warehouse cons

Pricing and Cost Advice

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

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

"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 platform is inexpensive."

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

"The tool has competitive pricing."

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

More BigQuery pricing and cost advice

"Oracle Autonomous Data Warehouse's pricing is fair and reasonable compared to the other cloud vendors."

"You pay as you go, and you don't pay for services that you don't use."

"The solution's cost is reasonable."

"ROI is high."

"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 cost is perfect with Oracle Universal credit."

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

"The solution is expensive."

More Oracle Autonomous Data Warehouse pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.

See recommendations

813,418 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Computer Software Company

17%

Financial Services Firm

14%

Manufacturing Company

12%

Retailer

Educational Organization

48%

Financial Services Firm

Computer Software Company

Manufacturing Company

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.

See all answers

What is your experience regarding pricing and costs for BigQuery?

The product operates on a pay-for-use model. Costs include storage and query execution, which can accumulate based on data volume and complexity.

See all answers

What needs improvement with BigQuery?

See all answers

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

See all answers

What is your experience regarding pricing and costs for Oracle Autonomous Data Warehouse?

The solution is expensive. I rate the price an eight out of ten.

See all answers

What needs improvement with Oracle Autonomous Data Warehouse?

The setup is complex. Oracle is a complex tool.

See all answers

Comparisons

Snowflake vs BigQuery

Compared 41% of the time

Teradata vs BigQuery

Compared 15% of the time

Vertica vs BigQuery

Compared 11% of the time

Apache Hadoop vs BigQuery

Compared 6% of the time

Oracle Exadata vs BigQuery

Compared 5% of the time

More BigQuery Competitors

Snowflake vs Oracle Autonomous Data Warehouse

Compared 31% of the time

Oracle Exadata vs Oracle Autonomous Data Warehouse

Compared 23% of the time

Microsoft Azure Synapse Analytics vs Oracle Autonomous Data Warehouse

Compared 19% of the time

Amazon Redshift vs Oracle Autonomous Data Warehouse

Compared 3% of the time

Apache Hadoop vs Oracle Autonomous Data Warehouse

Compared 2% of the time

More Oracle Autonomous Data Warehouse Competitors

Product Reports

Buyer's Guide

BigQuery

October 2024

Download BigQuery product report

Buyer's Guide

Oracle Autonomous Data Warehouse

October 2024

Download Oracle Autonomous Data Warehouse product report

Learn More

Google

Oracle

Overview

BigQuery is an enterprise data warehouse that solves this problem by enabling super-fast SQL queries using the processing power of Google's infrastructure. ... You can control access to both the project and your data based on your business needs, such as giving others the ability to view or query your data.

Oracle Autonomous Data Warehouse is the world’s first and only autonomous database optimized for analytic workloads, including data marts, data warehouses, data lakes, and data lakehouses. With Autonomous Data Warehouse, data scientists, business analysts, and nonexperts can rapidly, easily, and cost-effectively discover business insights using data of any size and type. Built for the cloud and optimized using Oracle Exadata, Autonomous Data Warehouse benefits from faster performance and, according to an IDC report (PDF), lowers operational costs by an average of 63%.

Autonomous Database provides the foundation for a data lakehouse—a modern, open architecture that enables you to store, analyze, and understand all your data. The data lakehouse combines the power and richness of data warehouses with the breadth, flexibility, and low cost of popular open source data lake technologies. Access your data lakehouse through Autonomous Database using the world's most powerful and open SQL processing engine.

Sample Customers

Information Not Available

Hertz, TaylorMade Golf, Outront Media, Kingold, FSmart, Drop-Tank

Buyer's Guide

BigQuery vs. Oracle Autonomous Data Warehouse

October 2024

Free Report: BigQuery vs. Oracle Autonomous Data Warehouse

Find out what your peers are saying about BigQuery vs. Oracle Autonomous Data Warehouse and other solutions. Updated: October 2024.

DOWNLOAD NOW

813,418 professionals have used our research since 2012.

See our BigQuery vs. Oracle Autonomous Data Warehouse report.

See our list of best Cloud Data Warehouse vendors.

We monitor all Cloud Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.