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

Design a normalized representation for representing database schemas

    Details

    • Type: Story
    • Status: In Progress
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: cat, metaserv
    • Labels:
      None
    • Templates:
    • Story Points:
      4
    • Team:
      Data Access and Database

      Description

      Minimal requirements for a normalized representation would be:

      1. A normalized representation would include all such objects in one or more files, ideally in a yaml format
      2. It must include ways of describing common database objects, such as Tables and Table columns, Primary and Foreign Keys.
      3. (Optional) It would include a way of describing Views, Triggers, and Jobs
      4. The normalized representation would attempt to be agnostic of database implementation and language implementation, attempting to use a common data type
      5. The normalized representation would provide a way to represent DBMS-specific information if necessary about the objects, such as table implementation (e.g. Innodb vs MyISAM)
      6. The normalized representation would include a way of representing arbitrary key-value metadata about objects (tables, columns, and index), such as units, descriptions, and other metadata.

        Attachments

          Container Issues

            Issue Links

              Activity

                People

                • Assignee:
                  bvan Brian Van Klaveren
                  Reporter:
                  bvan Brian Van Klaveren
                  Watchers:
                  Brian Van Klaveren, Gabriele Comoretto
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:

                    Summary Panel