Faster Queries in SAP BW
In the case of very large volumes of data it is worthwhile using the PBS nearline solutions with column-oriented database technology. When doing this, you can use either SAP Sybase IQ or Vectorwise by Actian as the analytics server. The column-oriented database technology enables an even greater degree of data compression and significantly more speed in reporting than is possible without a separate database in the ADK version
BW Archiving – Nearline Solution
PBS CBW NLS Solutions for SAP NetWeaver Business Warehouse enable SAP customers to act effectively against the unrestrained growth of the database and the accompanying increase in operating costs. CBW NLS provides effective nearline storage for transparent user access to archived InfoCube and DataStore objects via standard SAP NetWeaver BW queries. CBW is completely integrated into the data archiving process (DAP) of the SAP nearline storage (NLS) interface and lets users evaluate archived data separately or integrated with data from the SAP NetWeaver BW database.
PBS CBW NLS provides an infrastructure to either transfer SAP NetWeaver BW data to an external nearline storage device (here the Sybase IQ Analytics Server) or archive the data to ADK archive files. Both options are integrated into the SAP NLS interface and use the SAP data archiving process (DAP). Both provide excellent data compression which easily exceeds a compression rate of 80 %. Transparent and fast query access to the data will be covered by the SAP NLS interface and the corresponding PBS Interface. CBW includes MultiProvider integration. Additionally, PBS provides effective archiving , retrieval and reloading of PSA data.