Apr 19, 2020
I haven't used SQream personally. However, if you are only considering GPU based rdbms's please check the following
https://hackernoon.com/which-gpu-database-is-right-for-me-6ceef6a17505
Find out what your peers are saying about Snowflake Computing, Teradata, Oracle and others in Data Warehouse.
I saved a lot of money because the storage was on a cheaper alternative and was not directly on OpenText Analytics Database (Vertica), but on S3.
The time we used to take with our earlier databases has reduced to one-tenth of what was there earlier, which is a positive outcome that can be converted to financial metrics in terms of return on investment.
The efficiency has increased significantly, and our workflows are consolidated into a single platform, thus reducing the operational overhead we previously faced.
The objective was to scale as data loads with high-performing query model responses.
I have seen a return on investment in terms of time saved.
Throughout this process, customer support was outstanding, and we had a person actively supporting us from the OpenText Analytics Database (Vertica) team for our use case.
Overall, our experience with OpenText Analytics Database (Vertica) customer support has been good and reliable.
The customer support is very proactive and responsive twenty-four hours per day, seven days per week.
Their team is capable of resolving issues efficiently, allowing users to create tickets and receive support.
We have our own account manager who keeps us informed of the latest solutions and improvements in the system.
We have experienced easy horizontal scaling, consistent query performance as data grew, and the ability to handle large analytic workloads.
OpenText Analytics Database (Vertica) has very good scalability.
OpenText Analytics Database (Vertica) can scale to a great extent.
As our data volumes grow, we can expand resources without significant performance degradation.
SingleStore's scalability is really nice, as the process model includes master aggregator and slave aggregators or child aggregators, making it very well scalable both vertically and horizontally.
I have added both storage and additional instances many times, and it worked perfectly.
OpenText Analytics Database (Vertica) is very stable.
It handles large workloads and maintains consistent performance very well overall.
The performance and usability of SingleStore as a main database engine are significantly superior to other both paid and open-source solutions.
I have not seen any downtime.
Smarter automatic projection management is needed with more intelligence, auto projection creation, automatic optimization, and reduced manual testing with better workload management.
Projections could be made more dynamic, and if they could find a faster way to update, insert, and delete data, that would also be helpful.
OpenText Analytics Database (Vertica) does not have a cloud-based UI that Snowflake has, which features a very good comprehensive GUI for querying and analyzing data.
Error handling needs attention. When it fails due to memory, it only indicates that but not exactly in which process it failed.
The data which is sent to DataDog sometimes does not match with the SingleStore dashboard.
Better documentation for advanced use cases, especially where data volumes are very high and queries are frequent, would help us manage the feature more efficiently.
The pricing for OpenText Analytics Database (Vertica) is somewhat on the higher side for the license.
My experience with pricing, setup cost, and licensing is that it can be a bit expensive for startups.
The setup cost was surprisingly good, and our transfer to Helios was almost seamless, as far as databases go, and it was not expensive.
I can use it in Eon Mode in which I can store the data in cheaper storage such as Amazon S3 and have different compute nodes.
Projection and columnar storage are the most valuable features because they dramatically improve query performance and reduce the need for index management.
The best features that OpenText Analytics Database (Vertica) offers are mainly the parallel processing, ETL capabilities, and the multi-cloud features which are very handy to use.
SingleStore has impacted my organization positively by enabling us to run low-latency analytics and model-driven use cases at scale, which is quite difficult for OLAP and OLTP databases alone.
A very nice and useful feature is its compatibility with MySQL API, letting any system that can connect to MySQL also connect to SingleStore, thus solving many interoperability issues with different systems.
SingleStore is a distributed database that has the advantage that at any moment when resources are insufficient, there is a possibility to add more nodes, and everything is added online.
| Product | Mindshare (%) |
|---|---|
| OpenText Analytics Database (Vertica) | 5.7% |
| Snowflake | 9.4% |
| Teradata | 8.6% |
| Other | 76.3% |
| Product | Mindshare (%) |
|---|---|
| SingleStore | 3.6% |
| Amazon RDS | 12.6% |
| MongoDB Atlas | 11.5% |
| Other | 72.3% |
| Company Size | Count |
|---|---|
| Small Business | 29 |
| Midsize Enterprise | 23 |
| Large Enterprise | 43 |
| Company Size | Count |
|---|---|
| Small Business | 7 |
| Large Enterprise | 5 |
OpenText Analytics Database Vertica is known for its fast data loading and efficient query processing, providing scalability and user-friendliness with a low cost per TB. It supports large data volumes with OLAP, clustering, and parallel ingestion capabilities.
OpenText Analytics Database Vertica is designed to handle substantial data volumes with a focus on speed and efficient storage through its columnar architecture. It offers advanced performance features like workload isolation and compression, ensuring flexibility and high availability. The database is optimized for scalable data management, supporting data scientists and analysts with real-time reporting and analytics. Its architecture is built to facilitate hybrid deployments on-premises or within cloud environments, integrating seamlessly with business intelligence tools like Tableau. However, challenges such as improved transactional capabilities, optimized delete processes, and better real-time loading need addressing.
What features define OpenText Analytics Database Vertica?OpenText Analytics Database Vertica's implementation spans industries such as finance, healthcare, and telecommunications. It serves as a central data warehouse offering scalable management, high-speed processing, and geospatial functions. Companies benefit from its capacity to integrate machine learning and operational reporting, enhancing analytical capabilities.
SingleStore delivers the performance you need for enterprise AI, providing the most performant data platform for apps and analytics at scale. SingleStore enables organizations to scale from one to one million customers in one unified platform. SingleStore offers transparent pricing as shown here https://www.singlestore.com/pricing/
SingleStore caters to over 400 customers globally, including major banks and tech companies in 50+ countries and 40+ verticals. It offers seamless scaling for both transactional and analytical workloads, simplifying data management with its MySQL compatibility and real-time processing capabilities. SingleStore's distributed architecture ensures speed and reliability, efficiently handling large data volumes.
What are the key features of SingleStore?
What benefits can users find in SingleStore reviews?
Top banks and fintech companies leverage SingleStore for efficient management of financial data, while media and telecom industries use it for scalable metadata management and improved data processing. Retail and eCommerce sectors benefit from enhanced transactional capabilities, reducing the need for separate databases and optimizing reporting processes. SingleStore's capacity to unite diverse workloads makes it a strategic choice across many sectors.
We monitor all Data Warehouse 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.
