You might be interested in [0], which is one of the course readings for [1] which has video available ("Storage Models, Data Layout, & System Catalogs"). Specif

You might be interested in [0], which is one of the course readings for [1] which has video available ("Storage Models, Data Layout, & System Catalogs"). Specifically, the paper asks if you can turn a row-store into a column-store by just vertically partitioning the schema or building more indexes etc; the answer is no, and they go into various reasons why (late materialization 3x, compression 2x to 10x depending on whether query is accessing sorted data, etc). [0] https://15721.courses.cs.cmu.edu/spring2020/papers/08-storage/p967-abadi.pdf https://15721.courses.cs.cmu.edu/spring2020/papers/08-storag... [1] https://15721.courses.cs.cmu.edu/spring2020/schedule.html https://15721.courses.cs.cmu.edu/spring2020/schedule.html