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 > Adabas vs. Firebolt vs. Kinetica vs. SQLite vs. TimesTen

System Properties Comparison Adabas vs. Firebolt vs. Kinetica vs. SQLite vs. TimesTen

Editorial information provided by DB-Engines
NameAdabas infodenotes "adaptable data base"  Xexclude from comparisonFirebolt  Xexclude from comparisonKinetica  Xexclude from comparisonSQLite  Xexclude from comparisonTimesTen  Xexclude from comparison
DescriptionOLTP - DBMS for mainframes and Linux/Unix/Windows environments infoused typically together with the Natural programming platformHighly scalable cloud data warehouse and analytics product infoForked from ClickhouseFully vectorized database across both GPUs and CPUsWidely used embeddable, in-process RDBMSIn-Memory RDBMS compatible to Oracle
Primary database modelMultivalue DBMSRelational DBMSRelational DBMSRelational DBMSRelational DBMS
Secondary database modelsSpatial DBMS
Time Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score2.79
Rank#102  Overall
#2  Multivalue DBMS
Score1.73
Rank#140  Overall
#63  Relational DBMS
Score0.66
Rank#234  Overall
#107  Relational DBMS
Score111.41
Rank#10  Overall
#7  Relational DBMS
Score1.36
Rank#161  Overall
#75  Relational DBMS
Websitewww.softwareag.com/­en_corporate/­platform/­adabas-natural.htmlwww.firebolt.iowww.kinetica.comwww.sqlite.orgwww.oracle.com/­database/­technologies/­related/­timesten.html
Technical documentationdocs.firebolt.iodocs.kinetica.comwww.sqlite.org/­docs.htmldocs.oracle.com/­database/­timesten-18.1
DeveloperSoftware AGFirebolt Analytics Inc.KineticaDwayne Richard HippOracle, TimesTen Performance Software, HP infooriginally founded in HP Labs it was acquired by Oracle in 2005
Initial release19712020201220001998
Current release7.1, August 20213.46.0  (23 May 2024), May 202411 Release 2 (11.2.2.8.0)
License infoCommercial or Open SourcecommercialcommercialcommercialOpen Source infoPublic Domaincommercial
Cloud-based only infoOnly available as a cloud servicenoyesnonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC, C++C
Server operating systemsBS2000
Linux
Unix
Windows
z/OS
z/VSE
hostedLinuxserver-lessAIX
HP-UX
Linux
OS X
Solaris SPARC/x86
Windows
Data schemeyesyesyesyes infodynamic column typesyes
Typing infopredefined data types such as float or dateyesyesyesyes infonot rigid because of 'dynamic typing' concept.yes
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.nononono
Secondary indexesyesyesyesyesyes
SQL infoSupport of SQLyes infowith add-on product Adabas SQL GatewayyesSQL-like DML and DDL statementsyes infoSQL-92 is not fully supportedyes
APIs and other access methodsHTTP API infowith add-on software Adabas SOA Gateway
SOAP-based API infowith add-on software Adabas SOA Gateway
.Net
ODBC
RESTful HTTP API
JDBC
ODBC
RESTful HTTP API
ADO.NET infoinofficial driver
JDBC infoinofficial driver
ODBC infoinofficial driver
JDBC
ODBC
ODP.NET
Oracle Call Interface (OCI)
Supported programming languagesNaturalGo
JavaScript (Node.js)
Python
C++
Java
JavaScript (Node.js)
Python
Actionscript
Ada
Basic
C
C#
C++
D
Delphi
Forth
Fortran
Haskell
Java
JavaScript
Lisp
Lua
MatLab
Objective-C
OCaml
Perl
PHP
PL/SQL
Python
R
Ruby
Scala
Scheme
Smalltalk
Tcl
C
C++
Java
PL/SQL
Server-side scripts infoStored proceduresin Naturalnouser defined functionsnoPL/SQL
Triggersnonoyes infotriggers when inserted values for one or more columns fall within a specified rangeyesno
Partitioning methods infoMethods for storing different data on different nodesyes, with additonal products like Adabas Cluster Services, Adabas Parallel Services, Adabas VistaShardingnonenone
Replication methods infoMethods for redundantly storing data on multiple nodesyes, with add-on product Event Replicatordepending on storage layerSource-replica replicationnoneMulti-source replication
Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency or Eventual Consistency depending on configurationImmediate Consistency or Eventual Consistency depending on configuration
Foreign keys infoReferential integritynoyesyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnoACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyes infovia file-system locksyes
Durability infoSupport for making data persistentyesyesyesyes infoby means of logfiles and checkpoints
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyes infoGPU vRAM or System RAMyesyes
User concepts infoAccess controlonly with OS-specific tools (e.g. IBM RACF, CA Top Secret)Access rights for users and roles on table levelnofine grained access rights according to SQL-standard

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
3rd partiesNavicat for SQLite is a powerful and comprehensive SQLite GUI that provides a complete set of functions for database management and development.
» more

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

More resources
Adabas infodenotes "adaptable data base"FireboltKineticaSQLiteTimesTen
DB-Engines blog posts

Big gains for Relational Database Management Systems in DB-Engines Ranking
2 February 2016, Matthias Gelbmann

show all

Recent citations in the news

Re-evaluating legacy: Should you leave Adabas (and Natural) behind?
30 May 2024, ITWeb

State agency proves DevOps and mainframes can coexist
12 April 2024, SiliconANGLE News

IBM buys 50-year-old Software AG's enterprise tech units for €2.13B in cash
18 December 2023, The Register

Michael E. Jakes Obituary (1941 - 2023)
26 October 2023, Legacy.com

Is it the end of the road for Software AG after selling its integration business to IBM?
12 January 2024, diginomica

provided by Google News

10 Best Data Pipeline Tools of 2024 to Boost Your Productivity
20 February 2024, Datamation

Cloud data unicorn Firebolt fires dozens of employees
7 September 2022, CTech

Firebolt, a data warehouse startup, raises $100M at a $1.4B valuation for faster, cheaper analytics on large data sets
26 January 2022, TechCrunch

Firebolt vs Snowflake | Data Warehousing Platform Comparison
1 April 2022, TechRepublic

Firebolt, Israeli Cloud Data Warehouse Startup Forklifts Forward
5 January 2021, Forbes

provided by Google News

Kinetica Delivers Real-Time Vector Similarity Search
21 March 2024, insideBIGDATA

Kinetica Elevates RAG with Fast Access to Real-Time Data
26 March 2024, Datanami

Kinetica ramps up RAG for generative AI, empowering enterprises with real-time operational data
18 March 2024, SiliconANGLE News

Kinetica Launches Generative AI Solution for Real-Time Inferencing Powered by NVIDIA AI Enterprise
18 March 2024, GlobeNewswire

Transforming spatiotemporal data analysis with GPUs and generative AI
30 October 2023, InfoWorld

provided by Google News

Microsoft Research chief scientist has no issue with Windows Recall
6 June 2024, The Register

How to work with Dapper and SQLite in ASP.NET Core
10 May 2024, InfoWorld

A Guide to Working with SQLite Databases in Python
21 May 2024, KDnuggets

SQLite Vulnerability Could Put Thousands of Apps at Risk
22 March 2024, Dark Reading

Copilot‘s screen-snapping Recall data stored in plain text
31 May 2024, CyberNews.com

provided by Google News



Share this page

Featured Products

Neo4j logo

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

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

Present your product here