DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Amazon SimpleDB vs. Graph Engine vs. Informix vs. PlanetScale vs. Solr

System Properties Comparison Amazon SimpleDB vs. Graph Engine vs. Informix vs. PlanetScale vs. Solr

Editorial information provided by DB-Engines
NameAmazon SimpleDB  Xexclude from comparisonGraph Engine infoformer name: Trinity  Xexclude from comparisonInformix  Xexclude from comparisonPlanetScale  Xexclude from comparisonSolr  Xexclude from comparison
DescriptionHosted simple database service by Amazon, with the data stored in the Amazon Cloud. infoThere is an unrelated product called SimpleDB developed by Edward ScioreA distributed in-memory data processing engine, underpinned by a strongly-typed RAM store and a general distributed computation engineA secure embeddable database from IBM, positioned besides IBM Db2 as a relatively low-cost product optimized for OLTP and Internet of Things dataScalable, distributed, serverless MySQL database platform built on top of VitessA widely used distributed, scalable search engine based on Apache Lucene
Primary database modelKey-value storeGraph DBMS
Key-value store
Relational DBMS infoSince Version 12.10 support for JSON/BSON datatypes compatible with MongoDBRelational DBMSSearch engine
Secondary database modelsDocument store
Spatial DBMS
Time Series DBMS infowith Informix TimeSeries Extension
Document store
Spatial DBMS
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.88
Rank#133  Overall
#23  Key-value stores
Score0.67
Rank#232  Overall
#21  Graph DBMS
#34  Key-value stores
Score17.12
Rank#34  Overall
#21  Relational DBMS
Score1.49
Rank#155  Overall
#72  Relational DBMS
Score41.02
Rank#24  Overall
#3  Search engines
Websiteaws.amazon.com/­simpledbwww.graphengine.iowww.ibm.com/­products/­informixplanetscale.comsolr.apache.org
Technical documentationdocs.aws.amazon.com/­simpledbwww.graphengine.io/­docs/­manualinformix.hcldoc.com
www.ibm.com/­support/­knowledgecenter/­SSGU8G/­welcomeIfxServers.html
planetscale.com/­docssolr.apache.org/­resources.html
DeveloperAmazonMicrosoftIBM, HCL Technologies infoEffective May 1st, 2017, HCL took on development, technical support, and product management teams, and works jointly with IBM on product strategy, marketing, and sales.PlanetScaleApache Software Foundation
Initial release20072010198420202006
Current release14.10.FC5, November 20209.6.1, May 2024
License infoCommercial or Open SourcecommercialOpen Source infoMIT Licensecommercial infofree developer edition availablecommercialOpen Source infoApache Version 2
Cloud-based only infoOnly available as a cloud serviceyesnonoyesno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation language.NET and CC, C++ and JavaGoJava
Server operating systemshosted.NETAIX
HP-UX
Linux
macOS
Solaris
Windows
Docker
Linux
macOS
All OS with a Java VM inforuns as a servlet in servlet container (e.g. Tomcat, Jetty is included)
Data schemeschema-freeyesyesyesyes infoDynamic Fields enables on-the-fly addition of new fields
Typing infopredefined data types such as float or datenoyesyes infoSince Version 12.10 support for JSON/BSON datatypesyesyes infosupports customizable data types and automatic typing
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.noyes
Secondary indexesyes infoAll columns are indexed automaticallyyesyesyes infoAll search fields are automatically indexed
SQL infoSupport of SQLnonoyesyes infowith proprietary extensionsSolr Parallel SQL Interface
APIs and other access methodsRESTful HTTP APIRESTful HTTP APIJDBC
JSON API infoMongoDB compatible
MQTT (Message Queue Telemetry Transport)
ODBC
RESTful HTTP API
ADO.NET
JDBC
MySQL protocol
ODBC
Java API
RESTful HTTP/JSON API
Supported programming languages.Net
C
C++
Erlang
Java
PHP
Python
Ruby
Scala
C#
C++
F#
Visual Basic
.Net
C
C++
Java
JavaScript (Node.js)
PHP
Python
Ruby
Ada
C
C#
C++
D
Delphi
Eiffel
Erlang
Haskell
Java
JavaScript (Node.js)
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl
.Net
Erlang
Java
JavaScript
any language that supports sockets and either XML or JSON
Perl
PHP
Python
Ruby
Scala
Server-side scripts infoStored proceduresnoyesyesyes infoproprietary syntaxJava plugins
Triggersnonoyesyesyes infoUser configurable commands triggered on index changes
Partitioning methods infoMethods for storing different data on different nodesnone infoSharding must be implemented in the applicationhorizontal partitioningShardingShardingSharding
Replication methods infoMethods for redundantly storing data on multiple nodesyesMulti-source replication
Source-replica replication
Multi-source replication
Source-replica replication
yes
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononospark-solr: github.com/­lucidworks/­spark-solr and streaming expressions to reduce
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Immediate Consistency infocan be specified for read operations
Immediate ConsistencyEventual Consistency across shards
Immediate Consistency within a shard
Eventual Consistency
Foreign keys infoReferential integritynonoyesyes infonot for MyISAM storage engineno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datano infoConcurrent data updates can be detected by the applicationnoACIDACID at shard leveloptimistic locking
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes infotable locks or row locks depending on storage engineyes
Durability infoSupport for making data persistentyesoptional: either by committing a write-ahead log (WAL) to the local persistent storage or by dumping the memory to a persistent storageyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesyesyes
User concepts infoAccess controlAccess rights for users and roles can be defined via the AWS Identity and Access Management (IAM)Users with fine-grained authentication, authorization, and auditing controlsUsers with fine-grained authorization concept infono user groups or rolesyes

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
Amazon SimpleDBGraph Engine infoformer name: TrinityInformixPlanetScaleSolr
DB-Engines blog posts

