An online application stores each customer order along with all of its line items, the customer's shipping address as it stood at the time of purchase, and the payment confirmation. Each order is created once, read together as a complete unit, and never modified. The most appropriate database type for this workload is:

Question

Accepted Answer

A document database, because each order is a self-contained record with nested fields that are read and written together

Answer

A time-series database, because each order has a creation timestamp and orders accumulate continuously over time as the business operates.

Answer

Any database type performs equivalently here, because the workload is simple and the differences between database types do not apply.

Answer

A relational database, because every order has structured fields that map cleanly to columns in a single orders table.

Crowdly

An online application stores each customer order along with all of its line item...

Want instant access to all verified answers on moodle.polytechnic.bh?