Analytics2 min Read

Jordan Tigani is the Chief Product Officer at SingleStore. He was the co-founding engineer on Google BigQuery. He also led engineering team…
Read Post
Database5 min Read

Everybody has heard of the KISS principle -- Keep It Simple, Stupid. When applied to data management technology, it implies that you should use a simple solution when it works. Developers often believe that means using a single-node DBMS like MySQL, PostgreSQL, or SQL Server. So, what is a “single-node” database? Essentially, it’s a database designed for a single machine. The capacity of a single machine dictates the resource constraints of processing power, connections, and storage. If you need…
Read Post
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 I realize other people care deeply. I just think AVX512 is exactly the wrong thing to do…”. Having had the unique opportunity of migrating a portion of SingleStore’s library of SIMD kernels from AVX2 to AVX512/VBMI over the last few months, I disagree. For one thing, AVX512 is not designed solely for floating-point workloads. SingleStore’s code fundamentally…
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
Announcement2 min Read

Today, Martin Luther King Jr. (MLK) is celebrated, honored and remembered as one of America’s greatest leaders for his transformative ability to move the needle forward in regard to the civil rights movement in the United States and throughout the world. King sought equality and human rights for African Americans, the economically disadvantaged, and all victims of injustice through peaceful protest. Commitment. Determination. Clarity. Vision. Inspiration. Transformational Mindset. These words…
Read Post
Data Strategy6 min Read

On this National Cut your Energy Costs Day, it’s a good time to think about our carbon footprints at home and at work as data professionals. Since the first home was electrified in Manhattan in the 1880s, our home electricity usage has grown dramatically. According to Energy.gov, residential homes now account for 22% of all electricity consumption in the U.S. Roughly 63% of this electricity is still generated by nonrenewable fossil fuel sources in the U.S. according to the Energy Information…
Read Post
Data Strategy4 min Read

With the world still recovering and reorganizing from COVID-19 and How the Global Pandemic has reshaped supply chains, infrastructure, and the way that business is processed, 2021 is anticipated to be a year to make big gains for companies that embrace and implement strategic Digital First Strategies. Whether Mobile First, Tablet First, or Laptop First strategies are at the forefront of your organization, data will continue to reign supreme as 5G continues its global roll-out. What strategies…
Read Post
Engineering4 min Read

SingleStore introduced an APPROX_PERCENTILE function to estimate percentiles for a distribution of values. This function is faster and near-exact as compared to the analogous functions that calculate exact percentiles. Read more to learn about this feature and see the performance and accuracy comparisons between approximations and precise values on a sample dataset. Please check this demo video to learn more about the approx_percentile function in SingleStore: If you have a sizable numeric…
Read Post
Announcements4 min Read

SingleStore Universal Storage technology is a dramatic evolution of our columnstore data format that allows it to support both operational and analytical workloads with low total cost of ownership (TCO). People love our rowstores for OLTP-style access patterns because of our great performance based on memory-optimized data structures and compilation of queries to machine code. But for users with large data sets, the cost of providing servers with enough RAM to hold all the data started to be…
Read Post
Engineering4 min Read

I once heard that a “book worth reading is worth reading twice”, and I’ve found this to be true about other things as well. There’s a documentation page that’s been with me for the majority of my professional career; a page that I keep coming back to and that I’ve read from start to finish, without skipping a word, more than a few times in the last few years. This document is GitLab’s Embracing Asynchronous Communication guide , a section of GitLab’s public handbook that goes over their…
Read Post
real-time4 min Read

Business is about serving the needs of customers. But customer expectations are changing quickly, and most organizations are not truly aware of how fast that’s happening. Most businesses are moving in slow motion relative to their customers. That means they miss out on opportunities to make decisions about and act on the moments that matter. In the past, lag time was accepted. Nielsen called people on the phone to understand their TV viewing habits. Broadcast TV networks set advertising rates…
Read Post
SingleStore2 min Read

Today is Veterans Day, a time to recognize and thank our military servicemen and servicewomen. As a civilian, my frame of reference for the kind of sacrifice these individuals make is limited. In my efforts to better understand and appreciate their experiences – and enormous contributions – I have relied on a few movies that I find extremely inspirational. Amid the pandemic, people are subscribing to streaming services and watching movies more than ever . Movies bring history to life…
Read Post
Industry4 min Read

