It's the same basic concept, yes. The details matter, though, and the fact that AoS/SoA is mostly about in-memory layout, whereas row/column store is about on-disk layout means that the performance compromises are very different. E.g. column store databases frequently use RLE for compression, but that's probably _way_ too expensive for SoA.
Great read! I do enjoy exploring both row and column data stores every now and then. Love the way I get my head bent.
Am I missing something or is this nothing more but AOS vs SOA ?
Please introduce your acronyms!
Array of Structures vs Structure of Arrays.
It's the same basic concept, yes. The details matter, though, and the fact that AoS/SoA is mostly about in-memory layout, whereas row/column store is about on-disk layout means that the performance compromises are very different. E.g. column store databases frequently use RLE for compression, but that's probably _way_ too expensive for SoA.
Thank you!
I enjoyed reading this post