Changes between Version 1 and Version 2 of ComplexReports

Timestamp:

01/27/26 23:40:01 (12 days ago)

Author:

233051

Comment:

--

ComplexReports

@@ -21 +21 @@
 ORDER BY usage_count DESC, avg_build_rating DESC
 LIMIT 20;
+}}}
+
+{{{
+λ_20(
+ τ_{usage_count DESC, avg_build_rating DESC}(
+  σ_{avg_build_rating ≥ 4.5}(
+   γ_{c.type, c.brand, c.name;
+     COUNT(bc.component_id)→usage_count,
+     AVG(rb.value)→avg_build_rating
+   }(
+    σ_{b.created_at ≥ CURRENT_DATE - 1 year}(
+     (((components c ⋈_{c.id=bc.component_id} build_component bc)
+       ⋈_{bc.build_id=b.id} build b)
+       ⋈_{b.id=rb.build_id} rating_build rb)
+    )
+   )
+  )
+ )
+)
 }}}
 
@@ -67 +86 @@
 ORDER BY reputation_score DESC
 LIMIT 10;
+}}}
+
+{{{
+build_stats =
+γ_{b.id → build_id, b.user_id;
+   COUNT_DISTINCT(fb.user_id) → favorites_count,
+   AVG(rb.value) → avg_rating
+} (
+  σ_{b.is_approved = TRUE} (
+    (build b
+      ⟕_{b.id = fb.build_id} favorite_build fb)
+      ⟕_{b.id = rb.build_id} rating_build rb
+  )
+)
+
+user_stats =
+γ_{user_id;
+COUNT(build_id) → approved_builds_count,
+SUM(favorites_count) → total_favorites_received,
+AVG(avg_rating) → avg_rating_received
+} (
+build_stats
+)
+
+λ_10 (
+  τ_{reputation_score DESC} (
+    π_{u.username,
+      u.email,
+      us.approved_builds_count,
+      us.total_favorites_received,
+      ROUND(us.avg_rating_received, 2) → avg_rating_received,
+      ((us.approved_builds_count * 10)
+       + (us.total_favorites_received * 5)
+       + (us.avg_rating_received * 20)) → reputation_score
+    } (
+      user_stats us ⋈_{u.id = us.user_id} users u
+    )
+  )
+)
 }}}
 
@@ -116 +174 @@
 LIMIT 20;
 }}}
+
+{{{
+cpu_per_build =
+π_{b.id → build_id,
+   c.name → cpu_model,
+   cpu.cores,
+   cpu.base_clock
+} (
+  σ_{c.type = 'CPU'} (
+    (((build b
+      ⋈_{b.id = bc.build_id} build_component bc)
+      ⋈_{bc.component_id = c.id} components c)
+      ⋈_{c.id = cpu.component_id} cpu)
+  )
+)
+
+gpu_per_build =
+π_{b.id → build_id,
+   c.name → gpu_model,
+   gpu.vram
+} (
+  σ_{c.type = 'GPU'} (
+    (((build b
+      ⋈_{b.id = bc.build_id} build_component bc)
+      ⋈_{bc.component_id = c.id} components c)
+      ⋈_{c.id = gpu.component_id} gpu)
+  )
+)
+
+λ_20 (
+  τ_{price_to_performance_index DESC} (
+    π_{b.name → build_name,
+      cpu.cpu_model,
+      gpu.gpu_model,
+      b.total_price,
+      (cpu.cores * cpu.base_clock + gpu.vram * 100) → performance_score,
+      ROUND((cpu.cores * cpu.base_clock + gpu.vram * 100), 4) → price_to_performance_index
+    } (
+      σ_{b.total_price > 0} (
+        ((build b
+          ⋈_{b.id = cpu.build_id} cpu_per_build cpu)
+          ⋈_{b.id = gpu.build_id} gpu_per_build gpu)
+      )
+    )
+  )
+)
+}}}