DB-EnginesExtremeDB: is hard real time possible with a dbms?English
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Heroic vs. InfinityDB vs. Kinetica vs. Microsoft SQL Server vs. Oracle

System Properties Comparison Heroic vs. InfinityDB vs. Kinetica vs. Microsoft SQL Server vs. Oracle

Editorial information provided by DB-Engines
NameHeroic  Xexclude from comparisonInfinityDB  Xexclude from comparisonKinetica  Xexclude from comparisonMicrosoft SQL Server  Xexclude from comparisonOracle  Xexclude from comparison
DescriptionTime Series DBMS built at Spotify based on Cassandra or Google Cloud Bigtable, and ElasticSearchA Java embedded Key-Value Store which extends the Java Map interfaceFully vectorized database across both GPUs and CPUsMicrosofts flagship relational DBMSWidely used RDBMS
Primary database modelTime Series DBMSKey-value storeRelational DBMSRelational DBMSRelational DBMS
Secondary database modelsDocument store
Graph DBMS
Spatial DBMS
Document store
Graph DBMS infowith Oracle Spatial and Graph
RDF store infowith Oracle Spatial and Graph
Spatial DBMS infowith Oracle Spatial and Graph
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.21
Rank#290  Overall
#26  Time Series DBMS
Score0.04
Rank#326  Overall
#51  Key-value stores
Score0.74
Rank#202  Overall
#97  Relational DBMS
Score944.81
Rank#3  Overall
#3  Relational DBMS
Score1266.89
Rank#1  Overall
#1  Relational DBMS
Websitespotify.github.io/­heroic/­#!/­indexboilerbay.comwww.kinetica.comwww.microsoft.com/­en-us/­sql-serverwww.oracle.com/­database
Technical documentationspotify.github.io/­heroic/­#!/­docs/­overviewboilerbay.com/­infinitydb/­manualwww.kinetica.com/­docsdocs.microsoft.com/­en-US/­sql/­sql-serverdocs.oracle.com/­en/­database
DeveloperSpotifyBoiler Bay Inc.KineticaMicrosoftOracle
Initial release20142002201219891980
Current release4.07.1, August 2021SQL Server 2019, November 201919c, February 2019
License infoCommercial or Open SourceOpen Source infoApache 2.0commercialcommercialcommercial inforestricted free version is availablecommercial inforestricted free version is available
Cloud-based only infoOnly available as a cloud servicenonononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaJavaC, C++C++C and C++
Server operating systemsAll OS with a Java VMLinuxLinux
Windows
AIX
HP-UX
Linux
OS X
Solaris
Windows
z/OS
Data schemeschema-freeyes infonested virtual Java Maps, multi-value, logical ‘tuple space’ runtime Schema upgradeyesyesyes infoSchemaless in JSON and XML columns
Typing infopredefined data types such as float or dateyesyes infoall Java primitives, Date, CLOB, BLOB, huge sparse arraysyesyesyes
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.nononoyesyes
Secondary indexesyes infovia Elasticsearchno infomanual creation possible, using inversions based on multi-value capabilityyesyesyes
SQL infoSupport of SQLnonoSQL-like DML and DDL statementsyesyes infowith proprietary extensions
APIs and other access methodsHQL (Heroic Query Language, a JSON-based language)
HTTP API
Access via java.util.concurrent.ConcurrentNavigableMap Interface
Proprietary API to InfinityDB ItemSpace (boilerbay.com/­docs/­ItemSpaceDataStructures.htm)
JDBC
ODBC
RESTful HTTP API
ADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)
JDBC
ODBC
ODP.NET
Oracle Call Interface (OCI)
Supported programming languagesJavaC++
Java
JavaScript (Node.js)
Python
C#
C++
Delphi
Go
Java
JavaScript (Node.js)
PHP
Python
R
Ruby
Visual Basic
C
C#
C++
Clojure
Cobol
Delphi
Eiffel
Erlang
Fortran
Groovy
Haskell
Java
JavaScript
Lisp
Objective C
OCaml
Perl
PHP
Python
R
Ruby
Scala
Tcl
Visual Basic
Server-side scripts infoStored proceduresnonouser defined functionsTransact SQL, .NET languages, R, Python and (with SQL Server 2019) JavaPL/SQL infoalso stored procedures in Java possible
Triggersnonoyes infotriggers when inserted values for one or more columns fall within a specified rangeyesyes
Partitioning methods infoMethods for storing different data on different nodesShardingnoneShardingtables can be distributed across several files (horizontal partitioning); sharding through federationSharding, horizontal partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesyesnoneSource-replica replicationyes, but depending on the SQL-Server EditionMulti-source replication
Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonononono infocan be realized in PL/SQL
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Immediate Consistency
Immediate Consistency infoREAD-COMMITTED or SERIALIZEDImmediate Consistency or Eventual Consistency depending on configurationImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynono infomanual creation possible, using inversions based on multi-value capabilityyesyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACID infoOptimistic locking for transactions; no isolation for bulk loadsnoACIDACID infoisolation level can be parameterized
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.nonoyes infoGPU vRAM or System RAMyesyes infoVersion 12c introduced the new option 'Oracle Database In-Memory'
User concepts infoAccess controlnoAccess rights for users and roles on table levelfine grained access rights according to SQL-standardfine grained access rights according to SQL-standard
More information provided by the system vendor
HeroicInfinityDBKineticaMicrosoft SQL ServerOracle
Specific characteristicsNative and fully vectorized database across both GPUs and CPUs, with memory first...
» more
Competitive advantagesBest in class geospatial and temporal analytics. Lockless architecture provides real-time...
» more
Typical application scenariosAny application requiring (1) real time insights, (2) time series analysis (3) geospatial...
» more
Key customersCitibank, US Air Force, Softbank, OVO, Telkomsel, USPS, 2 of the top 3 US Telcos,...
» more
Market metricsThe largest IoT deployment in the world, NORAD, runs on Kinetica.
» more
Licensing and pricing modelsAlways Free Tier in the Cloud, Pay-As-You-Go Consumption Based Pricing, and Portable...
» more

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 partiesDBHawk: Secure access to SQL, NoSQL and Cloud databases with an all-in-one solution.
» more

