SingleStore

Last updated
SingleStore
Genre RDBMS
FoundedJanuary 2011 (2011-01)
Founders
  • Eric Frenkiel
  • Nikita Shamgunov
  • Adam Prout
Headquarters
Area served
Worldwide
Number of employees
380 [1]
Website www.singlestore.com

SingleStore (formerly MemSQL) is a distributed, relational, SQL database management system [2] (RDBMS) that features ANSI SQL support, it is known for speed in data ingest, transaction processing, and query processing. [3] [4]

Contents

SingleStore stores relational data, JSON data, geospatial data, key-value vector data, and time series data. It can be run in various Linux environments, including on-premises installations, public and private cloud providers, in containers via a Kubernetes operator, or as a hosted service in the cloud known as SingleStore Helios. [5] [6]

Recent updates have included bi-directional integration with Apache Iceberg, faster vector search, enhanced full-text search, autoscaling and a ‘bring your own cloud’ deployment. [7] In its latest release, v.8.9, SingleStore added support for continuous ingest from Iceberg tables, as well as Polaris and Hive catalogs, support for foreign languages as well as n-grams in full-text search; simplified pipelines; a no-code interface that simplifies data ingestion from S3, CSV and MongoDB sources; and disk spilling that now works on right and full join, as well as writable views and vector indexes on nullable columns. [8]

History

On April 23, 2013, SingleStore launched its first generally available version of the database to the public as MemSQL. [9] Early versions supported row-oriented tables, and were optimized for cases where all data fit within main memory.

Shortly after launch, MemSQL added general support for an on-disk column-based storage format to work alongside the in-memory rowstore. [10]

On October 27, 2020, MemSQL rebranded to SingleStore to reflect a shift in focus away from exclusively in-memory workloads. [11]

In April 2023, SingleStore introduced new features to enhance real-time AI capabilities, focusing on faster data processing and more efficient AI-driven applications. [12] In May, the company introduced additional  tools aimed at enhancing generative AI (GenAI) and analytics capabilities. [13]

In July 2023, SingleStore announced a partnership with AWS to advance real-time data analytics and AI applications. [14]

In August 2023, IBM announced a collaboration with SingleStore to integrate its watsonx.ai platform for developing generative AI applications. [15]

In January 2024, SingleStore announced a new capability under the name SingleStore Kai that added MongoDB API compatibility to SingleStore allowing users to bring in data from MongoDB and run the same queries within SingleStore. [16]

In September 2024, SingleStore announced its integration with Snowflake by making SingleStore available as a Snowflake Native App in the Snowpark Container Services (SPCS) marketplace. [17] [18]

In October 2024, the company announced the acquisition of BryteFlow, a leading data integration platform. The move expanded SingleStore’s capacity to ingest data from a wide range of sources like SAP, Oracle, Salesforce, and many more, enabling customers to operationalize data from their CRM and ERP systems at scale and in real time. [19] [20] [21]

Headquartered in San Francisco, California, in June 2021 SingleStore opened an office in Raleigh, North Carolina. Its other offices include Sunnyvale, California; Seattle, Washington; London, England; Hyderabad, India; and Lisbon, Portugal. [22]

Funding

In January 2013, SingleStore announced it raised $5 million. Since then, the company has raised $318.1M from investors including Khosla Ventures, Accel, Google Ventures, Dell Capital and HPE, among others. [23] In October 2022, SingleStore closed Series F-2 and welcomed new investor Prosperity7. [24]

Funding Rounds
SeriesDateAmount (million $)Lead Investors
A20135 DVCA, IA Ventures
B201435 [5] Accel
C201636 [5] Caffeinated Capital, REV
D201830 [2] Google Ventures, Glynn Capital
EDec. 202080 [25] Insight Partners
FSept. 202180 [3] Insight Partners
GJuly 2022116 [26] Goldman Sachs Asset Management
F-2October 202230 [27] Prosperity7

Distribution formats

SingleStore San Francisco office in 2020 MemSQL San Francisco office, October 2020.JPG
SingleStore San Francisco office in 2020

SingleStore can be downloaded for free and run on Linux for systems up to 4 leaf nodes of 32 gigs RAM each; an Enterprise license is required for larger deployments and for official SingleStore support.SingleStore is also available as a managed service named SingleStore Helios, available in various regions in Google Cloud and Amazon Web Services. The underlying engine and potential system performance are identical in all distribution formats. [1]

SingleStore includes a set of tools, called SingleStore Tools, for installing, managing, and monitoring its distributed database across multiple machines. It also offers a browser-based interface, SingleStore Studio, for running queries, monitoring the database, and viewing cluster health and status. [2]

See also

Related Research Articles

A relational database (RDB) is a database based on the relational model of data, as proposed by E. F. Codd in 1970.

Structured Query Language (SQL) is a domain-specific language used to manage data, especially in a relational database management system (RDBMS). It is particularly useful in handling structured data, i.e., data incorporating relations among entities and variables.

<span class="mw-page-title-main">IBM Db2</span> Relational model database server

