Outline of the testing plan for the "WISE data loaded" milestone, LDM-503-1.
The main step forward that this milestone captures is the loading of the original-mission and the reactivation-mission-year-1 single-epoch source catalog tables into PDAC.
The formal test specification will appear in LDM-540. The test report for this particular milestone will go in DMTR-52.
1) Qserv/DAX testing
- Verify that the tables are present and accessible via
dbserv
. - Verify that the row counts and schemas in the tables match those at IRSA. Document any discrepancies and try to understand their source.
- There are four tables involved: original-mission four-band, transitional-three-band, and "warm" two-band tables, and the reactivation-mission first-year two-band data.
- Measure performance for several representative queries. For small-scale queries, compare to IRSA performance.
- Queries that take advantage of primary and/or secondary indexing.
- Full-table scans:
- Ones that return trivially small results (i.e., just a few rows)
- Ones that return large results; try to explore the limits.
- Perform a substantive spatial cross-match query between S82 and the new WISE tables.
2) SUIT/Portal testing
- Verify that the tables are accessible via the portal.
- Perform sample queries using the previously existing features of the UI, but against the new tables.
- For small queries, compare the results with the equivalent query in IRSA.