LCGCT: A light curve generator in customisable-time-bin based on time-series database

In the era of time-domain astronomy, scientists often need to generate light curves with varying time-bin. However, an increase in time resolution typically leads to a substantial increase in data transmission. To enhance the data processing efficiency in time-domain astronomy, we propose a novel time-series data model for storing time-series observation data, and we construct the LCGCT, a tool designed to produce light curves with customisable time bins. To validate our approach, we utilise the 7-year MAXI/GSC (Gas Slit Camera of the Monitor of All-sky X-ray Image) X-ray source catalogue, incorporating its 24-h binned light curves for a comparative analysis with our approach. The results obtained confirm the accuracy and effectiveness of our proposed approach. Subsequently, we compare the storage capacity and query performance of LCGCT with a PostgreSQL-based implementation, and results show that LCGCT conserves 75% of the storage space and achieves three times the query speed. Owing to its noteworthy storage and query performance, our proposed time-series data model-based LCGCT can be used in time-domain astronomical projects with high time resolution.