DBMS > Axibase vs. Microsoft Access vs. Solr

System Properties Comparison Axibase vs. Microsoft Access vs. Solr

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
Name	Axibase  Xexclude from comparison	Microsoft Access  Xexclude from comparison	Solr  Xexclude from comparison
Description	Scalable TimeSeries DBMS based on HBase with integrated rule engine and visualization	Microsoft Access combines a backend RDBMS (JET / ACE Engine) with a GUI frontend for data manipulation and queries. The Access frontend is often used for accessing other datasources (DBMS, Excel, etc.)	A widely used distributed, scalable search engine based on Apache Lucene
Primary database model	Time Series DBMS	Relational DBMS	Search engine
Secondary database models			Spatial DBMS
DB-Engines Ranking measures the popularity of database management systems Trend Chart	Score 0.21 Rank #285   Overall #24   Time Series DBMS	Score 145.09 Rank #9   Overall #6   Relational DBMS	Score 55.70 Rank #20   Overall #3   Search engines
Website	axibase.com/­docs/­atsd/­finance	www.microsoft.com/­en-us/­microsoft-365/­access	lucene.apache.org/­solr
Technical documentation		developer.microsoft.com/­en-us/­access	lucene.apache.org/­solr/­resources.html
Developer	Axibase Corporation	Microsoft	Apache Software Foundation
Initial release	2013	1992	2006
Current release	15585	1902 (16.0.11328.20222), March 2019	9.0.0, May 2022
License Commercial or Open Source	commercial Community Edition (single node) is free, Enterprise Edition (distributed) is paid	commercial Bundled with Microsoft Office	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	C++	Java
Server operating systems	Linux	Windows Not a real database server, but making use of DLLs	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 short, integer, long, float, double, decimal, string	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		yes
Secondary indexes	no	yes	yes All search fields are automatically indexed
SQL Support of SQL	SQL-like query language	yes but not compliant to any SQL standard	Solr Parallel SQL Interface
APIs and other access methods	JDBC Proprietary protocol (Network API) RESTful HTTP API	ADO.NET DAO ODBC OLE DB	Java API RESTful HTTP/JSON API
Supported programming languages	Go Java PHP Python R Ruby	C C# C++ Delphi Java (JDBC-ODBC) VBA Visual Basic.NET	.Net Erlang Java JavaScript any language that supports sockets and either XML or JSON Perl PHP Python Ruby Scala
Server-side scripts Stored procedures	yes	yes since Access 2010 using the ACE-engine	Java plugins
Triggers	yes	yes since Access 2010 using the ACE-engine	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	Source-replica replication	none	yes
MapReduce Offers an API for user-defined Map/Reduce methods	yes	no	spark-solr: github.com/­lucidworks/­spark-solr and streaming expressions to reduce
Consistency concepts Methods to ensure consistency in a distributed system			Eventual Consistency
Foreign keys Referential integrity	no	yes	no
Transaction concepts Support to ensure data integrity after non-atomic manipulations of data	no	ACID but no files for transaction logging	optimistic locking
Concurrency Support for concurrent manipulation of data	yes	yes	yes
Durability Support for making data persistent	yes	yes but no files for transaction logging	yes
In-memory capabilities Is there an option to define some or all structures to be held in-memory only.			yes
User concepts Access control		no a simple user-level security was built in till version Access 2003	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
	Axibase	Microsoft Access	Solr
DB-Engines blog posts