IT Central Station is now PeerSpot: Here's why

Oracle Exadata vs Snowflake comparison

Cancel
You must select at least 2 products to compare!
Oracle Logo
14,535 views|11,122 comparisons
Snowflake Computing Logo
38,560 views|28,984 comparisons
Featured Review
Buyer's Guide
Oracle Exadata vs. Snowflake
May 2022
Find out what your peers are saying about Oracle Exadata vs. Snowflake and other solutions. Updated: May 2022.
607,332 professionals have used our research since 2012.
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"We can use virtualization on Exadata.""The business intelligence is very good.""Oracle Exadata is stable.""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.""The data replication is very good.""This product can noticeably enhance performance of contextual Oracle databases.""The most valuable feature is the time to solution.""Our machine is used for our internal development of Oracle-based solutions, PoC benchmarking, and training/familiarization."

More Oracle Exadata Pros →

"It was relatively easy to use, and it was easy for people to convert to it.""The querying speed is fast.""The technical support on offer is excellent.""The Time Travel feature is helpful for accessing historical data and the ability to clone external tables is useful.""It is a very good platform. It can handle structured and semi-structured data, and it can be used for your data warehouse or data lake. It can load and deal with any data that you have. It can extract data from an on-premises database or a website and make it available in the cloud. It has very fast implementation and integration as compared to other solutions. There is no need for the DBA to manage or do the day-to-day DBA tasks, which is one of the greatest things about it.""The initial setup is very simple.""Snowflake's most valuable features are data enrichment and flattening.""The most valuable features of Snowflake are its performance and power."

More Snowflake Pros →

Cons
"Tech support sometimes takes some time to identify and rectify issues.""I believe Oracle must improve its procedure to support the clients. The customer Ready Service must provide more use cases and benchmarks of their infrastructure to support client design decisions. Oracle must audit their partners regularly to guarantee they provide quality service even after been passed on partnership examination.""There is room for improvement with the handling of the Temp IO, which is often used for JOIN statements.""Oracle Exadata could improve the platform performance tuning should be easier, automated, and user-friendly.""There is a feature for security, but it is not included in the first purchase of this solution. That means if you need to increase the security, you need to buy the security feature which doesn't come by default on these solutions.""The integration with third-party applications regarding access management security could be better.""Setting up Exadata is complex. You need an Oracle vendor or someone who is Oracle-certified to set it up.""There is one aspect to Exadata that I dislike, and that's the inconsistency with other databases. When you try to get Exadata to function with another type of database like SQL, or others, there should be reliable and consistent operation. When this is improved on, we should start to see more applications growing the market."

More Oracle Exadata Cons →

"There are three things that came to my notice. I am not very sure whether they have already done it. The first one is very specific to the virtual data warehouse. Snowflake might want to offer industry-specific models for the data warehouse. Snowflake is a very strong product with credit. For a typical retail industry, such as the pharma industry, if it can get into the functional space as well, it will be a big shot in their arm. The second thing is related to the migration from other data warehouses to Snowflake. They can make the migration a little bit more seamless and easy. It should be compatible, well-structured, and well-governed. Many enterprises have huge impetus and urgency to move to Snowflake from their existing data warehouse, so, naturally, this is an area that is critical. The third thing is related to the capability of dealing with relational and dimensional structures. It is not that friendly with relational structures. Snowflake is more friendly with the dimensional structure or the data masks, which is characteristic of a Kimball model. It is very difficult to be savvy and friendly with both structures because these structures are different and address different kinds of needs. One is manipulation-heavy, and the other one is read-heavy or analysis-heavy. One is for heavy or frequent changes and amendments, and the other one is for frequent reads. One is flat, and the other one is distributed. There are fundamental differences between these two structures. If I were to consider Snowflake as a silver bullet, it should be equally savvy on both ends, which I don't think is the case. Maybe the product has grown and scaled up from where it was.""It would be better if they had a data profile tool that tells me where the gaps are in my time series data.""They should improve the reporting tools.""Pricing is an issue for many customers.""There is a scope for improvement. They don't currently support integration with some of the Azure and AWS native services. It would be good if they can enhance their product to integrate with these services.""They need to improve its ETL functionality so that Snowflake becomes an ETL product. Snowpipe can do some pipelines and data ingestion, but as compare to Talend, these functionalities are limited. The ETL feature is not good enough. Therefore, Snowflake can only be used as a database. You can't use it as an ETL tool, which is a limitation. We have spoken to the vendor, and they said they are working on it, but I'm not sure when they will bring it to production.""Their strategy is just to leverage what you've got and put Snowflake in the middle. It does work well with other tools. You have to buy a separate reporting tool and a separate data loading tool, whereas, in some platforms, these tools are baked in. In the long-term, they'll need to add more direct partnerships to the ecosystem so that it's not like adding on tools around Snowflake to make it work. They can also consider including Snowflake native reporting tools versus partnering with other reporting tools. It would kind of change where they sit in the market.""The data sharing capabilities across business units within the organization should be better."

