Strategic Options in SAP BW Data Storage Compared

  • by Michael Loveless, BI Strategic Architect, Sapiex, Inc.
  • November 1, 2003
How do you balance your users' demands for fast access against their demands for access to large volumes of data? Choosing the right option for storing aged data will help you achieve that balance. The four key options available for BW are SAP ArchiveLink, the SAP Archive Development Kit, near-line storage systems, and simply augmenting your existing BW hardware/software infrastructure. We compare the pros and cons of all four.

One of the most common requests from SAP BW end users can also lead to one of the biggest errors in BW design: They want quick queries, yet they also want access to significant volumes of data in BW. This request for peak performance and a long data horizon contradicts itself, and it is the BW development team’s responsibility to prevent inappropriate system design.

The value of historical data diminishes quickly. Even if the system is built to handle all historic data, the novelty fades as the end users realize that only the current and previous 12 to 18 months of data are useful in most analytical business reports. As BW databases grow in size, it becomes more difficult for the system to load, store, manage, and report on the vast amount of aged data, and it fails to provide acceptable system performance.

Michael Loveless

Michael Loveless is an SAP NetWeaver BI strategic architect for Sapiex, Inc., a consulting group that focuses on strategic architecture planning and integration for SAP applications. Previously, he worked for SAP America (1998-2004) as a platinum SAP NetWeaver BI consultant. Michael has worked on many SAP NetWeaver BI projects in roles ranging from an SAP NetWeaver BI application configuration consultant to a global strategic SAP NetWeaver BI SME. Currently, he is working as an SAP NetWeaver BI 7.0 project manager and architect for a global forecasting solution project in the pharmaceutical industry, and as a global BI strategic planner for federal government projects.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.