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

Add per-dataset-type tables to Registry

    XMLWordPrintable

    Details

    • Story Points:
      0
    • Epic Link:
    • Team:
      Data Release Production
    • Urgent?:
      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

          blocks

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. DM-21773 Add support for per-StorageClass metadata fields

          • To Do
          is blocked by

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. DM-21448 Clean up DatasetRef comparisons and immutability

          • Done

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. DM-21764 Better encapsulate dataset storage in Registry

          • Done

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. DM-21849 Make runs a type of collection

          • Done

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. DM-23079 Move opaque table Registry code into helper classes

          • Done

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. DM-23080 Move dimension Registry code into helper classes

          • Done
          is contained by

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. DM-21231 Refactor Registry handling of dataset and associated tables

          • Done

            Activity

            Ascending order - Click to sort in descending order
            Hide
            Permalink
            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.

            Show
            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.
            Hide
            Permalink
            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.

            Show
            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

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

                Dates

                Created:
                Updated:
                Resolved:

                  Jenkins

                  No builds found.