The popularity of cloud-based DBMSs has increased tenfold in four years
7 February 2017, Matthias Gelbmann

Amazon - the rising star in the DBMS market
3 August 2015, Matthias Gelbmann

show all

Elasticsearch replaced Solr as the most popular search engine
12 January 2016, Paul Andlinger

Enterprise Search Engines almost double their popularity in the last 12 months
2 July 2014, Paul Andlinger

The DB-Engines ranking includes now search engines
4 February 2013, Paul Andlinger

show all

Recent citations in the news

A Place for Everything – Amazon SimpleDB
14 December 2007, AWS Blog

Amazon DynamoDB Serves Trillions Of Requests Per Month While Counterpart SimpleDB Is No Longer A Listed ...
12 November 2013, TechCrunch

Hands-on Tutorial for Getting Started with Amazon SimpleDB
28 May 2010, Packt Hub

Amazon SimpleDB Expands Web Services
16 December 2007, Data Center Knowledge

An Overview of Amazon Web Services - Cloud Application Architectures [Book]
22 September 2018, O'Reilly Media

provided by Google News

Trinity
30 October 2010, Microsoft

Open source Microsoft Graph Engine takes on Neo4j
13 February 2017, InfoWorld

Aerospike Is Now a Graph Database, Too
21 June 2023, Datanami

The graph analytics landscape 2019 - DataScienceCentral.com
27 February 2019, Data Science Central

IBM releases Graph, a service that can outperform SQL databases
27 July 2016, GeekWire

provided by Google News

IBM Buys Informix for $1 Billion
1 June 2024, ITPro Today

IBM Informix: A key part of IBM’s hybrid cloud and AI strategy
11 January 2024, IBM

Unlock the value of your Informix data for advanced analytics and AI with watsonx.data
24 April 2024, IBM

IBM Informix review: What you need to know about the software
12 December 2022, TechRepublic

Cisco Systems, Informix and Softbank Ventures Make Investment in Internet Video Leader VXtreme
13 August 2022, Cisco Newsroom

provided by Google News

PlanetScale ends free tier bid, sheds staff in profitability bid
11 March 2024, The Register

PlanetScale forks MySQL to add vector support
3 October 2023, TechCrunch

PlanetScale Named to Fortune 2023 Best Small Workplaces
31 August 2023, Business Wire

PlanetScale forks MySQL to add vector support
3 October 2023, Yahoo Movies Canada

How to Migrate to PlanetScale's Serverless Database
14 October 2021, The New Stack

provided by Google News

Solr Network Launches Groundbreaking Solana Token Creator
28 May 2024, AccessWire

SOLR-led walkout demands better conditions for Compass workers
27 February 2024, Daily Northwestern

(SOLR) Proactive Strategies
27 May 2024, Stock Traders Daily

Have Insiders Been Buying Solar Alliance Energy Inc. (CVE:SOLR) Shares?
25 May 2024, Yahoo Movies UK

Solana Token Creator by Solr Network Becomes the Fastest-Growing Platform on Solana
16 May 2024, WICZ

provided by Google News



Share this page

Featured Products

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

Present your product here