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

BigQuery vs Oracle Exadata comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

BigQuery
Average Rating
8.2
Reviews Sentiment
7.6
Number of Reviews
35
Ranking in other categories
Cloud Data Warehouse (5th)
Oracle Exadata
Average Rating
8.6
Reviews Sentiment
7.3
Number of Reviews
126
Ranking in other categories
Data Warehouse (2nd)
 

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.
Guruprasad Gonjare - PeerSpot reviewer
Offers a variety of valuable features
The deployment depends on the Exadata options. There are primarily three options which include, Exadata, Exadata Cloud@Customer, and Exadata Cloud Service. Out of these, Cloud Service requires the minimum effort. The deployment takes around two to three weeks to complete. For the deployment purpose, we need information on the user base where the access is going to happen. We would also require around four to five engineers and admins for the solution’s deployment and maintenance. This estimation is based on the workflow.

Quotes from Members

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

Pros

"The solution's reporting, dashboard, and out-of-the-box capabilities match exactly our requirements."
"The query tool is scalable and allows for petabytes of data."
"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."
"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."
"The main thing I like about BigQuery is storage. We did an on-premise BigQuery migration with trillions of records. Usually, we have to deal with insufficient storage on-premises, but in BigQuery, we don't get that because it's like cloud storage, and we can have any number of records. That is one advantage. The next major advantage is the column length. We have some limits on column length on-premises, like 10,000, and we have to design it based on that. However, with BigQuery, we don't need to design the column length at all. It will expand or shrink based on the records it's getting. I can give you a real-life example based on our migration from on-premises to GCP. There was a dimension table with a general number of records, and when we queried that on-premises, like in Apache Spark or Teradata, it took around half an hour to get those records. In BigQuery, it was instant. As it's very fast, you can get it in two or three minutes. That was very helpful for our engineers. Usually, we have to run a query on-premises and go for a break while waiting for that query to give us the results. It's not the case with BigQuery because it instantly provides results when we run it. So, that makes the work fast, it helps a lot, and it helps save a lot of time. It also has a reasonable performance rate and smart tuning. Suppose we need to perform some joins, BigQuery has a smart tuning option, and it'll tune itself and tell us the best way a query can be done in the backend. To be frank, the performance, reliability, and everything else have improved, even the downtime. Usually, on-premise servers have some downtime, but as BigQuery is multiregional, we have storage in three different locations. So, downtime is also not getting impacted. For example, if the Atlantic ocean location has some downtime, or the server is down, we can use data that is stored in Africa or somewhere else. We have three or four storage locations, and that's the main advantage."
"What I like most about BigQuery is that it's fast and flexible. Another advantage of BigQuery is that it's easy to learn."
"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."
"The integrated data storage features are good."
"Oracle is known to be the number one in their industry; the help and support, the features they are giving the clients comparing to other databases, the new technology, the provide a good solution."
"Oracle Exadata is stable."
"A very stable solution, which we have hardly any problems with."
"The most valuable feature of Oracle Exadata is the integration with other solutions, such as SAN storage and shared VLAN network."
"It offers a significant advantage for accommodating a large number of users."
"Oracle is easy to use for peripheral things, such as the data vault and the data firewall, data sync, and partitions. These are the features that give an edge to other databases."
"Oracle Exadata's performance is one of its best features. We very satisfied with it."
"It is a highly relevant option with extreme performance."
 

Cons

"Some of the queries are complex and difficult to understand."
"The primary hurdle in this migration lies in the initial phase of moving substantial volumes of data to cloud-based platforms."
"For greater flexibility and ease of use, it would be beneficial if BigQuery offered more third-party add-ons and connectors, particularly for databases that don't have built-in integration options."
"Instead of connecting directly to BigQuery, we connect to GCP, Cloud Run, and then to BigQuery, which is a long process."
"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."
"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."
"The solution should reduce its pricing."
"The process of migrating from Datastore to BigQuery should be improved."
"We need a monitoring tool which can in one place, where we can manage, monitor the entire Exadata components."
"Oracle Exadata has room for improvement in pricing, especially for smaller companies. The solution is okay for bigger companies, but for smaller companies, it isn't."
"The solution lacks a visualized console."
"Checking the Smart Scan issues is complicated."
"I would like to add some features to run applications or microservices-based applications on Exadata."
"We had issues with system restoration."
"The analytics features must be improved."
"In a future release, I would like to see some upgrade analysis advisors to help with a clear roadmap on steps that need to be taken and some of the automated processes."
 

Pricing and Cost Advice

"The pricing is good and there are no additional costs involved."
"Its cost structure operates on a pay-as-you-go model."
"BigQuery is inexpensive."
"The pricing appears to be competitive for the intended usage scenarios we have in mind."
"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."
"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 solution's pricing is cheaper compared to other solutions."
"I would rate the tool's pricing a nine out of ten."
"All things considered, the price of this product is fairly high, as is always the case with Oracle."
"The price of Oracle Exadata is competitive. There are some features that are outside of the initial purchase license, such as some monitoring packages."
"The majority of our customers are in government or big enterprises, and the projects that we sell come out to several million USD. With this amount of money on the table, it's always better to have an experienced team of consultants, who know Exadata very well, handle the implementation."
"I did note that Oracle does tend to internally oversize things especially if they want to fill up a budget, and hence third-party oversight is essential."
"The price of the solution could improve, it is expensive."
"Oracle Exadata is costly. Its licensing should also be more versatile. Smaller companies would benefit if Oracle Exadata had lower pricing."
"We pay for an annual license and it is expensive."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
816,406 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%
Financial Services Firm
30%
Computer Software Company
13%
Manufacturing Company
6%
Government
5%
 

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?
The product operates on a pay-for-use model. Costs include storage and query execution, which can accumulate based on data volume and complexity.
What needs improvement with BigQuery?
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 dir...
What do you like most about Oracle Exadata?
It is the best solution for OLTP and data warehousing.
What is your experience regarding pricing and costs for Oracle Exadata?
The pricing of Exadata is high. It is more expensive than usual, making it suitable only for big enterprises or businesses that can afford it.
What needs improvement with Oracle Exadata?
I would like to add some features to run applications or microservices-based applications on Exadata.
 

Comparisons

 

Learn More

 

Overview

 

Sample Customers

Information Not Available
PayPal, EBS, Organic Food Retailer, Garmin, University of Minnesota, Major Semiconductor Company, Deutsche Bank, Starwood, Ziraat Bank, SK Telecom, and P&G.
Find out what your peers are saying about BigQuery vs. Oracle Exadata and other solutions. Updated: October 2024.
816,406 professionals have used our research since 2012.