Site Map | Contact Us

6.3.7 Outlook

Archiving support for other object types-master data, PSA data, and administrative data of the schedule and monitor functions-is planned for the next release of SAP BW.

StorHouse
An important part of these developments will be the support of a nearline storage concept (also see Section 6.3.1.2). SAP has concluded a partnership agreement with the company FileTek. The goal of this partnership is the integration of the FileTek product StorHouse into the SAP BW architecture. This integration is proposed to enable the admission of transaction data, which can be relocated from the local database to external storage media because of its age or access frequency but which must remain accessible for analytical processes, even if this is under reduced performance.

Figure 6.17 Nearline storage in SAP BW with StorHouse

StorHouse is a relational database management system, which has been implemented on the basis of an HSM system. Supported storage media include everything from hard disks to tape systems. Due to the characteristics of the storage media used, editing on a line item basis in the database tables is forfeited. Data can be loaded into new table segments only by way of a mass loading mechanism. However, as in normal databases, the data can be accessed using SQL queries.

Cross Media Manager
In addition, the use of a Cross Media Manager in SAP BW is planned. Based on a simple partitioning condition, which correlates with the age of the data, its task will be to control the transfer of data from the local database to the StorHouse database, and vice versa. Furthermore, based on the selection criteria of a query, it must decide which data sources are to be read. Selective read accesses to data that has been relocated to StorHouse are carried out by way of a database link via the local database to the StorHouse system.

Access time in StorHouse will depend largely on which storage media the required data is located in and how well it has been indexed. One of the major strengths of StorHouse is the fact that the storage of table segments and the corresponding indexes can be independently and dynamically adapted to access requirements.

StorHouse for SAP AG Business Information Warehouse (BW)

Excerpted from Chapter 6, "Data Archiving in Various Components of mySAP.com," in Archiving Your SAP® Data, edited by Helmut Stefani, pages 250-251.

©2003 by Galileo Press GmbH.
SAP PRESS is an imprint of Galileo Press, New York, Bonn.

To order this book, click:

Copyright © FileTek, Inc. 2002-2008
All rights reserved.

Webmaster@filetek.com
Legal notices and trademark attributions