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 > GeoSpock vs. HBase vs. Spark SQL vs. SQream DB vs. STSdb

System Properties Comparison GeoSpock vs. HBase vs. Spark SQL vs. SQream DB vs. STSdb

Editorial information provided by DB-Engines
NameGeoSpock  Xexclude from comparisonHBase  Xexclude from comparisonSpark SQL  Xexclude from comparisonSQream DB  Xexclude from comparisonSTSdb  Xexclude from comparison
DescriptionSpatial and temporal data processing engine for extreme data scaleWide-column store based on Apache Hadoop and on concepts of BigTableSpark SQL is a component on top of 'Spark Core' for structured data processinga GPU-based, columnar RDBMS for big data analytics workloadsKey-Value Store with special method for indexing infooptimized for high performance using a special indexing method
Primary database modelRelational DBMSWide column storeRelational DBMSRelational DBMSKey-value store
Secondary database modelsTime Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.13
Rank#307  Overall
#141  Relational DBMS
Score42.45
Rank#26  Overall
#2  Wide column stores
Score23.72
Rank#35  Overall
#21  Relational DBMS
Score0.55
Rank#228  Overall
#109  Relational DBMS
Score0.00
Rank#357  Overall
#56  Key-value stores
Websitegeospock.comhbase.apache.orgspark.apache.org/­sqlsqream.comgithub.com/­STSSoft/­STSdb4
Technical documentationdocs.geospock.com/­Content/­Home.htmhbase.apache.orgspark.apache.org/­docs/­latest/­sql-programming-guide.htmldocs.sqream.com
DeveloperGeoSpockApache Software Foundation infoApache top-level project, originally developed by PowersetApache Software FoundationSQream TechnologiesSTS Soft SC
Initial release2008201420142011
Current release2.0, September 20192.3.4, January 20213.3.0, June 20222021.2, September 20214.0.8, September 2015
License infoCommercial or Open SourcecommercialOpen Source infoApache version 2Open Source infoApache 2.0commercialOpen Source infoGPLv2, commercial license available
Cloud-based only infoOnly available as a cloud serviceyesnononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJava, JavascriptJavaScalaC++, CUDA, Haskell, Java, ScalaC#
Server operating systemshostedLinux
Unix
Windows infousing Cygwin
Linux
OS X
Windows
LinuxWindows
Data schemeyesschema-free, schema definition possibleyesyesyes
Typing infopredefined data types such as float or dateyesoptions to bring your own types, AVROyesyes, ANSI Standard SQL Typesyes infoprimitive types and user defined types (classes)
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 indexestemporal, categoricalnonoyesno
SQL infoSupport of SQLANSI SQL for query only (using Presto)noSQL-like DML and DDL statementsyesno
APIs and other access methodsJDBCJava API
RESTful HTTP API
Thrift
JDBC
ODBC
.Net
JDBC
ODBC
.NET Client API
Supported programming languagesC
C#
C++
Groovy
Java
PHP
Python
Scala
Java
Python
R
Scala
C++
Java
JavaScript (Node.js)
Python
C#
Java
Server-side scripts infoStored proceduresnoyes infoCoprocessors in Javanouser defined functions in Pythonno
Triggersnoyesnonono
Partitioning methods infoMethods for storing different data on different nodesAutomatic shardingShardingyes, utilizing Spark Corehorizontal and vertical partitioningnone
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replication
Source-replica replication
nonenonenone
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyesnono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency or Eventual ConsistencyImmediate Consistency
Foreign keys infoReferential integritynonononono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoSingle row ACID (across millions of columns)noACIDno
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.noyesno
User concepts infoAccess controlAccess rights for users can be defined per tableAccess Control Lists (ACL) for RBAC, integration with Apache Ranger for RBAC & ABACnono
More information provided by the system vendor
GeoSpockHBaseSpark SQLSQream DBSTSdb
Specific characteristicsDue to exponentially growing data, organizations today are facing slowdowns, with...
» more
Competitive advantagesMuch faster time to insight Analyze significantly more data Achieve previously unobtainable...
» more
Typical application scenariosWhat can you do with 100x faster SQL analytics? Better and more timely decision making...
» more
Key customersSome of our customers include: LG Uplus, AIS (Advanced Info Service), ACL Mobile,...
» more
News

