CASE HISTORY

Data Warehousing in Oracle Cloud on Autonomous

TOPIC AREA

Data Architecture

Data Architecture represents the infrastructural foundation of any data management strategy.
The area includes the design and implementation of infrastructures supporting data collection, storage and organization in more or less formally defined structures, as well as computational resources for processing and for end-user use.

Share the Case

Customer

The client is one of the large consumer cooperatives in the retail sector.

Customer Need

Ensure appropriate response times as requests continue to grow, the amount of data to be processed increases and the number of data sources processed increases.

Customer Value

  • Decrease in the workload of the saturated Exadata system due to the increasing DWH workload
  • Optimize HW investment by moving less predictable workload to the cloud. Autonomous DWH allows you to vary hot deployed resources based on workload.

Key differentiators

  • In-depth knowledge of the proposed infrastructure.

Processes & Technologies

The Data Warehouse solution uses Oracle database on Exadata platform, ODI as ETL tool, Golden Gate and Oracle BIEE for the reports and dashboards part. The database size is about 15 Terabytes, with an average load of 20/25 concurrent users on a total of 250/300 connected users.

Did you enjoy this project?

Find out how we can help your company to reach Data Architecture goals!

Contattaci Bridge Consulting