Database Design for SpExoDisks: A Database & Web Portal for Spectra of Exoplanet-Forming Disks

TL;DR

This paper discusses the development of SpExoDisks, a specialized database and web portal for infrared spectra of protoplanetary disks, emphasizing design, implementation, and community utility.

Contribution

It provides a generalized framework for creating astronomy databases with web interfaces, illustrated through the development and features of SpExoDisks.

Findings

Supports interactive spectral visualization in browsers

Demonstrates on-demand data query and distribution

Enhances understanding of protoplanetary disks

Abstract

Data access -- or the availability of new and archival data for use by the larger community -- is key for scientific advancement. How data is presented, searched, and formatted determines accessibility and it can be difficult to find a solution that fits the needs of a given subdiscipline. We present a generalized roadmap for developing a specialty astronomy database with web application based on the development of the SpExoDisks (Spectra of Exoplanet forming Disks) database (spexodisks.com), which provides infrared spectra of protoplanetary disks. Expertise in an astronomy subdiscipline can provide two necessary components for creating a database: access to a large volume of specialized data and knowledge of how that data should be presented to the community. However, there are a variety of steps and decisions for database development that can fall outside astronomy expertise. Here we offer generalized discussions on design and process that are accompanied by real-world examples from the SpExoDisks developer team and website. Starting from the database portal design and data organization, we demonstrate on-demand data distribution and query using publicly accessible database software. These systems support interactive visualizations such that users can explore spectra directly from their browsers. We also offer details that show how the technical concepts in SpExoDisks are implemented, particularly emphasizing sustainability and long-term management of the codebase and processes. Finally, we illustrate the utility that a specialty website can offer to the community by providing a specific example of how the combined spectra from SpExoDisks can enhance our understanding of protoplanetary disks.