DBMS > Microsoft Access vs. SiriDB vs. Solr

System Properties Comparison Microsoft Access vs. SiriDB vs. Solr

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
Name	Microsoft Access  Xexclude from comparison	SiriDB  Xexclude from comparison	Solr  Xexclude from comparison
Description	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.)	Open Source Time Series DBMS	A widely used distributed, scalable search engine based on Apache Lucene
Primary database model	Relational DBMS	Time Series DBMS	Search engine
Secondary database models			Spatial DBMS
DB-Engines Ranking measures the popularity of database management systems Trend Chart	Score 141.82 Rank #9   Overall #6   Relational DBMS	Score 0.01 Rank #353   Overall #31   Time Series DBMS	Score 56.61 Rank #20   Overall #3   Search engines
Website	www.microsoft.com/­en-us/­microsoft-365/­access	siridb.net	lucene.apache.org/­solr
Technical documentation	developer.microsoft.com/­en-us/­access	docs.siridb.net	lucene.apache.org/­solr/­resources.html
Developer	Microsoft	Cesbit	Apache Software Foundation
Initial release	1992	2017	2006
Current release	1902 (16.0.11328.20222), March 2019		9.0.0, May 2022
License Commercial or Open Source	commercial Bundled with Microsoft Office	Open Source MIT License	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	C++	C	Java
Server operating systems	Windows Not a real database server, but making use of DLLs	Linux	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 Numeric data	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	yes	yes	yes All search fields are automatically indexed
SQL Support of SQL	yes but not compliant to any SQL standard	no	Solr Parallel SQL Interface
APIs and other access methods	ADO.NET DAO ODBC OLE DB	HTTP API	Java API RESTful HTTP/JSON API
Supported programming languages	C C# C++ Delphi Java (JDBC-ODBC) VBA Visual Basic.NET	C C++ Go Python	.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 since Access 2010 using the ACE-engine	no	Java plugins
Triggers	yes since Access 2010 using the ACE-engine	no	yes User configurable commands triggered on index changes
Partitioning methods Methods for storing different data on different nodes	none	Sharding	Sharding
Replication methods Methods for redundantly storing data on multiple nodes	none	yes	yes
MapReduce Offers an API for user-defined Map/Reduce methods	no	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	yes	no	no
Transaction concepts Support to ensure data integrity after non-atomic manipulations of data	ACID but no files for transaction logging	no	optimistic locking
Concurrency Support for concurrent manipulation of data	yes	yes	yes
Durability Support for making data persistent	yes but no files for transaction logging	yes	yes
In-memory capabilities Is there an option to define some or all structures to be held in-memory only.		yes	yes
User concepts Access control	no a simple user-level security was built in till version Access 2003	simple rights management via user accounts	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
	Microsoft Access	SiriDB	Solr
DB-Engines blog posts	MS Access drops in DB-Engines Ranking 2 May 2013, Paul Andlinger Microsoft SQL Server regained rank 2 in the DB-Engines popularity ranking 3 December 2012, Matthias Gelbmann New DB-Engines Ranking shows the popularity of database management systems 3 October 2012, Matthias Gelbmann, Paul Andlinger show all