Metcash upgrades to Oracle Database 11g; Improves Performance by 300%
SYDNEY, Australia - June 18, 2009
Oracle today announced that Metcash, a leading marketing and distribution company operating in the food and other fast moving consumer goods categories, has completed an upgrade to Oracle Database 11g, deployed to consolidate hardware and minimise testing cycles across a database spanning thousands of products.
Improvements in Oracle Database 11g have meant Metcash can report performance improvements of “around 300 per cent” (see below) over the previous environment by allowing strutural changes to the multi-million-row database to be made in seconds instead of hours.
The performance level of Oracle Database 11g has enabled Metcash to keep more business data online. The business can now analyse several years’ data at once, which has led to increased accuracy and efficiency in reporting, measurement and forecasting.
The increased reporting capabilities and decreased reliance on archiving data have led to greater accuracy and improvements in overall supply chain effectiveness.
The company also uses Oracle Application Express rapid development tool to build applications, allowing Metcash’s 14-member data warehouse team to quickly create sales scenarios and run reports that would previously have to be outsourced to Java or HTML developers.
Carl Young, Technical Manager, Metcash: “Since moving to Oracle Database 11g, Metcash has experienced performance improvements of around 300 percent. We can store a greater amount of data online, which allows us to do more analysis over time.”
“With more data online, we can look more closely at the relationship between different business transactions,” he added. “For example, we can determine how quickly boxes moved through the warehouse at any given time, allowing us to better plan for grocery distribution in the future.”
Metcash Trading Limited Australasia (Metcash) is a leading marketing and distribution company operating in the food and other fast moving consumer goods categories. It has three Business Pillars - IGA Distribution, Campbells Cash & Carry and Australian Liquor Marketers.
Oracle (NASDAQ: ORCL) is the world's most complete, open, and integrated business software and hardware systems company. For more information about Oracle, visit oracle.com.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.