Database and Application Programming Interface Development for Rotational Spectroscopy

The Species-agnostic Automated Gas Analyzer (SAAGA) project aims to automate the detection and characterization of chemical compounds in a complex chemical mixture in the gas phase through experimental rotational spectroscopy and computational tools. A database of spectroscopic data serves as the foundation of the automation pipeline for assigning spectral lines to species. While there are existing databases available for use, we developed our custom database, named SAAGAdb, and an application programming interface (API) to access the database to fulfill the needs of SAAGA. SAAGAdb is designed to store structured, high quality spectroscopic data of all species not limited to astrochemically relevant ones, enabling convenient data manipulation, integration into future automation pipelines, deployment, and maintenance. We implemented software development best practices, including software development life cycle, continuous integration/continuous delivery, and version control, to develop a PostgreSQL database with a Python API built on Django with RDKit integration. The product passed all unit tests and was successfully seeded with data. With the flexibility provided by the Django framework as well as detailed documentation of the software, SAAGAdb and its API can be easily improved and expanded in the future to suit the needs of the SAAGA project.

Name thesis:degree_name

Master

Department dc:contributor.department

Massachusetts Institute of Technology. Department of Chemistry

Grantor dc:publisher

Massachusetts Institute of Technology

Year dc:date.issued

2024

Author dc:creator

• Cheung, Jasmine So Yee

Advisor dc:contributor.advisor

• McGuire, Brett

Statement dc:rights

• In Copyright - Educational Use Permitted
• Copyright retained by author(s)

Licence dc:rights.uri

• https://rightsstatements.org/page/InC-EDU/1.0/

Handle dc:identifier.uri

https://hdl.handle.net/1721.1/157820

OAI identifier oai:identifier

oai:dspace.mit.edu:1721.1/157820