The task of collecting a set of values to return a single value.
A node that routes queries to the leaf nodes, aggregates intermediate results, and sends the results back to a client.
An algorithm used by SingleStoreDB that allows columnstore segments to maintain sort order (as close as possible), while data is being ingested or updated
A node that can be promoted to the role of Master Aggregator in the event that the existing Master Aggregator’s host fails.
An industrial compiler to produce highly efficient machine code that enables low-level optimizations, which are not possible when executing queries via interpretation alone.
Common Table Expression
A named temporary result set that exists within the scope of a single statement and that can be referred to later within that statement, possibly multiple times.
A user that resides in the workspace.
A situation when two or more transactions mutually hold and request a table write that the other transaction needs.
An operation or function that will always produce the same result for the same input values.
Globbing is commonly used in data ingest to read or select a subset of files based on a naming pattern.
Hadoop Distributed File System
A distributed file system by Apache Hadoop.
A data structure optimized for fast equality lookups by a key.
A set of data items that are related to each other by hierarchical relationships.
A hardware or virtual machine which holds the aggregator and leaf nodes that comprise a SingleStoreDB cluster.
Holds the information or metadata for all the databases in a cluster.
SELECT statement embedded in the
WITH clause of another
SELECT statement that creates a temporary table that is operated on by the outer query.
An in-place change in a database refers to modifying the data or schema of the database without requiring a full data migration or recreation of the database.
An open standard file format and data interchange format that uses human-readable text to store and transmit data objects consisting of attribute–value pairs and arrays.
JSON Web Key Sets
A set of keys containing public keys that can be used to authenticate any JWT.
JSON Web Token
An open, industry standard typically used for authorization and information exchange.
A node that stores a subset of a cluster’s data.
A specialized node that’s responsible for cluster monitoring and failover.
Information about a database's schema, access to the database, storage, built-in programs, and or other information about the data such as date created, file size, and etc.
A SingleStoreDB server.
Non-uniform memory access
A computer memory design used in multiprocessing.
Organizing data to appear similar across all records and fields.
A data storage architecture that manages data as objects, as opposed to other storage architectures like file systems which manages data as a file hierarchy, and block storage which manages data as blocks within sectors and tracks.
Online Analytical Processing
A data processing type that is designed to analyze data dimensions concurrently.
Online Transaction Processing
A data processing type that executes a number of transactions occurring concurrently.
Allows shared access to workspaces and related resources within a company or group.
An organization user resides within the “control plane” of SingleStoreDB and can perform those actions that are available on the Cloud Portal, such as manage organization users, manage clusters, and run SQL queries against cluster data via the Cloud Portal SQL editor.
A partition contains a subset (a shard) of a database’s data.
Persisting the name of a file
Persisting the name of a file is storing the file name so it can be retrieved and used again later in a program or system.
A feature that continuously loads data as it arrives from external sources.
An application that allows you to design, manage, and monitor your SingleStoreDB instances.
A user that can log into the Cloud Portal and access portal services.
Patterns or structures in query.
A computer's short-term memory.
Ensures redundancy in a cluster.
A process where metadata stored for columnstore segments is used to determine where a segment can match a filter queried at execution time.
An isolation level provides the strictest transaction isolation.
A subset of a databases's data.
A solid-state drive is a storage device.
Single sign-on, where one can log into SingleStoreDB via Azure AD, Okta, and PingOne.
A data structure optimized for ordered data that allows for queries to quickly seek data by binary searching.
SQL Surface Area
The amount of components installed and or configuration options that are enabled.
A type of database partitioning that divides a database into smaller more easily manageable parts.
SingleStoreDB Cloud’s version of a cluster.
A collection of SingleStoreDB aggregator and leaf nodes.
Last modified: October 30, 2023