We performed a comparison between Oracle Exadata, TIBCO Live Datamart, and Vertica based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse."The storage capacity and the performance of Oracle Exadata are good. When comparing the performance to other technologies it is very good. I am satisfied with the management of the solution."
"Before using this machine, we took no less than two days to run a report. Now, we can do it within five hours. So, there is a lot of improvement."
"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."
"We have used this solution for a long period of time so it has become easy for us to query any kind of data from Oracle Exadata which has been valuable."
"It has improved the performance, now we run with more performance cores with less CPU to attend all the database demands. Reducing Time to Market, increase our ability to face the competition with speed and low cost."
"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 offloading of data to the SIM is a valuable feature."
"Parallelism is the most valuable feature."
"You can create your own rules that include mathematic calculations."
"The solution has a powerful aggregating feature"
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"The feature I like best is performance. We use Red Tool and Red Job for the data warehouse and reporting. It's perfect. Performance is good, and it can return ad hoc queries very quickly. Of course, it's a cluster, so it's easy to scale."
"It maximize cloud economics for mission-critical big data analytical initiatives."
"Bulk loads, batch loads, and micro-batch loads have made it possible for our organization to process near real-time ingestions and faster analytics."
"It's the fastest database I have ever tested. That's the most important feature of Vertica."
"It has improved my organization's functionality and performance."
"The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."
"I appreciate the flexibility offered by Vertica's projections. It allows for modifying the primary projection without altering the tables, which helps to optimize queries without the need to modify the underlying data."
"We have a little trepidation with the system as it does have a learning curve. Also changing to a binary logging format for us feels like retrograde motion, but sadly almost all Linux variants have moved in this direction."
"The scalability can be improved as it is not a parallel execution."
"Exadata would be improved with single dashboard visibility."
"Oracle Exadata could improve by having faster data retrieval. We receive data at four or five seconds and want to reduce that number to one second."
"We had issues with system restoration."
"Oracle Exadata could improve the monitoring system in the enterprise manager, it could be more user-friendly. In most Oracle tools there is a lot of functionality, and sometimes you need to do five or six clicks to find metrics, and sometimes it's a waste of time."
"Setting up Exadata is complex. You need an Oracle vendor or someone who is Oracle-certified to set it up."
"License or upgrade management can be difficult and time consuming because it requires login to a separate console."
"Improvements need to be made on the load balancing side."
"The solution's setup could be quicker and easier."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"The documentation of Vertica is an area with shortcomings where improvements are required."
"There are a lot of limitations within this product and it makes things extremely hard for developers. It lacks Stored Procedure, packages, and triggers like other RDBMs."
"In a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics."
"It should provide a GUI interface for data management and tuning."
"The geospatial functionality could be designed better."
"Vertica offers a platform-as-a-service version, but their software-as-a-service solution is only available on AWS. They need to get a SaaS version on Azure and GCP as fast as possible."
"It needs integration with multiple clouds."