Rossi Residencial shrinks database size and reduces cost by migrating its SAP applications to IBM DB2

Published on 01-Dec-2008

Validated on 01 Aug 2013

Rossi Residencial

Construction / Architecture / Engineering

Deployment country:

Customer Relationship Management, Enterprise Resource Planning, Supply Chain Management


Rossi Residencial is part of Grupo Rossi, founded in 1913, one of the leading engineering, construction and development groups in Brazil. The Group’s real estate operations were launched in 1961, and Rossi Residencial was created in 1980.

Business need:
Real-estate business Rossi Residencial was growing fast and needed to gain rapid insight into group operations, which was not possible with the existing applications. With data volumes growing by up to 50 per cent annually, operational costs were increasing even as system performance declined.

In preparation for new Java-based software and SAP applications such as SAP Supply Chain Management and SAP Customer Relationship Management, Rossi Residencial migrated its data to IBM DB2.

The migration to a single instance of DB2 has enabled Rossi Residencial to gain a complete, accurate and up-to-date view of its operations. IBM DB2 Deep Compression functionality has helped to reduce data storage growth, saving infrastructure and management costs, and has also produced faster system response times

Case Study

Rossi Residencial is part of Grupo Rossi, founded in 1913, one of the leading engineering, construction and development groups in Brazil. The Group’s real estate operations were launched in 1961, and Rossi Residencial was created in 1980.

The Group, with some 900 employees serving 22,000 customers, is known for the development of modern management and operational methods and highly efficient construction technologies.

With operations in 57 cities across Brazil, business systems at Rossi Residencial struggled to provide the necessary data in a timely fashion. A more detailed understanding of the current position would allow Rossi Residencial to raise development funds on more advantageous terms, and improve general business and financial management.

On a practical level, Rossi Residencial was experiencing a rapid increase in data volumes. Between the years 2000-2005, data storage demands increased by approximately 10 per cent a year; in 2006, volumes grew by 30 per cent, and in 2007 by 40 per cent, causing a rise in administration and hardware costs.

The objectives were to enable rapid, accurate and cost-effective group-wide reporting for business management and financial requirements, and to cut data storage and related operational costs. In combination, these changes would help Rossi Residencial continue its very successful expansion program throughout Brazil.

Meeting migration challenges

Migration was completed successfully with assistance from IBM Global Services. A key aspect was the migration to Unicode, which was likely to expand the company’s Informix databases (which held around 370GB of data) – with a consequent impact on hardware costs and system performance. The company also planned to implement the latest version of the SAP NetWeaver Business Intelligence component (SAP NetWeaver BI), which is not supported by Informix.

Reginaldo Mobrizi, Chief Information Officer at Rossi Residencial, comments, “An increase in data volumes would cause us immense difficulty. We needed a solution that would support SAP NetWeaver BI and that would reduce, if possible, our data growth rates.”

Rossi Residencial selected IBM DB2 as its new database platform, aiming to take future advantage of the Deep Compression functionality to restrain data storage requirements. This was important both for the immediate migration to Unicode and for the longer-term management of data within the business. The migration to DB2 has allowed Rossi to constrain database growth, with the longer-term ambition of deploying the powerful data compression technology to further reduce storage requirements.

Selecting IBM Global Business Services

The new SAP ERP application includes asset management, financial accounting, controlling, materials management, sales and distribution, and project management functionalities, and the company also uses the SAP Supply Chain Management application. Rossi Residencial completed the two-stage migration from Informix to DB2 and to the new SAP ERP applications with the assistance of IBM Global Business Services.

“We chose IBM because we viewed the Unicode migration as a complex task that needed real experts in SAP technologies,” says Reginaldo Mobrizi. “It was very important to select a company that would not only complete the migration successfully but could also offer us continued support. IBM offered the experience and global presence we required.

“We concluded that both Microsoft SQL Server and MaxDB were too limited in terms of performance and security for what we were planning to do, so we needed to choose between Oracle and DB2. We decided on DB2 mainly due to the partnership between SAP and IBM, and secondly because DB2 offers lower expected total maintenance costs.”

Unicode conversion often results in a substantial increase in database size, which can be mitigated by using DB2 Deep Compression. An elegant way to enable DB2 row compression is during SAP system copies, Unicode conversions or database migrations, compressing the data as it is loaded into the database. The SAP R3load tool provides several ways to deploy DB2 compression and to compress the data when it is loaded into the tables.

“We were happily surprised by the reduction in data growth offered by DB2, which enabled us to avoid expensive hardware upgrades. We decided to switch on the standard compression from the beginning of the migration because it allowed us to migrate to Unicode without significant impact on the database size. Our target is to compress the 500GB database by 40 per cent, or as close as possible, and we are analyzing the tables to select the ones to be compressed.”

Combining the migration to DB2 9 with Unicode conversion or SAP application upgrades in a single project can help produce savings in storage costs as well as in backup and recovery time, resulting in less overall downtime.

“Because many of the project tasks are identical, combining Unicode conversion with migration to DB2 added very little time to the overall process, helping us both to complete the work quickly and to keep costs low,” says Reginaldo Mobrizi.

Enabling great financial management

With the SAP applications in place, all Rossi Residencial operations share the same core data and functionality.

SAP NetWeaver BI allows Rossi Residencial to paint a complete picture of the business, based on the shared and standardized data generated by the SAP applications.

Even in the complex world of construction, with new projects springing up in cities across the globe, the company is now able to report on current progress and the financial position with complete confidence, allowing Rossi Residencial to build new projects more rapidly.

“IBM was central to the success of this project,” concludes Reginaldo Mobrizi, “bringing the required Unicode migration expertise and delivering a very smooth and totally reliable transition process. DB2 helps us to save infrastructure costs, and delivers excellent performance, allowing Rossi Residencial to continue its very successful expansion program.”

Products and services used

IBM products and services that were used in this case study.

DB2 9 for Linux, UNIX and Windows

Operating system:
Sun Solaris

IBM-SAP Alliance, IBM Global Business Services

Legal Information

IBM, the IBM logo, and are trademarks of International Business Machines Corporation, registered in many jurisdictions worldwide. A current list of other IBM trademarks is available on the Web at “Copyright and trademark information” at Intel, the Intel logo, Intel Xeon and the Intel Xeon logo are trademarks or registered trademarks of Intel Corporation or its subsidiaries in the United States and other countries. UNIX is a registered trademark of The Open Group in the United States and other countries. Linux is a trademark of Linus Torvalds in the United States, other countries, or both. Microsoft, Windows, Windows NT, and the Windows logo are trademarks of Microsoft Corporation in the United States, other countries, or both. Other company, product or service names may be trademarks, or service marks of others. This case study illustrates how one IBM customer uses IBM and/or IBM Business Partner technologies/services. Many factors have contributed to the results and benefits described. IBM does not guarantee comparable results. All information contained herein was provided by the featured customer and/or IBM Business Partner. IBM does not attest to its accuracy. All customer examples cited represent how some customers have used IBM products and the results they may have achieved. Actual environmental costs and performance characteristics will vary depending on individual customer configurations and conditions. This publication is for general guidance only. Photographs may show design models. © Copyright IBM Corp. 2008. All rights reserved. SAP AG Dietmar-Hopp-Allee 16 D-69190 Walldorf SAP, the SAP logo, SAP and all other SAP products and services mentioned herein are trademarks or registered trademarks of SAP AG in Germany and several other countries. © Copyright 2008 SAP AG