1 / 8

SourceLists & AssociateLists

SourceLists & AssociateLists. Parallel Tables External SourceLists CombinedLists SourceLinks New Developments / Problems. Parallel Tables. Oracle Table limit < 1000 columns Better for external SourceLists Easier for DB tuning and table statistics Space saving on other nodes (DB links) ‏.

theo
Download Presentation

SourceLists & AssociateLists

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SourceLists & AssociateLists • Parallel Tables • External SourceLists • CombinedLists • SourceLinks • New Developments / Problems

  2. Parallel Tables • Oracle Table limit < 1000 columns • Better for external SourceLists • Easier for DB tuning and table statistics • Space saving on other nodes (DB links)‏

  3. External SourceLists • USNO A2.0, # 526.280.881 (100%)‏ • SDSS PhotoObjAll-DR5, # 354.254.163 (29%)‏ • SDSS Photoz-DR5, # 354.188.961 (29%)‏ • SDSS SpecObjAll-DR5, # 1.048.960 (19%)‏ • UKIDSS lasSource-DR3, # 36.250.945 (85%)‏ • 2MASS PSC, # 470.992.970 (0%)‏ • 2MASS XSC, # 1.647.599 (0%)‏

  4. CombinedList • Not a Class, but a set of functions • All operations on DataBase level • AssociateList  Single Source Catalogue • AID  SID • filters='MAG_1:#849,MAG_2:#850'

  5. CombinedList

  6. CombinedList Estimation: 100.000.000 sources in 4 days by 100,000 chunks

  7. SourceLink • Required for Individual Source Processing (i.e. for Galfit, Galphot)‏ • Provides a pointer to a Source in a SourceList

  8. New Developments / Problems • Associate Large SourceLists • Maximum number of SourceLists to Associate should be increased • Problems with HTM software • Mosaic AssociateList • Combine AssociateLists • Import/Export SL from/to XML

More Related