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

  1. Verify that the tables are present and accessible via dbserv.
  2. Verify that the row counts and schemas in the tables match those at IRSA.  Document any discrepancies and try to understand their source.
    1. 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.
  3. Measure performance for several representative queries.  For small-scale queries, compare to IRSA performance.
    1. Queries that take advantage of primary and/or secondary indexing.
    2. Full-table scans:
      1. Ones that return trivially small results (i.e., just a few rows)
      2. Ones that return large results; try to explore the limits.
  4. Perform a substantive spatial cross-match query between S82 and the new WISE tables.

2) SUIT/Portal testing

  1. Verify that the tables are accessible via the portal.
  2. Perform sample queries using the previously existing features of the UI, but against the new tables.
    1. For small queries, compare the results with the equivalent query in IRSA.


  • No labels