We performed a comparison between kdb+ 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."The solution returns data quickly, and data retrieval is fast in kdb+."
"The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."
"I don't need any special hardware. I can use commodity hardware, which is nice to have in a commercial solution."
"Eighty percent of the ETL operations have improved since implementing this solution."
"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."
"The most valuable feature of Vertica is the ability to receive large aggregations at a very quick pace. The use case of subclusters is very good."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"I have found the solution to be scalable."
"I enjoy the cybersecurity and backup features."
"The solution should have a more user-friendly user interface."
"The integration of this solution with ODI could be improved."
"Limitations in group by projections is where I would like to see an improvement."
"Fact-to-fact joins on multi-billion record tables perform poorly."
"The geospatial functionality could be designed better."
"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."
"In my opinion, Vertica's documentation could be improved. Currently, there is not enough documentation available to gain a comprehensive understanding of the platform."
"It should provide a GUI interface for data management and tuning."
"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."
kdb+ is ranked 19th in Relational Databases Tools with 1 review while Vertica is ranked 4th in Data Warehouse with 82 reviews. kdb+ is rated 9.0, while Vertica is rated 8.4. The top reviewer of kdb+ writes "An easy-to-deploy solution that can be used for data ingestion and usage". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". kdb+ is most compared with Oracle Database In-Memory, MariaDB, SingleStore and SQL Server, 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.