DBMS > EXASOL vs. H2GIS vs. Solr

System Properties Comparison EXASOL vs. H2GIS vs. Solr

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
Name	EXASOL  Xexclude from comparison	H2GIS  Xexclude from comparison	Solr  Xexclude from comparison
Description	High-performance, in-memory, MPP database specifically designed for in-memory analytics.	Spatial extension of H2	A widely used distributed, scalable search engine based on Apache Lucene
Primary database model	Relational DBMS	Spatial DBMS	Search engine
Secondary database models		Relational DBMS	Spatial DBMS
DB-Engines Ranking measures the popularity of database management systems Trend Chart	Score 2.97 Rank #103   Overall #53   Relational DBMS	Score 0.03 Rank #341   Overall #4   Spatial DBMS	Score 56.61 Rank #20   Overall #3   Search engines
Website	www.exasol.com	www.h2gis.org	lucene.apache.org/­solr
Technical documentation	www.exasol.com/­resources	www.h2gis.org/­docs/­home	lucene.apache.org/­solr/­resources.html
Developer	Exasol	CNRS	Apache Software Foundation
Initial release	2000	2013	2006
Current release			9.0.0, May 2022
License Commercial or Open Source	commercial	Open Source LGPL 3.0	Open Source Apache Version 2
Cloud-based only Only available as a cloud service	no	no	no
DBaaS offerings (sponsored links) Database as a Service Providers of DBaaS offerings, please contact us to be listed.
Implementation language		Java	Java
Server operating systems			All OS with a Java VM runs as a servlet in servlet container (e.g. Tomcat, Jetty is included)
Data scheme	yes	yes	yes Dynamic Fields enables on-the-fly addition of new fields
Typing predefined data types such as float or date	yes	yes	yes supports customizable data types and automatic typing
XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.	no	no	yes
Secondary indexes	yes	yes	yes All search fields are automatically indexed
SQL Support of SQL	yes	yes	Solr Parallel SQL Interface
APIs and other access methods	.Net JDBC ODBC WebSocket		Java API RESTful HTTP/JSON API
Supported programming languages	Java Lua Python R	Java	.Net Erlang Java JavaScript any language that supports sockets and either XML or JSON Perl PHP Python Ruby Scala
Server-side scripts Stored procedures	user defined functions	yes based on H2	Java plugins
Triggers	yes	yes	yes User configurable commands triggered on index changes
Partitioning methods Methods for storing different data on different nodes	Sharding	none	Sharding
Replication methods Methods for redundantly storing data on multiple nodes		yes based on H2	yes
MapReduce Offers an API for user-defined Map/Reduce methods	yes Hadoop integration	no	spark-solr: github.com/­lucidworks/­spark-solr and streaming expressions to reduce
Consistency concepts Methods to ensure consistency in a distributed system	Immediate Consistency	Immediate Consistency	Eventual Consistency
Foreign keys Referential integrity	yes	yes	no
Transaction concepts Support to ensure data integrity after non-atomic manipulations of data	ACID	ACID	optimistic locking
Concurrency Support for concurrent manipulation of data	yes	yes, multi-version concurrency control (MVCC)	yes
Durability Support for making data persistent	yes	yes	yes
In-memory capabilities Is there an option to define some or all structures to be held in-memory only.	yes	yes	yes
User concepts Access control	Access rights for users, groups and roles according to SQL-standard	yes based on H2	yes
More information provided by the system vendor We invite representatives of system vendors to contact us for updating and extending the system information, and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.
Related products and services We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
More resources
	EXASOL	H2GIS	Solr
DB-Engines blog posts