DB-EnginesExtremeDB: the first and only COTS deterministic embedded database management system for mission- and safety-critical hard real-time applicationsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Amazon SimpleDB vs. GeoSpock vs. Impala

System Properties Comparison Amazon SimpleDB vs. GeoSpock vs. Impala

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAmazon SimpleDB  Xexclude from comparisonGeoSpock  Xexclude from comparisonImpala  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 ScioreSpatial and temporal data processing engine for extreme data scaleAnalytic DBMS for Hadoop
Primary database modelKey-value storeRelational DBMSRelational DBMS
Secondary database modelsTime Series DBMSDocument store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score2.19
Rank#117  Overall
#22  Key-value stores
Score0.28
Rank#273  Overall
#125  Relational DBMS
Score18.46
Rank#39  Overall
#24  Relational DBMS
Websiteaws.amazon.com/­simpledbgeospock.comwww.cloudera.com/­products/­open-source/­apache-hadoop/­impala.html
Technical documentationdocs.aws.amazon.com/­simpledbdocs.geospock.com/­Content/­Home.htmdocs.cloudera.com/­documentation/­enterprise/­latest/­topics/­impala.html
DeveloperAmazonGeoSpockCloudera
Initial release20072013
Current release2.0, September 20194.0.0, July 2021
License infoCommercial or Open SourcecommercialcommercialOpen Source infoApache Version 2
Cloud-based only infoOnly available as a cloud serviceyesyesno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJava, JavascriptC++
Server operating systemshostedhostedLinux
Data schemeschema-freeyesyes
Typing infopredefined data types such as float or datenoyesyes
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.nono
Secondary indexesyes infoAll columns are indexed automaticallytemporal, categoricalyes
SQL infoSupport of SQLnoANSI SQL for query only (using Presto)SQL-like DML and DDL statements
APIs and other access methodsRESTful HTTP APIJDBCJDBC
ODBC
Supported programming languages.Net
C
C++
Erlang
Java
PHP
Python
Ruby
Scala
All languages supporting JDBC/ODBC
Server-side scripts infoStored proceduresnonoyes infouser defined functions and integration of map-reduce
Triggersnonono
Partitioning methods infoMethods for storing different data on different nodesnone infoSharding must be implemented in the applicationAutomatic shardingSharding
Replication methods infoMethods for redundantly storing data on multiple nodesyesselectable replication factor
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonoyes infoquery execution via MapReduce
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Immediate Consistency infocan be specified for read operations
Immediate ConsistencyEventual Consistency
Foreign keys infoReferential integritynonono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datano infoConcurrent data updates can be detected by the applicationnono
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.nono
User concepts infoAccess controlAccess rights for users and roles can be defined via the AWS Identity and Access Management (IAM)Access rights for users can be defined per tableAccess rights for users, groups and roles infobased on Apache Sentry and Kerberos

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 SimpleDBGeoSpockImpala
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

Introducing Amazon SimpleDB
18 August 2010, Database Journal

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

AWS, Microsoft and Google should retire these cloud services
2 June 2020, TechTarget

Source: Google To Launch BigTable As Web Service
5 April 2008, TechCrunch

provided by Google News

How GeoSpock is supercharging geospatial analytics
23 February 2021, ComputerWeekly.com

GeoSpock Raises Additional $5.4M in Strategic Funding
2 October 2020, FinSMEs

GeoSpock Launches Pioneering New Spatial Big Data Platform
26 February 2019, Business Wire

GeoSpock joins Tomorrow Street to accelerate next-generation database technology adoption
28 October 2020, RealWire

GeoSpock and Tamoco Partner to Scale Location Data Insights
10 July 2018, Business Wire

provided by Google News

Cloudera Boosts Hadoop App Development On Impala
10 November 2014, InformationWeek

Cloudera’s Impala brings Hadoop to SQL and BI
25 October 2012, ZDNet

Harnessing Data In Motion
10 January 2022, insideHPC

Cloudera aims to bring real-time queries to Hadoop, big data
24 October 2012, ZDNet

Unravel Data Adds Native Support for Impala and Kafka
29 June 2017, insideBIGDATA

provided by Google News

Job opportunities

Software Development Engineer
Amazon.com Services LLC, Seattle, WA

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

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

Global Strategic Alliances Leader – AWS
Amazon Web Services, Inc., Dallas, TX

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

Tableau Developer
Capgemini, Chicago, IL

Teradata Developer
TAA Solutions LLC, Remote

Data Architect
Telnet Inc, Texas

Tableau Administrator
MAXIMUS, Remote

Data Engineer
Harmonia Holdings Group, LLC, Washington, DC

jobs by Indeed



Share this page

Featured Products

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

Couchbase logo

The modern database for enterprise applications. Build fast. Scale Big. Save more.
Get started today.

Neo4j logo

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

Datastax Astra logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Present your product here