3 ms·
MDX is microsoft proptech, OLAP is more generic term to define analytical processing (in contrast to transaction processing as in CRUD). OLAP cube is microsoft
by slt2021 4y ago
MDX is microsoft proptech, OLAP is more generic term to define analytical processing (in contrast to transaction processing as in CRUD).
OLAP cube is microsoft's take on OLAP using 90s technologies for tech stacks from 1990s (Windows Server + SQL Server + SSAS).
DuckDB is a modern take on OLAP
- intrasight 4y agoEvery OLAP database that I've used supports MDX MDX == OLAP SQL == relational