As a follow-up to our recent webinar with SingleStore Field CTO Domenic Ravita and our guest Forrester VP Principal Analyst Noel Yuhanna, we take a deeper dive into market-facing pandemic-relevant questions. Noel shares some of his key learnings over the past eight months. He talks about how businesses are learning to leverage data and analytics during COVID-19, the suddenly urgent need for real-time data, the benefits of a multi-cloud data and analytics strategy, and why companies must focus…
Read Post
Case Study9 min Read

Cybercrime damages in 2021 are expected to reach $6 trillion , with organizations of all sizes and industries exploring ways to protect themselves better. Potential security vulnerabilities come in many forms, from cross site scripting to improper privilege management. Over 17,000 new security vulnerabilities were discovered in 2020 alone. IT security teams are responsible for securing infrastructure that’s continually increasing in complexity, so it’s challenging to respond quickly to newly…
Read Post
fastboards6 min Read

Introduction Over the last many years, analytical dashboards have proliferated enterprises from the boardroom to the manufacturing line. As businesses have become increasingly more reliant on analytics, end users have started to demand snappier performance from their dashboards. Gone are the days that visualizations are used simply for historical data. Data professionals are now using them for predictive and prescriptive analytics on petabytes of information, expecting the most real-time…
Read Post
Announcement4 min Read

Today is an important milestone for our company. We have rebranded the company to reflect that we offer much more than an in-memory database. We also have an expanded vision to share. SingleStore, formerly MemSQL, provides one platform to actualize all of your enterprise’s data. “What’s in a name?” The MemSQL name has stood for unrivaled speed, scale, and simplicity for operational data since its founding in 2011. It is a well-recognized name among the data architect and performance engineer…
Read Post
Partners4 min Read

Infosys and SingleStore are now working together, identifying opportunities to implement SingleStore – a fast, scalable, relational database, renowned for fast analytics, streaming support, and solutions in areas such as financial services, digital media, telecom, and IoT – with the speed and effectiveness for which Infosys is rightly renowned, worldwide. Infosys is a global leader in next-generation digital services and consulting, with clients in 46 countries. With over three decades of…
Read Post
Partners3 min Read

Red Hat Marketplace provides a one-stop shop to purchase enterprise applications and deploy across any cloud or on-premise SAN FRANCISCO – SEPTEMBER 8, 2020 – SingleStore, The Database of NowTM for operational analytics and cloud-native applications, today announced that the SingleStore scalable SQL database is now available through Red Hat Marketplace. Red Hat Marketplace is an open cloud marketplace for enterprise customers to discover, try, purchase, deploy, and manage certified container…
Read Post
Resources2 min Read

The Database of Now delivers operational insights and advantages by providing the current state of the business. It is a modern, efficient approach to cloud data management which broadens, accelerates, and simplifies access to all the relevant in-the-moment and historical data while unifying data access styles and patterns. Digital transformation projects have accelerated to meet the increased demand for digital products and services providing answers and solutions with immediacy. With the…
Read Post
Engineering4 min Read

You run a database. You try to anticipate the future. You try to provide sufficient, even generous, resources to accommodate future growth in your service. But sometimes, growth far exceeds even your most optimistic expectations, and now you have to figure out how to accommodate that. One obvious way of increasing your database’s ability to handle and service more data is to simply add more machines to your cluster. That should increase the number of cores, and the amounts of memory and disk…
Read Post
Product9 min Read

You can run SingleStore software effectively on Windows, using the Windows Subsystem for Linux Version 2 (WSL 2). This is a development cluster running on a single host, and not suitable for production deployments – but fully capable for many development and demo tasks. You can also run SingleStore Managed Service for free or spin up a SingleStore cluster on Linux , on Docker Desktop , on Kubernetes , or on Vagrant , all in roughly 10 minutes. Read on to see how you can run SingleStore on…
Read Post
Announcement2 min Read

