(2024)
This was an incredibly comprehensive Database system created from the ground up. Some aspects included buffer management, file handling, undo functionality, logging, metadata, query parsing, record management, and transaction processing. In the end, a SQL query (in natural language) could be parsed, optimized, and executed within the system, interacting with the underlying storage and transaction mechanisms.
The hardest part about this project was rollback functionality, ensuring correct undo and redo operations.
- Tech Stack: Java