Uploaded image for project: 'OpenLMIS General'
  1. OLMIS-4778

Research PostgreSQL data storage database structure

    Details

    • Type: Story
    • Status: Done
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 3.4
    • Fix Version/s: 3.4
    • Component/s: None
    • Labels:
    • Sprint:
      Team Ona Gap Sprint 104, Team Ona Gap Sprint 102, Team Ona Gap Sprint 103
    • Story Points:
      3

      Description

      The reporting platform will require a streamlined data storage solution that supports performant dashboard views. We need to architect the data warehouse storage structure based on the current database schema and lessons learned from the JSI implementations. This issue will include the following:

      • Export of the current OpenLMIS v3 database structure for review by the technical team.
      • Export of the current eLMIS v2 database structure
      • Document the differences in database structure
      • Developer group discussions and possibly a virtual meeting between developer teams of JSI and Ona to discuss the eLMIS v2 database structure and lessons learned.

      Acceptance Criteria:

      • Documentation is created and published to the wiki
      • (Stretch) Adjusted ERD is created and made available on the wiki.

        Attachments

          Issue links

            Activity

              People

              • Assignee:
                cappl1 Craig Appl
                Reporter:
                cappl1 Craig Appl
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: