Exasol

Exasol is an analytics database management software company. Its product is called Exasol, an in-memory, column-oriented, relational database management system[1]

Exasol AG
TypePublic (Aktiengesellschaft)
FWB: EXL
IndustryEnterprise software & Database management & Data warehousing & OLAP
Founded2000
HeadquartersNuremberg, Germany
ProductsIn-memory database Exasol, ExaAppliance, ExaCloud
Websitewww.exasol.com

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.[2] Exasol holds the top position in absolute performance as well as price/performance.[3]

The database company used to be included as a niche player in Gartner's "Magic Quadrant for Data Warehouse Database Management Systems". It has not been included since 2016.[4] The 2021 "Gartner Magic Quadrant for Cloud Database Management Systems" includes Exasol as a niche player again.[5]

Products

Exasol 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).[1][6]

Exasol is designed to run in memory, although data is persistently stored on disk following the ACID rules. Exasol supports the SQL Standard 2003 via interfaces like ODBC, JDBC or ADO.NET. A software development kit (SDK) is provided for native integration.[6] For online analytical processing (OLAP) applications, the Multidimensional Expressions (MDX) extension of SQL is supported via OLE DB for OLAP and XML for Analysis.

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 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.[1][6]

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

See also

References
  1. Monash, C. : "Exasol technical briefing”, DBMS2, August 16, 2008
  2. TPC Website, As of 2-Mar-2017 Archived 2017-02-25 at the Wayback Machine
  3. Transaction Processing Performance Council : "TPC-H is an ad-hoc, decision support benchmark", TPC Benchmarks Archived 2008-12-18 at the Wayback Machine
  4. Mark A. Beyer, Donald Feinberg, Roxane Edjlali,Merv Adrian : "Magic Quadrant for Data Warehouse Database Management Systems", 31. January 2013, Gartner Research
  5. "Magic Quadrant for Cloud Database Management Systems". Gartner. Retrieved 2022-01-01.
  6. Howard, P. : "InDetail”, Bloor Research, August, 2008
This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.