Search arXiv⌕ Search
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

BibTeXRIS

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

arXiv2015

The exact numerical treatment of inflationary models

The precision reached by the recent CMB measurements gives new insights into the shape of the primordial power spectra of the cosmological perturbations. In the context of inflationary cosmology, this implies that the CMB data are now sensitive to the form of the inflaton potential. Most of the current approaches devoted to the derivation of the inflationary primordial power spectra, or to the inflaton potential reconstruction problem, rely on approximate analytical treatments that may break down for exotic models. In this article, we numerically solve the inflationary evolution of both the background and all the perturbed quantities to extract the primordial power spectra exactly. Such a method solely relies on General Relativity and linear perturbation theory. More than providing a tool to test analytical approximations, one may consider, without complications, the treatment of non-standard inflationary models as those involving several fields, eventually non-minimally coupled to gravity. The usefulness of the exact numerical approach to deal with CMB data is illustrated by analysing the WMAP third year data in the context of single field models. For this purpose, we introduce a new inflationary related parameter encoding the basic properties of the reheating era. This reheating parameter has significant observable effects and provides a self-consistency test of inflationary models. As a working example, the marginalised probability distributions of the reheating and potential parameters associated with the small field models are presented.

astro-ph↗
arXiv2015

Mass estimates from stellar proper motions: The mass of $ω$ Centauri

A projected mass estimator and a maximum likelihood estimator are developed to best determine the mass of stellar clusters from proper motion data. Both methods effectively account and correct for errors in the velocities, and provide an unbiased and robust estimate of the cluster mass. Using an extensive proper motion study of $ω$ Centauri by van Leeuwen et al. (2000), we estimate the mass of $ω$ Centauri using these two different methods to be $2.8 \times 10^{6} M_{\odot} \left[d/5.1 kpc\right]^{3}$. Within this modeling context, the statistical error is $3\%$ and the systematic error is $4\%$.

astro-ph↗
arXiv2015

Subarcsecond Submillimeter Imaging of the Ultracompact HII Region G5.89-0.39

We present the first subarcsecond submillimeter images of the enigmatic ultracompact HII region (UCHII) G5.89-0.39. Observed with the SMA, the 875 micron continuum emission exhibits a shell-like morphology similar to longer wavelengths. By using images with comparable angular resolution at five frequencies obtained from the VLA archive and CARMA, we have removed the free-free component from the 875 micron image. We find five sources of dust emission: two compact warm objects (SMA1 and SMA2) along the periphery of the shell, and three additional regions further out. There is no dust emission inside the shell, supporting the picture of a dust-free cavity surrounded by high density gas. At subarcsecond resolution, most of the molecular gas tracers encircle the UCHII region and appear to constrain its expansion. We also find G5.89-0.39 to be almost completely lacking in organic molecular line emission. The dust cores SMA1 and SMA2 exhibit compact spatial peaks in optically-thin gas tracers (e.g. 34SO2), while SMA1 also coincides with 11.9 micron emission. In CO(3-2), we find a high-velocity north/south bipolar outflow centered on SMA1, aligned with infrared H2 knots, and responsible for much of the maser activity. We conclude that SMA1 is an embedded intermediate mass protostar with an estimated luminosity of 3000 Lsun and a circumstellar mass of ~1 Msun. Finally, we have discovered an NH3 (3,3) maser 12 arcsec northwest of the UCHII region, coincident with a 44 GHz CH3OH maser, and possibly associated with the Br gamma outflow source identified by Puga et al. (2006).

astro-ph↗