OLTP vs OLAP for Progress Data

Compare and contrast different database strategies (OLTP vs. OLAP) for storing construction progress data at Doxel.

Using the provided operational event records and analytical daily summaries, write a query that compares the two representations for each project and date. Identify whether each record matches, differs, or exists in only one representation.

Output

1. One row per project and progress date, including projects and dates present in either source.
2. Return project_id, project_name, progress_date, oltp_planned_units, oltp_completed_units, olap_planned_units, olap_completed_units, and comparison_status.
3. Sort by project_id, then progress_date ascending.