DBMS > Kdb vs. QuestDB vs. Ultipa
System Properties Comparison Kdb vs. QuestDB vs. Ultipa
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||Kdb Xexclude from comparison||QuestDB Xexclude from comparison||Ultipa Xexclude from comparison|
|Description||High performance Time Series DBMS||A high performance open source SQL database for time series data||High performance Graph DBMS supporting HTAP high availability cluster deployment|
|Primary database model||Time Series DBMS|
|Time Series DBMS||Graph DBMS|
|Secondary database models||Relational DBMS||Relational DBMS|
|Developer||Kx Systems, a division of First Derivatives plc||QuestDB Technology Inc||Ultipa|
|Initial release||2000 kdb was released 2000, kdb+ in 2003||2014||2019|
|Current release||3.6, May 2018|
|License Commercial or Open Source||commercial free 32-bit version||Open Source Apache 2.0||commercial|
|Cloud-based only Only available as a cloud service||no||no||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Implementation language||q||Java (Zero-GC), C++, Rust|
|Server operating systems||Linux|
|Data scheme||yes||yes schema-free via InfluxDB Line Protocol|
|Typing predefined data types such as float or date||yes||yes|
|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.||yes||no|
|Secondary indexes||yes table attribute 'grouped'||no|
|SQL Support of SQL||SQL-like query language (q)||SQL with time-series extensions|
|APIs and other access methods||HTTP API|
InfluxDB Line Protocol (TCP/UDP)
PostgreSQL wire protocol
|RESTful HTTP API|
|Supported programming languages||C|
|C PostgreSQL driver|
Rust over HTTP
|Server-side scripts Stored procedures||user defined functions||no|
|Triggers||yes with views||no|
|Partitioning methods Methods for storing different data on different nodes||horizontal partitioning||horizontal partitioning (by timestamps)|
|Replication methods Methods for redundantly storing data on multiple nodes||Source-replica replication||Source-replica replication with eventual consistency|
|MapReduce Offers an API for user-defined Map/Reduce methods||no similar paradigm used for internal processing||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency||Immediate Consistency|
|Foreign keys Referential integrity||yes||no|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||no||ACID for single-table writes|
|Concurrency Support for concurrent manipulation of data||yes||yes|
|Durability Support for making data persistent||yes||yes|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||yes||yes through memory mapped files|
|User concepts Access control||rights management via user accounts|
|More information provided by the system vendor|
|Specific characteristics||Integrated columnar database & programming system for streaming, real time and historical...|
|Relational model with native time series support Column-based storage and time partitioned...|
|Competitive advantages||provides seamless scalability; runs on industry standard server platforms; is top-ranked...|
|High ingestion throughput: peak of 4M rows/sec (TSBS Benchmark) Code optimizations...|
|Typical application scenarios||tick database streaming sensor data massive intelligence applications oil and gas...|
|Financial tick data Industrial IoT Application Metrics Monitoring|
|Key customers||Goldman Sachs Morgan Stanley Merrill Lynch J.P. Morgan Deutsche Bank IEX Securities...|
|Banks & Hedge funds, Yahoo, OKX, Airbus, Aquis Exchange, Net App, Cloudera, Airtel,...|
|Market metrics||kdb+ performance and reliability proven by our customers in critical infrastructure...|
|Licensing and pricing models||upon request|
|Open source Apache 2.0 QuestDB Enterprise QuestDB Cloud|
QuestDB Release Week #4
Building a faster hash table for high performance SQL joins
Is all data time series data?
Solving duplicate data with performant deduplication
QuestDB + Hacktoberfest 2023: 10 Years of Hacking
We invite representatives of system vendors to contact us for updating and extending the system information,
Related products and services
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|Recent citations in the news|
KX BRINGS THE POWER AND PERFORMANCE OF KDB+ TO ...
KX ANNOUNCES KDB INSIGHTS AS FULLY MANAGED SERVICE ...
KX JOINS SNOWFLAKE PARTNER NETWORK
ICE and KX Bring High Performance Real-time Analytics to More ...
McLaren Applied and KX partner to enhance ATLAS software ...
provided by Google News
5 Awesome Java Projects People Don't Know About Vol 3 — Time ...
QuestDB nabs $2.3M seed to build open source time series database
Read the Pitch Deck Database Startup QuestDB Used to Raise $12 ...
Comparing Different Time-Series Databases
Aquis Exchange goes live with QuestDB for real time monitoring
provided by Google News
EPiC 2023: Fintechs Plotting Asia Expansion Hit the Elevator in ...
Graph database: ecco i vantaggi e perché usarli in azienda
Reporting ESG: i vantaggi del Graph Database
Il Graph Database favorisce la nascita di unicorni: ecco le ...
When an employee lies about race, there's no easy solution
provided by Google News
Share this page