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 > 4D vs. Datastax Enterprise vs. Firebase Realtime Database vs. Kdb vs. Microsoft Azure Data Explorer

System Properties Comparison 4D vs. Datastax Enterprise vs. Firebase Realtime Database vs. Kdb vs. Microsoft Azure Data Explorer

Editorial information provided by DB-Engines
Name4D infoformer name: 4th Dimension  Xexclude from comparisonDatastax Enterprise  Xexclude from comparisonFirebase Realtime Database  Xexclude from comparisonKdb  Xexclude from comparisonMicrosoft Azure Data Explorer  Xexclude from comparison
DescriptionApplication development environment with integrated database management systemDataStax Enterprise (DSE) is the always-on, scalable data platform built on Apache Cassandra and designed for hybrid Cloud. DSE integrates graph, search, analytics, administration, developer tooling, and monitoring into a unified platform.Cloud-hosted realtime document store. iOS, Android, and JavaScript clients share one Realtime Database instance and automatically receive updates with the newest data.High performance Time Series DBMSFully managed big data interactive analytics platform
Primary database modelRelational DBMSWide column storeDocument storeTime Series DBMS
Vector DBMS
Relational DBMS infocolumn oriented
Secondary database modelsDocument store
Graph DBMS
Spatial DBMS
Search engine
Vector DBMS
Relational DBMSDocument store infoIf a column is of type dynamic docs.microsoft.com/­en-us/­azure/­kusto/­query/­scalar-data-types/­dynamic then it's possible to add arbitrary JSON documents in this cell
Event Store infothis is the general usage pattern at Microsoft. Billing, Logs, Telemetry events are stored in ADX and the state of an individual entity is defined by the arg_max(timestamps)
Spatial DBMS
Search engine infosupport for complex search expressions docs.microsoft.com/­en-us/­azure/­kusto/­query/­parseoperator FTS, Geospatial docs.microsoft.com/­en-us/­azure/­kusto/­query/­geo-point-to-geohash-function distributed search -> ADX acts as a distributed search engine
Time Series DBMS infosee docs.microsoft.com/­en-us/­azure/­data-explorer/­time-series-analysis
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score2.47
Rank#110  Overall
#54  Relational DBMS
Score5.93
Rank#56  Overall
#4  Wide column stores
Score13.64
Rank#39  Overall
#6  Document stores
Score7.71
Rank#49  Overall
#2  Time Series DBMS
#1  Vector DBMS
Score3.80
Rank#81  Overall
#43  Relational DBMS
Websitewww.4d.comwww.datastax.com/­products/­datastax-enterprisefirebase.google.com/­products/­realtime-databasekx.comazure.microsoft.com/­services/­data-explorer
Technical documentationdeveloper.4d.comdocs.datastax.comfirebase.google.com/­docs/­databasecode.kx.comdocs.microsoft.com/­en-us/­azure/­data-explorer
Developer4D, IncDataStaxGoogle infoacquired by Google 2014Kx Systems, a division of First Derivatives plcMicrosoft
Initial release1984201120122000 infokdb was released 2000, kdb+ in 20032019
Current releasev20, April 20236.8, April 20203.6, May 2018cloud service with continuous releases
License infoCommercial or Open Sourcecommercialcommercialcommercialcommercial infofree 32-bit versioncommercial
Cloud-based only infoOnly available as a cloud servicenonoyesnoyes
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Datastax Astra DB: Astra DB simplifies cloud-native Cassandra application development for your apps, microservices and functions. Deploy in minutes on AWS, Google Cloud, Azure, and have it managed for you by the experts, with serverless, pay-as-you-go pricing.
Implementation languageJavaq
Server operating systemsOS X
Windows
Linux
OS X
hostedLinux
OS X
Solaris
Windows
hosted
Data schemeyesschema-freeschema-freeyesFixed schema with schema-less datatypes (dynamic)
Typing infopredefined data types such as float or dateyesyesyesyesyes infobool, datetime, dynamic, guid, int, long, real, string, timespan, double: docs.microsoft.com/­en-us/­azure/­kusto/­query/­scalar-data-types
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.yesnonoyesyes
Secondary indexesyesyesyesyes infotable attribute 'grouped'all fields are automatically indexed
SQL infoSupport of SQLyes infoclose to SQL 92SQL-like DML and DDL statements (CQL); Spark SQLnoSQL-like query language (q)Kusto Query Language (KQL), SQL subset
APIs and other access methodsODBC
RESTful HTTP API infoby using 4D Mobile
SOAP webservices
Proprietary protocol infoCQL (Cassandra Query Language)
TinkerPop Gremlin infowith DSE Graph
Android
iOS
JavaScript API
RESTful HTTP API
HTTP API
JDBC
Jupyter
Kafka
ODBC
WebSocket
Microsoft SQL Server communication protocol (MS-TDS)
RESTful HTTP API
Supported programming languages4D proprietary IDE
PHP
C
C#
C++
Java
JavaScript (Node.js)
PHP
Python
Ruby
Java
JavaScript
Objective-C
C
C#
C++
Go
J
Java
JavaScript
Lua
MatLab
Perl
PHP
Python
R
Scala
.Net
Go
Java
JavaScript (Node.js)
PowerShell
Python
R
Server-side scripts infoStored proceduresyesnolimited functionality with using 'rules'user defined functionsYes, possible languages: KQL, Python, R
TriggersyesyesCallbacks are triggered when data changesyes infowith viewsyes infosee docs.microsoft.com/­en-us/­azure/­kusto/­management/­updatepolicy
Partitioning methods infoMethods for storing different data on different nodesnoneSharding infono "single point of failure"horizontal partitioningSharding infoImplicit feature of the cloud service
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replicationconfigurable replication factor, datacenter aware, advanced replication for edge computingSource-replica replicationyes infoImplicit feature of the cloud service. Replication either local, cross-facility or geo-redundant.
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyesnono infosimilar paradigm used for internal processingSpark connector (open source): github.com/­Azure/­azure-kusto-spark
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency
Tunable Consistency infoconsistency level can be individually decided with each write operation
Eventual Consistency infoif the client is offline
Immediate Consistency infoif the client is online
Immediate ConsistencyEventual Consistency
Immediate Consistency
Foreign keys infoReferential integrityyesnonoyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDno infoAtomicity and isolation are supported for single operationsyesnono
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
Durability infoSupport for making data persistentyesyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyesyesno
User concepts infoAccess controlUsers and groupsAccess rights for users can be defined per objectyes, based on authentication and database rulesrights management via user accountsAzure Active Directory Authentication
More information provided by the system vendor
4D infoformer name: 4th DimensionDatastax EnterpriseFirebase Realtime DatabaseKdbMicrosoft Azure Data Explorer
Specific characteristicsDataStax Enterprise is scale-out data infrastructure for enterprises that need to...
» more
Integrated columnar database & programming system for streaming, real time and historical...
» more
Competitive advantagesSupporting the following application requirements: Zero downtime - Built on Apache...
» more
provides seamless scalability; runs on industry standard server platforms; is top-ranked...
» more
Typical application scenariosApplications that must be massively and linearly scalable with 100% uptime and able...
» more
tick database streaming sensor data massive intelligence applications oil and gas...
» more
Key customersCapital One, Cisco, Comcast, eBay, McDonald's, Microsoft, Safeway, Sony, UBS, and...
» more
Goldman Sachs Morgan Stanley Merrill Lynch J.P. Morgan Deutsche Bank IEX Securities...
» more
Market metricsAmong the Forbes 100 Most Innovative Companies, DataStax is trusted by 5 of the top...
» more
kdb+ performance and reliability proven by our customers in critical infrastructure...
» more
Licensing and pricing modelsAnnual subscription
» more
upon request
» 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
4D infoformer name: 4th DimensionDatastax EnterpriseFirebase Realtime DatabaseKdbMicrosoft Azure Data Explorer
DB-Engines blog posts

