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

✍ Scribed by Adrian Png, Heli Helskyaho

• Publisher: Apress
• Year: 2022
• Tongue: English
• Leaves: 421
• Edition: 1
• Category: Library

✦ Synopsis

This book shows Oracle Application Express (APEX) developers how to take advantage of Oracle Cloud Infrastructure (OCI) features for APEX that might otherwise go missed. You will learn how to use OCI features for data science tasks such as detecting anomalies in your data, training machine learning models, and much more. The book provides an in-depth look at Oracle Cloud features and demonstrates how they can be easily integrated into an APEX application. While the book focuses on developing for APEX, the approaches covered in the book are also applicable to any other modern web developer framework for applications running on the OCI platform.
For many organizations, the database is the heart of operations. Those who opt to invest in the Oracle Database can learn from this book how to maximize their return on investment. The book begins with an introduction to OCI and help on setting up your OCI developer environment. From there you’ll begin with security by learning to provide single sign-on via the Oracle Identity Cloud Service. Subsequent chapters take you through cloud-focused features such as Object Storage, Oracle Function, Oracle Machine Learning REST Services, and Oracle Cloud Anomaly Detection. You’ll even learn to troubleshoot email delivery services.

What You Will Learn

• Be aware of Oracle Cloud Infrastructure features for developers
• Integrate with cloud native services such as cloud-based object storage and serverless functions
• Enhance APEX applications with machine learning features
• Implement Natural Language Processing and Anomaly Detection Algorithms
• Troubleshoot email delivery services when sending emails using the APEX_MAIL package
• Design and implement an APEX environment that is secure

Who This Book Is For

APEX developers who are looking to extend their application’s capabilities using features and resources available through the Oracle Cloud, and cloud solutions architects who support development teams and help design and implement architectures that benefit business operations

✦ Table of Contents

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