Extending Oracle Application Express with Oracle Cloud Features: A Guide to Enhancing APEX Web Applications with Cloud-Native and Machine Learning Technologies

Table of Contents
About the Authors
About the Technical Reviewer
Acknowledgments
Introduction
Chapter 1: Architecting a Secure Infrastructure for APEX
	Network Components
		Virtual Cloud Network
		Network Security Groups
		Bastion
	Infrastructure as Code
		Terraform and the Resource Manager
		The OCI Designer Toolkit
	Deploying APEX to a Database System
		Oracle Autonomous Linux
		Load Balancer
	APEX on an Autonomous Database
		Private Endpoint
		Vanity URL
	Web Application Firewall
	Vulnerability Scanning
	Logs, Metrics, and Alarms
	Summary
Chapter 2: Storing Large Objects Using Object Storage
	Oracle Cloud Infrastructure
	Storing Files in the Oracle Database
	The OCI Object Storage Alternative
	Using OCI Object Storage with APEX
		Create a Compartment
		Create an OCI Object Storage Bucket
		Create an Oracle Autonomous Database (Optional)
		Create Identity and Access Management Resources
			Groups
			Policies
			IAM User
			API Keys
			Gather Information for APEX Web Credentials
		The APEX Application
			Digital Photos Table
			Web Credential for OCI
			Retrieve Tenancy Namespace
			Application Attributes – Substitutions
			Complete Code to Interact with Object Storage
		Considerations
	Summary
Chapter 3: Using Oracle Cloud Functions
	Image Processing
		Processing Images on the Client Browser
		Custom Image Processing REST API
		Using Third-Party REST APIs
	Oracle Cloud Functions
		Required Software and Tools
			OCI CLI
			Fn Project CLI
		Virtual Cloud Network
		Identity and Access Management
			User
			API Keys
			Auth Token
			Groups
			Policies
		Set Up Fn Project CLI
		Oracle Cloud Infrastructure Container Registry
		Validate Setup
	Thumbnail Generator Function
		Approach to Development
		Configuration Parameters
	Triggering Functions with Oracle Events
	Resource Principals
	Complete Function and Deploy
	Troubleshooting and Logging
	Thumbnails Applied
	Summary
Chapter 4: Exposing Functionality with API Gateway
	Use Case Definition
		Deploy the Language Translation Engine
		Oracle Functions for Language Translation
		API Gateway for Language Translation
			IAM Policy
			Network Security Group
			API Gateway
	Calling the API Gateway from APEX
	Security and Logging
	Summary
Chapter 5: Oracle Machine Learning in Autonomous Database
	Setting Up the Oracle Machine Learning Environment
		Creating an Autonomous Database
		Obtaining the URLs Needed for Using the OML Service
		Creating an OML User
			Creating a User Using Oracle ML User Administration
			Creating a User Using Database Actions
	Oracle Machine Learning
		An Introduction to Oracle Machine Learning User Interface
		Administration
		Notebooks
		AutoML
		Models
	Oracle Machine Learning for SQL (OML4SQL)
	Oracle Machine Learning for Python (OML4Py)
	In-Database Machine Learning and APEX
	Summary
Chapter 6: Oracle Machine Learning REST Services
	A Short Introduction to REST APIs
	Introduction to OML REST Services
		REST API for Oracle Machine Learning Services
		REST API for Embedded Python Execution
	Using OML REST Services
		Installing and Setting Up a REST Client (cURL)
		Creating an Access Token
		Examples of Using OML REST Services
	Using OML REST Services from APEX
	Summary
Chapter 7: Data Labeling
	Setting Up the Service
	Datasets, Records, and Labeling
		Creating a Dataset and Records
		Labeling Records in a Dataset
		Adding New Records to the Dataset
		Data Labeling Errors
	Data Labeling with APEX Using OCI APIs
		Data Labeling APIs
		Setting Up APEX for Data Labeling APIs
		Using Data Labeling APIs with APEX
	Summary
Chapter 8: Anomaly Detection
	Setting Up the Anomaly Detection Service
		Compartment, Policies, User Groups, and a User
		Vault, Keys, and Secrets
	Anomaly Detection Service
		Requirements for the Data
		Creating a Machine Learning Model and Detecting Anomalies
		Metrics
	Anomaly Detection with APEX Using the OCI API
		Anomaly Detection API
		Setting Up APEX for Anomaly Detection API
		Using Anomaly Detection APIs with APEX
	Summary
Chapter 9: Language
	Different Use Cases for Language Service
		Language Detection
		Text Classification
		Key Phrase Extraction
		Named Entity Recognition
		Sentiment Analysis
	Setting Up the Service
	Analyzing Text with the OCI Console
	Analyzing Text with the OCI Language API and APEX
		Language API
		Setting Up APEX for Language API
		Using Language API with APEX
	Summary
Chapter 10: Vision
	Working with OCI REST APIs
	OCI Object Storage
	OCI Vision
	Summary
Chapter 11: Email Delivery Services
	Setting Up OCI Resources
		Identity and Access Management
		Regions, Availability, and Server Information
		Email Domains
		Approved Senders
		Suppression List
	Configure APEX Instance for OCI Email Delivery Service
	Email Deliverability
		Testing Deliverability
		Troubleshooting Deliverability
	Other Essentials
	Summary
Index