DBMS > Altibase vs. Amazon CloudSearch vs. Solr

System Properties Comparison Altibase vs. Amazon CloudSearch vs. Solr

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
Name	Altibase  Xexclude from comparison	Amazon CloudSearch  Xexclude from comparison	Solr  Xexclude from comparison
Description	An enterprise grade, high-performance RDBMS	A hosted search engine service by Amazon with the data stored in Amazons cloud	A widely used distributed, scalable search engine based on Apache Lucene
Primary database model	Relational DBMS	Search engine	Search engine
Secondary database models			Spatial DBMS
DB-Engines Ranking measures the popularity of database management systems Trend Chart	Score 0.94 Rank #181   Overall #88   Relational DBMS	Score 2.20 Rank #120   Overall #11   Search engines	Score 55.70 Rank #20   Overall #3   Search engines
Website	altibase.com	aws.amazon.com/­cloudsearch	lucene.apache.org/­solr
Technical documentation	github.com/­ALTIBASE/­Documents/­tree/­master/­Manuals	docs.aws.amazon.com/­cloudsearch	lucene.apache.org/­solr/­resources.html
Developer	Altibase	Amazon	Apache Software Foundation
Initial release	1999	2012	2006
Current release	v7.1.0.5.3, March 2021		9.0.0, May 2022
License Commercial or Open Source	Open Source since February 2018	commercial	Open Source Apache Version 2
Cloud-based only Only available as a cloud service	no	yes	no
DBaaS offerings (sponsored links) Database as a Service Providers of DBaaS offerings, please contact us to be listed.
Implementation language	C++		Java
Server operating systems	AIX HP-UX Linux	hosted	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		yes
Secondary indexes	yes	yes all search fields are automatically indexed	yes All search fields are automatically indexed
SQL Support of SQL	ANSI SQL-92	no	Solr Parallel SQL Interface
APIs and other access methods	JDBC ODBC Proprietary protocol	HTTP API	Java API RESTful HTTP/JSON API
Supported programming languages	C C++ 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	stored procedures and stored functions	no	Java plugins
Triggers	yes	no	yes User configurable commands triggered on index changes
Partitioning methods Methods for storing different data on different nodes	Sharding	yes automatic partitioning across Amazon Search Instance as required	Sharding
Replication methods Methods for redundantly storing data on multiple nodes	yes	yes managed transparently by AWS	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	Immediate Consistency		Eventual Consistency
Foreign keys Referential integrity	yes	no	no
Transaction concepts Support to ensure data integrity after non-atomic manipulations of data	ACID	no	optimistic locking
Concurrency Support for concurrent manipulation of data	yes	yes	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
User concepts Access control	fine grained access rights according to SQL-standard	authentication via encrypted signatures	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
	Altibase	Amazon CloudSearch	Solr
DB-Engines blog posts