Changes between Version 9 and Version 10 of AdvancedReports

Timestamp:

02/09/26 00:39:23 (2 weeks ago)

Author:

213140

Comment:

--

AdvancedReports

@@ -32 +32 @@
 **JOIN на сите табели:**
 
-J1 ← P ⨝{P.id_user = U.id_user} U
-
-Ј2 ← Ј1 ⟕{P.id_user = C.id_patient} C
-
-Ј3 ← Ј2 ⟕{C.id_consultation = TH.id_consultation} TH
-
-Ј4 ← Ј3 ⨝{P.id_user = D.id_patient} D
+J1 ← P ⨝,,P.id_user = U.id_user,, U
+
+Ј2 ← Ј1 ⟕,,P.id_user = C.id_patient,, C
+
+Ј3 ← Ј2 ⟕,,C.id_consultation = TH.id_consultation,, TH
+
+Ј4 ← Ј3 ⨝,,P.id_user = D.id_patient,, D
 
 **Проекција со трансформација на датум**
 
-D' ← π{id_user, id_consultation, id_therapy, daily_rating, YEAR(date) -> Year}(J4)
+D' ← π,,id_user, id_consultation, id_therapy, daily_rating, YEAR(date) -> Year,,(J4)
 
 **Групирање и пресметка на агрегати**
 
-G ← Year σ
+G ← Year γ,,
 COUNT(DISTINCT id_user) -> Total_Patients, 
 COUNT(DISTINCT id_consultation) -> Total_Consultations, 
@@ -52 +52 @@
 AVG(daily_rating) -> Avg_Mood_All_Patients, 
 MIN(daily_rating) -> Lowest_Mood_Recorded
-}(D')
+,,(D')
 
 **Хронолошко подредување според година**
 
-R{final} ← τ{Year}(G)
+R,,final,, ← τ,,Year,,(G)
 
 == Годишен извештај за честота на користење на консултации и процент на платени консултации заедно со нивната просечна цена 
@@ -96 +96 @@
 **JOIN на сите табели:**
 
-J1 ← T ⨝{T.id_user = U.id_user} U
-
-Ј2 ← Ј1 ⨝{T.id_user = C.id_therapist} C
+J1 ← T ⨝,,T.id_user = U.id_user,, U
+
+Ј2 ← Ј1 ⨝,,T.id_user = C.id_therapist,, C
 
 **Екстракција на име и година**
 
-F1 ← π{id_user, id_consultation, price, date_of_payment, YEAR(date) -> Year, CONCAT(name, ' ', surname) -> Therapist_Name} (J2)
+F1 ← π,,id_user, id_consultation, price, date_of_payment, YEAR(date) -> Year, CONCAT(name, ' ', surname) -> Therapist_Name,, (J2)
 
 **Групирање и пресметка на агрегати**
 
-G ← {Year, id_user, Therapist_Name} σ
-COUNT(id_consultation) -> Total_Consultations,
+G ← ,,Year, id_user, Therapist_Name,, γ
+,,COUNT(id_consultation) -> Total_Consultations,
 COUNT_IF(date_of_payment != NULL) -> Completed_Consultations,
-AVG(price) -> Avg_Consultation_Price 
+AVG(price) -> Avg_Consultation_Price,, 
 (F1)
 
 **Пресметка на процент**
 
-P ←  π{Year, id_user, Therapist_Name, Total_Consultations, Completed_Consultations, Avg_Consultation_Price, (Completed_Consultations/ Total_Consultations) * 100 -> Completion_Rate_Percentage} (G)
+P ←  π,,Year, id_user, Therapist_Name, Total_Consultations, Completed_Consultations, Avg_Consultation_Price, (Completed_Consultations/ Total_Consultations) * 100 -> Completion_Rate_Percentage,, (G)
 
 **Подредување**
 
-R{final} ← τ{Year, Completion_Rate_Percentage DESC} (P)
+R,,final,, ← τ,,Year, Completion_Rate_Percentage DESC,, (P)
 
 == Годишен извештај за честота на постирање блогови и број на коментари по блог кај луѓе кој имаат отидено на терапевт барем 10 пати, според тоа кој терапевт го посетуваат
@@ -190 +190 @@
 **Дефинирање на LoyalPatients**
 
-J{lp} ← C ⨝{C.id_therapist = T.id_user} T ⨝{T.id_user = U.id_user} U
-
-LP ← σ{count_c >= 10} ({id_patient, id_therapist, name, surname} σ{COUNT(id_consultation) -> count_c} (J{lp}))
+J,,lp,,← C ⨝,,C.id_therapist = T.id_user,, T ⨝,,T.id_user = U.id_user,, U
+
+LP ← σ,,count_c >= 10,, ({id_patient, id_therapist, name, surname} γ,,COUNT(id_consultation) -> count_c,, (J,,lp,,))
 
 **Дефинирање на BlogStats**
 
-J{bs} ← B ⟕{B.id_blog = COM.id_blog} COM
-
-F{bs} ← π{id_patient, id_blog, id_comment, YEAR(date_of_post) -> post_year} (J{bs})
-
-BS ← {id_patient, post_year} σCOUNT(DISTINCT {id_blog} -> blogs_count, COUNT(id_comment) -> comments_count} (F{bs})
+J,,bs,, ← B ⟕,,B.id_blog = COM.id_blog,, COM
+
+F,,bs,, ← π,,id_patient, id_blog, id_comment, YEAR(date_of_post) -> post_year,, (J{bs})
+
+BS ← ,,id_patient, post_year,, γ,,COUNT(DISTINCT,,id_blog,, -> blogs_count, COUNT(id_comment) -> comments_count,, (F{bs})
 
 **Поврзување и пресметка на агрегати**
 
-J{final} ← LP ⨝{LP.id_patient = BS.id_patient} BS
-
-F{final} ← π{post_year, CONCAT(name, ' ', surname) -> Therapist, blogs_count, comments_count} (J{final})
-
-G ← {post_year, Therapist} σ
-SUM(blogs_count) -> Total_Blogs, 
+J,,final,, ← LP ⨝,,LP.id_patient = BS.id_patient,, BS
+
+F,,final,, ← π,,post_year, CONCAT(name, ' ', surname) -> Therapist, blogs_count, comments_count,, (J,,final,,)
+
+G ← ,,post_year, Therapist,, γ 
+,,SUM(blogs_count) -> Total_Blogs, 
 SUM(comments_count) -> Total_Comments, 
 AVG(blogs_count) -> Avg_Blogs,
-SUM(comments_count)/SUM(blogs_count) -> Avg_Comments_Per_Blog (F{final})
+SUM(comments_count)/SUM(blogs_count) -> Avg_Comments_Per_Blog,, (F,,final,,)
 
 **Подредување**
 
-R{final} ← τ{post_year DESC, Total_Blogs DESC} (G)
+R,,final,, ← τ,,post_year DESC, Total_Blogs DESC,, (G)
 
 == Вкупна годишна анализа на блогови по месец во однос на внесување дневници во просек по месец
@@ -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})
+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})
+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)
+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)
+π,,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})
-
+R,,final,, ← τ,,year DESC, month DESC,, (P,,ext,,)
+