Permit applications arrive as nested JSON-like records with sections that differ by permit type. Which NoSQL type is the best fit for storing these semi-structured civic records?
Select an answer to reveal the explanation.
Short Explanation
Permits look like folders with nested forms—perfect for documents. A document store keeps the whole JSON-shaped application together. That beats flattening every nested checkbox into awkward tables.
Full Explanation
Document databases store semi-structured records, typically JSON-like documents with nested fields. Permit applications vary by type yet still need to be retrieved as cohesive units, which maps well to documents. Rigid relational schemas struggle when nested sections differ widely across permit classes. Choosing a document store aligns storage shape with the civic application's natural structure.