Case studies

How do you migrate 20 TB of mission-critical data and 8 Oracle RAC databases without stopping the checkouts and logistics of a major large-scale retailer? The customer, a major international retail player, ran its critical databases on an Oracle RAC infrastructure installed on physical servers. The environment was heterogeneous (multiple Oracle versions, and databases for test, production, the data warehouse, and the store network) and had a critical structural limit: growing hardware obsolescence and the extreme difficulty of sourcing new physical servers with a limited number of CPUs, an essential condition for containing Oracle's high core-based license costs.

How adding a PREPARE statement at the application level eliminated continuous query re-planning on a PostgreSQL database under uninterrupted IoT traffic, removing load peaks and allowing the Amazon RDS instance to be downsized without changing the SQL logic.

How do you keep thousands of IoT devices around the world running without interruption? For a leader in the HVAC industry, Miriade engineered the upgrade of a 10 TB PostgreSQL database on Amazon RDS, removing the risks of an imminent end of life. The result: 30% lower cloud costs, much faster queries, and only 30 minutes of downtime, all without changing a single line of application code.

How do you fix chronic execution plan instability, when unpredictable response times create bottlenecks in financial processes? For a major Energy & Gas operator, the risk was operational as well as technical: delays in Sage X3 billing cycles threatened the company's competitiveness. This case study describes our work on an Oracle Standard Edition database to tame the optimizer without changing a single line of application code.

The client is a heritage luxury fashion house, recognized worldwide for the craftsmanship and elegance of its products. Part of one of the world's most prestigious conglomerates, the company operates through an extensive network of exclusive boutiques and a high-traffic global e-commerce platform. The main challenge came from the need to get value from the information assets generated by digital users: a massive volume of behavioral data (Big Data) that, although centralized at group level, was technically inaccessible for the granular analysis needed to understand purchasing and browsing patterns.

Maxi Di S.r.l. has been a cornerstone of Italian large-scale retail since 1937, with a daily commitment to innovation, quality, and closeness to its customers. It aims to satisfy customers with competitive prices and advanced services, expanding a large network that serves millions of Italian families through steady growth and shared value. To succeed in this challenge, it also relies on Miriade.

Build a tool that could read text and interpret technical images and tables in bilingual catalogs, while ensuring secure, role-based access to company data. All under a tight deadline, to make the technology operational as quickly as possible.

Fast growth through acquisitions carries a hidden burden: technology sprawl. For this customer, a global manufacturing leader producing high-performance specialty alloys for critical sectors such as aerospace and medical, the IT ecosystem had become a maze of scattered data centers, overlapping software contracts, and fragmented operating processes. The challenge was not to cut costs but to regain strategic control of IT spend, with the goal of providing granular cost visibility and making it possible to introduce a FinOps approach even in a hybrid cloud and on-premises environment.

A global leader in control solutions for air conditioning, refrigeration, heating, humidification, and evaporative cooling. Long committed to reducing its environmental impact, with an international network of production sites and more than 2,500 employees, the company is known for the energy efficiency of its commercial, industrial, and residential applications.

The existing reporting was effective but offered little customization for end customers' requests. The data flows to be handled were variable (from 5 to 200 transactions per second) and required real-time updates. What we were asked for was a platform able to scale dynamically to handle complex transactional flows.

Boero is a long-established company (in business since 1831) that produces paints, varnishes, and coating materials for construction and the marine sector, especially yachts. Since 2021 it has been part of CIN, a Portuguese group with which it joined forces to expand its presence in the global market.

A major Italian local health authority (ASL), a pillar of public healthcare for a large catchment area, faced an organizational issue common to many large public administrations: fragmented management of its information assets.

The company's logistics core was at risk of grinding to a halt. The Oracle database behind the sedApta suite — essential for real-time synchronization between demand planning and physical warehouse flows — began to show critical latency. Monitoring systems flagged abnormal spikes in response times, driven mainly by two bottlenecks: process memory saturation (PGA_memory_operation) and excessive CPU consumption, which led the database to forcibly throttle sessions (resmgr: cpu quantum).