index

2021-06-17

2021-10-17


how to represent nulls in indexes?

Two zero bytes is zero and zero and one is a null.

00 01 -> null
00 00 -> 00
00 01 00 00 -> null 00
00 00 00 01 -> 00 null

A bitmask per row could be used to mark null values on that row. One bit per column.

timestamps as offsets


→ timestamps as offsets
→ Variable length quantity
→ identifier number size does not matter for storage space and readability
→ using custom offset for millisecond precision unix epoch is not worth it

This site is generated with zetgen