Likelihood to Recommend Most of the time, server utilization is reliable and stable during peak times. Truly amazing, this product offers a lot and gets it done in no time without any confusion.It is reliable, too accurate and the performance is top-notch. It seems to be competitive in all virtual energy systems and its connectivity is also good. It's available at a low cost, but it's enough to have as many low-cost, more efficient systems as possible. It's a minor thing, but very rarely, it can cause work interruptions while it can get stuck due to more frequent use such as restless work. These power servers are very efficient and really help when things go wrong. I am using this product to retrieve data much faster.
Read full review SingleStore HTAP engine is well suited for real-time analytics, fast ingestion, scaling OLTP system like
MySQL . When you need to run reports or perform aggregates on billions of rows and you get result in seconds, you cannot get this experience with other OLTP engines. I wish DBtLab was a little more developer and supported for SingleStore. This would allow to perform better data transformation. You can use stored procedures, but DBTLabs has become a standard for dimensional modeling in data warehousing projects. This is probably why SingleStore has trouble piercing in the data warehouse world. It is definately capable to compete with
Snowflake when it comes to scalability, query performance, data compression, but
Snowflake has ravaged the data warehouse market in few years and large corporations have already invested lots of money in migrating into
Snowflake . The SingleStore community needs to grow. Everyone who uses SingleStore loves it.
Read full review Pros Virtualization for Scale-Out and Scale-Up in the same footprint Security for different workloads: Large Confidential Computing and lightweight Secure Execution Performance is a true game changer: extreme throughput powered by amazingly huge caches. The one and only FIPS 140-2 Level 4 HSM on this planet Quantum Safe Encryption NOW! AI infusion to every transaction Read full review Technical support is stellar -- far above and beyond anything I've experienced with any other company. When we compared SingleStore to other databases two years ago, we found SingleStore performance to be far superior. Pipeline data ingestion is exceptionally fast. The ability to combine transactional and analytical workloads without compromising performance is very impressive. Read full review Cons It would be good if IBM could demonstrate more use cases for Z to potential clients A migration strategy from Open Systems to Z would be helpful Any additional marketing to could explain the benefits of Z/Linux, especially now that RedHat is in the mix. Read full review We wish the product had better support for High Availability of the aggregator. Currently the indexes generated by the two different aggregators are not in the same sequential space and so our apps have more burden to deal with HA. More tools for debugging issues such as high memory usage would be good. The price was the one that kept us away from purchasing for the first few years. Now we are able to afford due to a promotion that gives it at 25% of the list price. Not sure if we'll continue after the promotion offer expires in another 2 years. Read full review Likelihood to Renew The IBM Z mainframe capabilities are unmatched for cloud readiness and optimization the learning capabilities are matched perfectly with Watson and the expandability of the cloud makes it a perfect choice.
Read full review We haven't seen a faster relation database. Period. Which is why we are super happy customers and will for sure renew our license.
Read full review Usability Once you learn how, it easy. It's different than most other systems
Read full review [Until it is] supported on AWS ECS containers, I will reserve a higher rating for SingleStore. Right now it works well on EC2 and serves our current purpose, [but] would look forward to seeing SingleStore respond to our urge of feature in a shorter time period with high quality and security.
Read full review Reliability and Availability The Z in IBM Z is for zero down time. If you configure your system according to IBM's best practices, you can achieve zero downtime
Read full review We have not experienced any downtime in the two years that we have been using SingleStore.
Read full review Performance Performance is a major part when you configure your system. IBM has many tools to study your system and suggest the appropriate configuration. With the right contract, you can add processing power dynamically and remove it when no longer needed
Read full review SingleStore's performance is incredible. Our predictive algorithms went from taking 24-48 HOURS down to 15 minutes allowing our team to run those much more frequently. Previously, we were limited to about 60 requests per minute due to table locks. Implementing columnstore on SingleStore allowed us to receive 1000 requests per minute.
Read full review Support Rating Support is usually superb, only occasionally dropping to very good. We participate in some of the CD (Continuous Delivery) aspects of z/OS, IMS, MQ, and DB2.
Read full review Very responsive to trouble tickets - Often, I think, the SingleStore's monitoring systems have already alerted the engineers by the time I get around to writing a ticket (about 10 - 20 mins after we see a problem). I feel like things are escalated nicely and SingleStore takes resolving trouble tickets seriously. Also SingleStore follows up after incidents to with a post mortem and actionable takaways to improve the product. Very satisfied here.
Read full review In-Person Training Over my 33 years on this platform, I attended many in person courses, conferences, and other training opportunities.
Read full review Online Training There are many online courses from both IBM and other vendors. Most are great. All of the documentation is available online.
Read full review Implementation Rating I do not personally have any key insights regarding implementation of IBM Z Enterprise Servers as that is what our mainframe architects do.
Read full review We allowed 2-3 months for a thorough evaluation. We saw pretty quickly that we were likely to pick SingleStore, so we ported some of our stored procedures to SingleStore in order to take a deeper look. Two SingleStore people worked closely with us to ensure that we did not have any blocking problems. It all went remarkably smoothly.
Read full review Alternatives Considered IBM Z is the best storage solution as it provides the best in class data protection with the cryptographic hardware keys, no loss in data while migration, and a user-friendly interface that makes it easy for develops to understand and has less of a learning curve. This makes it well above the competition.
Read full review Timescale was the biggest alternative option we looked at for SingleStore, however the requirement to learn a new syntax (due to not being SQL compatible) was our biggest pain point. Supporting a new language would require alterations to the Laravel framework, as this only offered SQL integration out of the box. This alteration would be time consuming and would limit our scope to future hiring due to the new syntax.
Read full review Scalability If you need more processing power, just add more CPU's or memory. The largest system can have close to 200 CPU's and 40 TB of memory. If that is not enough, you can add more physical computers, and connect them using a sysplex
Read full review We needed more memory on our cluster. SingleStore handled it very smoothly.
Read full review Return on Investment With IBM Z we really feel a different positive impact on our company. A trustworthy and the most powerful place we have ever. A unique computing platform that helps a lot for the progress of our company. It keeps our data save, encrypted. Read full review As the overall performance and functionality were expanded, we are able to deliver our data much faster than before, which increases the demand for data. Metadata is available in the platform by default, like metadata on the pipelines. Also, the information schema has lots of metadata, making it easy to load our assets to the data catalog. Read full review ScreenShots