Changes between Version 2 and Version 3 of AdvancedReport1

Timestamp:

12/29/25 18:24:38 (4 days ago)

Author:

211101

Comment:

--

AdvancedReport1

@@ -53 +53 @@
 
 JOIN на сите табели:
-- J1 := TA ⨝_{TA.user_id = U.user_id} U
-- J2 := J1 ⨝_{TA.transaction_account_id = TB.transaction_account_id} TB
-- J3 := J2 ⨝_{TB.transaction_id = T.transaction_id} T
+- J1 ← TA ⨝,,TA.user_id = U.user_id,, U
+- J2 ← J1 ⨝,,TA.transaction_account_id = TB.transaction_account_id,, TB
+- J3 ← J2 ⨝,,TB.transaction_id = T.transaction_id,, T
 
 Филтер според име на акаунт:
-- F1 := σ_{account_name = p_account_name}(J3)
+- F1 ← σ,,account_name = p_account_name,,(J3)
 
 Пресметка на кумулативен баланс:
-- CB := γ_{user_id, user_name, account_name, transaction_id, transaction_name, transaction_amount, transaction_date; 
-        Σ(transaction_amount) OVER (PARTITION BY transaction_account_id ORDER BY transaction_date) → calculated_balance}(F1)
+- CB ← γ,,user_id, user_name, account_name, transaction_id, transaction_name, transaction_amount, transaction_date; Σ(transaction_amount) OVER (PARTITION BY transaction_account_id ORDER BY transaction_date) → calculated_balance,,(F1)
 
 каде `transaction_amount = spent_amount` и кумулативната сума е `Σ(earned_amount - spent_amount)`
 
 Филтрирање на трансакциите кои го надминуваат балансот:
-- R := σ_{transaction_amount > calculated_balance ∧ transaction_amount > 0}(CB)
+- R ← σ,,transaction_amount > calculated_balance ∧ transaction_amount > 0,,(CB)
 
 Подредување хронолошки(почнувајќи од најновата трансакција до најстарата):
-- R_final := τ_{transaction_date DESC}(R)
+- R_final ← τ,,transaction_date DESC,,(R)