Who to blame for air pollution? The code we write
24 July 2022

The Power-Computing Weapon That Is Fighting Climate Change
24 July 2022

Sustainable business: 5 tips to boost code efficiency
12 July 2022

Women in Tech: “Positions and opportunities in the technology field are endless”
7 June 2022

Minimizing the carbon footprint of data analysis, maximizing sustainability for data centers
7 June 2022

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 partiesSQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.
» more

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

More resources
GeoSpockHBaseSpark SQLSQream DBSTSdb
DB-Engines blog posts

Cloudera's HBase PaaS offering now supports Complex Transactions
11 August 2021,  Krishna Maheshwari (sponsor) 

Why is Hadoop not listed in the DB-Engines Ranking?
13 May 2013, Paul Andlinger

show all

Recent citations in the news

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

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

Cambridge-based data analytics startup GeoSpock lands €4.6 million
2 October 2020, EU-Startups

UK-based database GeoSpock bags $5.4m, to expand into
6 October 2020, Tech in Asia

GeoSpock Confirms Commitment to Japanese Market with New Office Opening in Tokyo, Japan
10 March 2019, Geospatial World

provided by Google News

Top 10 Hadoop Analytics Tools Used in Big Data Projects in 2022
31 July 2022, Analytics Insight

Leading US Telecommunications Players benefit from OTSI's business transformation capabilities
5 August 2022, CXOToday.com

Review: HBase is massively scalable -- and hugely complex
31 March 2014, InfoWorld

B.Tech Graduates Vacancy at Urban Company
3 August 2022, StudyCafe

HBase: The database big data left behind
6 May 2016, InfoWorld

provided by Google News

Data chess game: Databricks vs. Snowflake, part 1
25 July 2022, VentureBeat

Top 10 Big Data Architect Jobs to Apply for in August 2022
2 August 2022, Analytics Insight

A Complete Guide to PySpark Data Frames
13 July 2022, Built In

DataCamp Courses, Skill Tracks and Pricing – Forbes Advisor
12 July 2022, Forbes

Spark Gets Closer Hooks to Pandas, SQL with Version 3.2
26 October 2021, Datanami

provided by Google News

SQream Technologies raises $39.4 million for GPU-accelerated databases
24 June 2020, VentureBeat

Accelerated Databases In The Fast Lane
25 June 2020, The Next Platform

Stretching GPU Database Performance With Flash Arrays
26 February 2019, The Next Platform

In A Parallel Universe, Data Warehouses Run On GPUs
4 October 2018, The Next Platform

Beyond the Delta: Compression is a Must for Big Data
8 October 2018, insideBIGDATA

provided by Google News

Job opportunities

Cloudera Admin
Apptad Inc, Remote

Developer
Wipro Limited, Dallas, GA

BigData Spark/ Scala Developer
FIIDUS, Remote

Hadoop Admin
AR Val services, Remote

Hadoop Administrator
Winwire Technologies, Remote

Data Engineer
Rangam Consultants Inc., Remote

Data Analyst I
Western Alliance Bank, Phoenix, AZ

Data Analyst
Harvey Nash, Remote

Data Engineer - 100% Remote
HealthFirst, New York, NY

Healthcare ETL Developer
HealthVerity, United States

jobs by Indeed



Share this page

Featured Products

Vertica logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Neo4j logo

The right graph database.
Not a graph add-on.
Free forever.
Start solving today

Redis logo

The world’s most loved real‑time data platform.
Try 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.

Present your product here