Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-5999

Data Warehouse Change Management

    XMLWordPrintable

    Details

    • Type: Feature Request
    • Status: CLOSED
    • Priority: Minor
    • Resolution: Won't Fix
    • Affects Version/s: 2.1.0
    • Fix Version/s: None
    • Component/s: Data Warehouse
    • Labels:
      None

      Description

      Originally http://bugs.osportfolio.org/jira/browse/OSP-1170 as an "other" component. Created as portal. Please recatagorize as nessecary
      This issue duplicates: http://bugs.osportfolio.org/jira/browse/OSP-1154 (which is closed)

      The data warehouse should have some kind of change management system so it knows when to add new tables and when to drop and then re-add the tables.

      The system can look at the table structures and explicitly compare the the table names, and columns (including name, types and parameters). If changed it can update (the table or the whole shabang?)
      Another possibility is to run an MD5 on all the source xml from which the tables are generated. We can store that md5 and if the md5 changes then we can flush the system. (saving the new md5, of course)

      Comments from OSP-1154 / Data warehouse drops its tables when starting tomcat
      Solution:

      Have a meta data warehouse table that contains the info about the various db files that are loaded. The table would have the file name and an md5 of the file.

      If the file doesn't exist in the table, or if the md5 doesn't match then drop and recreate the tables in the file.

      Lastly, put the file and its md5 into the the meta data warehouse.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                andersjb Brad Anderson (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Git Source Code