Multiple Depth DB Tables Indexing on the Sphere
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...
Saved in:
| Main Authors: | , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Wiley
2010-01-01
|
| Series: | Advances in Astronomy |
| Online Access: | http://dx.doi.org/10.1155/2010/524534 |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| _version_ | 1849408881533386752 |
|---|---|
| author | Luciano Nicastro Giorgio Calderone |
| author_facet | Luciano Nicastro Giorgio Calderone |
| author_sort | Luciano Nicastro |
| collection | DOAJ |
| description | 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. |
| format | Article |
| id | doaj-art-7f08df3f035e45d2a3fb55421b750722 |
| institution | Kabale University |
| issn | 1687-7969 1687-7977 |
| language | English |
| publishDate | 2010-01-01 |
| publisher | Wiley |
| record_format | Article |
| series | Advances in Astronomy |
| spelling | doaj-art-7f08df3f035e45d2a3fb55421b7507222025-08-20T03:35:40ZengWileyAdvances in Astronomy1687-79691687-79772010-01-01201010.1155/2010/524534524534Multiple Depth DB Tables Indexing on the SphereLuciano Nicastro0Giorgio Calderone1Istituto Nazionale di Astrofisica, IASF Bologna, Via P. Gobetti 101, 40129 Bologna, ItalyIstituto Nazionale di Astrofisica, IASF Palermo, Via U. La Malfa 153, 90146 Palermo, ItalyAny 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.http://dx.doi.org/10.1155/2010/524534 |
| spellingShingle | Luciano Nicastro Giorgio Calderone Multiple Depth DB Tables Indexing on the Sphere Advances in Astronomy |
| title | Multiple Depth DB Tables Indexing on the Sphere |
| title_full | Multiple Depth DB Tables Indexing on the Sphere |
| title_fullStr | Multiple Depth DB Tables Indexing on the Sphere |
| title_full_unstemmed | Multiple Depth DB Tables Indexing on the Sphere |
| title_short | Multiple Depth DB Tables Indexing on the Sphere |
| title_sort | multiple depth db tables indexing on the sphere |
| url | http://dx.doi.org/10.1155/2010/524534 |
| work_keys_str_mv | AT lucianonicastro multipledepthdbtablesindexingonthesphere AT giorgiocalderone multipledepthdbtablesindexingonthesphere |