Team 22

Team Members

Faculty Advisor

John Bogacz
Connor Brush
Maniza Shaikh
Jianhua Zhu
Walson Li
Peter Filip

Qian Yang

Sponsor

Boehringer Ingelheim

sponsored by
sponsor logo

Solubility Data Management

Solubility data management is an internal tool designed for scientists at Boehringer Ingelheim to assist them in accessing quick and reliable solubility data. Solubility plays a crucial role in drug development, influencing factors such as drug release in the gastrointestinal tract and the design of isolation processes for drug molecules. Our system aims to provide scientists with an efficient platform to access, organize, and analyze solubility data, accelerating the drug development process. Our system is composed of three main components: the frontend, backend, and relational database, it is engineered for seamless data flow and user-friendly interaction. The frontend component, built with Angular, offers a user-friendly interface for users to easily upload Excel files, retrieve and visualize data points from the database with their desired units, and finally, export the retrieved data points back to Excel for further analysis. The backend component, powered by Flask, ensures secure data storage and efficient data processing for quick access to information. Flask serves as a backbone in our system, orchestrating communication between the frontend and the database. The PostgreSQL database acts as the centralized repository for all solubility and user data. Moreover, our team has built a robust server to accommodate diverse global traffic. By integrating these components, our system provides a robust platform for scientists to effortlessly input, query, and visualize solubility data while also gaining access to insights derived from their peers' contributions. By centralizing solubility data management, our tool aims to transcend the limitations of manual data handling, offering a unified repository where scientists can collaborate, glean insights, and drive innovation forward in the field of pharmaceutical science.