SingleStore

From Wikipedia, the free encyclopedia

Template:Short description

Page Module:Message box/ambox.css has no content.Page Template:Multiple issues/styles.css has no content.

Page Module:Infobox/styles.css has no content.Page Template:Infobox company/styles.css has no content.

SingleStore
ISINScript error: No such module "WikidataIB".
IndustryScript error: No such module "WikidataIB".
GenreRDBMS
PredecessorScript error: No such module "WikidataIB".
IncorporatedScript error: No such module "WikidataIB".
FoundedScript error: No such module "WikidataIB".
FoundersScript error: No such module "WikidataIB".
DefunctScript error: No such module "WikidataIB".
SuccessorScript error: No such module "WikidataIB".
Headquarters
Area served
Worldwide
RevenueScript error: No such module "WikidataIB".
Script error: No such module "WikidataIB".
Script error: No such module "WikidataIB".
Total assetsScript error: No such module "WikidataIB".
Number of employees
Script error: No such module "WikidataIB".
ParentScript error: No such module "WikidataIB".
Websitewww.singlestore.com

Script error: No such module "Check for conflicting parameters".Script error: No such module "Check for deprecated parameters".

SingleStore (formerly MemSQL) is a distributed, relational, SQL database management system[2] (RDBMS) that features ANSI SQL support, designed to handle data ingest, transaction processing, and query processing.[3][4]

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]

