DB-EnginesInfluxDB download bannerEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Amazon SimpleDB vs. FoundationDB vs. SAP SQL Anywhere vs. Snowflake vs. Splunk

System Properties Comparison Amazon SimpleDB vs. FoundationDB vs. SAP SQL Anywhere vs. Snowflake vs. Splunk

Editorial information provided by DB-Engines
NameAmazon SimpleDB  Xexclude from comparisonFoundationDB  Xexclude from comparisonSAP SQL Anywhere infoformerly called Adaptive Server Anywhere  Xexclude from comparisonSnowflake  Xexclude from comparisonSplunk  Xexclude from comparison
Created as commercial project in 2013, FoundationDB has been acquired by Apple in March 2015 and was withdrawn from the market. As a consequence, the product was removed from the DB-Engines ranking. In April 2018, Apple open-sourced FoundationDB and it therefore reappears in the ranking.
DescriptionHosted simple database service by Amazon, with the data stored in the Amazon Cloud. infoThere is an unrelated product called SimpleDB developed by Edward ScioreOrdered key-value store. Core features are complimented by layers.RDBMS database and synchronization technologies for server, desktop, remote office, and mobile environmentsCloud-based data warehousing service for structured and semi-structured dataAnalytics Platform for Big Data
Primary database modelKey-value storeDocument store infosupported via specific layer
Key-value store
Relational DBMS infosupported via specific SQL-layer
Relational DBMSRelational DBMSSearch engine
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score2.53
Rank#111  Overall
#21  Key-value stores
Score1.07
Rank#164  Overall
#27  Document stores
#29  Key-value stores
#82  Relational DBMS
Score6.30
Rank#61  Overall
#35  Relational DBMS
Score15.53
Rank#37  Overall
#22  Relational DBMS
Score87.66
Rank#13  Overall
#2  Search engines
Websiteaws.amazon.com/­simpledbwww.foundationdb.orgwww.sap.com/­products/­sql-anywhere.htmlwww.snowflake.comwww.splunk.com
Technical documentationdocs.aws.amazon.com/­simpledbapple.github.io/­foundationdbhelp.sap.com/­sql-anywheredocs.snowflake.net/­manuals/­index.htmldocs.splunk.com/­Documentation/­Splunk
DeveloperAmazonFoundationDBSAP infoformerly SybaseSnowflake Computing Inc.Splunk Inc.
Initial release20072013199220142003
Current release6.2.28, November 202017, July 2015
License infoCommercial or Open SourcecommercialOpen Source infoApache 2.0commercialcommercialcommercial infoLimited free edition and free developer edition available
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 languageC++
Server operating systemshostedLinux
OS X
Windows
AIX
HP-UX
Linux
OS X
Solaris
Windows
hostedLinux
OS X
Solaris
Windows
Data schemeschema-freeschema-free infosome layers support schemasyesyes infosupport of semi-structured data formats (JSON, XML, Avro)yes
Typing infopredefined data types such as float or datenono infosome layers support typingyesyesyes
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.yesyesyes
Secondary indexesyes infoAll columns are indexed automaticallynoyesyes
SQL infoSupport of SQLnosupported in specific SQL layer onlyyesyesno infoSplunk Search Processing Language for search commands
APIs and other access methodsRESTful HTTP APIADO.NET
HTTP API
JDBC
ODBC
CLI Client
JDBC
ODBC
HTTP REST
Supported programming languages.Net
C
C++
Erlang
Java
PHP
Python
Ruby
Scala
.Net
C
C++
Go
Java
JavaScript infoNode.js
PHP
Python
Ruby
Swift
C
C#
C++
Delphi
Java
JavaScript (Node.js)
Perl
PHP
Python
Ruby
JavaScript (Node.js)
Python
C#
Java
JavaScript
PHP
Python
Ruby
Server-side scripts infoStored proceduresnoin SQL-layer onlyyes, in C/C++, Java, .Net or Perluser defined functionsyes
Triggersnonoyesno infosimilar concept for controling cloud resourcesyes
Partitioning methods infoMethods for storing different data on different nodesnone infoSharding must be implemented in the applicationShardingnoneyesSharding
Replication methods infoMethods for redundantly storing data on multiple nodesyesyesSource-replica replication infoDatabase mirroringyesMulti-source replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonononoyes
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Immediate Consistency infocan be specified for read operations
Linearizable consistencyImmediate ConsistencyImmediate ConsistencyEventual Consistency
Foreign keys infoReferential integritynoin SQL-layer onlyyesyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datano infoConcurrent data updates can be detected by the applicationACIDACIDACIDno infoA 'Transaction' in Splunk has a different meaning: grouping related events into a single one for later searching
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
Durability infoSupport for making data persistentyesyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesnono
User concepts infoAccess controlAccess rights for users and roles can be defined via the AWS Identity and Access Management (IAM)nofine grained access rights according to SQL-standardUsers with fine-grained authorization concept, user roles and pluggable authenticationAccess rights for users and roles

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
3rd partiesCData: Connect to Big Data & NoSQL through standard Drivers.
» more

General SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.
» more

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
Amazon SimpleDBFoundationDBSAP SQL Anywhere infoformerly called Adaptive Server AnywhereSnowflakeSplunk
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

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

show all

Recent citations in the news

NoSQL Databases Market 2020: Key Players with Product Particulars, Applications, Market Size & Forecast till 2027 : Accumulo, Aerospike, Amazon SimpleDB, Azure Table, Cassandra, BigTable, Couchbase Server, CouchDB, Dynamo DB, Elasticsearch, Flink, HBase, HPCC Systems, Hypertable, MongoDB, NeDB, Oracle NoSQL, Riak, Redis
21 January 2021, NeighborWebSJ

Trending News: Database as a Service Market Overview and Forecast Report 2020-2026 – Top players: Azure, Amazon, Zoho, Big Query, SimpleDB, etc. | InForGrowth
21 January 2021, NeighborWebSJ

NoSQL Databases Market Research Report by Key Drivers Analysis and Future Trends Forecast to 2026|Accumulo, Aerospike, Amazon SimpleDB, Azure Table, Cassandra
20 January 2021, Murphy's Hockey Law

NoSQL Databases Market Is Booming Worldwide | Accumulo, Aerospike, Flink, HBase – Murphy's Hockey Law
16 January 2021, Murphy's Hockey Law

2021 Database as a Service Market Size: by Application, Type, Trend, Revenue, Overview, Growth and Forecasts-2025 – Reviewindependent
25 January 2021, Reviewindependent

provided by Google News

FoundationDB, a very interesting NoSQL database owned by Apple, is now an open-source project
19 April 2018, GeekWire

Apple’s FoundationDB open sources the database layer behind CloudKit
14 January 2019, 9to5Mac

Apple Acquires Durable Database Company FoundationDB
24 March 2015, TechCrunch

FoundationDB's Record Layer Supports Relational Database Semantics, Schema Management and Indexing
10 February 2019, InfoQ.com

How choosing the unexpected helped shape Snowflake
20 November 2020, SiliconANGLE News

provided by Google News

SAP SQL Anywhere
3 April 2018, TechTarget

SAP gives SQL Anywhere a new IoT injection
16 July 2015, Computerworld

Best Database Management Software 2021
14 July 2020, Datamation

SAP IoT products: How do they work with ERP and big data?
28 December 2015, TechTarget

SAP HANA Dresses for Internet of Things and Predictive Analytics – Cloud Times
17 June 2015, CloudTimes

provided by Google News

Down 25% From December Highs, Is Snowflake Stock A Buy?
25 January 2021, Forbes

Can Oracle Beat AWS and Snowflake in the Cloud Database Wars?
9 January 2021, Cloud Wars

Oracle Database 21c Takes on AWS, Microsoft in Clash of the Titans
22 January 2021, Cloud Wars

A Detailed Look At Snowflake; Rich Valuation Keeps Us On The Sidelines
21 January 2021, Seeking Alpha

Better Buy: Snowflake vs. Datadog
22 January 2021, Motley Fool

provided by Google News

Job opportunities

Proposal Manager, NPO
Amazon Web Services, Inc., Arlington, VA

Principle Global Partner Success Manager - Healthcare/Life Sciences
Amazon Web Services, Inc., Remote

Global Alliance Manager - Security
Amazon Web Services, Inc., Santa Clara, CA

PDM - DevOps
Amazon Web Services, Inc., Broomfield, CO

Sr. Proposal Manager, National Security
Amazon Web Services, Inc., Herndon, VA

Engineering Manager
PEX, Remote

Site Reliability Engineer
PEX, Remote

Senior Software Engineer
PEX, Remote

Senior Frontend Engineer
PEX, Remote

Staff Data Scientist
Branch, Redwood City, CA

Database Administrator
ECR Software Corporation, United States

IT Leader- Retirement Plan Services
CBIZ, Cleveland, OH

IT Leader-Retirement Plan Services
CBIZ, Kansas City, MO

Data Analytics Mentor
Pathrise, Remote

Business Intelligence/ ETL Technical SME I
Farmers Insurance Group, Remote

data protection SMe
Capgemini, New York, NY

Data Analyst
OverlayAnalytics, Remote

Data Analyst
Red Lambda, Remote

jobs by Indeed




Share this page

Featured Products

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 5 GB free..

Neo4j logo

Get your free copy of the new O'Reilly book Graph Algorithms with 20+ examples for
machine learning, graph analytics and more.

Couchbase logo

SQL + JSON + NoSQL.
Power, flexibility & scale.
All open source.
Get started now.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Vertica logo

The fastest unified analytical warehouse at extreme scale with in-database Machine Learning. Try Vertica for free with no time limit.

Present your product here