Performance3 min Read

Linus Torvalds had some interesting things to say about AVX512: “I hope AVX512 dies a painful death… I absolutely detest FP benchmarks, and…
Read Post
Analytics6 min Read

Everyone remembers their first experience in a Tesla. Mine was in Las Vegas with a good friend and CIO. I was in town for a tech conference and that provided a good opportunity to reconnect and discuss a new project. He offered to pick me up at my hotel. That was the moment I was first introduced to Tesla’s unique Ludicrous mode. It was exhilarating. The Strip became one long, breathless blur. If you haven’t experienced zero to 60 mph in 2.2 seconds, take a look at the “Tesla reactions” genre of…
Read Post
Cloud9 min Read

This webinar describes what’s needed to successfully migrate your data to the cloud. What does a good cloud data migration look like? What are the strategic decisions you have to make as to priorities, and what are the challenges you’ll face in carrying out your plans? We will describe a tried and tested approach you can use to get your first wave of applications successfully migrated to the cloud. About This Webinar Series This is the second part of a three-part series . Last week we covered…
Read Post
Analytics13 min Read

There is a trend in industry which says that modern applications need to be built on top of one or more special-purpose databases. That every application benefits from using the best-of-breed technology for each requirement. And that the plethora of special-purpose options available from certain cloud providers is reasonable to manage. That’s all BUNK. The reality is that navigating the choices, figuring out how to use them effectively, and dealing with the ETL and inevitable data sprawl, is so…
Read Post
Database2 min Read

You can take advantage of a free download of key chapters from the exciting e-book, Designing Data-Intensive Applications . The chapters included in the free download cover two areas of vital concern to most SingleStore users, and indeed most developers and architects: transactions and streaming data. Designing Data-Intensive Applications, as a complete book, is more than 500 pages long. It takes as its premise that data is at the center of many of the challenges in system design today. (This…
Read Post
Case Study17 min Read

In 2016, Pandora chose SingleStore to serve as the data store and foundation for solving a specific business problem. In this post, we explore: The Business Problem — what were we trying to solve? The Previous System — a few details Requirements — business requirements (and a few technical ones too) The Contenders — what did the options look like About SingleStore How We Implemented SingleStore Data Strategy: Columnstore vs. Rowstore Hardware Details Into the Weeds Summary The Business Problem…
Read Post
Announcements3 min Read

Many organizations find they need to support a database-as-a-service workload. This is a model where multiple organizations have data living side by side to reduce management costs but each organization requires a strong namespace and security boundary around its data. Organizations also often want to leverage the existing ecosystem of tooling available on top of the data layer. This is a challenge to do using legacy databases because they do not scale out and a challenge with NoSQL systems…
Read Post
Database6 min Read

On March 13, we published a blog demonstrating the performance of SingleStore in the context of ad hoc analytical queries. Specifically, we showed that the query can process 1,280,625,752,550 rows per seconds on a SingleStore cluster containing 448 Intel Skylake cores clocked at 2.5GHz. In this blog post, we drill down into how this was made possible by carefully designing code, exploiting distributed execution, and instruction-level and data-level parallelism. Why is such high throughput…
Read Post
Artificial Intelligence3 min Read

Introduction Machine Learning (ML) and Artificial Intelligence (AI) have stirred the technology sector into a flurry of activity over the past couple of years. However, it is important to remember that it all comes back to data. As Hilary Mason, a prominent data scientist, noted in Harvard Business Review * , …you can’t do AI without machine learning . You also can’t do machine learning without analytics , and you can’t do analytics without data infrastructure . Over the last year we…
Read Post
Database4 min Read

In a recent webcast , we shared some tips and tricks on how you can operationalize SingleStore for configuring SingleStore Ops and SingleStore root user passwords; memory settings and health metrics; and how you can take backups and add nodes securely to your cluster. Here are the topics we covered: Permissioning a new cluster by adding a super-user to SingleStore Ops and via GRANT statements on the cluster itself Best practices for configuring memory limits Best practices for basic…
Read Post
Artificial Intelligence6 min Read

Just like IoT, around in various forms for years, AI has been prevalent in nearly every enterprise for decades. The catch? It was hidden inside the databases and data warehouses in use under the banner of Query Optimization. Query optimization is the process where a database or data warehouse takes the input from a user’s question, and reworks that question to deliver a quick response with as few compute resources as possible. The number of query plan choices reach far beyond what a human can…
Read Post
CDC4 min Read

Data is driving innovative customer experiences, operation optimization, and new revenue streams. Data infrastructure teams are being asked to update their legacy infrastructure to respond to changing business conditions without disrupting existing operations. The future of data management is modernizing legacy systems using real-time data synchronization with modern databases that can accelerate innovation without impacting existing applications. The Challenge of Legacy Systems A constant…
Read Post
Data Warehouse3 min Read

We know choosing or evaluating a new database technology can be challenging due to the variety of choices available. In a recent webcast, we shared various use cases businesses face with traditional database and data warehouse technologies, key differentiators and architectures of SingleStore, sample applications and customer case studies, and a quick demo of SingleStore. SingleStore provides an adaptable database for real-time applications that unite transactions and analytics in a single high…
Read Post
Amazon6 min Read

The database market is large and filled with many solutions. In this post, we will take a look at what is happening within AWS, the overall data landscape, and how customers can benefit from using SingleStore within the AWS ecosystem. Understanding the AWS Juggernaut At AWS re:Invent in December 2017, AWS CEO Andy Jassy revealed that the business is at a revenue run rate of $18 billion, growing 42 percent per year. Those numbers are staggering and showcase the importance Amazon Web Services now…
Read Post
Database2 min Read

Whether you’re the CTO of the Rebel Alliance or the Galactic Empire, it could be very difficult to decide on your next database technology with the distraction of both sides constantly at war. In 2018, you’ll need to make a database choice for an existing or new application. Here are the things you need to keep in mind as you shop for your next database. 8 Criteria To Keep In Mind While Looking For Your Next Database 1) Pick the right language: SQL The history of SQL, or Structured Query…
Read Post
Database5 min Read

Most users of SQL databases have a good understanding of the join algorithms single-box databases employ. They understand the trade-offs and uses for nested loop joins, merge joins, and hash joins. Distributed join algorithms, on the other hand, tend not to be as well understood. Distributed databases need to make a different set of tradeoffs to account for table data that is spread around a cluster of machines instead of stored on a single machine, like in a traditional database. Because these…
Read Post