SQLFlow: 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

Navicat Monitor is a safe, simple and agentless remote server monitoring tool for SQL Server and many other database management systems.
» more

Navicat for SQL Server gives you a fully graphical approach to database management and development.
» more

Fivetran: Quickly and easily centralize your on-premise and cloud databases.
» more
Fivetran: Quickly and easily centralize your on-premise and cloud databases.
» more

SQLFlow: 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

Navicat for Oracle improves the efficiency and productivity of Oracle developers and administrators with a streamlined working environment.
» more

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

More resources
HeroicInfinityDBKineticaMicrosoft SQL ServerOracle
DB-Engines blog posts

MySQL is the DBMS of the Year 2019
3 January 2020, Matthias Gelbmann, Paul Andlinger

The struggle for the hegemony in Oracle's database empire
2 May 2017, Paul Andlinger

Microsoft SQL Server is the DBMS of the Year
4 January 2017, Matthias Gelbmann, Paul Andlinger

show all

MySQL is the DBMS of the Year 2019
3 January 2020, Matthias Gelbmann, Paul Andlinger

The struggle for the hegemony in Oracle's database empire
2 May 2017, Paul Andlinger

Architecting eCommerce Platforms for Zero Downtime on Black Friday and Beyond
25 November 2016, Tony Branson (guest author)

show all

Recent citations in the news

Bank Replaces Hundreds of Spark Streaming Nodes with Kinetica
6 January 2022, Datanami

GPU Database Market Prediction To 2026, Growth Factors – HeteroDB, Blazegraph, Graphistry, SQream, Jedox, etc – Construction News Portal
27 January 2022, Construction News Portal

Kinetica Now Accessible as a Service on Microsoft Azure
14 October 2021, HPCwire

The Global GPU Database Market is expected to grow by $ 361.56 mn during 2021-2025, progressing at a CAGR of 17.82% during the forecast period
21 December 2021, Yahoo Finance

GPU Acceleration Makes Kinetica's Brute Force Database a Brute
17 November 2016, Data Center Knowledge

provided by Google News

How to Download Microsoft SQL Server 2019 on Windows 11
27 January 2022, BollyInside

High Availability for Containerized SQL Server in K8s
24 January 2022, Container Journal

Senior SQL Server Developer
28 January 2022, IT-Online

PureCM Supports SQL Server with Current Release of its Version Control Solution
31 July 2010, Database Journal

SQL Server Transformation Market Size, Business Opportunities and Forecast to 2029 – The Oxford Spokesman
28 January 2022, The Oxford Spokesman

provided by Google News

IBM Preconfigures Power System Racks Running Oracle Database
17 January 2022, IT Jungle

Top 5 Companies Hiring for Storage Cybersecurity Jobs | ESF
28 January 2022, Enterprise Storage Forum

South Florida Water Management District Upgrades Business Plumbing With SAP S/4HANA
28 January 2022, Forbes

Can Oracle make Cerner's EHR sing? CIOs and analysts chime in
21 January 2022, Healthcare IT News

Oracle opens Johannesburg cloud region as demand for data centres grows
21 January 2022, CIO

provided by Google News

Job opportunities

SQL Server Developer
WorkCog, Remote

Sr. SQL Server DBA
XTIVIA, Inc., Remote

SQL Server Developer
Spruce, New York, NY

SQL Server DBA
Volto Consulting, Remote

Azure SQL Server DBA
Mid America Mortgage, Remote

ORACLE DATABASE ADMINISTRATORS
TIMESQUARE IT, Peachtree Corners, GA

Database Administrator
City of Carrollton, Carrollton, TX

Oracle Database Administrator 3/Senior Oracle Database Administrator
MidAmerican Energy, Las Vegas, NV

Database Administrator
Peraton, Landover, MD

Database Administrator (Oracle Applications)
Garmin, Olathe, KS

jobs by Indeed



Share this page

Featured Products

Neo4j logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

AllegroGraph logo

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

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.

Couchbase logo

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

Present your product here