60 likes | 196 Views
How organizations deal with recovering after a disaster. Article: Recovering from Database Recovery: Case Studies and the Lessons They Teach. Group 12 Connar Grimley Steven Vukelich. Citation
E N D
How organizations deal with recovering after a disaster Article: Recovering from Database Recovery: Case Studies and the Lessons They Teach Group 12 Connar Grimley Steven Vukelich Citation Hoferek, M.J.; Wilson, S.C., "Recovering from Database Recovery: Case Studies and the Lessons They Teach," Information Assurance and Security Workshop, 2007. IAW '07. IEEE SMC , vol., no., pp.9,13, 20-22 June 2007 doi: 10.1109/IAW.2007.381907 URL: http://ieeexplore.ieee.org.ezp2.lib.umn.edu/stamp/stamp.jsp?tp=&arnumber=4267535&isnumber=4267527
Real world events • World Trade Center attack - September 11th, 2001 • Hurricane Katrina - August 29th, 2005 • Effects on three companies
Barclays Capital • Phase I – 8:45 – report to a staging center • Originally WTC, but changed to a seaport • Phase II - get backup site up and running • Initiated when second plane hit • Contact Disaster Recovery Company – Comdisco • email declaration of disaster • could house 1/3 of 1200 employees in NJ for 2 weeks • Set up Command-and-control centers • London branch was set by 9:30 AM • New York employees home • Contact remaining employees
Disaster Proofing DBMS Technologies • Database backups • Replication of most important sensitive data in real-time, daily dumps of non-sensitive • Used by Putnam Investments and many others • Redundant data centers • Can shift workload from downed or crippled data center to another one to support business needs • Uses synchronous data replication to keep separated centers identical • Barclay's had option to balance load to London • Very popular after Sept 11 attacks • Putnam Investments, Mellon FInancial, and more have two data centers physically separated now
Where the database people come in • Understand your organization's disaster plan • Learn what your organization expects of personnel to do and where to go • Understand where database systems are crucial to the execution of the disaster plan • Use your technical knowledge • Know how to implement and install different recovery techniques • Complement the different disaster plans with database technologies that will benefit the organization • Improve upon the existing technologies for specific circumstances
Additional Sources • Guerra, A. (2001). Disaster Recovery in Action: Barclays Capital. Wall Street and Technology. October 8, 2001. Retrieved March 26, 2013 from http://www.wallstreetandtech.com/asset-management/disaster-recovery-in-action-barclays-cap/14703631