Latihan 1: Choosing Your Database — System Design

Latihan 1 dari materi Choosing Your Database di System Design — praktek dengan editor kode interaktif, test case otomatis, dan hint terpandu. Langsung jalan di browser.

Implementasikan pickDatabase(workload) yang mengembalikan salah satu: "SQL", "KV", "Document", "Graph", atau "TimeSeries".

workload adalah object dengan properti:

shape: "relational" | "document" | "graph" | "timeseries" | "keyvalue"
writesPerSec: number
needsAcidTransactions: boolean
queryPattern: "joins" | "lookup" | "traversal" | "range-scan" | "aggregate"

Aturan (cek berurutan, yang pertama match menang):

Kalau shape === "timeseries" atau queryPattern === "range-scan" dengan writesPerSec > 10000 → "TimeSeries"
Kalau shape === "graph" atau queryPattern === "traversal" → "Graph"
Kalau needsAcidTransactions === true atau queryPattern === "joins" → "SQL"
Kalau shape === "document" → "Document"
Default → "KV"

Hint

Aturan dicek berurutan, first match menang. Artinya pakai if-else berurutan (bukan if-if-if), dan urutan HARUS sesuai instruksi.
Urutan pasti: 1) timeseries OR (range-scan AND writesPerSec > 10000) → TimeSeries. 2) graph OR traversal → Graph. 3) needsAcidTransactions OR joins → SQL. 4) document → Document. 5) default → KV.
Struktur: if (workload.shape === "timeseries" || (workload.queryPattern === "range-scan" && workload.writesPerSec > 10000)) return "TimeSeries"; if (...) return "Graph"; ... Return string yang case-sensitive.