We performed a comparison between Oracle Java DB and Vertica based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools."It has a programming language so anything that we require for Selenium is all available there."
"The additional value of having Java inside the Oracle database is all the security that is applied to an Oracle database will be enforced on Java's stored procedures as well."
"It's very clever."
"There have been no issues in relation to stability. We've never really had do to any recoveries. It is very stable."
"The solution is stable."
"The most valuable feature is automation."
"Able to write queries more efficiently and the management of data has become better and easier."
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"Vertica is a great product because customers can compress and code data. The infrastructure that data warehouse solutions need is a commodity server so that customers don't have to invest in infrastructure."
"The hardware usage and speed has been the most valuable feature of this solution. It is very fast and has saved us a lot of money."
"It's the fastest database I have ever tested. That's the most important feature of Vertica."
"We are also opening new areas of business and potential new revenue streams using Vertica's analytic functions, most notably geospatial, where we are able to run billions of comparisons of lat/long point locations against polygon and point/radius locations in seconds. "
"I have found the solution to be scalable."
"I like the projection feature, which increases query performance."
"The most valuable feature of Vertica is the unmatchable database performance."
"The biggest lesson that I have learned from using Oracle products is vendor lock-in."
"In terms of improvement, I'd like an automation tool that is lower priced. The core prices are very high."
"Needs improvement in consistency issues with respect to timeframes."
"The solution could be more user-friendly."
"It'll be better if Oracle Java supports open source technologies, like Node.js."
"The solution should continue to keep updating and improving the Java language."
"The biggest problem is the cost of cloud deployment."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"The integration of this solution with ODI could be improved."
"I have found that coding support could be simplified."
"Suboptimal projection design causes queries to not scale linearly."
"The documentation of Vertica is an area with shortcomings where improvements are required."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"In a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics."
Oracle Java DB is ranked 23rd in Relational Databases Tools with 7 reviews while Vertica is ranked 4th in Data Warehouse with 83 reviews. Oracle Java DB is rated 8.2, while Vertica is rated 8.2. The top reviewer of Oracle Java DB writes "Ability to handle large volumes and data sets but could be more user-friendly". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". Oracle Java DB is most compared with MySQL, Oracle Database, SQL Server, SAP HANA and Apache Derby, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and Oracle Exadata.
We monitor all Relational Databases Tools 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.