Db2 is a family of data management products, including database servers, developed by IBM. It initially supported the relational model, but was extended to support object–relational features and non-relational structures like JSON and XML. The brand name was originally styled as DB2 until 2017, when it changed to its present form. In the early days, it was sometimes wrongly styled as DB/2 in a false derivation from the operating system OS/2.

An XML database is a data persistence software system that allows data to be specified, and stored, in XML format. This data can be queried, transformed, exported and returned to a calling system. XML databases are a flavor of document-oriented databases which are in turn a category of NoSQL database.

The following tables compare general and technical information for a number of relational database management systems. Please see the individual products' articles for further information. Unless otherwise specified in footnotes, comparisons are based on the stable versions without any add-ons, extensions or external programs.

In relational databases, the information schema is an ANSI-standard set of read-only views that provide information about all of the tables, views, columns, and procedures in a database. It can be used as a source of the information that some databases make available through non-standard commands, such as:

 => SELECT count(table_name) FROM information_schema.tables;  count   -------  99    => SELECT column_name, data_type, column_default, is_nullable  FROM information_schema.columns WHERE table_name='alpha';  column_name | data_type | column_default | is_nullable   -------------+-----------+----------------+-------------  foo | integer | | YES  bar | character | | YES    => SELECT * FROM information_schema.information_schema_catalog_name;  catalog_name   --------------  johnd
<span class="mw-page-title-main">Michael Stonebraker</span> American computer scientist (born 1943)

Michael Ralph Stonebraker is an American computer scientist specializing in database systems. Through a series of academic prototypes and commercial startups, Stonebraker's research and products are central to many relational databases. He is also the founder of many database companies, including Ingres Corporation, Illustra, Paradigm4, StreamBase Systems, Tamr, Vertica and VoltDB, and served as chief technical officer of Informix. For his contributions to database research, Stonebraker received the 2014 Turing Award, often described as "the Nobel Prize for computing."

NoSQL is an approach to database design that focuses on providing a mechanism for storage and retrieval of data that is modeled in means other than the tabular relations used in relational databases. Instead of the typical tabular structure of a relational database, NoSQL databases house data within one data structure. Since this non-relational database design does not require a schema, it offers rapid scalability to manage large and typically unstructured data sets. NoSQL systems are also sometimes called "Not only SQL" to emphasize that they may support SQL-like query languages or sit alongside SQL databases in polyglot-persistent architectures.

Donald Haderle is an American computer scientist and IBM Fellow, best known for his work on relational database management systems (RDBMS). He led the architecture and design of DB2, one of the first commercial RDBMSs, which led to his moniker "Father of DB2." DB2 debuted on IBM's mainframe system MVS in 1983 and validated the applicability of relational databases for high performance transaction processing. With DB2 enterprises store, retrieve, and analyze their business transaction data. The cited reference describes the early technology hurdles, the shift from a monolithic architecture to a distributed architecture portable across many operating systems and the technology collaborations with IBM Research. DB2 is used in most enterprises around the world.

Clustrix, Inc. is a San Francisco-based private company founded in 2006 that developed a database management system marketed as NewSQL.

DataStax, Inc. is a real-time data for AI company based in Santa Clara, California. Its product Astra DB is a cloud database-as-a-service based on Apache Cassandra. DataStax also offers DataStax Enterprise (DSE), an on-premises database built on Apache Cassandra, and Astra Streaming, a messaging and event streaming cloud service based on Apache Pulsar. As of June 2022, the company has roughly 800 customers distributed in over 50 countries.

<span class="mw-page-title-main">SAP HANA</span> Database management system by SAP

SAP HANA is an in-memory, column-oriented, relational database management system developed and marketed by SAP SE. Its primary function as the software running a database server is to store and retrieve data as requested by the applications. In addition, it performs advanced analytics and includes extract, transform, load (ETL) capabilities as well as an application server.

Actian is an American software company headquartered in Santa Clara, California that provides analytics-related software, products, and services. The company sells database software and technology, cloud engineered systems, and data integration solutions.

Druid is a column-oriented, open-source, distributed data store written in Java. Druid is designed to quickly ingest massive quantities of event data, and provide low-latency queries on top of the data. The name Druid comes from the shapeshifting Druid class in many role-playing games, to reflect that the architecture of the system can shift to solve different types of data problems.

Google Cloud Platform (GCP) is a suite of cloud computing services offered by Google that provides a series of modular cloud services including computing, data storage, data analytics, and machine learning, alongside a set of management tools. It runs on the same infrastructure that Google uses internally for its end-user products, such as Google Search, Gmail, and Google Docs, according to Verma et al. Registration requires a credit card or bank account details.

<span class="mw-page-title-main">Databricks</span> American software company

Databricks, Inc. is a global data, analytics, and artificial intelligence (AI) company, founded in 2013 by the original creators of Apache Spark. The company provides a cloud-based platform to help enterprises build, scale, and govern data and AI, including generative AI and other machine learning models.

