30 likes | 114 Views
Explore requirements for Edinburgh sky survey databases, focusing on scalability, spatial indexing, ease of integration, cost-effective solutions, and minimal DBA involvement. Learn about a proposed approach to build and analyze large datasets efficiently.
E N D
What next? Bob Mann
Summary: requirements for Edinburgh sky survey databases • Scalability • Handling 1-10TB of catalogue databases • Spatial indexing crucial to performance • Interoperability • Easy integration into web/Grid service framework • Ease of use • No professional DBA, part-time job for astronomer • Cost • Limited funds for hardware/software in academia
One possible approach • Goal: • Build copies of the combined SuperCOSMOS and SDSS dataset in the SDSS EDR region • Do this for both DB2 and Oracle • Run SSA “20 queries” on them • Variants: • Get HTM working in DB2 and Oracle • Implement fGetNearbyObjEq() using native spatial indexing in DB2 and Oracle • Implement new Gray-Szalay geometric approach?…. • What else?