Announcements11 min Read

SingleStore Universal Storage is a new vision for how databases can work – first blurring and then, for most use cases, erasing any apparen…
Read Post
Analytics6 min Read

John Sherwood, a senior engineer at SingleStore on the query optimizer team, presented at SingleStore’s Engineering Open House in our Seattle offices last month. He gave a technical introduction to the SingleStore database, including its support for in-memory rowstore tables and disk-backed columnstore tables, its SQL support and MySQL wire protocol compatibility, and how aggregator and leaf nodes interact to store data and answer queries simultaneously, scalably, and with low latencies. He also…
Read Post
Columnstore6 min Read

Thanks to Oryan Moshe for this awesome blog post, which originally appeared on DEV Community. In the blog post, Oryan describes how to achieve the high performance of SingleStore’s columnstore for queries while keeping transaction data in PostgreSQL for updates – Ed. Making the impossible hard So it’s this time of the year again, we need to upgrade our SingleStore cluster and expand our contract to fit the new cluster topology. We really outdid ourselves this time. Expanding to a 1TB cluster…
Read Post
Cloud6 min Read

Intel’s new Optane DC persistent memory adds a new performance option for SingleStore users. After careful analysis, we’ve identified one area in which SingleStore customers and others can solve a potentially urgent problem using Optane today, and we describe that opportunity in this blog post. We also point out other areas where SingleStore customers and others should keep an eye on Optane-related developments for the future. If you need broader information than what’s offered here, there are…
Read Post
In Memory Database1 min Read

Adoption of in-memory technology solutions is happening faster than ever. This stems from a three pronged demand – first, a greater number of users, analysts, and businesses need access to data. Second, the number of transactions is increasing globally, so companies need faster ingest and analytics engines. Finally, performance inconsistencies are the nail in the coffin for companies competing in the on-demand economy – these enterprises need the responsiveness in-memory technology provides. In…
Read Post
Analytics3 min Read

Prediction 1. The industrial internet moves to real-time data pipelines The industrial internet knits together big data, machine learning, and machine-to-machine communications to detect patterns and adjust operations in near real time. Soon the industrial internet will expand by definition to include the Internet of Things. The detection of patterns and insights often comes with a price: time. While the goal of machine learning is to develop models that will prove useful, dealing with large…
Read Post
Analytics3 min Read

We often hear “How can I use SingleStore together with my Oracle database?” As a relational database, SingleStore is similar to an Oracle database, and can serve as an alternative to Oracle in certain scenarios. Here is what sets SingleStore apart: SingleStore is a distributed system, designed to run on multiple machines with a massively parallel processing architecture. An Oracle database, on the other hand, resides in a single, large machine, or a smaller fixed cluster size. SingleStore has…
Read Post
In-Memory1 min Read

Tradelab, a programmatic marketing platform company based in France, uses SingleStore to process and analyze real-time bidding data for hundreds of customers. Challenge: NoSQL Data Latency The Tradelab real-time ad serving platform requires a heavy mixed read/write workload, and the NoSQL database they had in place was introducing unnecessary data latency into the ad-bidding process. The company began searching for a replacement – a true real-time data management solution with two key criteria…
Read Post
Analytics4 min Read

Bitcoin has occupied headlines of technology and business publications over the past several years. The concept of digital currency, or cryptocurrency, rocked the financial industry, and public opinion about the applications of Bitcoin continues to ebb and flow. Today, Bitcoin is being overshadowed by another technology: blockchain. Blockchain is a public ledger for Bitcoin and other cryptocurrencies. This is where the real money is, say payment industry experts. Blockchain is a distributed…
Read Post
Gartner2 min Read

There is no question that data is infiltrating our world. Recently 451 Research predicted that the Total Data Market is expected to double in size from $60 billion in 2014 to $115 billion in 2019. IDC suggested that Internet of Things (IoT) spending will reach $1.7 trillion in 2020. and noted, “the real opportunity remains in the enterprise…” And as stated in a recent Gartner blog post , while the three leading independent Hadoop distribution players measure their revenue in 10s of millions…
Read Post
Events1 min Read

The inaugural In-Memory Computing Summit begins next week, June 29-30, and we are thrilled to be a part of it. From speaking sessions on Spark and customer use cases, to games and giveaways, you will not want to miss the action. Visit us at booth #4 to pick up our brand new t-shirt, and learn how in-memory computing can bring peak performance to new or existing applications. SingleStore Speaking Sessions From Spark to Ignition: Fueling Your Business on Real-Time Analytics Monday, June 29 at 1…
Read Post
Gartner2 min Read

Takeaways from the Gartner Business Intelligence and Analytics Summit Last week, SingleStore had the opportunity to participate in the Gartner Business Intelligence and Analytics Summit in Las Vegas. It was a fun chance to talk to hundreds of analytics users about their current challenges and future plans. As an in-memory database company , we fielded questions on both sides of the analytics spectrum. Some attendees were curious about how we compared with SAP HANA, an in-memory offering at…
Read Post
In-Memory1 min Read

Strata+Hadoop World was full of activity for SingleStore. Our keynote explained why real-time is the next phase for big data . We showcased a live application with Pinterest where they combine Spark and SingleStore to ingest and analyze real-time data. And we gave away dozens of prizes to Strata+Hadoop attendees who proved their latency crushing skills in our Query Kong game. During the event, Mike Hendrickson of O’Reilly Media sat down with SingleStore CEO Eric Frenkiel to discuss: The state…
Read Post