Changes between Version 2 and Version 3 of DatabaseCreation

Timestamp:

05/04/26 11:50:23 (3 weeks ago)

Author:

231141

Comment:

--

DatabaseCreation

@@ -1 @@
-Database createion
-DDL
-DdlScript
-DML
-DmlScript
+= Database Creation =
+
+== DDL ==
+ * '''Script:''' DdlScript  
+ Defines the database schema, including tables, relationships, constraints, and indexes.
+
+
+== DML ==
+ * '''Script:''' DmlScript  
+
+This 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.
+
+The price of each offer is not purely random—it depends on the worker’s badge in the corresponding category. As 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:
+
+ * '''reviews → badges → offer price'''
+
+Because of this dependency, the data cannot be generated in a single step. Instead, the script simulates the application timeline, where data is created in a realistic order:
+
+ 1. TaskRequests are created first  
+ 2. Offers are generated  
+ 3. One offer per task is accepted and Tasks are created  
+ 4. Tasks are completed  
+ 5. Reviews are added  
+ 6. Badges are recalculated  
+
+This process runs in monthly batches (e.g., February → March), allowing reviews to accumulate gradually and workers to progress naturally through badge levels.
+
+For simplicity and performance reasons, badge recalculation is not triggered after every change (such as each new review). Instead, it is performed at the end of each month, which significantly reduces computational overhead while still preserving realistic system behavior.
+
+
+== Conclusion ==
+This DML script acts as a time-based simulation of the application lifecycle, ensuring that dependencies between reviews, badges, and offer pricing are respected while maintaining efficiency.