Changes between Version 14 and Version 15 of AnalyticalStatisticalQuerying

Timestamp:

09/30/25 20:44:20 (13 days ago)

Author:

222077

Comment:

--

AnalyticalStatisticalQuerying

@@ -249 +249 @@
 }}}
 
-== Results (Relational Algebra) ==
+=== Results (Relational Algebra) ===
 {{{
 T1 = σ(account_id = 300 ∧ date_purchased ≥ CURRENT_DATE - 3m)(ticket)
@@ -270 +270 @@
 }}}
 
-== Analysis (Optimizations) ==
+=== Analysis (Optimizations) ===
  * Push selection down: filter `ticket` by `account_id` and `date_purchased` before joins to reduce data early.
  * Compute `weight` in a projection step before aggregation for clarity and efficiency.
@@ -278 +278 @@
    - Foreign key indexes on `ticket.trip_id`, `trip.route_id`, and `route.{from_location_id, to_location_id, transport_organizer_id}`.
 
-== Conclusion (Rewritten SQL) ==
+=== Conclusion (Rewritten SQL) ===
 {{{
 WITH route_scores AS (
@@ -356 +356 @@
 }}}
 
-== Results (Relational Algebra) ==
+=== Results (Relational Algebra) ===
 {{{
 J1 = location ⨝ ticket (l.location_id = t.gets_off_location_id)
@@ -376 +376 @@
 }}}
 
-== Analysis (Optimizations) ==
+=== Analysis (Optimizations) ===
  * Push projections early: keep only `location_id`, `ticket_id`, `account_id`, `price`, and join keys before grouping.
  * Apply the date filter (`past year`) explicitly in the `WHERE` clause on `ticket.date_purchased` (missing in original).
@@ -385 +385 @@
    - Foreign keys on `trip.route_id`, `trip.transport_organizer_id`.
 
-== Conclusion (Rewritten SQL) ==
+=== Conclusion (Rewritten SQL) ===
 {{{
 WITH destinations AS (
@@ -450 +450 @@
 }}}
 
-== Results (Relational Algebra) ==
+=== Results (Relational Algebra) ===
 {{{
 J1 = route ⨝ transport_organizer
@@ -469 +469 @@
 }}}
 
-== Analysis (Optimizations) ==
+=== Analysis (Optimizations) ===
  * Push projections early to reduce carried attributes before aggregation.
  * Join order: start with fact tables (`ticket`, `payment`) then join dimension tables (`trip`, `route`, `location`, `transport_organizer`).
@@ -477 +477 @@
    - Foreign keys: `route.from_location_id`, `route.to_location_id`, `route.transport_organizer_id`
 
-== Conclusion (Rewritten SQL) ==
+=== Conclusion (Rewritten SQL) ===
 {{{
 CREATE VIEW top_selling_routes_view AS