Astronomy and Astrophysics – Astronomy
Scientific paper
May 2007
adsabs.harvard.edu/cgi-bin/nph-data_query?bibcode=2007pasa...24...13p&link_type=abstract
Publications of the Astronomical Society of Australia, Volume 24, Issue 1, pp. 13-20.
Astronomy and Astrophysics
Astronomy
Astronomical Data Bases: Miscellaneous, Catalogs, Surveys
Scientific paper
The performance of the mysql and oracle database systems have been compared for a selection of astronomy queries using large catalogues of up to a billion objects. The queries tested are those expected from the astronomy community: general database queries, cone searches, neighbour finding and cross matching. The catalogue preparation, sql query formulation and database performance is presented. Most of the general queries perform adequately when appropriate indexes are present in the database. Each system performs well for cone search queries when the Hierarchical Triangular Mesh spatial index is used. Neighbour finding and cross matching are not well supported in a database environment when compared to software specifically developed to solve these problems.
No associations
LandOfFree
Large Catalogue Query Performance in Relational Databases does not yet have a rating. At this time, there are no reviews or comments for this scientific paper.
If you have personal experience with Large Catalogue Query Performance in Relational Databases, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Large Catalogue Query Performance in Relational Databases will most certainly appreciate the feedback.
Profile ID: LFWR-SCP-O-1743188