ArcticDB vs kdb+
ArcticDB: Serverless DataFrame database from Man Group: Pandas in, versioned columnar data on S3 out. kdb+: Column-store time-series engine with the q language, a fixture of capital-markets tick data.
key differences
- Licensing: ArcticDB is source-available (Business Source License 1.1 (converts to Apache-2.0 after 2 years)); kdb+ is proprietary (Commercial; KDB-X Community Edition free with resource limits).
- Horizontal scaling is native in ArcticDB and manual in kdb+.
- Only ArcticDB has time travel.
- Only kdb+ has joins, secondary indexes, json, stored procedures, pub/sub.
- ArcticDB has a serverless option; kdb+ does not.
- ArcticDB can run embedded in your application process.
choose arcticdb for
- +Quant research data stores
- +Versioned financial time series
- +Feature and factor libraries for backtesting
- +Scientific DataFrame storage on object storage
best at · Tick data, Time-series, Scientific
choose kdb-plus for
- +Equities, FX and futures tick capture
- +Trade surveillance and best-execution analysis
- +Quant research on historical market data
- +Real-time risk and P&L
best at · Tick data, Time-series, Real-time analytics
ArcticDB vs kdb+: FAQ
What is the difference between ArcticDB and kdb+?
ArcticDB: Serverless DataFrame database from Man Group: Pandas in, versioned columnar data on S3 out. kdb+: Column-store time-series engine with the q language, a fixture of capital-markets tick data. Licensing: ArcticDB is source-available (Business Source License 1.1 (converts to Apache-2.0 after 2 years)); kdb+ is proprietary (Commercial; KDB-X Community Edition free with resource limits). Horizontal scaling is native in ArcticDB and manual in kdb+. Only ArcticDB has time travel.
When should I choose ArcticDB over kdb+?
Choose ArcticDB for quant research data stores; versioned financial time series; and feature and factor libraries for backtesting. Choose kdb+ for equities, FX and futures tick capture; trade surveillance and best-execution analysis; and quant research on historical market data.
Is ArcticDB or kdb+ more popular?
kdb+ ranks #75 on the WhichDB Score (31.8/100) and ArcticDB ranks #232 (14.4/100). Popularity is not fit: check the requirements that matter for your project.
Are ArcticDB and kdb+ open source?
Not in the OSI sense. ArcticDB is source-available: you can read the code, but the license restricts some uses, typically offering it as a competing managed service. License: Business Source License 1.1 (converts to Apache-2.0 after 2 years). No. kdb+ is proprietary, closed-source software. License: Commercial; KDB-X Community Edition free with resource limits.