APOGEE-centric Ananke simulations in a SciServer SQL database

Rachael Beaton; Suzanne Werner; Arik Mitschang; Gerard Lemson; Aniruddha Thakar; Anne-Marie Weijmans; Joel Brownstein; Farnik Nikakhtar; Robyn Sanderson; Andrew Wetzel; Sarah Loebman; Sanjib Sharma

doi:10.3847/2515-5172/ac7808

APOGEE-centric Ananke simulations in a SciServer SQL database

Rachael Beaton^*, Suzanne Werner, Arik Mitschang, Gerard Lemson, Aniruddha Thakar, Anne-Marie Weijmans, Joel Brownstein, Farnik Nikakhtar, Robyn Sanderson, Andrew Wetzel, Sarah Loebman, Sanjib Sharma

^*Corresponding author for this work

Research output: Contribution to journal › Article › peer-review

Abstract

Modern galaxy simulations have reached the complexity required to create sophisticated mock catalogs. Ananke is a set of nine mock catalogs constructed from synthetic surveys of three Milky Way-like galaxies from the Latte suite of FIRE simulations. Ananke provides observed quantities for comparison with modern large-scale stellar surveys. In SDSS-IV DR17, mock catalogs for the Apache Point Galactic Evolution Experiment (APOGEE) were built from Ananke synthetic surveys as a Value-Added Catalog, but were only provided as large flat files (∼>10's GB). Here we announce an >40 Tb SQL database for nine APOGEE-specific mock catalogs and describe additions to the data model necessary for effective user queries. The catalogs can be accessed on the free, science platform, SciServer—supported by the Institute for Data Intensive Engineering and Science at the Johns Hopkins University (IDIES); SciServer supports server-side analysis with commonly used coding languages and tools.

Original language	English
Article number	125
Journal	Research Notes of the AAS
Volume	6
Issue number	6
Early online date	15 Jun 2022
DOIs	https://doi.org/10.3847/2515-5172/ac7808
Publication status	Published - Jun 2022

Keywords

Catalogs
Milky Way galaxy
Surveys
Redshift surveys
Astronomy databases

Access to Document

10.3847/2515-5172/ac7808Licence: CC BY

SDSS-IV Data Release 17 (DR17)
Weijmans, A.-M. (Creator), Sloan Digitial Sky Survey IV (SDSS-IV), 6 Dec 2021
https://www.sdss.org/dr17
Dataset

Cite this

@article{fedcb31b05104e0f846888f65fc4ffd3,

title = "APOGEE-centric Ananke simulations in a SciServer SQL database",

abstract = "Modern galaxy simulations have reached the complexity required to create sophisticated mock catalogs. Ananke is a set of nine mock catalogs constructed from synthetic surveys of three Milky Way-like galaxies from the Latte suite of FIRE simulations. Ananke provides observed quantities for comparison with modern large-scale stellar surveys. In SDSS-IV DR17, mock catalogs for the Apache Point Galactic Evolution Experiment (APOGEE) were built from Ananke synthetic surveys as a Value-Added Catalog, but were only provided as large flat files (∼>10's GB). Here we announce an >40 Tb SQL database for nine APOGEE-specific mock catalogs and describe additions to the data model necessary for effective user queries. The catalogs can be accessed on the free, science platform, SciServer—supported by the Institute for Data Intensive Engineering and Science at the Johns Hopkins University (IDIES); SciServer supports server-side analysis with commonly used coding languages and tools.",

keywords = "Catalogs, Milky Way galaxy, Surveys, Redshift surveys, Astronomy databases",

author = "Rachael Beaton and Suzanne Werner and Arik Mitschang and Gerard Lemson and Aniruddha Thakar and Anne-Marie Weijmans and Joel Brownstein and Farnik Nikakhtar and Robyn Sanderson and Andrew Wetzel and Sarah Loebman and Sanjib Sharma",

note = "Funding for the SDSS-IV has been provided by the Alfred P. Sloan Foundation, the U.S. Department of Energy Office of Science, and the Participating Institutions.",

year = "2022",

month = jun,

doi = "10.3847/2515-5172/ac7808",

language = "English",

volume = "6",

journal = "Research Notes of the AAS",

issn = "2515-5172",

publisher = "The American Astronomical Society",

number = "6",

}

TY - JOUR

T1 - APOGEE-centric Ananke simulations in a SciServer SQL database

AU - Beaton, Rachael

AU - Werner, Suzanne

AU - Mitschang, Arik

AU - Lemson, Gerard

AU - Thakar, Aniruddha

AU - Weijmans, Anne-Marie

AU - Brownstein, Joel

AU - Nikakhtar, Farnik

AU - Sanderson, Robyn

AU - Wetzel, Andrew

AU - Loebman, Sarah

AU - Sharma, Sanjib

N1 - Funding for the SDSS-IV has been provided by the Alfred P. Sloan Foundation, the U.S. Department of Energy Office of Science, and the Participating Institutions.

PY - 2022/6

Y1 - 2022/6

N2 - Modern galaxy simulations have reached the complexity required to create sophisticated mock catalogs. Ananke is a set of nine mock catalogs constructed from synthetic surveys of three Milky Way-like galaxies from the Latte suite of FIRE simulations. Ananke provides observed quantities for comparison with modern large-scale stellar surveys. In SDSS-IV DR17, mock catalogs for the Apache Point Galactic Evolution Experiment (APOGEE) were built from Ananke synthetic surveys as a Value-Added Catalog, but were only provided as large flat files (∼>10's GB). Here we announce an >40 Tb SQL database for nine APOGEE-specific mock catalogs and describe additions to the data model necessary for effective user queries. The catalogs can be accessed on the free, science platform, SciServer—supported by the Institute for Data Intensive Engineering and Science at the Johns Hopkins University (IDIES); SciServer supports server-side analysis with commonly used coding languages and tools.

AB - Modern galaxy simulations have reached the complexity required to create sophisticated mock catalogs. Ananke is a set of nine mock catalogs constructed from synthetic surveys of three Milky Way-like galaxies from the Latte suite of FIRE simulations. Ananke provides observed quantities for comparison with modern large-scale stellar surveys. In SDSS-IV DR17, mock catalogs for the Apache Point Galactic Evolution Experiment (APOGEE) were built from Ananke synthetic surveys as a Value-Added Catalog, but were only provided as large flat files (∼>10's GB). Here we announce an >40 Tb SQL database for nine APOGEE-specific mock catalogs and describe additions to the data model necessary for effective user queries. The catalogs can be accessed on the free, science platform, SciServer—supported by the Institute for Data Intensive Engineering and Science at the Johns Hopkins University (IDIES); SciServer supports server-side analysis with commonly used coding languages and tools.

KW - Catalogs

KW - Milky Way galaxy

KW - Surveys

KW - Redshift surveys

KW - Astronomy databases

U2 - 10.3847/2515-5172/ac7808

DO - 10.3847/2515-5172/ac7808

M3 - Article

SN - 2515-5172

VL - 6

JO - Research Notes of the AAS

JF - Research Notes of the AAS

IS - 6

M1 - 125

ER -

APOGEE-centric Ananke simulations in a SciServer SQL database

Abstract

Keywords

Access to Document

Fingerprint

Datasets

SDSS-IV Data Release 17 (DR17)

Cite this