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. BigObject vs. Cachelot.io vs. DuckDB

System Properties Comparison Amazon SimpleDB vs. BigObject vs. Cachelot.io vs. DuckDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAmazon SimpleDB  Xexclude from comparisonBigObject  Xexclude from comparisonCachelot.io  Xexclude from comparisonDuckDB  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 ScioreAnalytic DBMS for real-time computations and queriesIn-memory caching systemAn embeddable, in-process, column-oriented SQL OLAP RDBMS
Primary database modelKey-value storeRelational DBMS infoa hierachical model (tree) can be imposedKey-value storeRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score2.11
Rank#123  Overall
#24  Key-value stores
Score0.05
Rank#329  Overall
#148  Relational DBMS
Score0.00
Rank#354  Overall
#54  Key-value stores
Score0.34
Rank#267  Overall
#123  Relational DBMS
Websiteaws.amazon.com/­simpledbbigobject.iocachelot.ioduckdb.org
Technical documentationdocs.aws.amazon.com/­simpledbdocs.bigobject.ioduckdb.org/­docs
DeveloperAmazonBigObject, Inc.
Initial release2007201520152018
Current release0.2, August 2020
License infoCommercial or Open Sourcecommercialcommercial infofree community edition availableOpen Source infoSimplified BSD LicenseOpen Source infoMIT License
Cloud-based only infoOnly available as a cloud serviceyesnonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++C++
Server operating systemshostedLinux infodistributed as a docker-image
OS X infodistributed as a docker-image (boot2docker)
Windows infodistributed as a docker-image (boot2docker)
FreeBSD
Linux
OS X
server-less
Data schemeschema-freeyesschema-freeyes
Typing infopredefined data types such as float or datenoyesnoyes
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.nonono
Secondary indexesyes infoAll columns are indexed automaticallyyesnoyes
SQL infoSupport of SQLnoSQL-like DML and DDL statementsnoyes
APIs and other access methodsRESTful HTTP APIfluentd
ODBC
RESTful HTTP API
Memcached protocolCLI Client
JDBC
Supported programming languages.Net
C
C++
Erlang
Java
PHP
Python
Ruby
Scala
.Net
C
C++
ColdFusion
Erlang
Java
Lisp
Lua
OCaml
OCaml
Perl
PHP
Python
Ruby
C
C++
Go info3rd party driver
Java
Python
R
Ruby info3rd party driver
Server-side scripts infoStored proceduresnoLuanono
Triggersnononono
Partitioning methods infoMethods for storing different data on different nodesnone infoSharding must be implemented in the applicationnonenonenone
Replication methods infoMethods for redundantly storing data on multiple nodesyesnonenonenone
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononono
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Immediate Consistency infocan be specified for read operations
nonenoneImmediate Consistency
Foreign keys infoReferential integritynoyes infoautomatically between fact table and dimension tablesnono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datano infoConcurrent data updates can be detected by the applicationnonoACID
Concurrency infoSupport for concurrent manipulation of datayesyes infoRead/write lock on objects (tables, trees)yesyes, multi-version concurrency control (MVCC)
Durability infoSupport for making data persistentyesyesnoyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesnoyes
User concepts infoAccess controlAccess rights for users and roles can be defined via the AWS Identity and Access Management (IAM)nonono

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 SimpleDBBigObjectCachelot.ioDuckDB
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

Recent citations in the news

Database as a Service Market to Witness Huge Growth by 2030 | Azure, Amazon, Zoho – Queen Anne and Mangolia News
10 May 2022, Queen Anne and Mangolia News

Amazon Simple Database Service (SimpleDB)
21 March 2022, TechTarget

Why AWS Keeps It Simple
13 December 2021, Datanami

Amazon DynamoDB Serves Trillions Of Requests Per Month While Counterpart SimpleDB Is No Longer A Listed Product On AWS
13 November 2013, TechCrunch

Amazon Goes Back to the Future With 'NoSQL' Database
19 January 2012, WIRED

provided by Google News

New CWI spin-off company DuckDB Labs: Solutions for fast database analytics
14 July 2021, Centrum Wiskunde & Informatica (CWI)

Apache Arrow 6 Improves Support For R and Rust
22 November 2021, iProgrammer

Meet TQP: The First Query Processor to Run On Tensor Computation Runtimes Delivers up to 20x Speedups Over CPU-Only Systems
4 March 2022, Synced

14 Open Source SQL Parsers
8 October 2021, hackernoon.com

provided by Google News

Job opportunities

Platform & Systems Architect - Remote
TTEC, Englewood, CO

Senior Business Development Manager
Amazon Web Services, Inc., Chicago, IL

Software Development Engineer II
Amazon.com Services LLC, Austin, TX

Principal Global Partner Success Manager - Healthcare/Life Sciences
Amazon Web Services, Inc., New York, NY

WW Head for Telecom - Global Systems Integrators
Amazon Web Services, Inc., Dallas, TX

Sr. Data Engineer
Solidigm, Folsom, CA

Enterprise Architect (BE MFG)
Solidigm, Folsom, CA

Data Engineer
Solidigm, Folsom, CA

Software Engineer - Compute Kernel (Rust)
Singularity Data, Remote

jobs by Indeed



Share this page

Featured Products

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Neo4j logo

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

Redis logo

The world’s most loved real‑time data platform.
Try free

Vertica logo

Vertica Accelerator. The fastest analytics and machine learning, delivered as SaaS, with automated setup, administration, and management. Free trial.

The definitive guide for Cassandra

Imagine What You Could Do if Scalability Wasn‘t a Problem!
Download the Cassandra e-book for free!

Present your product here