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."
"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."
"It accelerates query processing, which in turn speeds up operations and streamlines workflow, and ultimately enhancing productivity."
"I like Oracle because it is a backward-compatible solution."
"The most valuable aspects of this solution are the fast caching and improved performance to the database"
"The product offers high scalability."
"The application development is very user-friendly."
"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."
"Speed and resiliency are probably the best parts of this product."
"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."
"Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams. "
"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."
"It has improved my organization's functionality and performance."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"The most valuable feature of Vertica is the unmatchable database performance."
"Vertica has a few features that I like. From an architecture standpoint, they have separated compute and storage. So you have low-cost object storage for primary storage and the ability to have several sub-clusters working off the same ObjectStore. So it provides workload isolation."
"Oracle Database In-Memory appliance-based solutions can be restrictive for some applications, as they may require more flexibility in the database design to be tuned and sized to the customer's needs."
"The platform’s pricing needs improvement."
"We often have to find solutions on our own through the support site, so there's room for improvement in this regard."
"They should lower the price. My customers think that it's too expensive."
"We use some partitions in In-Memory. We have a very large table and a low dose. It is very expensive in data to load all of them into In-Memory. It takes up more memory slots in the server, as well as a lot of RAM. We use last partitions on the table. We always need to create a script and make a schedule that can load a last partition in In-Memory. Oracle doesn't have features to do this automatically. I would like them to allow us to load last partitions, as well as other table partitions, in In-Memory. I think a good feature would do that automatically, letting you see a table, load a large partition, and monitor loading memory. It's quite a good feature."
"They should improve the solution's scalability for large databases."
"The high cost of the product is an area of concern where improvements are required."
"The pricing could be improved. It would ideal if it was more reasonable."
"I have found that coding support could be simplified."
"It needs integration with multiple clouds."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"Suboptimal projection design causes queries to not scale linearly."
"They could improve on customer service."
"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."
"Support is an area where it could get better."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
Oracle Database In-Memory is ranked 2nd in Embedded Database with 27 reviews while Vertica is ranked 4th in Data Warehouse with 83 reviews. Oracle Database In-Memory is rated 8.8, while Vertica is rated 8.2. 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, IBM Db2 Database, Progress OpenEdge RDBMS, SQL Server and Apache Derby, 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.