Large Catalogue Query Performance in Relational Databases

Publications of the Astronomical Society of Australia

Robert A. Power¹ 

关键词: astronomical data bases: miscellaneous;    catalogs;    surveys;   

DOI  :  10.1071/AS06026

学科分类：天文学(综合)

来源: CSIRO

【 摘 要 】

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.

【 授权许可】

Unknown