AstroDB Toolkit: A Collaborative Data Management Tool
11-08, 23:14– (US/Arizona), Posters

We present the AstroDB Toolkit, a collaborative database management tool, intended for small-to-medium sized projects to manage their living datasets. The database management relies on a review using GitHub, thus integrating itself into the existing workflows of many Astronomers. The Toolkit relies on the astrodbkit2 python package to convert back and forth between a non-relational and relational database that can be used with established packages like SQLAlchemy. This facilitates a novel way of reviewing, updating, and version-controlling the contents of medium-scale databases while still integrating with existing tools. We have also developed a web app which presents the database contents as an interactive, queryable website. The proof-of-concept application is the SIMPLE Archive of low mass stars, brown dwarfs, and exoplanets (https://simple-bd-archive.org/). In this poster, we present the architecture of the AstroDB Toolkit, the document-store model, and the GitHub workflow for reviewing and approving database modifications.

See also: AstroDB Toolkit (1.8 MB)