Row format (logical)
Heap:
[10, FRED, 10, M]
[11, WILMA, 10, F]
[12, DINO, 30, M]
[13, BARNEY, 10, M]
[14, BETTY, 20, F]
Column stores:
EMPNO: [1, 10] [2, 11] [3, 12] [4, 13] [5, 14]
ENAME: [1, FRED] [2, WILMA] [3, DINO] [4, BARNEY] [5, BETTY]
DEPTNO: [1, 10] [2, 10] [3, 30] [4, 10] [5, 20]
SEX: [1, M] [2, F] [3, M] [4, M] [5, F]
RID EMPNO ENAME DEPTNO SEX 1 10 FRED 10 M 2 11 WILMA 10 F 3 12 DINO 30 M 4 13 BARNEY 10 M 5 14 BETTY 20 F