DB-EnginesExtremeDB: mitigate connectivity issues in a DBMSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > IBM Db2 vs. NSDb vs. SpaceTime vs. Vertica

System Properties Comparison IBM Db2 vs. NSDb vs. SpaceTime vs. Vertica

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameIBM Db2 infoformerly named DB2 or IBM Database 2  Xexclude from comparisonNSDb  Xexclude from comparisonSpaceTime  Xexclude from comparisonVertica infoOpenText™ Vertica™  Xexclude from comparison
DescriptionCommon in IBM host environments, 2 different versions for host and Windows/LinuxScalable, High-performance Time Series DBMS designed for Real-time Analytics on top of KubernetesSpaceTime is a spatio-temporal DBMS with a focus on performance.Cloud or off-cloud analytical database and query engine for structured and semi-structured streaming and batch data. Machine learning platform with built-in algorithms, data preparation capabilities, and model evaluation and management via SQL or Python.
Primary database modelRelational DBMS infoSince Version 10.5 support for JSON/BSON documents compatible with MongoDBTime Series DBMSSpatial DBMSRelational DBMS infoColumn oriented
Secondary database modelsDocument store
RDF store infoin Db2 LUW (Linux, Unix, Windows)
Spatial DBMS infowith Db2 Spatial Extender
Relational DBMSSpatial DBMS
Time Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score128.46
Rank#8  Overall
#5  Relational DBMS
Score0.00
Rank#383  Overall
#41  Time Series DBMS
Score0.00
Rank#383  Overall
#7  Spatial DBMS
Score10.68
Rank#43  Overall
#27  Relational DBMS
Websitewww.ibm.com/­products/­db2nsdb.iowww.mireo.com/­spacetimewww.vertica.com
Technical documentationwww.ibm.com/­docs/­en/­db2nsdb.io/­Architecturevertica.com/­documentation
DeveloperIBMMireoOpenText infopreviously Micro Focus and Hewlett Packard
Initial release1983 infohost version201720202005
Current release12.1, October 201612.0.3, January 2023
License infoCommercial or Open Sourcecommercial infofree version is availableOpen Source infoApache Version 2.0commercialcommercial infoLimited community edition free
Cloud-based only infoOnly available as a cloud servicenononono infoon-premises, all major clouds - Amazon AWS, Microsoft Azure, Google Cloud Platform and containers
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC and C++Java, ScalaC++C++
Server operating systemsAIX
HP-UX
Linux
Solaris
Windows
z/OS
Linux
macOS
LinuxLinux
Data schemeyesyesYes, but also semi-structure/unstructured data storage, and complex hierarchical data (like Parquet) stored and/or queried.
Typing infopredefined data types such as float or dateyesyes: int, bigint, decimal, stringyesyes
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 indexesyesall fields are automatically indexednoNo Indexes Required. Different internal optimization strategy, but same functionality included.
SQL infoSupport of SQLyesSQL-like query languageA subset of ANSI SQL is implementedFull 1999 standard plus machine learning, time series and geospatial. Over 650 functions.
APIs and other access methodsADO.NET
JDBC
JSON style queries infoMongoDB compatible
ODBC
XQuery
gRPC
HTTP REST
WebSocket
RESTful HTTP APIADO.NET
JDBC
Kafka Connector
ODBC
RESTful HTTP API
Spark Connector
vSQL infocharacter-based, interactive, front-end utility
Supported programming languagesC
C#
C++
Cobol
Delphi
Fortran
Java
Perl
PHP
Python
Ruby
Visual Basic
Java
Scala
C#
C++
Python
C#
C++
Go
Java
JavaScript (Node.js)
Perl
PHP
Python
R
Server-side scripts infoStored proceduresyesnonoyes, PostgreSQL PL/pgSQL, with minor differences
Triggersyesnoyes, called Custom Alerts
Partitioning methods infoMethods for storing different data on different nodesSharding infoonly with Windows/Unix/Linux VersionShardingFixed-grid hypercubeshorizontal partitioning, hierarchical partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesyes infowith separate tools (MQ, InfoSphere)Real-time block device replication (DRBD)Multi-source replication infoOne, or more copies of data replicated across nodes, or object-store used for repository.
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononono infoBi-directional Spark integration
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesnonoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnonoACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesUsing Apache Luceneyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.nono
User concepts infoAccess controlfine grained access rights according to SQL-standardyesfine grained access rights according to SQL-standard; supports Kerberos, LDAP, Ident and hash
More information provided by the system vendor
IBM Db2 infoformerly named DB2 or IBM Database 2NSDbSpaceTimeVertica infoOpenText™ Vertica™
Specific characteristicsDeploy-anywhere database for large-scale analytical deployments. Deploy off-cloud,...
» more
Competitive advantagesFast, scalable, and capable of high concurrency. Separation of compute/storage leverages...
» more
Typical application scenariosCommunication and network analytics, Embedded analytics, Fraud monitoring and Risk...
» more
Key customersAbiba Systems, Adform, adMarketplace, AmeriPride, Anritsu, AOL, Avito, Auckland Transport,...
» more
Licensing and pricing modelsCost-based models and subscription-based models are both available. One license is...
» 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

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

More resources
IBM Db2 infoformerly named DB2 or IBM Database 2NSDbSpaceTimeVertica infoOpenText™ Vertica™
Recent citations in the news

Data migration strategies to Amazon RDS for Db2 | Amazon Web Services
15 May 2024, AWS Blog

IBM Collaborates with AWS to Launch a New Cloud Database Offering, Enabling Customers to Optimize Data ...
27 November 2023, IBM Newsroom

IBM's vintage Db2 database jumps on AWS's cloud bandwagon
29 November 2023, The Register

Precisely says it's smoothing migration of Db2 analytics data to AWS cloud – Blocks and Files
5 April 2024, Blocks & Files

Precisely Supports Amazon RDS for Db2 Service with Real-Time Data Integration Capabilities
3 April 2024, precisely.com

provided by Google News

Stonebraker Seeks to Invert the Computing Paradigm with DBOS
12 March 2024, Datanami

How Embedded Analytics Help ISVs Overcome Challenges
14 September 2023, Spiceworks News and Insights

OpenText expands enterprise portfolio with AI and Micro Focus integrations
25 July 2023, VentureBeat

Postgres pioneer Michael Stonebraker promises to upend the database once more
26 December 2023, The Register

OpenText integrates Micro Focus tech through Cloud Editions 23.3
26 July 2023, Techzine Europe

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.

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

AllegroGraph logo

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

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB for free.

Milvus logo

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

Present your product here