InfluxDB和oracle,InfluxDB vs. Oracle vs. Spark SQL Comparison

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