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."The application development is very user-friendly."
"The most valuable feature is that Database-In-Memory is more consistent and faster than traditional databases as it requires fewer CPUs to process instructions."
"It efficiently handles low-code data and supports read-and-write operations for clustering."
"The scalability is very good."
"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."
"I like Oracle because it is a backward-compatible solution."
"Oracle Database In-Memory is a suite of features that improves performance for real-time analytics and mixed workloads."
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"It has improved my organization's functionality and performance."
"Vertica is a columnar database where the query performance is extremely fast and it can be used for real-time integrations for API and other applications. The solution requires zero maintenance which is helpful."
"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."
"DBAs don’t need to add a partition every month/quarter like with other DBs."
"Allows us to take volumes and process them at a very high speed."
"It maximize cloud economics for mission-critical big data analytical initiatives."
"The fast columnar store database structure allows our query times to be at least 10x faster than on any other database."
"Oracle should include column store or advanced query optimization so a database can be optimized by enabling analytic queries to run faster."
"The pricing could be improved. It would ideal if it was more reasonable."
"Technical support is below our expectations currently. It could be improved."
"The platform’s pricing needs improvement."
"The solution should move to the new way of writing software code with AI that is intelligent and learns."
"The query optimization and backup features should be added."
"Lacks sufficient integration with other tools."
"The solution is quite expensive."
"Vertica seems to scale well, except for one use case where you are on a multi-node cluster. For example, if you had a nine-node cluster, one node goes down, then the eight nodes don't scale, because the absence of the node is very apparent, which is a problem. If you have nine nodes or multiple nodes, the whole idea is that if one of those nodes goes down, then you should not see an impact on the system if you have enough capacity. Even though we have enough capacity, you can still see the impact of the one node going down."
"They could improve on customer service."
"They could improve the integration and some of the features in the cloud version."
"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."
"Documentation has become much better, but can always use some improvement."
"I believe the installation process could be streamlined."
"In a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics."
"Limitations in group by projections is where I would like to see an improvement."
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, 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.