Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-21766

Add per-dataset-type tables to Registry

    XMLWordPrintable

Details

    • 0
    • Data Release Production
    • No

    Description

      Move dimension foreign key fields to separate, per-dataset-type tables.  Duplicate primary key fields and optionally (via configuration) duplicate other fields.

      This should move the schema to something like the "Partition datasets (only)" design on https://confluence.lsstcorp.org/display/DM/Dataset+and+Collection+Table+Reorganization.

      Attachments

        Issue Links

          Activity

            jbosch Jim Bosch added a comment -

            This work is being done on the branch for DM-21764; I've zeroed the story points here and will mark as done as soon as that ticket closes.

            jbosch Jim Bosch added a comment - This work is being done on the branch for DM-21764 ; I've zeroed the story points here and will mark as done as soon as that ticket closes.
            jbosch Jim Bosch added a comment -

            Note that these will actually be per-sets-of-dimensions (e.g. calexp and src will go in the same table, as both are identified by visit+detector). We'd be able to implement per-DatasetType tables and swap that in via configuration on another ticket if desired, but there's no sign that it is right now.

            jbosch Jim Bosch added a comment - Note that these will actually be per-sets-of-dimensions (e.g. calexp and src will go in the same table, as both are identified by visit+detector). We'd be able to implement per-DatasetType tables and swap that in via configuration on another ticket if desired, but there's no sign that it is right now.

            People

              jbosch Jim Bosch
              jbosch Jim Bosch
              Jim Bosch
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Jenkins

                  No builds found.