Changes between Version 8 and Version 9 of AdvancedReports

Timestamp:

02/03/26 19:09:40 (3 weeks ago)

Author:

213140

Comment:

--

AdvancedReports

@@ -298 +298 @@
 **Дефинирање на Blog_Monthly**
 
-
-
+F{bm} ← π{id_blog, id_patient, YEAR(date_of_post) -> year, MONTH(date_of_post) -> month} (B)
+
+BM ← {year, month} σCOUNT(id_blog) -> total_blogs, COUNT(DISTINCT {id_patient}) -> active_bloggers} (F{bm})
+
+**Дефинирање на Diary_Monthly**
+
+F{dm} ← π{id_diary, id_patient, daily_rating, YEAR(date) -> year, MONTH(date) -> month} (D)
+
+DM ← {year, month} σ{COUNT(id_diary) -> total_diaries, COUNT(DISTINCT id\_patient) -> active_diarists, AVG(daily_rating) -> avg_monthly_mood} (F{dm})
+
+**Поврзување на Monthly_Stats**
+
+MS ← BM ⟗{BM.year = DM.year ∧ BM.month = DM.month} DM
+
+MS{final} ← π{COALESCE(BM.year, DM.year) -> year, COALESCE(BM.month, DM.month) -> month, ..., avg_monthly_mood} (MS)
+
+**Selection и Projection**
+
+P ← 
+π{year, month, total_blogs, total_diaries, avg_monthly_mood, (total_blogs / active_bloggers) -> BlogsPerUser, (total_diaries / active_diarists) -> DiariesPerUser} (MS{final})
+
+P{ext} ← 
+π{*, CASE_WHEN}(...) -> BehaviourType, (total_blogs / (total_blogs + total_diaries)) * 100 -> PublicityRate} (P)
+
+**Подредување**
+
+R{final} ← τ{year DESC, month DESC} (P{ext})
+