Difference between revisions of "SAP HANA"
From Suhrid.net Wiki
Jump to navigationJump to search (Created page with "= Motivation = * Earlier: CPU, Memory expensive * New DB needs to take advantage of multi-core, large RAM * and Columnar technologies : Transactional vs Analytical * Better for ...") |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 5: | Line 5: | ||
* and Columnar technologies : Transactional vs Analytical | * and Columnar technologies : Transactional vs Analytical | ||
* Better for retrieval performance (analytical workloads) | * Better for retrieval performance (analytical workloads) | ||
| + | |||
| + | = Technology = | ||
| + | |||
| + | * Multi-core parallelism : massively parallel. Every operator is in parallel. | ||
| + | * Data locality in memory | ||
| + | * Columnar structures | ||
| + | * Row store : in memory : Transactions are quicker | ||
| + | * Column store : for analytics | ||
| + | * Projections, Dynamic Aggregation, Integrated Compression (From columnar structure) | ||
| + | * Insert-only : When something changes in a colstore, insert it and invalidate the old data | ||
| + | * Partitioning : distribute data across machines. rows/cols can be distributed. | ||
| + | * Hot/cold : When semantics are known, then some data can be kept in hot. | ||
| + | * SQL : Is the interface language | ||
| + | * MDX : Multi dimensional data traversal | ||
| + | * Text : functional | ||
| + | * Business functional stuff + Various libraries | ||
Latest revision as of 08:08, 6 April 2014
Motivation
- Earlier: CPU, Memory expensive
- New DB needs to take advantage of multi-core, large RAM
- and Columnar technologies : Transactional vs Analytical
- Better for retrieval performance (analytical workloads)
Technology
- Multi-core parallelism : massively parallel. Every operator is in parallel.
- Data locality in memory
- Columnar structures
- Row store : in memory : Transactions are quicker
- Column store : for analytics
- Projections, Dynamic Aggregation, Integrated Compression (From columnar structure)
- Insert-only : When something changes in a colstore, insert it and invalidate the old data
- Partitioning : distribute data across machines. rows/cols can be distributed.
- Hot/cold : When semantics are known, then some data can be kept in hot.
- SQL : Is the interface language
- MDX : Multi dimensional data traversal
- Text : functional
- Business functional stuff + Various libraries
