We performed a comparison between Oracle Database In-Memory and Vertica based on real PeerSpot user reviews.
Find out what your peers are saying about SAP, Oracle, Firebird and others in Embedded Database."We can integrate it with any data sources as well."
"The solution's ROI is excellent."
"The most valuable aspects of this solution are the fast caching and improved performance to the database"
"The on-premise version is stable. We have different teams and resources for the server side, for admin, and for development. We can easily take care of all the services and applications."
"Oracle Database In-Memory is a suite of features that improves performance for real-time analytics and mixed workloads."
"I like Oracle because it is a backward-compatible solution."
"The solution is very fast."
"Normally, every database server uses hard disks. In-Memory has a feature, apart from their database, which is very good. When we start our server, all your data needs loading memory. We can use that. It's a very good feature. I think they added this feature in 2019. We can mount memory in the partition, create partitions in there, and create table space from that spot to share. It's a really good feature. We use it a lot."
"Any novice user can tune vertical queries with minimal training (or no training at all)."
"The most valuable feature is Vertica's performance and the ease of using the database."
"We are able to integrate our Vertica data warehouse with Tableau to create numerous reports quickly and efficiently."
"The fast columnar store database structure allows our query times to be at least 10x faster than on any other database."
"It's the fastest database I have ever tested. That's the most important feature of Vertica."
"The extensibility and efficiency provided by their C++ SDK."
"Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams. "
"The feature of the product that is most important is the speed. I needed a columnar database, and its speed is what it's built to do, and so that's what really does differentiate Vertica from its competitors."
"The pricing could be improved. It would ideal if it was more reasonable."
"The query optimization and backup features should be added."
"The high cost of the product is an area of concern where improvements are required."
"Technical support is below our expectations currently. It could be improved."
"The solution should move to the new way of writing software code with AI that is intelligent and learns."
"Oracle should include column store or advanced query optimization so a database can be optimized by enabling analytic queries to run faster."
"They should improve the solution's scalability for large databases."
"They should lower the price. My customers think that it's too expensive."
"They could improve on customer service."
"The documentation of Vertica is an area with shortcomings where improvements are required."
"Suboptimal projection design causes queries to not scale linearly."
"I have found that coding support could be simplified."
"Promotion/marketing must be improved, even though it is a very useful product at very good price, it is not as "popular" as it should be."
"They could improve the integration and some of the features in the cloud version."
"I believe the installation process could be streamlined."
"I think they need an easy client so that you can write queries easily, but it's not necessarily a weak point. I think some users would need them."
Oracle Database In-Memory is ranked 2nd in Embedded Database with 27 reviews while Vertica is ranked 4th in Data Warehouse with 82 reviews. Oracle Database In-Memory is rated 8.8, while Vertica is rated 8.4. The top reviewer of Oracle Database In-Memory writes "User friendly with great scalability but needs to move toward intelligent AI". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". Oracle Database In-Memory is most compared with SAP HANA, Progress OpenEdge RDBMS, IBM Db2 Database, SQL Server and MariaDB, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and Oracle Exadata.
We monitor all Embedded Database 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.