More Snowflake Cons →

Pricing and Cost Advice
  • "Oracle is always costly but it's fine."
  • "It is an expensive product and you pay more for certain performance enhancements."
  • "All things considered, the price of this product is fairly high, as is always the case with Oracle."
  • "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 licensing can be a bit expensive because you need to have certain tools enabled that require them."
  • "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."
  • "The price of the solution has been expensive to implement."
  • "The cost of the product could be improved."
  • More Oracle Exadata Pricing and Cost Advice →

  • "The pricing for Snowflake is competitive."
  • "On average, with the number of queries that we run, we pay approximately $200 USD per month."
  • "Pricing is approximately $US 50 per DB. Terabyte is around $US 50 per month."
  • "The price of Snowflake is very reasonable."
  • "The price of Snowflake is quite reasonable."
  • "Its price should be improved. It should be cheaper than Microsoft."
  • "It is per credit. It has a use-it-as-you-go model. We bought a chunk of 20,000 credits, and they were lasting us for at least a year. We didn't have the scale of data like a much larger company to consume more credits. For us, it was very inexpensive. Their strategy is just to leverage what you've got and put Snowflake in the middle. It doesn't make it expensive because most of the organizations already have reporting tools. Now, if you were starting from scratch, it might be cheaper to go a different way."
  • "We used Snowflake to see if it is cheaper than using BigQuery. It was just to maintain the cost or the KPI regarding the cost of connectivity by users. Snowflake wasn't cheaper than BigQuery, and its affordability was the main issue."
  • More Snowflake Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
    607,332 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:The most valuable feature of Oracle Exadata is its capabilities for storing and processing data. It is very good for our domain.
    Top Answer:There is an annual license to use this solution. The solution is expensive. I rate the price of Oracle Exadata a three out of five.
    Top Answer:Oracle Exadata could improve the platform performance tuning should be easier, automated, and user-friendly. In a future release, I would like to have new analytical capabilities.
    Top Answer:This is the advanced version of the cloud version, so it's really a flexible tool. If you have it implemented at home, you can access it from anywhere.
    Top Answer:The pricing is fair for all the features that Snowflake is providing. The way Snowflake has emerged in the past few years is impressive. It was just a beginner in the space, and it has become a leader… more »
    Top Answer:Sometimes when I'm trying to refresh the data, my different application or tool has to connect to its backend database through the connection I create. Sometimes, I face some issues like not having… more »
    Ranking
    2nd
    out of 30 in Data Warehouse
    Views
    14,535
    Comparisons
    11,122
    Reviews
    22
    Average Words per Review
    583
    Rating
    8.8
    1st
    out of 30 in Data Warehouse
    Views
    38,560
    Comparisons
    28,984
    Reviews
    49
    Average Words per Review
    566
    Rating
    8.4
    Comparisons
    Also Known As
    Snowflake Computing
    Learn More
    Overview

    Oracle Exadata Database Machine is a modern framework, engineered to run databases and to scale database servers. Oracle Exadata Database Machine can be run on the cloud or on premises.

    The main benefit of Exadata is its speed. It hosts operating systems, CPU memory, and hard drives. It runs all types of databases, including online transaction systems, processors, and data warehouses, while remedying the poor performances of older databases.

    Oracle Exadata Database Machine features a simple and fast database storage system that protects and backs up your critical data. It accelerates data warehouse performance for faster access to business information and data. It is the ideal database solution for companies looking to build up their infrastructure from scratch.

    Oracle Exadata Database Machine Key Benefits

    • Rapid, reliable, and scalable deployment: Exadata Database Machine is the most cost-efficient and highest performance platform for running Oracle databases. Exadata’s deployment is very straightforward since the database servers, storage servers, and network are pre-configured, pre-tuned and pre-tested by Oracle experts. This ensures that all your components work seamlessly together. Any Oracle Database application can be seamlessly migrated to and from the Exadata Database Machine, with no changes to the original application.

    • Powerful, cutting-edge hardware: Exadata Database Machine is the most versatile database platform. It uses powerful database servers and a scaled-out, intelligent storage layer.

    • Accelerate database processing: Exadata Storage Server implements a unique, highly efficient database-optimized storage infrastructure that enables Exadata’s unparalleled performance without any of the bottlenecks that traditional storage experiences. Each storage server contains CPU processors that are used to offload database processing. The CPUs in the storage servers do not replace database CPUs, but work alongside them to accelerate database workloads.

    Reviews from Real Users

    Oracle Exadata Database Machine stands out among its competitors for a number of reasons. Two major ones are its robust performance and its wide variety of database features that make it a comprehensive database solution.

    Adriano S., an IT system integrator at a financial services firm, writes, "Oracle Exadata's performance is one of its best features. We are very satisfied with it. The previous equipment used to make a payment for all the government employees used to take at least two days for some of the transactions. Now, it will take hours to make the same amount of payments. Another thing is the flexibility to organize all our databases. We can use it with new features that come with this version of Oracle 19c, which is the container database. With container databases, we can work with many databases, organized, and segregated, and still access the functions and management, the things that most of the technical people like to have in place."

    Paulo X., a sales manager at LTA-RH Informatica, notes, "Regarding features, there are so many that we can offer to customers. When we sell Exadata Cloud, there are many options to choose from, especially when it comes to enterprise database options. In my experience, the main features that are appreciated are various ones like GPS and the assortment of security options."

    Snowflake is a fully managed SaaS (software as a service) that provides a single platform for data warehousing, data lakes, data engineering, data science, data application development, and secure sharing and consumption of real-time / shared data.

    Its platform is made up of three components:

    1. Cloud services: As part of its cloud services, Snowflake uses ANSI SQL, which empowers users to optimize their data and manage their infrastructure, while Snowflake handles the security and encryption of stored data.
    1. Query processing: With Snowflake, workload concurrency is never a problem because its compute layer is made up of virtual cloud data warehouses that let you analyze data through requests. Each of the warehouses do not compete for computing resources nor do they affect the performance of each other.
    1. Database storage: Snowflake manages all parts of the data storage process automatically, including file size, compression, organization, structure, and metadata, as well as statistics.

    Snowflake Features

    Snowflake has many valuable key features. Some of the most useful ones include:

    • Scalability: Snowflake architecture provides nearly unlimited scalability and high speed because it uses a single elastic performance engine. The solution also supports an unlimited amount of concurrent users and workloads, from interactive to batch.
    • Automation: Snowflake makes automation easy and enables enterprises to automate data management, security, governance, availability, and data resiliency.
    • Seamless cross-cloud and cross-region connections: With seamless cross-cloud and cross-region connections, Snowflake eliminates ETL and data silos. Anyone who needs access to shared secure data can get a single copy via the data cloud. In addition, Snowflake makes remote collaboration and decision-making fast and easy via a single shared data source.
    • Third-party data integrations: Snowflake’s Data Marketplace offers third-party data which allows you to connect with Snowflake customers to extend workflows with data services and third-party applications.

    Snowflake Benefits

    There are many benefits to implementing Snowflake. Some of the biggest advantages the solution offers include:

    • Helps optimize costs
    • Reduces downtime
    • Improves operational efficiency
    • Built for high reliability and availability
    • Automates data replication for fast recovery

    Reviews from Real Users

    Below are some reviews and helpful feedback written by PeerSpot users currently using the Snowflake solution.

    Sreenivasan R., Director of Data Architecture and Engineering at Decision Minds, says, "Data sharing is a good feature. It is a majorly used feature. The elastic compute is another big feature. Separating compute and storage gives you flexibility. It doesn't require much DBA involvement because it doesn't need any performance tuning. We are not really doing any performance tuning, and the entire burden of performance tuning and SQL tuning is on Snowflake. Its usability is very good. I don't need to ramp up any user, and its onboarding is easier. You just onboard the user, and you are done with it. There are simple SQL and UI, and people are able to use this solution easily. Ease of use is a big thing in Snowflake."

    A director of business operations at a logistics company mentions, "It requires no maintenance on our part. They handle all that. The speed is phenomenal. The pricing isn't really anything more than what you would be paying for a SQL server license or another tool to execute the same thing. We have zero maintenance on our side to do anything and the speed at which it performs queries and loads the data is amazing. It handles unstructured data extremely well, too. So, if the data is in a JSON array or an XML, it handles that super well."

    A Solution Architect at a wholesaler/distributor comments, "The ability to share the data and the ability to scale up and down easily are the most valuable features. The concept of data sharing and data plumbing made it very easy to provide and share data. The ability to refresh your Dev or QA just by doing a clone is also valuable. It has the dynamic scale up and scale down feature. Development and deployment are much easier as compared to other platforms where you have to go through a lot of stuff. With a tool like DBT, you can do modeling and transformation within a single tool and deploy to Snowflake. It provides continuous deployment and continuous integration abilities. There is a separation of storage and compute, so you only get charged for your usage. You only pay for what you use. When we share the data downstream with business partners, we can specifically create compute for them, and we can charge back the business."

    Offer
    Learn more about Oracle Exadata
    Learn more about Snowflake
    Sample Customers
    PayPal, EBS, Organic Food Retailer, Garmin, University of Minnesota, Major Semiconductor Company, Deutsche Bank, Starwood, Ziraat Bank, SK Telecom, and P&G.
    Accordant Media, Adobe, Kixeye Inc., Revana, SOASTA, White Ops
    Top Industries
    REVIEWERS
    Financial Services Firm27%
    Comms Service Provider14%
    Insurance Company14%
    Retailer9%
    VISITORS READING REVIEWS
    Computer Software Company34%
    Financial Services Firm15%
    Comms Service Provider13%
    Government5%
    REVIEWERS
    Computer Software Company39%
    Financial Services Firm12%
    Manufacturing Company9%
    Comms Service Provider6%
    VISITORS READING REVIEWS
    Computer Software Company26%
    Comms Service Provider13%
    Financial Services Firm10%
    Insurance Company6%
    Company Size
    REVIEWERS
    Small Business28%
    Midsize Enterprise12%
    Large Enterprise61%
    VISITORS READING REVIEWS
    Small Business11%
    Midsize Enterprise11%
    Large Enterprise78%
    REVIEWERS
    Small Business24%
    Midsize Enterprise23%
    Large Enterprise53%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise14%
    Large Enterprise70%
    Buyer's Guide
    Oracle Exadata vs. Snowflake
    May 2022
    Find out what your peers are saying about Oracle Exadata vs. Snowflake and other solutions. Updated: May 2022.
    607,332 professionals have used our research since 2012.

    Oracle Exadata is ranked 2nd in Data Warehouse with 22 reviews while Snowflake is ranked 1st in Data Warehouse with 49 reviews. Oracle Exadata is rated 8.8, while Snowflake is rated 8.4. The top reviewer of Oracle Exadata writes "High performing and reliable work environment". On the other hand, the top reviewer of Snowflake writes "Good usability, good data sharing and elastic compute features, and requires less DBA involvement". Oracle Exadata is most compared with Teradata, Oracle Database Appliance, Amazon Redshift, Oracle Autonomous Data Warehouse and IBM Netezza Performance Server, whereas Snowflake is most compared with Microsoft Azure Synapse Analytics, Amazon Redshift, Vertica, AWS Lake Formation and Azure Data Factory. See our Oracle Exadata vs. Snowflake report.

    See our list of best Data Warehouse vendors.

    We monitor all 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.