Keeping business schema synchronized
Business integration of homogeneous systems often arises questions regarding the best approach. Different approaches exist as how to keep E/R models up to date, while allowing for other data to coexist. This may employ techniques such as : database-level synchro, employment of triggers to facilitate change logs, the straightforward differential updates with full check of dependent objects, etc. This lecture covers a non-comprehensive list of approaches devised from authors’ experience with such systems spanning over the course of 15 years of integration and development expertise. The topic of partial schema updates will also be covered.