Skip to content

leahjia/DB-System-Design

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

DB-System-Design

LinkedIn Personal


Logo

Appointment Reservation System

Goal: Make Reservation Process Simpler

About The Design

  • This DB system is scheduling application that takes in user information and lets you interactively schedule appointments using command-line interface as UI 🏥
  • It uses SQL queries within Java to create relational databases and send to Azure via JDBC drivers 💻
  • It enforced data security by encrypting sensitive data before storing it in the cloud-based environment ✔️
  • It also optimizes queries to retrieve data with low latency (<800ms) and error rate (<0.02%), reduced query time from 600.03 seconds to 0.77 seconds using dataverse, saving you minutes of wait time 🏃‍♂️

Built With

Azure

Contact / Feedback

Email: yuwenj3@uw.edu

Personal Web - leahjia.com

LinkedIn - @leahjia

Acknowledgments

(back to top)