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

DBMS > BaseX vs. Blueflood vs. IBM Db2 vs. Infobright

System Properties Comparison BaseX vs. Blueflood vs. IBM Db2 vs. Infobright

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameBaseX  Xexclude from comparisonBlueflood  Xexclude from comparisonIBM Db2 infoformerly named DB2 or IBM Database 2  Xexclude from comparisonInfobright  Xexclude from comparison
DescriptionLight-weight Native XML DBMS with support for XQuery 3.0 and interactive GUI.Scalable TimeSeries DBMS based on CassandraCommon in IBM host environments, 2 different versions for host and Windows/LinuxHigh performant column-oriented DBMS for analytic workloads using MySQL or PostgreSQL as a frontend
Primary database modelNative XML DBMSTime Series DBMSRelational DBMS infoSince Version 10.5 support for JSON/BSON documents compatible with MongoDBRelational DBMS
Secondary database modelsDocument store
RDF store infoin Db2 LUW (Linux, Unix, Windows)
Spatial DBMS infowith Db2 Spatial Extender
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.90
Rank#136  Overall
#4  Native XML DBMS
Score0.09
Rank#353  Overall
#33  Time Series DBMS
Score127.49
Rank#8  Overall
#5  Relational DBMS
Score1.00
Rank#193  Overall
#90  Relational DBMS
Websitebasex.orgblueflood.iowww.ibm.com/­products/­db2ignitetech.com/­softwarelibrary/­infobrightdb
Technical documentationdocs.basex.orggithub.com/­rax-maas/­blueflood/­wikiwww.ibm.com/­docs/­en/­db2
DeveloperBaseX GmbHRackspaceIBMIgnite Technologies Inc.; formerly InfoBright Inc.
Initial release200720131983 infohost version2005
Current release10.7, August 202312.1, October 2016
License infoCommercial or Open SourceOpen Source infoBSD licenseOpen Source infoApache 2.0commercial infofree version is availablecommercial infoThe open source (GPLv2) version did not support inserts/updates/deletes and was discontinued with July 2016
Cloud-based only infoOnly available as a cloud servicenononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaJavaC and C++C
Server operating systemsLinux
OS X
Windows
Linux
OS X
AIX
HP-UX
Linux
Solaris
Windows
z/OS
Linux
Windows
Data schemeschema-freepredefined schemeyesyes
Typing infopredefined data types such as float or dateno infoXQuery supports typesyesyesyes
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.nono
Secondary indexesyesnoyesno infoKnowledge Grid Technology used instead
SQL infoSupport of SQLnonoyesyes
APIs and other access methodsJava API
RESTful HTTP API
RESTXQ
WebDAV
XML:DB
XQJ
HTTP RESTADO.NET
JDBC
JSON style queries infoMongoDB compatible
ODBC
XQuery
ADO.NET
JDBC
ODBC
Supported programming languagesActionscript
C
C#
Haskell
Java
JavaScript infoNode.js
Lisp
Perl
PHP
Python
Qt
Rebol
Ruby
Scala
Visual Basic
C
C#
C++
Cobol
Delphi
Fortran
Java
Perl
PHP
Python
Ruby
Visual Basic
.Net
C
C#
C++
D
Eiffel
Erlang
Haskell
Java
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl
Server-side scripts infoStored proceduresyesnoyesno
Triggersyes infovia eventsnoyesno
Partitioning methods infoMethods for storing different data on different nodesnoneSharding infobased on CassandraSharding infoonly with Windows/Unix/Linux Versionnone
Replication methods infoMethods for redundantly storing data on multiple nodesnoneselectable replication factor infobased on Cassandrayes infowith separate tools (MQ, InfoSphere)Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononono
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency infobased on Cassandra
Immediate Consistency infobased on Cassandra
Immediate Consistency
Foreign keys infoReferential integritynonoyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datamultiple readers, single writernoACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyes
User concepts infoAccess controlUsers with fine-grained authorization concept on 4 levelsnofine grained access rights according to SQL-standardfine grained access rights according to SQL-standard infoexploiting MySQL or PostgreSQL frontend capabilities

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

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

More resources
BaseXBluefloodIBM Db2 infoformerly named DB2 or IBM Database 2Infobright
Recent citations in the news

XML Injection Attacks: What to Know About XPath, XQuery, XXE & More
18 May 2022, Hashed Out by The SSL Store™

9 Skills You Need to Become a Data Engineer
2 November 2022, KDnuggets

provided by Google News

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

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

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

How Amazon RDS for IBM Db2 Showcases the Power of Co-Creation
21 December 2023, Acceleration Economy

Precisely Supports Amazon RDS for Db2 Service with Real-Time Data Integration Capabilities
3 April 2024, Silicon Canals

provided by Google News



Share this page

Featured Products

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

Neo4j logo

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

Ontotext logo

GraphDB allows you to link diverse data, index it for semantic search and enrich it via text analysis to build big knowledge graphs. Get it free.

Milvus logo

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

SingleStore logo

Database for your real-time AI and Analytics Apps.
Try it today.

Present your product here