MySQL, PostgreSQL and Redis are the winners of the March ranking
2 March 2016, Paul Andlinger

show all

Cloud-based DBMS's popularity grows at high rates
12 December 2019, Paul Andlinger

show all

Recent citations in the news

DataStax previews new Hyper Converged Data Platform for enterprise AI
15 May 2024, VentureBeat

DataStax Launches New Hyper-Converged Data Platform Giving Enterprises the Complete Modern Data Center Suite ...
15 May 2024, Business Wire

DataStax and LlamaIndex Partner to Make Building RAG Applications Easier than Ever for GenAI Developers
20 February 2024, insideBIGDATA

DataStax Introduces Enhanced RAG Capabilities Through Astra DB and NVIDIA Tech
19 March 2024, Datanami

DataStax goes vector searching with Astra DB
20 July 2023, Blocks and Files

provided by Google News

Realtime vs Cloud Firestore: Which Firebase Database to go?
8 March 2024, Appinventiv

Atos cybersecurity blog: Misconfigured Firebase: A real-time cyber threat
18 January 2024, Atos

Don't be like these 900+ websites and expose millions of passwords via Firebase
18 March 2024, The Register

Google launches Firebase Genkit, a new open source framework for building AI-powered apps
14 May 2024, TechCrunch

Hundreds of Google Firebase websites might have leaked data online
19 March 2024, TechRadar

provided by Google News

Turbocharging the Engine: KX Unleashes AI-First Transformation with kdb+
28 February 2024, Business Wire

McLaren Applied and KX partner to enhance ATLAS software analytics capabilities
9 August 2023, Professional Motorsport World

Introducing Amazon FinSpace with Managed kdb Insights, a fully managed analytics engine, commonly used by capital ...
18 May 2023, AWS Blog

KX ANNOUNCES KDB INSIGHTS AS FULLY MANAGED SERVICE ON AMAZON FINSPACE
18 May 2023, PR Newswire

KX Brings the Power and Performance of kdb+ to Python Developers with PyKX
7 June 2023, Datanami

provided by Google News

We’re retiring Azure Time Series Insights on 7 July 2024 – transition to Azure Data Explorer | Azure updates
31 May 2024, Microsoft

Update records in a Kusto Database (public preview) | Azure updates
20 February 2024, Microsoft

Public Preview: Azure Data Explorer connector for Apache Flink | Azure updates
8 January 2024, Microsoft

Announcing General Availability to migrate Virtual Network injected Azure Data Explorer Cluster to Private Endpoints ...
5 February 2024, Microsoft

New Features for graph-match KQL Operator: Enhanced Pattern Matching and Cycle Control | Azure updates
24 January 2024, Microsoft

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