DBmaestro is a computer software company with sales headquartered in Boston. It markets its services for DevOps collaboration between development and IT operations teams.

MindsDB is an artificial intelligence company headquartered in California, an innovator bringing AI and Data together and is focused on enabling developers to build AI capabilities that can Reason, Plan and Orchestrate over enterprise data.

Raj Verma is the chief executive officer of SingleStore, a data technology company that allows users to transact, analyze, and search data in real time.

References

  1. 1 2 "Why Is Better Data Management Silicon Valley's New Obsession?". Inno & Tech Today. 18 April 2022. Retrieved 26 April 2022.
  2. 1 2 3 "IBM invests in SingleStore to get faster AI and analytics on distributed data" . Retrieved 2017-09-29.
  3. 1 2 Lunden, Ingrid (8 September 2021). "Real-time database platform SingleStore raises $80M more, now at a $940M valuation". TechCrunch. Retrieved 8 September 2021.
  4. ↑ "Enterprise Technology: Revenge of the Nerdiest Nerds". Business Week. Archived from the original on July 1, 2012. Retrieved 26 April 2022.
  5. 1 2 3 "BOTTOMLESS STORAGE AND PIPELINE: THE QUEST FOR A NEW DATABASE PARADIGM". Dataconomy. 20 April 2022. Retrieved 26 April 2022.
  6. ↑ "Database Firm SingleStore Scores $80M in Series F Funding". Datanami. 10 September 2021. Retrieved 26 April 2022.
  7. ↑ "SingleStore adds Iceberg integration, improved vector search | TechTarget". Search Data Management. Retrieved 2025-01-14.
  8. ↑ "SingleStore Self-Managed with IBM_8.9.x". www.ibm.com. 2024-12-19. Retrieved 2025-01-14.
  9. ↑ Hainzinger, Brittany (2020). "MemSQL Is Now SingleStore" (published 2020-11-02). Retrieved 2022-04-23.
  10. ↑ "SingleStore raises $80M for distributed SQL database". TechTarget. Retrieved 26 April 2022.
  11. ↑ "MemSQL rebrands as SingleStore". Software Development Times. 30 October 2020. Retrieved 26 April 2022.
  12. ↑ "SingleStore unveils features aimed at enabling real-time AI | TechTarget". Search Data Management. Retrieved 2024-12-13.
  13. ↑ "SingleStore update adds new tools to fuel GenAI, analytics | TechTarget". Search Data Management. Retrieved 2024-12-13.
  14. ↑ "SingleStore Partners with AWS to Advance Real-Time Data Analytics and AI Applications". BigDATAwire. Retrieved 2024-12-14.
  15. ↑ "Announcing watsonx.ai and SingleStore for generative AI applications | IBM". www.ibm.com. 2023-11-15. Retrieved 2024-12-14.
  16. ↑ "SingleStore Announces Real-time Data Platform to Further Accelerate AI, Analytics and Application Development". BigDATAwire. Retrieved 2025-01-14.
  17. ↑ "SingleStore Unicorn News: SingleStore And Snowflake Forge Real-Time AI Partnership". Private Equity Investing | Linqto Private Investing. Retrieved 2025-01-14.
  18. ↑ Allen, Kieron (2024-01-03). "SingleStore, Snowflake Help Customers Build Enterprise-Ready Generative AI Apps". Cloud Wars. Retrieved 2025-01-14.
  19. ↑ Mathews, Anshika (2024-10-04). "SingleStore Acquires BryteFlow to Strengthen Real-Time Analytics and Generative AI Capabilities". AIM Research | Artificial Intelligence Market Insights. Retrieved 2025-01-14.
  20. ↑ "SingleStore's BryteFlow Acquisition: A Strategic Move Reshaping the Real-Time Analytics Landscape". QKS Group. Retrieved 2025-01-14.
  21. ↑ "SingleStore Acquires BryteFlow to Accelerate Adoption of Real-Time Analytics". Yahoo Finance. Retrieved 2025-01-14.
  22. ↑ "SingleStore Could Double Employee Count in Raleigh". News Observer. Retrieved 26 April 2022.
  23. ↑ "Database Startup SingleStore Raises $75M". VentureBeat. 8 September 2021. Retrieved 26 April 2022.
  24. ↑ "SingleStore raises funding to fuel development, expansion | TechTarget". Search Business Analytics. Retrieved 2024-11-15.
  25. ↑ "SingleStore, formerly MemSQL, raises $80M to integrate and leverage companies' disparate data silos". TechCrunch. 8 December 2020. Retrieved 27 April 2022.
  26. ↑ "SingleStore helps enterprises better manage growing data volumes". VentureBeat. 12 July 2022. Retrieved 26 July 2022.
  27. ↑ "SingleStore raises funding to fuel development, expansion | TechTarget". Search Business Analytics. Retrieved 2024-11-15.
This page is based on this Wikipedia article
Text is available under the CC BY-SA 4.0 license; additional terms may apply.
Images, videos and audio are available under their respective licenses.