SAPINSIDER SPECIAL REPORT | DATA AND DOCUMENT MANAGEMENT
The Key to Success for Retailers?
Consolidated, Up-to-Date POS Data
Senior Software Engineer
The retail world is evolving quickly. Strong competi- tion, new sales channels, and changing consumer
behavior mean a rising number of challenges for retailers.
In addition, the volumes of data involved in retail transactions have increased dramatically. With all these factors,
the ability to effectively capture, process, consolidate, and
manage point of sale (POS) data within a data warehouse
is key to the success of today’s retail businesses.
management and improve performance for the extract,
transform, and load (ETL) process can use IBM DB2 to
optimize their SAP for Retail solutions and SAP
Net Weaver BW. For example, IBM DB2 can improve the
performance of SAP’s POS data management functionality by performing parallel processing on each ETL step
and other long-running functions.
Other key IBM DB2 features, such as compression and
automated database administration and management
features, also seamlessly integrate with SAP applications.
In addition, companies can reduce the database size
required for POS data by 50% or more using the IBM
DB2-specific nearline storage functionality, which transfers aged data to a low-cost storage infrastructure.
The IBM POWER7 series, launched in 2010, also delivers unprecedented performance for both transactional
and throughput computing. For example, the IBM
POWER7 series’ advanced memory expansion feature
can reduce the physical memory requirements of SAP
application servers by 40% and the database server by
25% or more, with minimal impact on performance.
IBM DB2 and IBM POWER7 meet the needs of today’s
retailers by delivering high performance, fast processing,
and an efficient way to manage large volumes of POS
data. For example, when we tested these solutions, one
system, which was based on a mid-sized IBM POWER7
server, was able to handle over 8 billion POS data records.
In addition, the system achieved an overall data throughput of 15 million POS data records per hour.
Start by Giving the Business a Single
Point of Entry for Sales Data
To establish a single point of entry for sales data from
various distribution channels, companies can use SAP’s
POS data management functionality within the SAP for
Retail solution portfolio. This can be installed as a standalone solution or as part of a larger SAP Net Weaver Business Warehouse (SAP Net Weaver BW) implementation.
The POS data management functionality acts as a data
hub for POS data in an organization. It enables data consolidation and cleansing, and makes the POS data available for near real-time reporting, providing up-to-date
sales information to users. By gathering facts and figures
from your retail outlets and making them available
throughout your enterprise, SAP’s POS data management functionality improves decision making at all levels. It also provides standardized reports at the click of a
mouse through a state-of-the-art user interface, enabling
users to access, explore, and analyze incoming sales information faster and more easily than ever before.
Dr. Stefan Hoffmann
Then, Optimize Your Performance
To help companies derive even more value from their
POS data management software, IBM provides IBM DB2
for Linux, Unix, and Windows (IBM DB2 for LUW) and
the IBM POWER series.
IBM DB2 for LUW is an industry-leading database
solution that delivers maximum performance, scalability,
and reliability for a wide range of operating systems and
platforms. IBM DB2 boasts a wealth of built-in features
that help you get the most from your SAP software.
Companies that are looking to support their POS data
IBM has optimized its hardware and database offerings
to provide a strong, powerful platform for SAP for Retail
solutions. Together, IBM’s and SAP’s solutions can help
retail organizations slash TCO, boost performance and
scalability, reduce maintenance efforts, and support the
entire data life cycle.
To learn more, visit www.ibm-sap.com/db2. You can
also find detailed information about running SAP software on IBM DB2 LUW solutions at https://www.sdn.
Jul n Aug n Sep 2011 | sapinsider.wispubs.com | © 2011 Wellesley Information Services.
No portion of this publication may be reproduced without written consent.