Data Warehousing in Oracle Cloud on Autonomous
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.