EXASOL
Encyclopedia
EXASOL is an analytic database management software company. Its product is called EXASolution, a RDBMS.
EXASOL regularly publishes results of the TPC-H benchmark.
The name EXASOL is derived from EXA (Prefix in the System of units
denoting 1018 or 1 000 000 000 000 000 000) and SOL
(Speed of light).
model, on each node the identical code is executed simultaneously. The data is stored in a column-oriented way and proprietory InMemory compression methods are used. The company claims that tuning efforts are not necessary since the database includes some kind of automatic self-optimization (like automatic indices, table statistics, and distributing of data).
Furthermore, EXASolution is designed to run In Memory, although data is persistently stored on disc following the ACID rules. EXASolution supports the SQL Standard 2003
and can be integrated via standard interfaces like ODBC, JDBC or ADO.NET
. Additionally, a SDK is provided for native integration.
The license model is based on the allocated RAM for the database software (per GB RAM) and independent to the physical hardware. Customers gain the maximal performance if their compressed active data fits into that licenced RAM, but it can also be much larger.
EXASOL has implemented a so called Cluster Operating System (EXACluster OS). It is based on standard Linux and provides functionality for parallel programs. It can be compared to Virtualization, but instead of virtualizing the hardware of a single server, it virtualizes a cluster of nodes to a single one. Cluster management algorithms are provided like failover mechanisms or automatic cluster installation.
EXASOL regularly publishes results of the TPC-H benchmark.
The name EXASOL is derived from EXA (Prefix in the System of units
Si
Si, si, or SI may refer to :- Measurement, mathematics and science :* International System of Units , the modern international standard version of the metric system...
denoting 1018 or 1 000 000 000 000 000 000) and SOL
Speed of light
The speed of light in vacuum, usually denoted by c, is a physical constant important in many areas of physics. Its value is 299,792,458 metres per second, a figure that is exact since the length of the metre is defined from this constant and the international standard for time...
(Speed of light).
Products
EXASolution is a parallelized relational DBMS which runs on a cluster of standard hardware servers. Following the SPMDSPMD
In computing, SPMD is a technique employed to achieve parallelism; it is a subcategory of MIMD. Tasks are split up and run simultaneously on multiple processors with different input in order to obtain results faster. SPMD is the most common style of parallel programming...
model, on each node the identical code is executed simultaneously. The data is stored in a column-oriented way and proprietory InMemory compression methods are used. The company claims that tuning efforts are not necessary since the database includes some kind of automatic self-optimization (like automatic indices, table statistics, and distributing of data).
Furthermore, EXASolution is designed to run In Memory, although data is persistently stored on disc following the ACID rules. EXASolution supports the SQL Standard 2003
SQL:2003
SQL:2003 is the fifth revision of the SQL database query language. The latest revision of the standard is SQL:2008.-Summary:The SQL:2003 standard makes minor modifications to all parts of SQL:1999 , and officially introduces a few new features such as:* XML-related features * Window functions* the...
and can be integrated via standard interfaces like ODBC, JDBC or ADO.NET
ADO.NET
ADO.NET is a set of computer software components that programmers can use to access data and data services. It is a part of the base class library that is included with the Microsoft .NET Framework. It is commonly used by programmers to access and modify data stored in relational database systems,...
. Additionally, a SDK is provided for native integration.
The license model is based on the allocated RAM for the database software (per GB RAM) and independent to the physical hardware. Customers gain the maximal performance if their compressed active data fits into that licenced RAM, but it can also be much larger.
EXASOL has implemented a so called Cluster Operating System (EXACluster OS). It is based on standard Linux and provides functionality for parallel programs. It can be compared to Virtualization, but instead of virtualizing the hardware of a single server, it virtualizes a cluster of nodes to a single one. Cluster management algorithms are provided like failover mechanisms or automatic cluster installation.
See also
- Shared nothing architectureShared nothing architectureA shared nothing architecture is a distributed computing architecture in which each node is independent and self-sufficient, and there is no single point of contention across the system...
- Column-oriented database
- In Memory Database