Changes between Version 3 and Version 4 of ComponentCompatibilitySuccessRate

Timestamp:

01/29/26 16:50:20 (10 days ago)

Author:

233194

Comment:

--

ComponentCompatibilitySuccessRate

@@ -77 +77 @@
 {{{
 cpu_mobo_pairs = 
-  π_{cpu.brand ⇒ cpu_brand, cpu.name ⇒ cpu_model,
+  π_{cpu_comp.brand ⇒ cpu_brand, 
+     cpu_comp.name ⇒ cpu_model,
      mobo.chipset ⇒ motherboard_chipset,
-     b.id ⇒ build_id
+     b.id ⇒ build_id,
+     b.user_id,
+     b.created_at
   } (
-    σ_{c1.type = 'CPU' AND c2.type = 'Motherboard'} (
+    σ_{b.is_approved = TRUE} (
       build b 
-      ⋈_{b.id = bc1.build_id} build_component bc1
-      ⋈_{bc1.component_id = c1.id} components c1
-      ⋈_{b.id = bc2.build_id} build_component bc2
-      ⋈_{bc2.component_id = c2.id} components c2
+      ⋈_{b.id = bc_cpu.build_id} build_component bc_cpu
+      ⋈_{bc_cpu.component_id = cpu_comp.id} components cpu_comp
+      ⋈_{cpu.component_id = cpu_comp.id} cpu
+      ⋈_{b.id = bc_mobo.build_id} build_component bc_mobo
+      ⋈_{bc_mobo.component_id = mobo_comp.id} components mobo_comp
+      ⋈_{mobo.component_id = mobo_comp.id} motherboard mobo
     )
   )
 
+recent_activity = 
+  π_{DISTINCT build_id} (
+    σ_{created_at ≥ CURRENT_DATE - INTERVAL '3 months'} (review)
+  )
+
 pair_metrics = 
-  γ_{cpu_brand, cpu_model, motherboard_chipset;
-     COUNT(build_id) ⇒ total_builds,
-     AVG(rb.value) ⇒ avg_satisfaction,
-     COUNT(DISTINCT ub.user_id WHERE ub.still_active = TRUE) ⇒ active_builds
+  γ_{cmp.cpu_brand, cmp.cpu_model, cmp.motherboard_chipset;
+     COUNT(DISTINCT cmp.build_id) ⇒ total_builds,
+     AVG(COALESCE(rb.value, 0)) ⇒ avg_satisfaction,
+     COUNT(DISTINCT ra.build_id) ⇒ active_builds
   } (
     cpu_mobo_pairs cmp
-    ⋈_{cmp.build_id = rb.build_id} rating_build rb
-    ⋈_{cmp.build_id = ub.build_id} user_builds ub
+    ⟕_{cmp.build_id = rb.build_id} rating_build rb
+    ⟕_{cmp.build_id = ra.build_id} recent_activity ra
   )
+  WHERE total_builds ≥ 2
 
-λ_12 (
+λ_15 (
   τ_{success_rate DESC, total_builds DESC} (
-    σ_{total_builds ≥ 10} (
-      π_{pm.cpu_brand + ' ' + pm.cpu_model ⇒ cpu_combo,
-         pm.motherboard_chipset,
-         pm.total_builds,
-         ROUND(pm.avg_satisfaction, 2) ⇒ avg_satisfaction,
-         ROUND((pm.avg_satisfaction / 5.0) * 0.6 + (pm.active_builds / pm.total_builds) * 0.4, 3) ⇒ success_rate
-      } (pair_metrics pm)
-    )
+    π_{CONCAT(pm.cpu_brand, ' ', pm.cpu_model) ⇒ cpu_combo,
+       pm.motherboard_chipset,
+       pm.total_builds,
+       ROUND(pm.avg_satisfaction, 2) ⇒ avg_satisfaction,
+       ROUND((pm.avg_satisfaction / 5.0) * 0.6 + (pm.active_builds / pm.total_builds) * 0.4, 3) ⇒ success_rate
+    } (pair_metrics pm)
   )
 )