Item: SingleStore
Rating: 10
Author: Verified User

Use Cases and Deployment Scope

We are using SingleStore as our primary analytics database within our own platform (called "Pulse"). The Pulse platform is used primarily in Siemens internally, but is also available to enterprises outside of Siemens.
We offer end to end reporting & analytics services and use SingleStore to power our dashboards and reports.

Pros and Cons

Performance.
SQL-interface.
Relational online analytical processing (ROLAP).

SQL completeness (e.g. triggers).
Performance tuning insides.

Return on Investment

Increased customer satisfaction.
Increased possibilities.
Increased user engagement.

Alternatives Considered

MySQL, Microsoft SQL Server and PostgreSQL

We have tested various SQL databases including SQL Server, PostgreSQL and MySQL (in different flavors) and SingleStore is easily 20x faster than any of them; depending on the query we have even seen 100x improvements for analytics queries. An analytical query on Aurora MySQL that takes 40s to run runs in <100ms on SingleStore without changes to query.

Real-Time Analytics

Fast query and real time analytics certainly have a positive impact on user/customer satisfaction, but predictive analytics are achieved through ML models.

Scalability

We have increased our license size over time and have increased our cluster both through vertical as well as horizontal scaling. When we know there is going to be peak traffic, we have also increased sizes proactively just for a couple of days. Because more CPUs usually result in higher concurrency, SingleStore can easily scale by just adding more CPUs to the cluster.

Key Insights

Do you think SingleStore delivers good value for the price?

Yes

Are you happy with SingleStore's feature set?

Yes

Did SingleStore live up to sales and marketing promises?

Yes

Did implementation of SingleStore go as expected?

Yes

Would you buy SingleStore again?

Yes

Likelihood to Recommend

We have not found an analytical database faster than SingleStore. While our data volume per project is usually below 100 million rows, we expect reporting and analytics queries to be executed within 100ms so that dashboard users can interactively work with their data. So if you are looking for a truly fast analytical database, SingleStore is the right database to use (even though it is also crazy fast for OLTP workloads, but that is not our use case).

Users and Roles

3000 - Users from all functions you SingleStore, but not directly but as users of applications that heavily depend on SingleStore.

Support Headcount Required

5 - Our in-house people that support the SingleStore operations have an IT background. Skills required are:

Basic Linux command line skills.
Basic SQL skills.
Infrastructure skills (setting up servers and firewalls).

Business Processes Supported

Analytics.
Self-service.
Business intelligence.

Likelihood to Renew

We haven't seen a faster relation database. Period. Which is why we are super happy customers and will for sure renew our license.

Other Software Used

Dundas BI, Tableau Server

SingleStore is the fastest database ever tested by us

Overall Satisfaction with SingleStore (formerly MemSQL)