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.3
Number of Reviews
38
Ranking in other categories
Cloud Data Warehouse (5th)
Oracle Exadata
Average Rating
8.6
Reviews Sentiment
6.8
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 feature called calibrating the capacity is valuable."
"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 most valuable aspect of BigQuery is its ability to handle high data workloads without causing friction with our online systems."
"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."
"There are some performance features like partitioning, which you can do based on an integer, and it improves the performance a lot."
"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."
"It's pretty stable. It's fast, and it is able to go through large quantities of data pretty quickly."
"A very stable solution, which we have hardly any problems with."
"The most valuable feature of Oracle Exadata is the storage available."
"Exadata is a fantastic machine. Two features stand out. The first is the resource input/output management tool that allows you to manage the resources to the neck on the Exadata box."
"The new Exadata x9m has an even higher speed of 100GBps connectivity."
"The most valuable feature of Oracle Exadata is its capabilities for storing and processing data. It is very good for our domain."
"What I like best about Oracle Exadata is its good performance. It's also a very fast solution."
"On-premises Exadata is just as stable as the cloud version. It's a very stable platform."
"Oracle has reliable solutions and this one is no different."
 

Cons

"BigQuery should integrate with other tools, such as Cloud Logging and Local Studio, to enhance its capabilities further and enable powerful and innovative analyses."
"I rate BigQuery six out of 10 for affordability. It could be cheaper."
"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."
"It would be helpful if they could provide some dashboards where you can easily view charts and information."
"It would be better if BigQuery didn't have huge restrictions. For example, when we migrate from on-premises to on-premise, the data which handles all ebook characters can be handled on-premise. But in BigQuery, we have huge restrictions. If we have some symbols, like a hash or other special characters, it won't accept them. Not in all cases, but it won't accept a few special characters, and when we migrate, we get errors. We need to use Regexp or something similar to replace that with another character. This isn't expected from a high-range technology like BigQuery. It has to adapt all products. For instance, if we have a TV Showroom, the TV symbol will be there in the shop name. Teradata and Apache Spark accept this, but BigQuery won't. This is the primary concern that we had. In the next release, it would be better if the query on the external table also had cache. Right now, we are using a GCS bucket, and in the native table, we have cache. For example, if we query the same table, it won't cost because it will try to fetch the records from the cached result. But when we run queries on the external table a number of times, it won't be cached. That's a major drawback of BigQuery. Only the native table has the cache option, and the external table doesn't. If there is an option to have an external table for cache purposes, it'll be a significant advantage for our organization."
"I would like to see version-based implementation and a fallback arrangement for data stored in BigQuery storage. These are some features I'm interested in."
"Sometimes, support specialists might not have enough experience or business understanding, which can be an issue."
"There are some limitations in the query latency compared to what it was three years ago."
"A room for improvement in Oracle Exadata is that it's not very easy to use in a microservices environment. It's not easy to split databases, and if this was easier to do in Oracle Exadata, it would make the solution better. What I'd like to see in the next release of Oracle Exadata is for it to become more modular, so you can use it in a context where the data layer is spread between many independent services."
"The solution lacks a visualized console."
"Patching must be simplified."
"The handling of temp space has room for improvement."
"We have experienced some issues with processing unstructured data on Exadata. This is an important requirement for our AIML based use case. Reactive analytics data can not be prepared easily in Oracle Exadata."
"Oracle Exadata compatibility with the analytics could be better and the OBIEE could improve. Oracle BI to Exadata needs to be improved. Even if the full analytics practice for Oracle should be improved and when compared with other solutions it is weak."
"The solution's pricing is very high."
"The performance could be improved."
 

Pricing and Cost Advice

"The platform is inexpensive."
"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."
"We are above the free threshold, so we are paying around 40 euros per month for BigQuery."
"The solution is pretty affordable and quite cheap in comparison to PDP or Cloudera."
"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 product’s pricing could be more flexible for end users."
"The product operates on a pay-for-use model. Costs include storage and query execution, which can accumulate based on data volume and complexity."
"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."
"Oracle is always costly but it's fine."
"There is an annual license to use this solution. The solution is expensive."
"The price of the solution has been expensive to implement."
"In the sizing phase, you can also decide whether to license all cores, or reduce the number cores using capacity-on-demand features of Exadata, as well. This has a direct impact on licensing."
"Our customers are always looking to reduce the license's cost."
"I give the pricing of the solution a five out of ten."
"Oracle Exadata is costly. Its licensing should also be more versatile. Smaller companies would benefit if Oracle Exadata had lower pricing."
"The price is very high."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
824,053 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
29%
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?
We are above the free threshold, so we are paying around 40 euros per month for BigQuery. It is generally low cost.
What needs improvement with BigQuery?
Sometimes, support specialists might not have enough experience or business understanding, which can be an issue. They might have basic knowledge but lack specific insights related to the specific ...
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: December 2024.
824,053 professionals have used our research since 2012.