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.
Would you like to see this full item?