HEALPix Alchemy: Fast All-Sky Geometry and Image Arithmetic in a Relational Database for Multimessenger Astronomy Brokers
Leo P. Singer, B. Parazin, Michael W. Coughlin, Joshua S. Bloom, Arien, Crellin-Quick, Daniel A. Goldstein, St\'efan van der Walt

TL;DR
HEALPix Alchemy is a Python-based, high-performance database tool that enables rapid all-sky geometry calculations for multimessenger astronomy, significantly improving query speed and scalability on commodity hardware.
Contribution
It introduces a new PostgreSQL extension leveraging multirange types for fast all-sky queries, integrating HEALPix into relational databases for the first time.
Findings
Enables all-sky queries in seconds on standard hardware.
Scales linearly with the number of telescope pointings.
Outperforms existing implementations by orders of magnitude.
Abstract
Efficient searches for electromagnetic counterparts to gravitational wave, high-energy neutrino, and gamma-ray burst events demand rapid processing of image arithmetic and geometry set operations in a database to cross-match galaxy catalogs, observation footprints, and all-sky images. Here we introduce HEALPix Alchemy, an open-source, pure Python implementation of a set of methods that enables rapid all-sky geometry calculations. HEALPix Alchemy is built upon HEALPix, a spatial indexing strategy that is widely used in astronomical databases as well as the native format of LIGO-Virgo-KAGRA gravitational-wave sky localization maps. Our approach leverages new multirange types built into the PostgreSQL 14 database engine. This enables fast all-sky queries against probabilistic multimessenger event localizations and telescope survey footprints. Questions such as "What are the galaxies…
Peer Reviews
No public reviews on file for this paper yet. If you reviewed it on a platform where reviews are public (OpenReview, ICLR, NeurIPS, ICML), you can paste yours below so the community can read it here.
Code & Models
Videos
No videos yet. Explain this paper in a talk, walkthrough, or lecture? Add one.
