Item: SingleStore
Rating: 8
Author: Virginie Aelst

Use Cases and Deployment Scope

UCB Biopharma wanted to offer a solution enabling scientists to "self-service" research data rapidly with the aim to accelerate the early discovery process.

○ Scientists define the data set that is relevant to their investigation in a ‘data collection & preparation’ tool, execute the resulting query against SingleStore, and visualize it in a data-analytics tool.

○ Data alerts are generated with the help of SingleStore queries to inform end-users about the arrival of fresh information.

UCB selected SingleStore for raw query performance and for concurrency. we serve on a daily basis between 220-800x scientists in several countries.

Pros and Cons

Query performance execution
Concurrent users
Simplified data pipeline

Metrics collection/visualization for queries execution.

Return on Investment

Real time data availability that speeds up the research process.
Decrease scientist's time needed to collect and prepare data and provides more time to analyze them.
Gives more flexibility in data combination across areas

Real-Time Analytics

Thanks to SingleStore, query latency went down from 10-20 mins to 20 secs. Ad-hoc queries are instantly handled by SingleStore, allowing the analysts to validate their hypotheses in real-time. SingleStore data store also allows the usage of multiple analysis tools. Because the analysis of data requires different approaches, it is now possible for different data scientists to access data from their favorite tools.

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

The availability of high-performance, simple and affordable database technology like SingleStore’s provides an additional accelerator to any data-driven companies.

Usability Pros and Cons

Pros	Cons
Like to use Relatively simple Easy to use Consistent Quick to learn Feel confident using Familiar	Cumbersome

Easy Tasks

Query definition

Difficult Tasks

sometimes, in a streaming mode, some procedures are called twice for the same data
Satistics usage (query performance)

Usability

The cluster has been easily installed, integration is well done (SingleStore studio) - user community is available in case of help and react quickly

Mobile Interface Availability and Impressions

Yes, but I don't use it

How SingleStore helped the Research department to "self-service" their data and accelerate the discovery process

Overall Satisfaction with SingleStore (formerly MemSQL)