Overall Satisfaction with SingleStore (formerly MemSQL)
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.
- Query performance execution
- Concurrent users
- Simplified data pipeline
- Metrics collection/visualization for queries execution.
- 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
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.
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
Using SingleStore (formerly MemSQL)
Pros | Cons |
---|---|
Like to use Relatively simple Easy to use Consistent Quick to learn Feel confident using Familiar | Cumbersome |
- Query definition
- sometimes, in a streaming mode, some procedures are called twice for the same data
- Satistics usage (query performance)
Yes, but I don't use it