Oracle Autonomous Database vs. Snowflake vs. Vertica Analytics Database

Pro - Stability. Does everything anyone could need. If it's not there it will be on the next update. There is plenty of support for it. It's been around for a long time and it's reliable. The support is well documented and has a great reputation. Cons - Errors have been found in the documentation provided by Oracle with guidelines, etc. Oracles salespeople have a reputation of being obnoxious and condescending.

Incentivized

Snowflake is well suited when you have to store your data and you want easy scalability and increase or decrease the storage per your requirement. You can also control the computing cost, and if your computing cost is less than or equal to 10% of your storage cost, then you don't have to pay for computing, which makes it cost-effective as well.

Incentivized

Vertica as a data warehouse to deliver analytics in-house and even to your client base on scale is not rivaled anywhere in the market. Frankly, in my experience it is not even close to equaled. Because it is such a powerful data warehouse, some people attempt to use it as a transactional database. It certainly is not one of those. Individual row inserts are slow and do not perform well. Deletes are a whole other story. RDBMS it is definitely not. OLAP it rocks.

Incentivized

• Robust - this product doesn't have a lot of downtime. It's less prone to errors than some other tools I've worked with.
• Scalable - we can keep adding more things to it. We haven't hit any roadblocks when we've tried to do more with our database.

Incentivized

• Snowflake scales appropriately allowing you to manage expense for peak and off peak times for pulling and data retrieval and data centric processing jobs
• Snowflake offers a marketplace solution that allows you to sell and subscribe to different data sources
• Snowflake manages concurrency better in our trials than other premium competitors
• Snowflake has little to no setup and ramp up time
• Snowflake offers online training for various employee types

Incentivized

• Extremely fast query performance - Vertica is one of the fastest query engines out there.
• Scales to TBs - Scales reasonably well up to 10-20 nodes and 10 - 100s of TB of data.
• Easy to Use - Fairly easy to user, we made quite some headway with just 1 person running it for a while.

Incentivized

• There is no access to the physical host of the DB. This is expected from a managed DB. Everything must be done through the console or via API calls. This is a new learning curve for the DBAs.
• Due to the lack of physical host access, certain features are not supported, such as Transportable tablespaces and Oracle LogMiner.
• Certain special data types, (such as XMLType) are not allowed; be sure the app vendor certifies their product on this platform.

Incentivized

• Add constraints for views and not just for tables
• Do not force customers to renew for same or higher amount to avoid loosing unused credits. Already paid credits should not expire (at least within a reasonable time frame), independent of renewal deal size.

Incentivized

• Could use some work on better integrating with cloud providers and open source technologies. For AWS you will find an AMI in the marketplace and recently a connector for loading data from S3 directly was created. With last release, integration with Kafka was added that can help.
• Managing large workloads (concurrent queries) is a bit challenging.
• Having a way to provide an estimate on the duration for currently executing queries / etc. can be helpful. Vertica provides some counters for the query execution engine that are helpful but some may find confusing.
• Unloading data over JDBC is very slow. We've had to come up with alternatives based on vsql, etc. Not a very clean, official on how to unload data.

Incentivized

Because it does exactly what we need: it enables us to manage our development and testing database environments in a quick and simple way without requiring support from a database administrators team.

Incentivized

SnowFlake is very cost effective and we also like the fact we can stop, start and spin up additional processing engines as we need to. We also like the fact that it's easy to connect our SQL IDEs to Snowflake and write our queries in the environment that we are used to

Incentivized

The product is continuously evolving and new features are added frequently. Management options through the OCI (Oracle Cloud Infrastructure) console and through the command line and API are being enhanced frequently.

Incentivized

Because the fact that you can query tons of data in a few seconds is incredible, it also gives you a lot of functions to format and transform data right in your query, which is ideal when building data models in BI tools like Power BI, it is available as a connector in the most used BI tools worldwide.

Incentivized

We have had terrific experiences with Snowflake support. They have drilled into queries and given us tremendous detail and helpful answers. In one case they even figured out how a particular product was interacting with Snowflake, via its queries, and gave us detail to go back to that product's vendor because the Snowflake support team identified a fault in its operation. We got it solved without lots of back-and-forth or finger-pointing because the Snowflake team gave such detailed information.

Incentivized

I haven't had any recent opportunity to reach out to Vertica support. From what I remember, I believe whenever I reached out to them the experience was smooth.

Incentivized

I found Oracle Autonomous Database very secure to store data and private information.I always feel secure with Oracle Autonomous Databases disaster recovery features.It is very effective to build applications for mobile and desktop devices lesser code using a low code development framework namely Oracle Application Express (ApEx).

Incentivized

I have had the experience of using one more database management system at my previous workplace. What Snowflake provides is better user-friendly consoles, suggestions while writing a query, ease of access to connect to various BI platforms to analyze, [and a] more robust system to store a large amount of data. All these functionalities give the better edge to Snowflake.

Incentivized

Vertica performs well when the query has good stats and is tuned well. Options for GUI clients are ugly and outdated. IO optimized: it's a columnar store with no indexing structures to maintain like traditional databases. The indexing is achieved by storing the data sorted on disk, which itself is run transparently as a background process.

Incentivized

• Oracle Autonomous Database has a wide range of warehouses, which is competent and of high performance.
• The transactional processing power that Oracle Autonomous Database outlines are completely important and digital.
• The efficiency of Oracle Autonomous Database data encryption fosters security measures, a form that demands more threat detectors.

Incentivized

• With separate compute and storage feature, the queries get executed quickly and it improves our overall productivity.
• Earlier we were using a different product for analytical purposes, but with Snowflake's in-built analytical feature we are now able to save money.
• Snowflake is cost efficient, features like auto suspend for compute resources helped to control the costs.

Incentivized

• Positive impact on ROI by being able to get customer insights in real-time.
• Positive ROI through reduced time to set-up and maintain Vertica instances.

Incentivized