Published November 6, 2023 | Version v1
Poster Open

AstroDB Toolkit: A collaborative data management tool

  • 1. Hunter College
  • 2. ROR icon Space Telescope Science Institute
  • 3. ROR icon University of Hertfordshire
  • 4. ROR icon University of Maryland, College Park

Description

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.

 

Files

ADASS2023_poster.pdf

Files (4.0 MB)

Name Size Download all
md5:b979e5d6abaa62c6cf97afe264eac238
2.2 MB Download
md5:689b7c12bfcb29fdbb084cc80f98d420
1.8 MB Preview Download

Additional details

Software

Repository URL
https://github.com/astrodbtoolkit/
Development Status
Active