Housekeeping at the push of a button, frees up 25 percent of Database space
Heidelberg (Germany), August 13, 2014 – Specialist publishing group Springer Science+Business Media reduced by a quarter, the size of its global SAP NetWeaver® Business Warehouse solution and improved the loading performance. The fact that long loading times had affected the day-to-day business and the intended migration to the SAP HANA® platform, made it necessary to reduce the database size. The software and consulting company DataVard (http://www.datavard.com) had identified a considerable potential for optimization and assisted the data cleansing with the help of the DataVard housekeeping module ERNA. (http://www.erna.datavard.com/en/)
Springer Science+Business Media is an international leader in specialist publishing, with a registered office in Luxembourg and operational office in Berlin. Approximately 3.000 users from differing divisions, utilized SAP NetWeaver® Business Warehouse solution for reporting and analysis. The long loading times of the Business Intelligence application meant that the results were seldom available before the early morning. Preparing for the future operation of SAP HANA® platform, the system size also represented a significant cost factor.
To improve the loading performance and to be better positioned for the later migration to SAP HANA® platform, Springer Science+Business Media decided to use the application DataVard housekeeping module ERNA. This solution developed by DataVard, automates and controls the handling of temporary data in SAP systems. ERNA’s central cockpit provides transparency on the conducted housekeeping measures, while providing provisions for data deletion and controls for the automation of future measures to improve performance.
DataVard initially performed a system analysis using their software tool DataVard BW Fitness Test. “Our analysis showed, that 1,308 GB of temporary data and logs blocked nearly half of the system size”, says DataVard”s managing director Gregor Stoeckler. “This data significantly slowed the system down.” DataVard also identified considerable potential for optimization with regards to Cube Compression and the deletion of various Logs. In order to automate future data cleansing for Springer Science+Business Media, DataVard’s IT specialists installed the housekeeping module ERNA.
As a result the clearance of unnecessary data was a major success: With the help of ERNA, 750 GB of superfluous data has now been deleted. “We are very impressed, how fast we achieved effective results”, says Matthias Kicherer, Head of Business Intelligence, IT Controlling and End User Support at Springer Science+Business Media. “And the functionalities of the application are also convincing. With the ERNA cockpit we always have a good overview of where we stand. This makes communication much easier.” Another positive aspect was the minor effort required to operate the tool. Housekeeping now only requires one workday per month. In the past, the cleaning activities were more extensive, the process chains for these activities had to be developed first. This led to less housekeeping activities due the lack of time and transparency.
“With the help of ERNA we were able to substantially reduce the effort for data cleansing within our Business Warehouse, with minimum effort and realizing savings of 25 percent of the system”s size. Thus we are now well prepared for future challenges like SAP HANA®,” resumes Matthias Kicherer.
About Springer Science+Business Media
Springer Science+Business Media (http://www.springer.com) is an international leader in specialist publishing in the area Science, Technology, Medicine. Core target groups are scientists in universities and scientific institutes as well as in research departments of companies. The publishing group is also a renowned provider of specialist publications in the German-speaking area and the Netherlands. In 2013 Springer published nearly 2.200 English language magazines and more than 8.400 new books. The publishing house also publishes the world”s largest collection of eBooks in the area Science, Technology, Medicine and the largest portfolio of Open-Access-magazines. Springer Science+Business Media S.A. achieved in 2013 an annual turnover of Euro 943 million. The group has more than 7.000 employees worldwide.
DataVard is a provider of SAP solutions in the areas of SAP restructuring, data management and systems administration. Global, medium-sized and major corporations typically employ our solutions and services. DataVard was founded in 1998. The software and consulting company has seven branches worldwide in Germany, Italy, Slovakia, the USA and United Kingdom.
Frau Daniela Ott
Donner & Doria® Public Relations GmbH
Frau Simone Schmickl