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 created issue -
            jbosch Jim Bosch made changes -
            Field Original Value New Value
            Epic Link DM-21254 [ 414685 ]
            jbosch Jim Bosch made changes -
            Link This issue is contained by DM-21231 [ DM-21231 ]
            jbosch Jim Bosch made changes -
            Link This issue is blocked by DM-21448 [ DM-21448 ]
            jbosch Jim Bosch made changes -
            Link This issue is blocked by DM-21764 [ DM-21764 ]
            jbosch Jim Bosch made changes -
            Link This issue blocks DM-21773 [ DM-21773 ]
            jbosch Jim Bosch made changes -
            Description Move dimension foreign key fields to separate, per-dataset-type tables.  Duplicate primary key fields and optionally (via configuration) duplicate other fields. 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
            jbosch Jim Bosch made changes -
            Link This issue blocks DM-21849 [ DM-21849 ]
            jbosch Jim Bosch made changes -
            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
            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|https://confluence.lsstcorp.org/display/DM/Dataset+and+Collection+Table+Reorganization.].
            jbosch Jim Bosch made changes -
            Labels gen3-middleware gen2-deprecation-blocker gen3-middleware
            dinob Dino Bektesevic made changes -
            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|https://confluence.lsstcorp.org/display/DM/Dataset+and+Collection+Table+Reorganization.].
            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|https://confluence.lsstcorp.org/display/DM/Dataset+and+Collection+Table+Reorganization].
            yusra Yusra AlSayyad made changes -
            Epic Link DM-21254 [ 414685 ] DM-22586 [ 427653 ]
            jbosch Jim Bosch made changes -
            Link This issue is blocked by DM-23080 [ DM-23080 ]
            jbosch Jim Bosch made changes -
            Link This issue is blocked by DM-23079 [ DM-23079 ]
            jbosch Jim Bosch made changes -
            Link This issue blocks DM-21849 [ DM-21849 ]
            jbosch Jim Bosch made changes -
            Link This issue is blocked by DM-21849 [ DM-21849 ]
            yusra Yusra AlSayyad made changes -
            Epic Link DM-22586 [ 427653 ] DM-23737 [ 431393 ]
            tjenness Tim Jenness made changes -
            Labels gen2-deprecation-blocker gen3-middleware gen2-deprecation-blocker gen3-middleware gen3-registry-incompatibility
            jbosch Jim Bosch made changes -
            Story Points 2 0
            Urgent? off
            jbosch Jim Bosch made changes -
            Status To Do [ 10001 ] In Progress [ 3 ]
            jbosch Jim Bosch made changes -
            Resolution Done [ 10000 ]
            Status In Progress [ 3 ] Done [ 10002 ]

            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.