The Best Scripts and a Database Design for Retrieving Data of Space Objects of the SIMBAD Database

Kalhor B

Published on: 2023-11-07

Abstract

SIMBAD is an astronomical database that provides basic information about astronomical objects outside the solar system. Although SIMBAD Astronomical Database allows us to write our own Standard Query Language (SQL) to extract data, there are too many problems. The maximum number of records per query is too low. On the other hand, the repetition of star names in different records makes its output useless. Also, many fields are empty. As a result, the paper proposes a program to retrieve, group data, and delete repeated records. The paper uses the TAP protocol for executing scripts. We anticipate our assay to be a starting point to provide data for more sophisticated research which needs distance, temperature, and Redshift of space objects.