Team 22
Team Members |
Faculty Advisor |
John Bogacz |
Qian Yang Sponsor Boehringer Ingelheim |
sponsored by
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.