In-Depth: In-Memory Database for a Table | Dataford Interview Questions

Design and implement an in-memory database for a single static table. Requirements: All values are numeric. Build a column index during initialization. (remaining requirements hidden)

Asked in the Round 1: coding tech screen stage. Remaining requirements are behind a points wall.

Output

Return every row from static_table.
Include row_id, value_a, value_b, value_c, and value_d.
Order rows by row_id ascending.

Schema

static_table

Column	Type	Description
row_idPK	BIGINT	Unique row identifier
value_a	NUMERIC(12,2)	First numeric value
value_b	NUMERIC(12,2)	Second numeric value
value_c	NUMERIC(12,2)	Third numeric value
value_d	NUMERIC(12,2)	Fourth numeric value

Your question is In-Depth: In-Memory Database for a Table. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem