Columnary vs Row based

OLAP vs OLTP

Columnary data

• https://hevodata.com/learn/columnar-databases/

Parquet

• faster query run time

• it is smaller in size

• requires fewer data to be scanned compared to formats such as CSV

Columnary data is suitable for OLAP operations

• https://www.sobyte.net/post/2021-11/whys-the-design-olap-column-oriented/

• https://www.quora.com/Why-are-columnar-databases-more-suited-for-OLAP-applications?share=1

• https://support.microsoft.com/en-us/office/overview-of-online-analytical-processing-olap-15d2cdde-f70b-4277-b009-ed732b75fdd6

• What is OLAP: https://learn.microsoft.com/en-us/azure/architecture/data-guide/relational-data/online-analytical-processing

• https://www.ibm.com/cloud/learn/olap

• https://dwgeek.com/column-oriented-database-stores-data-details.html/