SAP HANA
SAP's in-memory column database, the base of S/4HANA, serving transactions and analytics from the same tables. See how developers rate it month by month on DTDb.
- Category
- database engine
- Developer
- SAP
- Created by
- —
- First release
- 2010
- License
- Proprietary
- Open source
- No
- Pricing
- Paid
- Website
- https://www.sap.com/products/data-cloud/hana.html
- Written in
- C++
- Data model
- Relational, Document, Graph, Vector
- Storage layout
- In-memory
- Workload
- Both (HTAP)
- Analytics architecture
- Not an analytics platform
- Query language
- SQL, SQLScript
- ACID transactions
- Yes
- Schema
- Strict
- Deployment
- Server, Distributed cluster, Managed cloud
- Scaling
- Sharding
- Create, read, update, delete
- Create: fast (Inserts land in a write-optimized delta store); Read: fast (In-memory column scans); Update: moderate (Writes go to the delta, merged into the main store later); Delete: moderate (Old versions removed when the delta is merged)