Storage systems and file structures

storage systems

file storage block storage blob storage

types of data structures

1. row stores
   • mysql and postgres
   • used for transaction processing
2. column stores
   • redshift, bigquery, snowflake
   • used for aggregating large volumes of data for a subset of columns
   • used for highly analytical query models

https://dataschool.com/data-modeling-101/row-vs-column-oriented-databases/ https://www.percona.com/blog/2016/12/14/row-store-and-column-store-databases/#:~:text=At%20a%20basic%20level%2C%20row,for%20a%20subset%20of%20columns.