Indexing astronomical database tables using HTM and HEALPix

Luciano Nicastro; Giorgio Calderone

Home/Archive/arXiv

arXiv · 0711.4964

Indexing astronomical database tables using HTM and HEALPix

Luciano Nicastro·Giorgio Calderone

View original source ↗Read source document ↗Export metadata ↓

Abstract

In various astronomical projects it is crucial to have coordinates indexed tables. All sky optical and IR catalogues have up to 1 billion objects that will increase with forthcoming projects. Also partial sky surveys at various wavelengths can collect information (not just source lists) which can be saved in coordinate ordered tables. Selecting a sub-set of these entries or cross-matching them could be un-feasible if no indexing is performed. Sky tessellation with various mapping functions have been proposed. It is a matter of fact that the astronomical community is accepting the HTM and HEALPix schema as the default for object catalogues and for maps visualization and analysis, respectively. Within the MCS library project, we have now made available as MySQL-callable functions various HTM and HEALPix facilities. This is made possible thanks to the capability offered by MySQL 5.1 to add external plug-ins. The DIF (Dynamic Indexing Facilities) package distributed within the MCS library, creates and manages a combination of Views, Triggers, DB-engine and plug-ins allowing the user to deal with database tables indexed using one or both these pixelisation schema in a completely transparent way.

Explore related subjects

astro-ph

Keep this discovery

BibTeX RIS

Luciano Nicastro, Giorgio Calderone. 2007-11-30. Indexing astronomical database tables using HTM and HEALPix. https://arxiv.org/abs/0711.4964

Cite the original work for its findings. Save a collection to share your selection of sources.

KEEP EXPLORING

Related papers

arXiv2011

Can inhomogeneities solve the horizon problem ?

We show how inhomogeneous cosmological models can naturally explain the large angle correlation we observe in the CMB (cosmological microwave background) radiation without invoking any inflationary stage, but simply considering the effects of inhomogeneities on the propagation of photons from the last scattering surface.

astro-ph↗

arXiv2011

Helium abundance in galaxy clusters and Sunyaev-Zeldovich effect

It has long been suggested that helium nuclei in the intracluster plasma can sediment in the cluster gravitational potential well. Some theoretical estimates for the cores of relaxed clusters predict an excess of helium abundance by up to a factor of a few over its primordial value. The intracluster helium abundance cannot be measured directly. This presents a significant source of uncertainty for cosmological tests based on the X-ray derived cluster quantities, such as the gas mass, total mass, and gas mass fraction, all of which depend on the assumed helium abundance. We point out that cluster distances derived by combining the Sunyaev-Zeldovich (SZ) and X-ray data also depend on the helium abundance. This dependence can be used to measure the abundance, provided the distance is known independently. For example, if one adopts the WMAP H_0 value, then the recent H_0 measurement by Bonamente and collaborators, derived from SZ data on 38 clusters assuming a primordial helium abundance, corresponds to an abundance excess by a factor of 1.9+-0.8 within r~1 Mpc (using only their statistical errors). This shows that interesting accuracy is within reach. We also briefly discuss how the SZ and X-ray cluster data can be combined to resolve the helium abundance dependence for the d_a(z) cosmological test.

astro-ph↗

arXiv2011

Primordial statistical anisotropy generated at the end of inflation

We present a new mechanism for generating primordial statistical anisotropy of curvature perturbations. We introduce a vector field which has a non-minimal kinetic term and couples with a waterfall field in hybrid inflation model. In such a system, the vector field gives fluctuations of the end of inflation and hence induces a subcomponent of curvature perturbations. Since the vector has a preferred direction, the statistical anisotropy could appear in the fluctuations. We present the explicit formula for the statistical anisotropy in the primordial power spectrum and the bispectrum of curvature perturbations. Interestingly, there is the possibility that the statistical anisotropy does not appear in the power spectrum but does appear in the bispectrum. We also find that the statistical anisotropy provides the shape dependence to the bispectrum.

astro-ph↗