The following announcement is being released by SingleStore today on the news that SingleStore is a winner in the 2020 SaaS Awards, for Best SaaS Innovation in the Internet of Things. SingleStore Named 2020 SaaS Awards Winner Global Software Awards Program Announces Final Winners San Francisco, CA – 25 August 2020 – SingleStore, The Database of Now™ for operational analytics and cloud-native applications, is a winner in the 2020 SaaS Awards Program in the category of The Best SaaS…
Read Post
Announcement2 min Read

The following announcement is being released by SingleStore today to announce the adoption of SingleStore as the core operational database for cloud-based regulatory licensing, assurance, and enforcement technology from Thentia, a global leader in regulatory software. SingleStore Powers the Rapid Rise of Thentia Regulatory Technology As More Regulators Seek Digital Tools Amid COVID-19, There’s a Greater Need for Speed, Scale SAN FRANCISCO – AUGUST 25, 2020 – SingleStore, The Database of Now TM…
Read Post
Analytics4 min Read

Infiswift uses AI to help meet real-world challenges, largely through Internet of Things (IoT) deployments. They optimize the operation of physical devices using connectivity and data. The company’s innovative platform makes it easy to connect and manage any number of endpoints at scale, with security, and to build solutions that open new services or improve existing ones. Infiswift empowers its customers to be data-driven in industries such as renewable energy, agriculture, and manufacturing…
Read Post
IoT1 min Read

In  this Forbes article , Nikita Shamgunov, SingleStore co-founder & co-CEO, discusses the importance of digital twins. While digital twins are frequently associated with industrial and heavy machinery use cases, a digital twin can be built for any business or product. Digital twins can also be found in consumer electronics and financial services. Nikita explains that for a digital twin to work, a business must create a live mirror, or clone, of all the data that is flowing through the veins of…
Read Post
Announcement3 min Read

The following announcement is being released by SingleStore today on the news that SingleStore is being shortlisted as a finalist in two categories for the 2020 SaaS Awards: Best SaaS for Business Intelligence or Analytics, and Best SaaS Innovation in the Internet of Things. SingleStore Shortlisted as a Finalist in the 2020 SaaS Awards International Software Awards Program Recognizes SingleStore Managed Service for Best SaaS for Business Intelligence or Analytics and Best SaaS Innovation in the…
Read Post
Case Study13 min Read

The exchange is at the heart of our economic system. From the Rialto in Venice (fourteenth century), the Grand Bazaar in Turkey (seventeenth century), the Amsterdam Bourse in Holland (seventeenth century) and the New York Stock Exchange (twentieth century), markets have purposely been built to be a place for buyers and sellers of goods and services to meet and transact. In this blog post, we explain how we built an exchange, with SingleStore at the core. After the invention of computers, and…
Read Post
hadoop8 min Read

This blog post describes how Hadoop has moved through the famous Gartner Hype Cycle, and how it is now often combined with SQL-native solutions to deliver results. The author, Yassine Faihe, is Head of International Solution Consulting at SingleStore. This piece originally appeared, in slightly different form, on LinkedIn last December. Hadoop, which was once poised to rule the large-scale data analytics space and toll the bell for traditional data warehouses, is currently experiencing a…
Read Post
Announcement3 min Read

The following press release has been issued by SingleStore today – Wednesday, July 28th, 2020 – to announce the use of SingleStore technology for COVID-19 tracking by SingleStore partner Bahwan Cybertek (BCT). Middle Eastern Technology Company Partners With BCT on Effort to Limit COVID-19 Spread using SingleStore Joint Endeavor Highlights the Power of Digital Transformation, Massively Scalable Architecture SAN FRANCISCO – July 29, 2020 – In an effort to help a government in the Middle East to…
Read Post
Announcement1 min Read

Advisory firm Ventana Research has released a new Analyst Viewpoint piece, describing the need for “a bridge between analytics and operational systems” in AI and machine learning. Although the report does not name any specific product, such a bridge must have “scalability, elasticity and real-time processing capabilities” – a nearly perfect description of SingleStore . In this Analyst Viewpoint, David Menninger SVP and Research Director at Ventana, describes AI and ML as useful – but as also…
Read Post