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

Improve schema representation inside cat package

    Details

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

      Description

      We need a way to store schema information and metadata descriptions in a normalized fashion in addition to storing the original source formats for a given database schema, where:

      1. A schema is a collection of tables and database objects (indexes, functions, procedures, etc...) namespaced under that collection. A schema maps to a "database" in MySQL; parlance; a "schema" in postgres parlance; or a user in Oracle parlance, (where a schema and user are interchangeable and the same).
      2. A normalized canonical representation, which may originate from an arbitrary source format. If the format is simple (YAML, JSON), it may not be required to include extra code to process it.
      3. A source format, which is opaque and not to be relied on, but included for completeness and ideally readable by tools external to the cat project
      4. If a source format exists, a description of it's provenance should be included in a README file and information on how the conversion to the canonical format was performed

        Attachments

          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