Laserfiche WebLink
Prior to the initial database refresh process, the following one-time tasks need to be performed for <br />every table that is to be part of the refresh process: <br />1-2 hours <br />-Identify the rules and constraints that will be enforced through the verification exercise. <br />1 hour total <br />-Write the SQL to unload a copy of each table eligible for the refresh process. <br />1 hour total <br />-Write the SQL to create the temporary ?refresh? table. <br />-Write the SQL to create the temporary ?verify? table (if present). <br />-Write the SQL to create the temporary ?delete? table (if present). <br />1 hour total <br />-Write the SQL to load the ASCII ?refresh? data set into the temporary database table. <br />-Write the SQL to load the ASCII ?verify? data set into the temporary database table (if present). <br />-Write the SQL to load the ASCII ?delete? data set into the temporary database table (if present). <br />1 hour total <br />-Write the SQL to drop the temporary ?refresh? table. <br />-Write the SQL to drop the temporary ?verify? table (if present). <br />-Write the SQL to drop the temporary ?delete? table (if present). <br />2-8 hours total <br />-Write the SQL to verify any foreign keys present in the ?refresh? table. <br />-Write the SQL to verify any foreign keys present in the ?verify? table (if present). <br />-Write the SQL to verify any foreign keys present in the ?delete? table (if present). <br />-Write the SQL to verify any identified column constraints for the ?refresh? table. <br />-Write the SQL to verify any identified column constraints for the ?verify? table (if present). <br />-Write the SQL to verify any identified column constraints for the ?delete? table (if present). <br />1 hour total <br />-Write the SQL to identify rows from the ?refresh? table that currently exist in the production table. <br />1 hour total <br />-Write the SQL to match rows in the ?change? table with rows in the ?verify? table. <br />3 hours total <br />-Write the SQL to insert ?new? data into the production table. <br />-Write the SQL to modify existing production data with data from the ?change? table (if present). <br />-Write the SQL to delete existing production data with data from the ?delete? table (if present). <br />12-19 hours total for each database table <br />If this range of values is applied against all 64 tables in the CRDSS database, the total number of <br />hours necessary to refresh the entire database would fall in the range 768 - 1216 hours. <br />10 <br />a320/taskmems/ 2-13-01.doc 01/03/97 <br />