Vertica by the Hour, Red Hat
Micro Focus | 12.0.0-0Linux/Unix, Red Hat Enterprise Linux 7.5 - 64-bit Amazon Machine Image (AMI)
External reviews
External reviews are not included in the AWS star rating for the product.
Superb experience
What do you like best?
Speed performance, user friendly. Very innovative way of handling complex data
What do you dislike?
No cons till now. Mainly users UI TO BE improved
What problems is the product solving and how is that benefiting you?
Procurement domain and banking domain. Trillions of data rows with complex business logivs
Recommendations to others considering the product:
Superb database
- Leave a Comment |
- Mark review as helpful
My Views on Vertica
What do you like best?
Performance and data reliability along with ease of architecture
What do you dislike?
while using on premise, extending or limiting to size and maintaining cleanups was bit hectic
What problems is the product solving and how is that benefiting you?
analysis and data to information.
aggregates, snowflake architecture
aggregates, snowflake architecture
Recommendations to others considering the product:
If someone wants high performance and much more analytical functions then one should go for vertica
Vertica Database is Easy to understand AS RDBMS
What do you like best?
Since it is columnar database, its different from RDBMS and its saving data as column fashion, so while reading data instead of reading row, it will read column and it will be faster while giving less IO on Disk
What do you dislike?
lack of HIgh concurrency, Vertica can improve in with its concurrency transaction.
What problems is the product solving and how is that benefiting you?
since its transaction happen in memory, its way faster than RDBMS DB.
Recommendations to others considering the product:
Since Vertica is the in memory columnar Database, read transaction for milion data fetch will be faster than Other RDBMS DB, mostly people will use this DB for productbase business.
Complete Value for money
What do you like best?
Supports a super fast information retrieval.
What do you dislike?
The GUI is a bit old fashioned. Can be implemented in a good manner.
What problems is the product solving and how is that benefiting you?
Analysis and monitoring of applications.
Fast and Easy to Use
What do you like best?
Query Execution Speed, Best Database for Transaction System
What do you dislike?
Can't Write Store Procedure and Function
What problems is the product solving and how is that benefiting you?
Store huge amount of transactional data in shorts of time. Best benefits is projection
Recommendations to others considering the product:
Add PL/SQL functionality
Vertica review
What do you like best?
Columnar access to database. Fetch records fastly then row based
What do you dislike?
Only accessible on servers. Would like to see it in UI.
What problems is the product solving and how is that benefiting you?
Dat files to vertica database and then access to SAS
If you have bulk Data to process and heavy processing load then vertica is a good choice.
What do you like best?
we have machine learning and NLP work, I like the most about is I can do much Regular expression and Data cleaning directly in Vertica. We can create our own function which is most helpful thing.
What do you dislike?
For simple crud operation with some joins query could be faster.
What problems is the product solving and how is that benefiting you?
Regular expression at Vertica level I personally used the most for my profesional work. And our team is using it work various machine learning work.
Recommendations to others considering the product:
If you are looking for ETL solution then give a chance to Vertica. Performance is good and maximize performance for work related to big data.
Vertica review
What do you like best?
It's extremely helpful for fast querying on the reporting side involving TBs of data. We had migrated same data to newer streaming dbs which did not perform as well for the large data. It's easy to learn and implement - uncluttered and simple ! System tables are easy to read to understand underlying workings.
What do you dislike?
Tuning is developer centric. Which means performance heavily depends on the developers decisions and knowledge. Conditional Updates not possible for alrge datasets - db crashes
What problems is the product solving and how is that benefiting you?
Sub second performance benchmark are met and nice integration with dashboards
Recommendations to others considering the product:
Awesome for sub second performance for huge datasets.
Vertica the high performance DB
What do you like best?
It's performance, scalability and it's ease of use.Its reduced data storage is another great feature. It is IO optimized DB
What do you dislike?
Pricing, supporting procedure would be a good option.Deletion is slower in vertica
What problems is the product solving and how is that benefiting you?
It helped in our huge volume and query performance issue which was a pain in traditional DB
Recommendations to others considering the product:
Please go ahead with vertica as it is one of the best DB for analytics.A POC will help in judging it's advantages
Good things are being done
What do you like best?
Good work, excellent commitment, humanitarian will
What do you dislike?
Not much of it seems fine let's see how it goes
What problems is the product solving and how is that benefiting you?
Pretty good computational problems
showing 91 - 100