Editorial information provided by DB-Engines
NameInfluxDB Xexclude from comparisonOracle Xexclude from comparisonSpark SQL Xexclude from comparison
DescriptionDBMS for storing time series, events and metricsWidely used RDBMSSpark SQL is a component on top of 'Spark Core' for structured data processing
Secondary database modelsSpatial DBMS with GEO packageDocument store
Graph DBMS with Oracle Spatial and Graph
RDF store with Oracle Spatial and Graph
Spatial DBMS with Oracle Spatial and Graph
DB-Engines Ranking measures the popularity of database management systems
DeveloperOracleApache Software Foundation
Initial release201319802014
Current release2.0.2, November 202019c, February 20193.1.1, March 2021
License Commercial or Open SourceOpen Source
MIT-License; commercial enterprise version availablecommercial
restricted free version is availableOpen Source
Apache 2.0
Cloud-based only Only available as a cloud servicenonono
DBaaS offerings (sponsored links) Database as a Service
Providers of DBaaS offerings, please contact us to be listed.
Implementation languageGoC and C++Scala
Server operating systemsLinux
OS X through HomebrewAIX
HP-UX
Linux
OS X
Solaris
Windows
z/OSLinux
OS X
Windows
Data schemeschema-freeyes Schemaless in JSON and XML columnsyes
Typing predefined data types such as float or dateNumeric data and Stringsyesyes
XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.noyesno
Secondary indexesnoyesno
SQL Support of SQLSQL-like query languageyes
with proprietary extensionsSQL-like DML and DDL statements
APIs and other access methodsHTTP API
JSON over UDPJDBC
ODBC
ODP.NET
Oracle Call Interface (OCI)JDBC
ODBC
Supported programming languages.Net
Clojure
Erlang
Go
Haskell
Java
JavaScript
JavaScript (Node.js)
Lisp
Perl
PHP
Python
R
Ruby
Rust
ScalaC
C#
C++
Clojure
Cobol
Delphi
Eiffel
Erlang
Fortran
Groovy
Haskell
Java
JavaScript
Lisp
Objective C
OCaml
Perl
PHP
Python
R
Ruby
Scala
Tcl
Visual BasicJava
Python
R
Scala
Server-side scripts Stored proceduresnoPL/SQL
also stored procedures in Java possibleno
Triggersnoyesno
Partitioning methods Methods for storing different data on different nodesSharding
in enterprise version onlySharding, horizontal partitioningyes, utilizing Spark Core
Replication methods Methods for redundantly storing data on multiple nodesselectable replication factor
in enterprise version onlyMulti-source replication
Source-replica replicationnone
MapReduce Offers an API for user-defined Map/Reduce methodsnono
can be realized in PL/SQL
Consistency concepts Methods to ensure consistency in a distributed systemImmediate Consistency
Foreign keys Referential integritynoyesno
Transaction concepts Support to ensure data integrity after non-atomic manipulations of datanoACID
isolation level can be parameterizedno
Concurrency Support for concurrent manipulation of datayesyesyes
Durability Support for making data persistentyesyesyes
In-memory capabilities Is there an option to define some or all structures to be held in-memory only.yes
Depending on used storage engineyes
Version 12c introduced the new option 'Oracle Database In-Memory'no
User concepts Access controlsimple rights management via user accountsfine grained access rights according to SQL-standardno
More information provided by the system vendor
InfluxDBOracleSpark SQL
Specific characteristicsInfluxData is the creator of InfluxDB , the open source time series database. It...
» more
Competitive advantagesTime to Value An end-to-end platform, InfluxData is ready to go on the cloud or via...
» more
Typical application scenariosIoT & Sensor Monitoring Instrumentation of every available surface in the material...
» more
Key customersInfluxData has over 630 paying customers, including IBM, PayPal, Siemens Tesla and...
» more
Market metricsFastest growing database to garnish 17,000 github stars Over 260,000 daily active...
» more
Licensing and pricing modelsOpen source core with closed source clustering available either on-premise or on...
» 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 partiesGeneral SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.
» more
Fivetran: Quickly and easily centralize your on-premise and cloud databases.
» 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
InfluxDBOracleSpark SQL