SQL Executor

This project is part of the course CS527 at Rutgers University.

The web application is specifically designed to take user queries as input and seamlessly execute them on our AWS data infrastructure. It establishes connections with MySQL, RedShift, and MongoDB server databases, offering users the flexibility to choose the desired database (Instacart or ADNIMERGE) for query execution. Once the query is submitted, it undergoes processing, and the resulting output is displayed on the intuitive interface for easy user access. Additionally, we have incorporated a convenient feature that allows users to effortlessly view the Entity-Relationship (ER) diagram of the dataset whenever needed.

Installation

A few things are required before getting started with the project:

• Java
• Gradle
  • Installation - https://gradle.org/next-steps/?version=6.9.1&format=all
  • Environment Variable Setup - https://stackoverflow.com/a/48033901

1. Simply checkout the project
2. Configure IDE to point to the required gradle version
3. Voila! The project is ready to run - gradle bootrun

Tech Stack

Spring Boot
Amazon Web Services
MySQL
MongoDB
CSS3
HTML5
JavaScript
Gradle

Contributors

Karan Bheda

Nooria Ali

Arathi Reghukumar

Vipul Ishwarchandra Gharde

Rishika Bhanushali

Samyuktha Gopalsamy