Nowadays we need to run analytics on all kinds of data. This includes flexible formats and semi-structured data from data lakes as well as curated data from relational databases. A great way to access these different types of data sets and sources with Oracle Analytics is by integrating a flexible, scalable (object) storage layer with the powerful Oracle database engine. This works especially well in the cloud, using OAC on top of the Autonomous Data Warehouse service. The key to all of this is the clever use of (partitioned) Oracle External Tables. In this presentation we will discuss the integration of OAC, ADB, and Object Storage from an architecture point of view, as well as the technical implementation. Demos will show the elegance of the approach, the great performance, and its security benefits.
Become a member of ODTUG to gain access to more than 12,500 files in our technical database.
- Not a member? Click through to the topic of interest to browse a list of available presentations.
- Already a member? Log-in here to access the full database
Click here to see the Full Techincal Resource Database