DBMS > Kdb vs. SQLite vs. TinkerGraph
System Properties Comparison Kdb vs. SQLite vs. TinkerGraph
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||Kdb Xexclude from comparison||SQLite Xexclude from comparison||TinkerGraph Xexclude from comparison|
|Description||High performance Time Series DBMS||Widely used embeddable, in-process RDBMS||A lightweight, in-memory graph engine that serves as a reference implementation of the TinkerPop3 API|
|Primary database model||Time Series DBMS|
|Relational DBMS||Graph DBMS|
|Secondary database models||Relational DBMS|
|Developer||Kx Systems, a division of First Derivatives plc||Dwayne Richard Hipp|
|Initial release||2000 kdb was released 2000, kdb+ in 2003||2000||2009|
|Current release||3.6, May 2018||3.43.1 (11 September 2023), September 2023|
|License Commercial or Open Source||commercial free 32-bit version||Open Source Public Domain||Open Source Apache 2.0|
|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.
|Server operating systems||Linux|
|Data scheme||yes||yes dynamic column types||schema-free|
|Typing predefined data types such as float or date||yes||yes not rigid because of 'dynamic typing' concept.||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||no|
|Secondary indexes||yes table attribute 'grouped'||yes||no|
|SQL Support of SQL||SQL-like query language (q)||yes SQL-92 is not fully supported||no|
|APIs and other access methods||HTTP API|
|ADO.NET inofficial driver|
JDBC inofficial driver
ODBC inofficial driver
|Supported programming languages||C|
|Server-side scripts Stored procedures||user defined functions||no||no|
|Triggers||yes with views||yes||no|
|Partitioning methods Methods for storing different data on different nodes||horizontal partitioning||none||none|
|Replication methods Methods for redundantly storing data on multiple nodes||Source-replica replication||none||none|
|MapReduce Offers an API for user-defined Map/Reduce methods||no similar paradigm used for internal processing||no||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency||none|
|Foreign keys Referential integrity||yes||yes||yes Relationships in graphs|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||no||ACID||no|
|Concurrency Support for concurrent manipulation of data||yes||yes via file-system locks||no|
|Durability Support for making data persistent||yes||yes||optional|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||yes||yes||yes|
|User concepts Access control||rights management via user accounts||no||no|
|More information provided by the system vendor|
|Specific characteristics||Integrated columnar database & programming system for streaming, real time and historical...|
|Competitive advantages||provides seamless scalability; runs on industry standard server platforms; is top-ranked...|
|Typical application scenarios||tick database streaming sensor data massive intelligence applications oil and gas...|
|Key customers||Goldman Sachs Morgan Stanley Merrill Lynch J.P. Morgan Deutsche Bank IEX Securities...|
|Market metrics||kdb+ performance and reliability proven by our customers in critical infrastructure...|
|Licensing and pricing models||upon request|
We invite representatives of system vendors to contact us for updating and extending the system information,
|Related products and services|
|3rd parties||Navicat for SQLite is a powerful and comprehensive SQLite GUI that provides a complete set of functions for database management and development.|
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|DB-Engines blog posts|
Big gains for Relational Database Management Systems in DB-Engines Ranking
|Recent citations in the news|
KX BRINGS THE POWER AND PERFORMANCE OF KDB+ TO ...
ICE and KX Bring High Performance Real-time Analytics to More ...
KX JOINS SNOWFLAKE PARTNER NETWORK
KX LAUNCHES KDB.AI EARLY ACCESS PROGRAM: NAVIGATING ...
McLaren Applied and KX partner to enhance ATLAS software ...
provided by Google News
RDBMS Software Market Size [2023-2030] | Rising Trends, Growing ...
Two flaws in Apache SuperSet allow to remotely hack servers
Scale Higher Per-Database Storage Limits and Create More ...
VB.NET SQL Examples for Querying Databases Efficiently - MUO
How LLMs Helped Me Build an ODBC Plugin for Steampipe
provided by Google News
Gremlin, a Language for Working with Graphs
Graph Databases, NOSQL and Neo4j
provided by Google News
windows app c++ developer
Associate Software Developer
Information Technology Specialist (DATAMGT)
Mobile App Engineer
Species Habitat Modeling Program Contractor (Remote)
Share this page