Type: Feature Request
Resolution: Won't Fix
Affects Version/s: 2.1.0
Fix Version/s: None
Component/s: Data Warehouse
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
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.