IBM Db2
IBM's relational database for mainframes, Linux and Windows, with BLU columnar tables for analytics next to transactions. See how developers rate it month by month on DTDb.
- Category
- database engine
- Developer
- IBM
- Created by
- —
- First release
- 1983
- License
- Proprietary
- Open source
- No
- Pricing
- Free with paid plans
- Website
- https://www.ibm.com/db2
- Written in
- C, C++
- Data model
- Relational
- Storage layout
- Hybrid row and column
- Workload
- Both (HTAP)
- Analytics architecture
- Not an analytics platform
- Query language
- SQL, SQL PL
- ACID transactions
- Yes
- Schema
- Strict
- Deployment
- Server, Distributed cluster, Managed cloud
- Scaling
- Replication
- Create, read, update, delete
- Create: fast (Fast inserts, LOAD for bulk data); Read: fast (Mature cost-based optimizer); Update: fast (In-place updates with logging); Delete: fast (Fast deletes, space reused by reorg)