Database Query Optimizer Simulation

• Tech Stack: Java

Developed a comprehensive database query optimizer simulation as a significant component of my databases coursework at SJSU. Leveraged Java programming to create a sophisticated simulation model inspired by IBM DB2 query optimizer algorithms. Demonstrated a dedicated focus on translating algorithmic concepts into a practical high-level database query optimizer simulation.

Skillfully implemented a process for generating optimized access paths by incorporating advanced cost estimation techniques. Utilized in-depth database statistics and available index data to enhance the accuracy of access path optimization. Encompassed a wide array of optimization elements in the generated access path, including JOIN sequence, JOIN method selection, Query Transformation strategies, Index and Data page utilization, Prefetch mechanisms, Predicate evaluation sequencing, and precise Filter factor application.