Lesson+3+-+The+Solution

__Lesson 3 - The Solution __
After identifying the current enviornment for Manhattan Associates, my team began to try and determine possible solutions for the database consolidation. The most feasible solution we came up with was actually discussed by the database management team at Manhattan prior to our project. This information gave us some positive re-enforcement that we were at least headed in the right direction to provide an acceptable solution for the task assigned. One of my team mates proposed that we incorporate a staging environment to allow uninterupted access to the consolidated database. The staging area would basically be an area where temporary tables would be stored on the data warehouse server. This would allow for the data to be changed or manipulated before loading it into the data warehouse. This technique would help provide an environment where data reports can be retrieved without system lock-ups and provide higher data integrity. We also suggest that transaction log shipping be used to protect the data and provide data backup in the case of the primary server going offline. This technique acts basically as a reference point that is saved to the secondary server, which can be brought online at any point that the primary server is down.

An Example of Staging Utilization: []

This article discusses how the website for the Liverpool Football Club was experiencing high volume which the system could not handle. The web site administrators decided to switch to a staging environment which instantly increased the amount of volume the website could handle at one time. Bailey, Dave. "Liverpool Web Site Uses NTT Europe to Deal with Traffic Spikes - 08 Oct 2010 - Computing." Insight for IT Leaders - Business Technology News, Analysis, Reviews and Jobs - Computing. 8 Oct. 2010. Web. 13 Oct. 2010. []. **Your paper overall is good; Before your final submission, I suggest having a friend/classmate review your work for grammatical errors.**  **Jarett**