Development of 2MASS Catalog Server Kit

Astronomy and Astrophysics – Astrophysics – Instrumentation and Methods for Astrophysics

Scientific paper

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

2011 PASP accepted

Scientific paper

We develop a software kit called "2MASS Catalog Server Kit" to easily construct a high-performance database server for the 2MASS Point Source Catalog (includes 470,992,970 objects) and several all-sky catalogs. Users can perform fast radial search and rectangular search using provided stored functions in SQL similar to SDSS SkyServer. Our software kit utilizes open-source RDBMS, and therefore any astronomers and developers can install our kit on their personal computers for research, observation, etc. Out kit is tuned for optimal coordinate search performance. We implement an effective radial search using an orthogonal coordinate system, which does not need any techniques that depend on HTM or HEALpix. Applying the xyz coordinate system to the database index, we can easily implement a system of fast radial search for relatively small (less than several million rows) catalogs. To enable high-speed search of huge catalogs on RDBMS, we apply three additional techniques: table partitioning, composite expression index, and optimization in stored functions. As a result, we obtain satisfactory performance of radial search for the 2MASS catalog. Our system can also perform fast rectangular search. It is implemented using techniques similar to those applied for radial search. Our way of implementation enables a compact system and will give important hints for a low-cost development of other huge catalog databases.

No associations

LandOfFree

Say what you really think

Search LandOfFree.com for scientists and scientific papers. Rate them and share your experience with other people.

Rating

Development of 2MASS Catalog Server Kit 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 Development of 2MASS Catalog Server Kit, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Development of 2MASS Catalog Server Kit will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFWR-SCP-O-597159

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.