![](/images/graphics-bg.png)
Multiple Depth DB Tables Indexing on the Sphere
Joint Authors
Calderone, Giorgio
Nicastro, Luciano
Source
Issue
Vol. 2010, Issue 2010 (31 Dec. 2010), pp.1-11, 11 p.
Publisher
Hindawi Publishing Corporation
Publication Date
2010-04-14
Country of Publication
Egypt
No. of Pages
11
Main Subjects
Abstract EN
Any project dealing with large astronomical datasets should consider the use of a relational database server (RDBS).
Queries requiring quick selections on sky regions, objects cross-matching and other high-level data investigations involving sky coordinates could be unfeasible if tables are missing an effective indexing scheme.
In this paper we present the Dynamic Index Facility (DIF) software package.
By using the HTM and HEALPix sky pixelization schema, it allows a very efficient indexing and management of spherical data stored into MySQL tables.
Any table hosting spherical coordinates can be automatically managed by DIF using any number of sky resolutions at the same time.
DIF comprises a set of facilities among which SQL callable functions to perform queries on circular and rectangular regions.
Moreover, by removing the limitations and difficulties of 2-d data indexing, DIF allows the full exploitation of the RDBS capabilities.
Performance tests on Giga-entries tables are reported together with some practical usage of the package.
American Psychological Association (APA)
Nicastro, Luciano& Calderone, Giorgio. 2010. Multiple Depth DB Tables Indexing on the Sphere. Advances in Astronomy،Vol. 2010, no. 2010, pp.1-11.
https://search.emarefa.net/detail/BIM-478536
Modern Language Association (MLA)
Nicastro, Luciano& Calderone, Giorgio. Multiple Depth DB Tables Indexing on the Sphere. Advances in Astronomy No. 2010 (2010), pp.1-11.
https://search.emarefa.net/detail/BIM-478536
American Medical Association (AMA)
Nicastro, Luciano& Calderone, Giorgio. Multiple Depth DB Tables Indexing on the Sphere. Advances in Astronomy. 2010. Vol. 2010, no. 2010, pp.1-11.
https://search.emarefa.net/detail/BIM-478536
Data Type
Journal Articles
Language
English
Notes
Includes bibliographical references
Record ID
BIM-478536