Development of search APIs for flavorDB2: BTech project in API creation and data management

Abstract

This report presents the development of robust search APIs for FlavorDB2, an advanced database of flavor molecules and their associated properties, aimed at enhancing data accessibility and usability for researchers in computational gastronomy and food science. The project involved migrating raw CSV datasets to a MongoDB database, followed by the implementation of RESTful APIs using the Spring Boot framework. The APIs enable complex and multidimensional queries, allowing users to retrieve data based on molecular identifiers, regulatory statuses, food categories, and synthesis processes. Advanced features like query filtering and aggregation ensure precise results and scalability.