CSIRO Publishing Books Journals About Us Shopping Cart You are here: Journals > PASA   
PASA
  Publications of the Astronomical Society of Australia
 
Search
 
 
  Advanced Search
   

Journal Home
About the Journal
Editorial Board
Contacts
Content
Online Early
Current Issue
Just Accepted
All Issues
Special Issues
Sample Issue
Call for Proposals
For Authors
General Information
Instructions to Authors
Submit Article
Open Access
For Referees
General Information
Review Article
For Subscribers
Subscription Prices
Customer Service

 Early Alert
Subscribe to our email Early Alert or RSS feeds for the latest journal papers.

 Connect with us
facebook   youtube

Training

Publication Workshops


 

Article << Previous     |     Next >>   Contents Vol 24(1)

Large Catalogue Query Performance in Relational Databases

Robert A. Power

CSIRO ICT Centre, Canberra ACT 2601, Australia. Email: robert.power@csiro.au
 
 Full Text
 PDF (202 KB)
 Export Citation
 Print
  


Abstract

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.

Keywords: astronomical data bases: miscellaneous — catalogs — surveys


   
    


 
Top  Email this page
 
Legal & Privacy | Contact Us | Help

CSIRO

© CSIRO 1996-2012