Reducing Operational Costs and Ensuring Scalability: A Case Study of Oracle Retail and EBS Transformation to AWS Cloud


Technology Category
- Application Infrastructure & Middleware - Database Management & Storage
- Infrastructure as a Service (IaaS) - Cloud Databases
Applicable Industries
- Consumer Goods
- Retail
Applicable Functions
- Maintenance
- Quality Assurance
Use Cases
- Retail Store Automation
- Theft Detection
Services
- Cloud Planning, Design & Implementation Services
- System Integration
The Challenge
The client faced challenges such as lack of high availability for applications and databases, difficulty in scaling and handling traffic spikes and loads, the need to complete migration before the expiration of on-premises licenses, lack of robust security with on-premises infrastructure, ineffective management of cost and resources, and the need for upgrading OS, database, and server versions along with migration.
The Customer
Metro Retail Stores Group
About The Customer
Metro Retail Stores Group is a leading operator of department stores and hypermarkets in the Visayas region, Philippines. It is the second largest supermarket operator in terms of retail sales value and has multiple store formats ranging from department stores to hypermarkets. It was awarded 'Retailer of the Year' at the Outstanding Filipino Retailer Awards.
The Solution
The solution involved migrating the operating system and EBS applications to the AWS system, managing traffic-related spikes, ensuring upgrades in the database and WebLogic for future upgrades, and implementing the ASM file system to optimize storage performance on AWS.
Quantitative Benefit
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
Related Case Studies.
.png)
Case Study
Improving Vending Machine Profitability with the Internet of Things (IoT)
The vending industry is undergoing a sea change, taking advantage of new technologies to go beyond just delivering snacks to creating a new retail location. Intelligent vending machines can be found in many public locations as well as company facilities, selling different types of goods and services, including even computer accessories, gold bars, tickets, and office supplies. With increasing sophistication, they may also provide time- and location-based data pertaining to sales, inventory, and customer preferences. But at the end of the day, vending machine operators know greater profitability is driven by higher sales and lower operating costs.

Case Study
Improving Production Line Efficiency with Ethernet Micro RTU Controller
Moxa was asked to provide a connectivity solution for one of the world's leading cosmetics companies. This multinational corporation, with retail presence in 130 countries, 23 global braches, and over 66,000 employees, sought to improve the efficiency of their production process by migrating from manual monitoring to an automatic productivity monitoring system. The production line was being monitored by ABB Real-TPI, a factory information system that offers data collection and analysis to improve plant efficiency. Due to software limitations, the customer needed an OPC server and a corresponding I/O solution to collect data from additional sensor devices for the Real-TPI system. The goal is to enable the factory information system to more thoroughly collect data from every corner of the production line. This will improve its ability to measure Overall Equipment Effectiveness (OEE) and translate into increased production efficiencies. System Requirements • Instant status updates while still consuming minimal bandwidth to relieve strain on limited factory networks • Interoperable with ABB Real-TPI • Small form factor appropriate for deployment where space is scarce • Remote software management and configuration to simplify operations

Case Study
How Sirqul’s IoT Platform is Crafting Carrefour’s New In-Store Experiences
Carrefour Taiwan’s goal is to be completely digital by end of 2018. Out-dated manual methods for analysis and assumptions limited Carrefour’s ability to change the customer experience and were void of real-time decision-making capabilities. Rather than relying solely on sales data, assumptions, and disparate systems, Carrefour Taiwan’s CEO led an initiative to find a connected IoT solution that could give the team the ability to make real-time changes and more informed decisions. Prior to implementing, Carrefour struggled to address their conversion rates and did not have the proper insights into the customer decision-making process nor how to make an immediate impact without losing customer confidence.

Case Study
Series Production with Lot-size-1 Flexibility
Nobilia manufactures customized fitted kitchens with a lot size of 1. They require maximum transparency of tracking design data and individual processing steps so that they can locate a particular piece of kitchen furniture in the sequence of processes.