Uploaded image for project: 'Request For Comments'
  1. Request For Comments
  2. RFC-777

Change dataset ID type in butler registries to a UUID

    XMLWordPrintable

    Details

    • Type: RFC
    • Status: Implemented
    • Resolution: Done
    • Component/s: DM
    • Labels:
      None

      Description

      Currently dataset IDs in butler registries are stored as auto-incrementing integers. This works fine for a standalone registry that will never receive datasets from other registries.

      The middleware team would like to change the dataset ID to instead use a UUID. This is required to simplify the change we are making to batch processing where batch jobs are given a prepopulated SQLite registry and at the end of the processing the new datasets are merged into the new registry. This process is simplified significantly if the UUIDs generated by the batch job are retained during the merge with the main registry.

      This UUID system will also allow us to ingest raw files predictably such that a UUID in a registry in the OODS (or any other registry) matches that at the data facility even though the file has been ingested independently.

      Since this requires a schema change the RFC will be flagged to DMCCB. The UUID code is implemented and we are currently working on migration scripts. We would want to change over the main NCSA and IDF repositories to enable them to make use of the UUID features.

        Attachments

          Issue Links

            Activity

            tjenness Tim Jenness created issue -
            tjenness Tim Jenness made changes -
            Field Original Value New Value
            Status Proposed [ 10805 ] Flagged [ 10606 ]
            tjenness Tim Jenness made changes -
            Link This issue relates to RFC-778 [ RFC-778 ]
            tjenness Tim Jenness made changes -
            Remote Link This issue links to "Page (Confluence)" [ 28269 ]
            ktl Kian-Tat Lim made changes -
            Status Flagged [ 10606 ] Board Recommended [ 11405 ]
            tjenness Tim Jenness made changes -
            Link This issue is blocked by RFC-779 [ RFC-779 ]
            tjenness Tim Jenness made changes -
            Remote Link This issue links to "Page (Confluence)" [ 28334 ]
            tjenness Tim Jenness made changes -
            Status Board Recommended [ 11405 ] Adopted [ 10806 ]
            tjenness Tim Jenness made changes -
            Link This issue is triggering DM-29593 [ DM-29593 ]
            tjenness Tim Jenness made changes -
            Remote Link This issue links to "Page (Confluence)" [ 28403 ]
            tjenness Tim Jenness made changes -
            Link This issue is triggering DM-30186 [ DM-30186 ]
            tjenness Tim Jenness made changes -
            Link This issue is triggering DM-30316 [ DM-30316 ]
            tjenness Tim Jenness made changes -
            Remote Link This issue links to "Page (Confluence)" [ 29160 ]
            tjenness Tim Jenness made changes -
            Resolution Done [ 10000 ]
            Status Adopted [ 10806 ] Implemented [ 11105 ]
            tjenness Tim Jenness made changes -
            Remote Link This issue links to "Page (Confluence)" [ 29373 ]

              People

              Assignee:
              tjenness Tim Jenness
              Reporter:
              tjenness Tim Jenness
              Watchers:
              Andy Salnikov, Colin Slater, Jim Bosch, John Parejko, Kian-Tat Lim, Leanne Guy, Michelle Butler [X] (Inactive), Michelle Gower, Tim Jenness, Wil O'Mullane, Yusra AlSayyad
              Votes:
              0 Vote for this issue
              Watchers:
              11 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Planned End:

                  Jenkins

                  No builds found.