Search Publications

The ESA Gaia Archive: Data Release 1

González-Núñez, J.; Gutiérrez-Sánchez, R.; Segovia, J. C. +4 more

The ESA Gaia mission is producing the most accurate source catalogue in astronomy to date. This represents a challenge in archiving to make the information and data accessible to astronomers in an efficient way, due to the size and complexity of the data. Also, new astronomical missions, taking larger and larger volumes of data, are reinforcing th…

Photo-z-SQL: Integrated, flexible photometric redshift computation in a database

Beck, R.; Szalay, A. S.; Csabai, I. +2 more

We present a flexible template-based photometric redshift estimation framework, implemented in C#, that can be seamlessly integrated into a SQL database (or DB) server and executed on-demand in SQL. The DB integration eliminates the need to move large photometric datasets outside a database for redshift estimation, and utilizes the computational c…

Enabling data science in the Gaia mission archive: The present-day mass function and age distribution

Sarro, L. M.; Berihuete, A.; Julbe, F. +2 more

Recent advances in large scale computing architectures enable new opportunities to extract value out of the vast amounts of data being currently generated. However, their successful adoption is not straightforward in areas like science, as there are still some barriers that need to be overcome. Those comprise (i) the existence of legacy code that …

A parallel model for SQL astronomical databases based on solid state storage. Application to the Gaia Archive PostgreSQL database

González-Núñez, J.; Gutiérrez-Sánchez, R.; Segovia, J. C. +3 more

Query planning and optimisation algorithms in most popular relational databases were developed at the times hard disk drives were the only storage technology available. The advent of higher parallel random access capacity devices, such as solid state disks, opens up the way for intra-machine parallel computing over large datasets.

We describe…