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

BigQuery vs Oracle Database Appliance comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

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

ROI

Sentiment score
8.6
Organizations saved costs and improved performance with BigQuery, achieving significant returns despite an initial learning period.
Sentiment score
7.1
Oracle Database Appliance offers long-term value with efficient support and quality, ensuring positive ROI despite variable setup complexity.
 

Customer Service

Sentiment score
7.1
Google BigQuery support is generally reliable and agile but lacks direct engagement compared to competitors like Teradata.
Sentiment score
6.2
Oracle Database Appliance customer service is generally solid but faces criticism for costs, response times, and mixed hardware service experiences.
rating the customer support at ten points out of ten
 

Scalability Issues

Sentiment score
7.9
BigQuery excels in scalability and performance for large operations but may be costly for smaller businesses.
Sentiment score
6.6
Oracle Database Appliance offers scalable CPU and storage options but faces limitations in on-premises scalability and storage scalability.
The scalability is definitely good because we are migrating to the cloud since the computers on the premises or the big database we need are no longer enough.
All enterprise-grade analytics tools allow rapid scaling, making our business more competitive.
 

Stability Issues

Sentiment score
8.5
BigQuery is praised for stability, reliability, and performance but has minor glitches with room for improvement in some areas.
Sentiment score
7.5
Oracle Database Appliance is praised for stability and performance, with minor issues resolved by support and high satisfaction ratings.
 

Room For Improvement

BigQuery's drawbacks include special character restrictions, high pricing, integration issues, and needed improvements in user interface and support.
Oracle Database Appliance requires improved scalability, flexibility, integration, and pricing, along with AI features and better support.
Troubleshooting requires opening each pipeline individually, which is time-consuming.
In general, if I know SQL and start playing around, it will start making sense.
There is room for improvement in better integration with third-party tools, such as Power BI or Redshift.
 

Setup Cost

BigQuery's pricing is flexible, based on usage, with low storage costs, and customizable to enterprise needs within Google Cloud.
Oracle Database Appliance is cost-effective for its value, but licensing and support can be expensive compared to alternatives.
The price is perceived as expensive, rated at eight out of ten in terms of costliness.
Oracle is on the higher end of the pricing spectrum, along with SAP.
 

Valuable Features

BigQuery provides scalable, fast, cost-effective data analytics with seamless GCP integration and supports complex queries and various data types.
Oracle Database Appliance offers easy deployment, scalability, high performance, and seamless integration, popular for data processing and application hosting.
It is really fast because it can process millions of rows in just a matter of one or two seconds.
BigQuery processes a substantial amount of data, whether in gigabytes or terabytes, swiftly producing desired data within one or two minutes.
The most valuable feature is the ease of dashboarding and ease of reporting.
 

Categories and Ranking

BigQuery
Average Rating
8.2
Reviews Sentiment
7.3
Number of Reviews
40
Ranking in other categories
Cloud Data Warehouse (4th)
Oracle Database Appliance
Average Rating
8.0
Reviews Sentiment
6.7
Number of Reviews
44
Ranking in other categories
Data Warehouse (6th)
 

Featured Reviews

VikashKumar1 - PeerSpot reviewer
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.
Charu Mazumdar - PeerSpot reviewer
Simplifies database management tasks and provides high availability and disaster recovery
Oracle Database Appliance has simplified our database management tasks. Our clients are using the solution for high availability and disaster recovery. Our overall experience with the solution was good, especially the DR. Oracle Database Appliance's integrated storage solutions have enhanced our data management. Oracle Database Appliance's integration with other solutions was straightforward. We faced compatibility issues while moving from another device to this one, and the integration was not seamless. I would recommend the solution to other users. Overall, I rate the solution an 8 out of 10.
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
848,207 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
18%
Financial Services Firm
14%
Manufacturing Company
11%
Retailer
8%
Financial Services Firm
29%
Computer Software Company
13%
Manufacturing Company
10%
Government
8%
 

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 price is perceived as expensive, rated at eight out of ten in terms of costliness. Still, it offers significant cost savings.
What needs improvement with BigQuery?
When I open many of the Google Cloud products, I am in an environment that I do not feel familiar with; it is a little overwhelming. In general, if I know SQL and start playing around, it will star...
What do you like most about Oracle Database Appliance?
Oracle Database Appliance provides high stability.
What is your experience regarding pricing and costs for Oracle Database Appliance?
While I'm somewhat familiar with standard licensing, pricing isn't really my area of expertise. However, Oracle is on the higher end of the pricing spectrum, along with SAP.
What needs improvement with Oracle Database Appliance?
There is room for improvement in better integration with third-party tools, such as Power BI or Redshift. When dealing with federated data sources, this integration can be a challenge.
 

Also Known As

No data available
X5-2
 

Overview

 

Sample Customers

Information Not Available
LifeLock, Incarlopsa, Al Yusur Industrial Contracting
Find out what your peers are saying about BigQuery vs. Oracle Database Appliance and other solutions. Updated: March 2025.
848,207 professionals have used our research since 2012.