Data Warehousing in Oracle Cloud on Autonomous
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
The client is one of the large consumer cooperatives in the retail sector.
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.
- 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.
- 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.