1 / 10

MK Archiving Strategies Balancing System Performance & Data Availability

MK Archiving Strategies Balancing System Performance & Data Availability. David Cervelli Strategic Systems Group, Inc. Session MK007. MK Archiving Strategies Balancing System Performance & Data Availability. Overview Rationale for Archiving Typical Methodology Airborne Approach

maleah
Download Presentation

MK Archiving Strategies Balancing System Performance & Data Availability

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MK Archiving StrategiesBalancing System Performance & Data Availability David Cervelli Strategic Systems Group, Inc. Session MK007

  2. MK Archiving StrategiesBalancing System Performance & Data Availability Overview Rationale for Archiving Typical Methodology Airborne Approach Comparative Benefits Discussion of Alternatives Conclusions

  3. Overview • Installation & Initial Implementation • Database Grows Over Time • Disk Space Requirements Increase • Run Times Increase • Forces Equipment Purchases

  4. Rationale for Archiving • Reduce Volume of Data in Live Company • Provide Appropriate Visibility • Improve Performance & Reclaim Disk Space • Reduce Risk of Data Corruption • Get within DBMS Constraints • Delay Equipment & Software Purchases

  5. Typical Methodology • Create Empty Archive Company • Populate Parameter & Logistics Tables • Populate Common Tables • Select Archiving & Deletion Sessions • Run the Sessions • Put Archive Company to Tape & Delete • Reorganize the Live Tables

  6. Airborne Approach • Logistics Application • Keep Additional Information in Sales Order History • Airbill Numbers • Serial Numbers • Ship-To • Process Delivered Sales Orders • Write Additional Data to Custom Tables • Delete Sales Orders • Display Sales Order History

  7. Comparative Benefits • Typical Methodology • Additional Company • Switch Companies (Cntl-Z) • Reclaim Disk Space • Put to Tape & Delete • Airborne Approach • Same Company • Reclaim Some Disk Space • Additional Visibility & Functionality • Delete History

  8. Discussion Of Alternatives • Typical Methodology • Airborne Approach

  9. Conclusions • Archiving is Important - Don’t Wait Too Long • Deletion versus Archiving • Consider Alternative Methods • Consider Hardware Options • Develop Written Procedures • Survey Users’ Requirements for Retention • Summary Document

  10. Product Details and Investment Please contact one of the experts at Strategic Systems Group, Inc. for more detailed product information, a live demonstration or investment details. Strategic Systems Group, Inc. (310) 539-4645 http://www.ssgnet.comdcervelli@ssgnet.com

More Related