In the 2020s, SingleStore introduced updates related to data lake integration, search capabilities, and deployment flexibility, including support for Apache Iceberg and expanded cloud deployment options.[7][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. This design was based on the idea that the cost of RAM would continue to decrease exponentially over time, in a trend similar to Moore's law. This would eventually allow most use cases for database systems to store their data exclusively in 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 announced updates to its platform, with a focus on data processing and support for artificial intelligence, including tools for Generative AI (GenAI), and analytics workloads.[12][13]

In July 2023, SingleStore announced a partnership with Amazon Web Services (AWS) related to real-time data analytics and AI applications.[14]

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

In January 2024, SingleStore introduced a feature named SingleStore Kai, which provides compatibility with the MongoDB API.[16][17] In September 2024, the company announced availability as a Snowflake Native App within the Snowpark Container Services (SPCS) marketplace.[18][19]

In October 2024, the company announced the acquisition of BryteFlow, a data integration platform.[20][21][22] Following the acquisition, data ingest capabilities were incorporated into the product under the name "SingleStore Flow".[23]

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.[24]

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.[25] In October 2022, SingleStore closed Series F-2 and welcomed new investor Prosperity7.[26]

Funding Rounds
Series Date Amount (million $) Lead Investors
A 2013 5 DVCA, IA Ventures
B 2014 35[5] Accel
C 2016 36[5] Caffeinated Capital, REV
D 2018 30[2] Google Ventures, Glynn Capital
E Dec. 2020 80[27] Insight Partners
F Sept. 2021 80[3] Insight Partners
G July 2022 116[28] Goldman Sachs Asset Management
F-2 October 2022 30[26] Prosperity7

Architecture

Row and column table formats

SingleStore can store data in either row-oriented tables ("rowstores") or column-oriented tables ("columnstores"). The format used is determined by the user when creating the table.[29]

Rowstore tables, as the name implies, store information in row format, which is the traditional data format used by RDBMS systems. Rowstores are optimized for singleton or small insert, update, or delete queries and are most closely associated with OLTP (transactional) use cases. Data for rowstore tables is stored completely in-memory, making random reads fast, with snapshots and transaction logs persisted to disk. Columnstores are optimized for complex SELECT queries, typically associated with OLAP (analytics) and data warehousing use cases.[30]

Indexing

Rather than the traditional B-tree index, SingleStore rowstores use skiplists optimized for fast, lock-free processing in memory. Columnstores store data in sorted segments, in order to maximize on-disk compression and achieve fast ordered scans. SingleStore also supports using hash indexes as secondary indexes to speed up certain queries.[31][32]

Distributed architecture

A SingleStore database is distributed across many nodes, which may be cloud-based servers or commodity machines. Data is stored in partitions on leaf nodes, and users connect to aggregator nodes.[33][34] A single piece of software is installed for SingleStore aggregator and leaf nodes; administrators designate each machine’s role in the cluster during setup. An aggregator node is responsible for receiving SQL queries, breaking them up across leaf nodes, and aggregating results back to the client. A leaf node stores SingleStore data and processes queries from the aggregator(s). All communication between aggregators and leaf nodes is done over the network using SQL. SingleStore uses hash partitioning to distribute data uniformly across the number of leaf nodes.[35]

Durability

Durability for the in-memory rowstore is implemented with a write-ahead log and snapshots, similar to checkpoints. With default settings, as soon as a transaction is acknowledged in memory, the database will asynchronously write the transaction to disk as fast as the disk allows.[36]

Replication

A SingleStore cluster can be configured in "High Availability" (HA) mode, where every data partition is automatically created with primary and replica partitions on two separate leaf nodes. In HA mode, aggregators send transactions to the primary  partitions, which then send logs to the secondary partitions. In the event of an unexpected primary failure, the replica partitions take over as primary partitions, in a fully online operation with no downtime.[37]

In 2024, SingleStore added support for Apache Iceberg, a table format used in data lake architectures.[38] The release also included updates to vector search, full-text search, autoscaling, and deployment options.[39][40][41]

Distribution formats

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. The system is also available as a managed cloud service named SingleStore Helios, which is available on public cloud platforms including Google Cloud and Amazon Web Services. The underlying engine is identical in all distribution formats.[1]

The system includes tools for installation, management, and monitoring of database clusters across multiple machines; as well as a web-based interface for querying and administration.

See also

References

Page Template:Reflist/styles.css has no content.

  1. ^ a b Page Module:Citation/CS1/styles.css has no content."Why Is Better Data Management Silicon Valley's New Obsession?". Inno & Tech Today. 18 April 2022. Retrieved 26 April 2022.
  2. ^ a b Page Module:Citation/CS1/styles.css has no content."IBM invests in SingleStore to get faster AI and analytics on distributed data". Retrieved 2017-09-29.
  3. ^ a b Page Module:Citation/CS1/styles.css has no content.Lunden, Ingrid (8 September 2021). "Real-time database platform SingleStore raises $80M more, now at a $940M valuation". TechCrunch. Retrieved 8 September 2021.
  4. ^ Page Module:Citation/CS1/styles.css has no content."Enterprise Technology: Revenge of the Nerdiest Nerds". Business Week. Archived from the original on July 1, 2012. Retrieved 26 April 2022.
  5. ^ a b c Page Module:Citation/CS1/styles.css has no content."BOTTOMLESS STORAGE AND PIPELINE: THE QUEST FOR A NEW DATABASE PARADIGM". Dataconomy. 20 April 2022. Retrieved 26 April 2022.
  6. ^ Page Module:Citation/CS1/styles.css has no content."Database Firm SingleStore Scores $80M in Series F Funding". Datanami. 10 September 2021. Retrieved 26 April 2022.
  7. ^ Page Module:Citation/CS1/styles.css has no content."SingleStore adds Iceberg integration, improved vector search | TechTarget". Search Data Management. Retrieved 2025-01-14.
  8. ^ Page Module:Citation/CS1/styles.css has no content."SingleStore Self-Managed with IBM_8.9.x". www.ibm.com. 2024-12-19. Retrieved 2025-01-14.
  9. ^ Page Module:Citation/CS1/styles.css has no content.Hainzinger, Brittany (2020). "MemSQL Is Now SingleStore" (published 2020-11-02). Retrieved 2022-04-23.
  10. ^ Page Module:Citation/CS1/styles.css has no content."SingleStore raises $80M for distributed SQL database". TechTarget. Retrieved 26 April 2022.
  11. ^ Page Module:Citation/CS1/styles.css has no content."MemSQL rebrands as SingleStore". Software Development Times. 30 October 2020. Retrieved 26 April 2022.
  12. ^ Page Module:Citation/CS1/styles.css has no content."SingleStore unveils features aimed at enabling real-time AI | TechTarget". Search Data Management. Retrieved 2024-12-13.
  13. ^ Page Module:Citation/CS1/styles.css has no content."SingleStore update adds new tools to fuel GenAI, analytics | TechTarget". Search Data Management. Retrieved 2024-12-13.
  14. ^ Page Module:Citation/CS1/styles.css has no content."SingleStore Partners with AWS to Advance Real-Time Data Analytics and AI Applications". BigDATAwire. Retrieved 2024-12-14.
  15. ^ Page Module:Citation/CS1/styles.css has no content."Announcing watsonx.ai and SingleStore for generative AI applications | IBM". www.ibm.com. 2023-11-15. Retrieved 2024-12-14.
  16. ^ Page Module:Citation/CS1/styles.css has no content."SingleStore Announces Real-time Data Platform to Further Accelerate AI, Analytics and Application Development". BigDATAwire. Retrieved 2025-01-14.
  17. ^ Page Module:Citation/CS1/styles.css has no content.News, DATAVERSITY (2024-01-25). "SingleStore Unveils New Capabilities for Real-Time Data Platform". DATAVERSITY. Retrieved 2025-01-28. {{cite web}}: |last= has generic name (help)
  18. ^ Page Module:Citation/CS1/styles.css has no content."SingleStore Unicorn News: SingleStore And Snowflake Forge Real-Time AI Partnership". Private Equity Investing | Linqto Private Investing. Retrieved 2025-01-14.
  19. ^ Page Module:Citation/CS1/styles.css has no content.Allen, Kieron (2024-01-03). "SingleStore, Snowflake Help Customers Build Enterprise-Ready Generative AI Apps". Cloud Wars. Retrieved 2025-01-14.
  20. ^ Page Module:Citation/CS1/styles.css has no content.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.
  21. ^ Page Module:Citation/CS1/styles.css has no content."SingleStore's BryteFlow Acquisition: A Strategic Move Reshaping the Real-Time Analytics Landscape". QKS Group. Retrieved 2025-01-14.
  22. ^ Page Module:Citation/CS1/styles.css has no content."SingleStore Acquires BryteFlow to Accelerate Adoption of Real-Time Analytics". Yahoo Finance. Retrieved 2025-01-14.
  23. ^ Page Module:Citation/CS1/styles.css has no content."Load Data with SingleStore Flow · SingleStore Helios Documentation". docs.singlestore.com. Retrieved 2026-03-25.
  24. ^ Page Module:Citation/CS1/styles.css has no content."SingleStore Could Double Employee Count in Raleigh". News Observer. Retrieved 26 April 2022.
  25. ^ Page Module:Citation/CS1/styles.css has no content."Database Startup SingleStore Raises $75M". VentureBeat. 8 September 2021. Retrieved 26 April 2022.
  26. ^ a b Page Module:Citation/CS1/styles.css has no content."SingleStore raises funding to fuel development, expansion | TechTarget". Search Business Analytics. Retrieved 2024-11-15.
  27. ^ Page Module:Citation/CS1/styles.css has no content."SingleStore, formerly MemSQL, raises $80M to integrate and leverage companies' disparate data silos". TechCrunch. 8 December 2020. Retrieved 27 April 2022.
  28. ^ Page Module:Citation/CS1/styles.css has no content."SingleStore helps enterprises better manage growing data volumes". VentureBeat. 12 July 2022. Retrieved 26 July 2022.
  29. ^ Page Module:Citation/CS1/styles.css has no content.Brys, Dirk (2022-10-19). "SingleStore - the one ring to rule them all?". sAInce.io. Retrieved 2025-02-20.
  30. ^ Page Module:Citation/CS1/styles.css has no content."Online analytical processing (OLAP) - Azure Architecture Center". learn.microsoft.com. Retrieved 2025-02-20.
  31. ^ Page Module:Citation/CS1/styles.css has no content."Cloud-Native Transactions and Analytics in SingleStore | PDF | Databases | Replication (Computing)". Scribd. Retrieved 2025-03-04.
  32. ^ Page Module:Citation/CS1/styles.css has no content.Xing, Lu; Venkata Sai Pavan Kumar Vadrevu; Aref, Walid G. (2025). "The Ubiquitous Skiplist: A Survey of What Cannot be Skipped About the Skiplist and its Applications in Data Systems". ACM Computing Surveys. 57 (11): 1–37. arXiv:2403.04582. doi:10.1145/3736754.
  33. ^ Page Module:Citation/CS1/styles.css has no content."SingleStore cluster components | Deploying SingleStore Database on Dell PowerFlex 3.6 | Dell Technologies Info Hub". infohub.delltechnologies.com (in svenska). Retrieved 2025-03-04.
  34. ^ Page Module:Citation/CS1/styles.css has no content."What is SingleStore Database? Concepts and Importance | Decube". www.decube.io. Retrieved 2025-03-04.
  35. ^ Page Module:Citation/CS1/styles.css has no content."Introduction to MemSQL | DBMS 2 : DataBase Management System Services". www.dbms2.com. Archived from the original on 2024-07-10. Retrieved 2025-03-04.
  36. ^ Page Module:Citation/CS1/styles.css has no content."A blazingly fast database in a data-driven world". IBM. Retrieved 2018-01-19.
  37. ^ Page Module:Citation/CS1/styles.css has no content."Bottomless Storage and Pipeline: The Quest for a New Database Paradigm - Dataconomy". 2022-04-20. Retrieved 2025-03-12.
  38. ^ Page Module:Citation/CS1/styles.css has no content."SingleStore adds Iceberg support and speedier vector search". SiliconANGLE. 2024-06-26. Retrieved 2025-03-12.
  39. ^ Page Module:Citation/CS1/styles.css has no content."SingleStoreDB joins the Apache Iceberg bandwagon". InfoWorld. Retrieved 2025-03-12.
  40. ^ Page Module:Citation/CS1/styles.css has no content.Azhar, Ali (2024-06-28). "SingleStore Turbocharges Data Lakehouses with Iceberg Support and Faster Vector Search". BigDATAwire. Retrieved 2025-03-12.
  41. ^ Page Module:Citation/CS1/styles.css has no content.Mellor, Chris (2024-07-22). "SingleStore: We do vectors and you don't need knowledge graphs". Blocks and Files. Retrieved 2025-03-12.

Lua error in mw.title.lua at line 404: bad argument #2 to 'title.new' (unrecognized namespace name 'Portal').

Retrieved from "https://cosmopedia.co/index.php?title=SingleStore&oldid=11381218"