Instruct: Identify the main and secondary category of Arxiv papers based on the titles and abstracts
Query: Indexing astronomical database tables using HTM and HEALPix   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.

0
The categories of this paper are: hep-ph
22
The categories of this paper are: chao-dyn
21
The categories of this paper are: adap-org
33
The categories of this paper are: plasm-ph
3
The categories of this paper are: physics
15
The categories of this paper are: nucl-ex
20
The categories of this paper are: acc-phys
28
The categories of this paper are: alg-geom
17
The categories of this paper are: q-fin
18
The categories of this paper are: econ
19
The categories of this paper are: eess
9
The categories of this paper are: nlin
37
The categories of this paper are: supr-con
35
The categories of this paper are: mtrl-th
23
The categories of this paper are: solv-int
30
The categories of this paper are: q-alg