Changeset 2853f2e for sql

Timestamp:

09/23/26 14:02:31 (3 hours ago)

Author:

Stefan-Saveski <stefansaveski19@…>

Branches:

master

Parents:

0496e6e

Message:

Add performance analysis scripts and schema for educational database

• Created performance analysis scripts for student dossier, subject pass rate, and top students per major.
• Added indexes to improve query performance on key tables.
• Generated bulk test data for performance analysis in the 'perf' schema.
• Established the 'perf' schema with necessary tables and types for educational data management.

Location:

sql/perf

Files:

• after_dossier_one.txt (added)
• after_gradebook.txt (added)
• after_rep_busiest_professor.txt (added)
• after_rep_semester_growth.txt (added)
• after_rep_student_dossier.txt (added)
• after_rep_subject_pass_rate.txt (added)
• after_rep_top_student_per_major.txt (added)
• before_dossier_one.txt (added)
• before_gradebook.txt (added)
• before_rep_busiest_professor.txt (added)
• before_rep_semester_growth.txt (added)
• before_rep_student_dossier.txt (added)
• before_rep_subject_pass_rate.txt (added)
• before_rep_top_student_per_major.txt (added)
• indexes.sql (added)
• perf_data.sql (added)
• perf_schema.sql (added)