Case Study7 min Read

True Digital Group is using SingleStore to power a contact tracing app, preventing the spread of COVID-19 in Thailand. (See our joint pres…
Read Post
Analytics6 min Read

In earlier blog posts we described what time series data is and key characteristics of a time series database . In this blog post, which originally appeared in The New Stack, Eric Hanson, principal product manager at SingleStore, shows you how to use SingleStore for time series applications. At SingleStore we’ve seen strong interest in using our database for time series data . This is especially the case when an organization needs to accommodate the following: (1) a high rate of event…
Read Post
Case Study4 min Read

SME Solutions Group is a SingleStore partner. An SME customer, a utility company, was installing a new meter network, comprising 2 million meters, generating far more data than the old meters. The volume of data coming in, and reporting needs, were set to overwhelm their existing, complex, Hadoop-based solution. The answer: replacing 10 different data processing components with a single SingleStore cluster. The result: outstanding performance, scalability for future requirements, the ability to…
Read Post
SingleStore 7.022 min Read

With the SingleStore DB 7. 0 release, SingleStore has added more special-purpose features, making it even easier to manage time series data within our best-of-breed operational database. These new features allow you to structure queries on time series data with far fewer lines of code and with less complexity. With time series features in SingleStore, we make it easier for any SQL user, or any tool that uses SQL, to work with time series data, while making expert users even more productive. In a…
Read Post
SingleStore 7.05 min Read

SingleStore is uniquely suited to real-time analytics, where data is being ingested, updated, and queried concurrently with aggregate queries. Real-time analytics use cases often are based on event data, where each separate event has a timestamp. It’s natural to interpret such a sequence of events as a time series. Prior to the 7.0 release, SingleStore delivered many capabilities that make it well-suited to time-series data management [ Han19 ] . These include: a scaled-out, shared-nothing…
Read Post
Time Series7 min Read

Time series data is as old as databases themselves – and also the hot new thing. Interest in the topic has more than doubled during this decade. In a previous blog post, we described how time series data is used and stored. In this blog post, we look at the desirable characteristics of a time series database and evaluate our own database, SingleStore, against those requirements. Time series data is more and more widely used. It’s seen in everything from managing oil drilling rigs to machine…
Read Post