BigQuery vs Oracle Autonomous Data Warehouse comparison

Cancel
You must select at least 2 products to compare!
Comparison Buyer's Guide
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: March 2024).
765,386 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"It's similar to a Hadoop cluster, except it's managed by Google.""When integrating their system into the cloud-based solutions, we were able to increase their efficiency and overall productivity twice compared with their on-premises option.""It has a well-structured suite of complimentary tools for data integration and so forth.""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.""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.""As a cloud solution, it's easy to set up.""The feature called calibrating the capacity is valuable.""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."

More BigQuery Pros →

"I loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW.""It is a stable and scalable solution.""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 reason we use it.""It is an extremely scalable solution since you can dynamically change the resources as some other cloud solutions.""A very good integration feature that restricts access to unauthorized people.""I really like the auto-tuning, auto-scaling, and the automatic load balancing and query tuning in the system.""The product is easy to use.""The solution integrates well with Power BI."

More Oracle Autonomous Data Warehouse Pros →

Cons
"Some of the queries are complex and difficult to understand.""It would be beneficial to integrate additional tools, particularly from a business intelligence perspective.""The processing capability can be an area of improvement.""I noticed recently it's more expensive now.""The solution hinges on Google patterns so continued improvement is important.""The product’s performance could be much faster.""The initial setup could be improved making it easier to deploy.""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."

More BigQuery Cons →

"The initial setup was pretty complex. It was not easy.""The installation process is complex. Oracle can make the installation process better.""My main suggestion for Oracle is the configuration and key values that come for JSON files. When we create a table, especially if you see in our RedShift or some other stuff, if I create a table on top of a JSON file with multiple array columns or superset columns, those column values create some difficulty in Oracle.""Sometimes the solution works differently between the cloud and on-premises. It needs to be more consistent and predictable.""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.""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.""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."

More Oracle Autonomous Data Warehouse Cons →

Pricing and Cost Advice
  • "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."
  • "BigQuery is inexpensive."
  • "One terabyte of data costs $20 to $22 per month for storage on BigQuery and $25 on Snowflake. Snowflake is costlier for one terabyte, but BigQuery charges based on how much data is inserted into the tables. BigQuery charges you based on the amount of data that you handle and not the time in which you handle it. This is why the pricing models are different and it becomes a key consideration in the decision of which platform to use."
  • "The price is a bit high but the technology is worth it."
  • "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 solution is pretty affordable and quite cheap in comparison to PDP or Cloudera."
  • "BigQuery pricing can increase quickly. It's a high-priced solution."
  • "The pricing is good and there are no additional costs involved."
  • More BigQuery Pricing and Cost Advice →

  • "The cost is perfect with Oracle Universal credit."
  • "ROI is high."
  • "You pay as you go, and you don't pay for services that you don't use."
  • "Cloud solutions are cheaper, but in the long run, they may not be much cheaper. They certainly have a lower initial cost. The licensing is yearly, and it is based on the size of the hardware and the number of users."
  • "The solution's cost is reasonable."
  • "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 price depends on the configuration we choose."
  • More Oracle Autonomous Data Warehouse Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
    765,386 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:The most valuable features of BigQuery is that it supports standard SQL and provides good performance.
    Top Answer:The solution's pricing is cheaper compared to other solutions. On a scale from one to ten, where one is cheap, and ten is expensive, I rate the solution's pricing a two or three out of ten.
    Top Answer:The main challenges are in the areas of performance and cost optimizations. Achieving optimal results demands a certain level of familiarity with the platform's internals. The key point for… more »
    Top Answer: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… more »
    Top Answer:Cost-wise, it's a solid seven out of ten. A bit costly, but it is a good tool.
    Top Answer:My main suggestion for Oracle is the configuration and key values that come for JSON files. When we create a table, especially if you see in our RedShift or some other stuff, if I create a table on… more »
    Ranking
    5th
    Views
    3,497
    Comparisons
    2,548
    Reviews
    30
    Average Words per Review
    507
    Rating
    8.1
    10th
    Views
    3,493
    Comparisons
    2,338
    Reviews
    7
    Average Words per Review
    556
    Rating
    8.1
    Comparisons
    Learn More
    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
    Top Industries
    REVIEWERS
    Financial Services Firm11%
    Computer Software Company11%
    Comms Service Provider11%
    Transportation Company6%
    VISITORS READING REVIEWS
    Computer Software Company17%
    Financial Services Firm13%
    Manufacturing Company10%
    Retailer7%
    REVIEWERS
    Computer Software Company30%
    Manufacturing Company20%
    Financial Services Firm20%
    Transportation Company10%
    VISITORS READING REVIEWS
    Educational Organization43%
    Financial Services Firm9%
    Computer Software Company8%
    Manufacturing Company4%
    Company Size
    REVIEWERS
    Small Business31%
    Midsize Enterprise21%
    Large Enterprise48%
    VISITORS READING REVIEWS
    Small Business21%
    Midsize Enterprise13%
    Large Enterprise67%
    REVIEWERS
    Small Business40%
    Midsize Enterprise7%
    Large Enterprise53%
    VISITORS READING REVIEWS
    Small Business13%
    Midsize Enterprise47%
    Large Enterprise40%
    Buyer's Guide
    BigQuery vs. Oracle Autonomous Data Warehouse
    March 2024
    Find out what your peers are saying about BigQuery vs. Oracle Autonomous Data Warehouse and other solutions. Updated: March 2024.
    765,386 professionals have used our research since 2012.

    BigQuery is ranked 5th in Cloud Data Warehouse with 30 reviews while Oracle Autonomous Data Warehouse is ranked 10th in Cloud Data Warehouse with 16 reviews. BigQuery is rated 8.2, while Oracle Autonomous Data Warehouse is rated 8.6. The top reviewer of BigQuery writes "Expandable and easy to set up but needs more local data residency". On the other hand, the top reviewer of Oracle Autonomous Data Warehouse writes "A tool for data warehousing that offers scalability, stability, and ease of setup". BigQuery is most compared with Snowflake, Teradata, Vertica, Apache Hadoop and AWS Lake Formation, whereas Oracle Autonomous Data Warehouse is most compared with Oracle Exadata, Snowflake, Microsoft Azure Synapse Analytics, Amazon Redshift and Teradata. 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.