Changes between Version 4 and Version 5 of AdvancedTopics

Timestamp:

06/15/26 02:31:12 (27 hours ago)

Author:

231141

Comment:

--

AdvancedTopics

@@ -9 +9 @@
 == 1. Personalized Recommendations ==
 
-This is the recommendation system that recommends open task requests to workers that have the most similar completed tasks. For this purpose we first embedded the open task requests and then as a starting point for our system we embedded three task requests that resulted in a completed task for each worker. We found this number of tasks enough as a starting point for our app. We built these embeddings with the script [attachment:embed_taskrequests.py] and we used a table to store these vectors:
-
+This is the recommendation system that recommends open task requests to workers that have the most similar completed tasks. For this purpose we first embedded the open task requests and then as a starting point for our system we embedded three task requests that resulted in a completed task for each worker. We found this number of tasks enough as a starting point for our app. We built these embeddings and we used a table to store these vectors:
+{{{
+#!sql
+INSERT INTO worker_recommendation_profiles
+(
+    worker_id,
+    preference_embedding,
+    updated_at
+)
+WITH ranked_tasks AS
+(
+    SELECT
+        o.worker_id,
+        o.task_request_id,
+        ROW_NUMBER() OVER
+        (
+            PARTITION BY o.worker_id
+            ORDER BY
+                COALESCE(t.updated_at, t.created_at) DESC
+        ) AS rn
+    FROM Task t
+    JOIN Offer o
+        ON o.id = t.offer_id
+    WHERE t.status = 'COMPLETED'
+)
+SELECT
+    rt.worker_id,
+    AVG(tre.embedding),
+    CURRENT_TIMESTAMP
+FROM ranked_tasks rt
+JOIN task_request_embeddings tre
+    ON tre.task_request_id = rt.task_request_id
+WHERE rt.rn <= 3
+GROUP BY rt.worker_id
+ON CONFLICT (worker_id)
+DO UPDATE SET
+    preference_embedding = EXCLUDED.preference_embedding,
+    updated_at = CURRENT_TIMESTAMP;
+}}}
 {{{
 #!sql