Introduction Suppose it is necessary to process rows according to last_update_date using an external application. For example there might be two systems that needs to be synchronized which should be achieved through a middleware application. Requirement roughly can be described such that when last_update_date of a row changes, in other words a row is updated or a new row is added, it is necessary to take some actions, e.g. synchronize peer system. Considering life cycle of external application, it is necessary to differentiate two phases: early phase and late phase. Early phase is the phase when external application is first launched. Existing data must be processed. After all existing data is processed, early phase ends. Since all pre-existing data is processed, early phase is probably the phase which most processing throughput happens. Late phase is the phase new updates are processed. Late phase spans the external application lifecycle excluding ea...
Software Engineering experiences and best practices