Trade-Offs Between Database Technologies

HardSQL · PostgreSQL

Problem

Discuss the trade-offs between different database technologies for data storage.

Using the supplied technology and benchmark data, write a SQL query that summarizes measurable trade-offs for each technology, including technologies without benchmark records. Classify each technology based on its observed characteristics.

Output

One row per storage technology with its name, storage model, average read and write latency, average throughput, average storage footprint, and trade-off profile.
Include technologies without benchmark records, using NULL metrics and Insufficient benchmark data as the profile.
Sort by technology name alphabetically.

Schema

database_technologies

Column	Type	Description
technology_idPK	INT	Unique storage technology identifier
technology_name	VARCHAR(100)	Name of the database or storage technology
storage_model	VARCHAR(50)	Primary storage model
consistency_level	VARCHAR(50)	Typical consistency guarantee

storage_benchmarks

Column	Type	Description
benchmark_idPK	INT	Unique benchmark observation identifier
technology_id	INT	Referenced storage technology
workload_type	VARCHAR(50)	Workload represented by the observation
read_latency_ms	DECIMAL(10,2)	Average read latency in milliseconds
write_latency_ms	DECIMAL(10,2)	Average write latency in milliseconds
throughput_ops_sec	INT	Observed operations per second
storage_gb	DECIMAL(10,2)	Storage consumed in gigabytes

Tablesdatabase_technologiesstorage_benchmarks