This image shows how functions and event automation move staged file-based data sources in object storage into a database for local analysis.

Data exported from a database or application is stored in files as comma-separated values (CSV) and uploaded to a bucket in object storage. Event automation detects the new object and initiates an associated function to process the file, load the data into Oracle Autonomous JSON Database using REST services, and then move the file to another bucket for tracking purposes. The logging service provides insight into workflow execution. The database makes the data available for analysis.

This image shows a single Oracle Cloud Infrastructure region with a single availability domain. The region provides the following:

• Access management
• Audit service
• Object storage
• Events service

The availability domain includes a virtual cloud network (VCN) with two private regional subnets, a service gateway, and a dynamic routing gateway for private connections from the customer's data center through IPSec VPN or FastConnect and from Oracle Analytics Desktop. The VCN provides routing tables for each subnet and each subnet provides its own security list access. The regional subnets are arranged as functional layers:

• Application layer (regional private subnet): This subnet includes the application and function implementation. It accepts incoming event messaging and interacts with object storage through the service gateway. It also moves processed data to the database in the database layer.

• Database layer (regional private subnet): This subnet houses Oracle Autonomous JSON Database which receives processed data from the application layer and communicates with Oracle Analytics Desktop through the dynamic routing gateway (DRG). In addition to the access management provided by the route table and security list for the subnet, the database layer is also managed by a network security group (NSG) that defines a set of security rules that apply to database resources within the subnet.