MemSQL

MemSQL is a distributed, in-memory, SQL database management system.wikipedia
38 Related Articles

Skip list

skip listsindexable skiplistjump list
More specifically, MemSQL implements lock-free hash tables and lock-free skip lists in memory for fast random access to data.
MemSQL uses skip lists as its prime indexing structure for its database technology.

In-memory database

in-memoryin-memory database management systemIMDB
MemSQL is a distributed, in-memory, SQL database management system.

Relational database management system

RDBMSrelational database management systemsrelational database
It is a relational database management system (RDBMS).

Compiler

compiledcompilerscompile
It compiles Structured Query Language (SQL) into machine code, via termed code generation.

SQL

Structured Query LanguageSQL DatabasesWikibook SQL
MemSQL is a distributed, in-memory, SQL database management system. It compiles Structured Query Language (SQL) into machine code, via termed code generation.

Just-in-time compilation

JITjust-in-time compilerjust-in-time
MemSQL combines lock-free data structures and a just-in-time compilation (JIT) to process highly volatile workloads.

Hash table

hash tableshashhashes
More specifically, MemSQL implements lock-free hash tables and lock-free skip lists in memory for fast random access to data.

Central processing unit

CPUprocessorprocessors
Executing pre-compiled query plans removes interpretation along hot code paths, providing highly efficient code paths that minimize the number of central processing unit (CPU) instructions required to process SQL statements.

MySQL

M'''ySQLMySQL 4.1MySQL 4.x
MemSQL is wire-compatible with MySQL.

Open Database Connectivity

ODBCdatabase driverdriver
This means that applications can connect to MemSQL through MySQL clients and drivers, as well as standard Open Database Connectivity (ODBC) and Java Database Connectivity (JDBC) connectors.

Java Database Connectivity

JDBCJava Database Connectivity (JDBC)JDBC API
This means that applications can connect to MemSQL through MySQL clients and drivers, as well as standard Open Database Connectivity (ODBC) and Java Database Connectivity (JDBC) connectors.

JSON

JavaScript Object Notation (JSON)JSON-likedictionary
In addition to MySQL syntax and functionality, MemSQL can also store columns in JSON format, and supports geospatial datatypes and operations.

Geographic data and information

geospatialgeographic datageoinformation
In addition to MySQL syntax and functionality, MemSQL can also store columns in JSON format, and supports geospatial datatypes and operations.

Data definition language

DDLdata definition DDL
The format used is determined by the user at DDL time (i.e. when the table is created).

Online transaction processing

OLTPOLTP queriesOLTP workloads
Rowstores are optimized for singleton or small insert, update or delete queries and are most closely associated with OLTP (transactional) use cases.

Online analytical processing

OLAPmultidimensional databasemulti-dimensional database
Columnstores are optimized for complex select queries, typically associated with OLAP (analytics) use cases.

Apache Spark

SparkApache Spark SQLMLlib
Starting with MemSQL 4.1, launched in September 2015, MemSQL gives users the ability to install Apache Spark as part of the MemSQL cluster, and use Spark as an ETL tool to import data into MemSQL.

Extract, transform, load

ETLETL (Extract-Transform-Load)extract, transform and load
Starting with MemSQL 4.1, launched in September 2015, MemSQL gives users the ability to install Apache Spark as part of the MemSQL cluster, and use Spark as an ETL tool to import data into MemSQL.

Database

database management systemdatabasesdatabase systems
Database management system