Changes between Version 1 and Version 2 of DmlScript


Ignore:
Timestamp:
05/04/26 11:47:28 (3 weeks ago)
Author:
231141
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • DmlScript

    v1 v2  
    11This DML script simulates the real behavior of the application over time, rather than inserting all data at once. The key idea is that several parts of the system are interdependent, especially offer pricing, badges, and reviews.
    22
    3 The price of each offer is not purely random—it depends on the worker’s badge in the corresponding category. The badge itself is calculated based on the worker’s average ratings derived from reviews accumulated over time. In other words, there is a clear dependency chain:
     3The price of each offer is not purely random—it depends on the worker’s badge in the corresponding category.
     4As workers progress through badge levels over time based on their reviews, offer pricing must remain aligned with their current badge status. For this reason, data generation was performed in monthly batches, enabling periodic badge recalculation and corresponding updates to price ranges. The badge itself is calculated based on the worker’s average ratings derived from reviews accumulated over time. In other words, there is a clear dependency chain:
    45reviews → badges → offer price
    56