Project Overview
Collaborated on the development of a MySQL database for a cab booking service. The project focused on optimizing the database for efficient data handling and managing concurrent transactions in a high-volume booking environment.
Implemented SQL triggers to automate certain database operations and OLAP queries for complex data analysis. Developed and integrated transaction management protocols to ensure data consistency during concurrent operations, enhancing the overall reliability and performance of the booking system.
Tools Used
MySQL
SQL Triggers
OLAP Queries
Transaction Management
Concurrency Control