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

arXiv2017

Pulsar Magnetic Field Oscillation Model and Verification Methods

We constructed the magnetic field oscillation model (hereafter the MO model) by analogizing the periodically reversing phenomenon of the solar magnetic field to pulsars. Almost all kinds of pulsar radiation phenomena are best explained using the MO model, especially polarization characteristics, glitch, generation rate, the geodetic precession of pulsars and the configuration of pulsar-wind nebula of the Crab. The MO model also provides satisfactory explanation for other characteristics of pulsars, e.g., interpulse, spin-down, pulse nulling, beat and pulse drift, the loss rate of the rotating energy, and the accuracy of frequency. We present eight verification methods for the MO model. In addition to pulsars, our MO model can also be used to explain the pulse emission from non-compact stars such as the ultracool dwarf TVLM 513-46546 and the magnetic chemically peculiar star CU Virginis.

astro-ph↗

arXiv2017

Cosmological parameters from WMAP 5-year temperature maps

I calculate a hybrid cross-power spectrum estimator from the WMAP 5-year CMB temperature maps, discuss the goodness of fit, and then constrain cosmological parameters. The spectrum and results are generally consistent with previous results, though the power spectrum error bars are slightly smaller and there are small shifts at high ell. The small improvement in error bars is obtained at very low numerical cost but does not significantly improve parameter constraints. I discuss the accuracy of the likelihood model and how constraints on the optical depth translate into constraints on the reionization history allowing for helium reionization. In the appendices I propose a simple reionization parameterization that determines the history in terms of a mid-point reionization redshift, and suggest a new likelihood approximation for chi-squared-like distributions with varying skewness.

astro-ph↗

arXiv2017

The Statistics of Radio Astronomical Polarimetry: Bright Sources and High Time Resolution

A four-dimensional statistical description of electromagnetic radiation is developed and applied to the analysis of radio pulsar polarization. The new formalism provides an elementary statistical explanation of the modal broadening phenomenon in single pulse observations. It is also used to argue that the degree of polarization of giant pulses has been poorly defined in past studies. Single and giant pulse polarimetry typically involves sources with large flux densities and observations with high time resolution, factors that necessitate consideration of source-intrinsic noise and small-number statistics. Self noise is shown to fully explain the excess polarization dispersion previously noted in single pulse observations of bright pulsars, obviating the need for additional randomly polarized radiation. Rather, these observations are more simply interpreted as an incoherent sum of covariant, orthogonal, partially polarized modes. Based on this premise, the four-dimensional covariance matrix of the Stokes parameters may be used to derive mode-separated pulse profiles without any assumptions about the intrinsic degrees of mode polarization. Finally, utilizing the small-number statistics of the Stokes parameters, it is established that the degree of polarization of an unresolved pulse is fundamentally undefined; therefore, previous claims of highly polarized giant pulses are unsubstantiated. Unpublished supplementary material is appended after the bibliography.

astro-ph↗