Samiksha Jaiswal

EXASOL

Updated on
Share on FacebookTweet on TwitterShare on LinkedIn
Website  www.exasol.com
Founded  2000
Headquarters  Nuremberg
Type of business  Private
EXASOL httpsd7umqicpi7263cloudfrontnetimgproductb
Industry  Enterprise Software & Database Management & Data Warehousing & OLAP
Products  In-memory database EXASolution, EXAAppliance, EXACloud
Profiles
TwitterLinkedInYouTube

Installation of a single node version of exasol 4 2 on a laptop


EXASOL is an analytic database management software company. Its product is called EXASolution, an in-memory, column-oriented, relational database management system

Contents

Since 2008 EXASOL led the Transaction Processing Performance Council's TPC-H benchmark for analytical scenarios, in all data volume-based categories 100 GB, 300 GB, 1 TB, 3 TB, 10 TB, 30 TB and 100 TB. EXASolution holds the top position in absolute performance as well as price/performance.

The high-speed database company is acknowledged by Gartner in its "Magic Quadrant for Data Warehouse Database Management Systems" as the only German database vendor besides SAP.

Dramatically speed up your tableau visualizations with exasol


Products

EXASolution is a parallelized relational database management system (RDBMS) which runs on a cluster of standard computer hardware servers. Following the SPMD model, on each node the identical code is executed simultaneously. The data is stored in a column-oriented way and proprietary in-memory 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).

EXASolution is designed to run in memory, although data is persistently stored on disk 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. For OLAP applications, the MDX extension of SQL is supported via ODBO and XMLA.

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 licensed 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 a runtime environment and storage layer for the RDBMS, employing a proprietary, cluster-based file system (ExaStorage). Cluster management algorithms are provided like failover mechanisms or automatic cluster installation.

In-database analytics is supported. EXASolution integrates support to run Lua, Java, Python and GNU R scripts in parallel inside user defined functions (UDFs) within the DBMS' SQL pipeline.

References

EXASOL Wikipedia


Similar Topics
Tess of the Storm Country (1922 film)
Gary Bartz
Joe Stevenson
Topics