OLAP
Short for Online Analytical Processing — optimised for the opposite of OLTP: scanning and aggregating huge numbers of rows at once, not fetching one record fast. Not a general-purpose replacement for an OLTP database; a different tool for a different shape of problem, only worth reaching for once something is actually doing analytics at volume.
| App | License | FOSS problems | SSO | Users | Tested |
|---|---|---|---|---|---|
| ClickHouseColumn-oriented database built for fast analytical queries over very large datasets, rather than transactional application state. | Apache-2.0Permissive license. Like MIT, but each contributor grants users a patent licence covering their contribution, preventing later suits. | — | — | Unlimited | ❌ |