SUMMARY

SEARCH

Disclaimer: Authors have full rights over their works. Reproduction of any part of the content is prohibited without prior authorization.

BOOK ORACLE APPLICATION EXPRESS BY DESIGN

SUMMARY

280

Introduction
Chapter 1: Design Trade-Offs
Chapter 2: Inside vs Outside of the Box
Chapter 3: Database Design for APEX
Chapter 4: Many Light Pages vs One Heavy Page
Chapter 5: Database Updates
Chapter 6: Cookie Applications
Chapter 7: Authorization
Chapter 8: GUI Design
Chapter 9: Error Handling
Chapter 10: Mobile
Chapter 11: Rules and Guidelines
Appendix A: A Cloudy Crystal Ball
Appendix B: Things Not Covered
Index
About the Author
About the Technical Reviewer
Acknowledgments
Introduction
Chapter 1: Design Trade-Offs
Stakeholders
Trade-Offs and Quality
The Human Side of Trade-Offs
Summary
Chapter 2: Inside vs Outside of the Box
Working Inside the Box
Historical Perspective
The Box: Pros and Cons
Designing Inside and Outside of the Box
Branding
User Experience (UX)
Updating the Database
Road Map for Stepping Outside the Box
Summary
Chapter 3: Database Design for APEX
Primary Keys
Column Name Lengths
Thick Database
Summary
Chapter 4: Many Light Pages vs One Heavy Page
APEX Wizards Build Many Light Pages
Merging Many Light Pages into a Few Heavy Pages
Light Pages vs Heavy Pages: Picking the Correct Strategy
Designing for End Users
Designing for Roles
Performance Issues
Summary
Chapter 5: Database Updates
Architecture
APEX in a Thick Database
DEV vs TEST and PROD Environments
TAPI Helper Tools
Optimistic Locking
Summary
Chapter 6: Cookie Applications
APEX Cookie Application Architecture
Cookie Name Attribute
Global Application Items
Login Application
Sharing Regions and Pages Among Cookie Apps
Parameters That Will Never Change
Substitution Strings
Application Items
Parameter Table
PL/SQL Constant Package
Designing Cookie Application Environments
Summary
Chapter 7: Authorization
The Need for Configuration
Built-in Access Control Page
Authorization Architecture
Binding APEX Users to Components
Finding the Value of APP_COMPONENT_NAME
Coding the Authorization Scheme
Authorization Granularity
Coarse Grained
Fine Grained
A Mixture of Coarse and Fine Grained Authorization
Authorization Configuration Pages
Component Names
Security
Training the Configuration Team
Authorization vs Conditions
Summary
Chapter 8: GUI Design
GUI Goals
The Invisible GUI
User Experience
Your GUI Budget
The Cost of a Click
The Sloppy GUI
Know Your User Community
GUI Design for Multiple User Groups
GUI Style: Conservative vs Trendy
GUI Layout and Terminology
Summary
Chapter 9: Error Handling
APEX Error Environment
System Errors
User Errors
JavaScript Validations
JavaScript Validations with AJAX Calls
APEX Computations and Validations
Transaction API and Constraints
APEX Error-Handling Function Mechanism
The Prime Directives of Validation Logic
Coding Errors
Syntax Errors
Logic Errors
Risk Management
Summary
Chapter 10: Mobile
Users First
Internal Company Employees
Retail Customers
Device Choices
Native vs Browser/Server
Native Applications
Browser/Server Applications
Hybrid Mobile Applications
APEX in a Mobile World
Responsive vs jQuery Mobile
One vs Two APEX Apps
Summary
Chapter 11: Rules and Guidelines
Why Standards?
Consistency
Standardize Low Value Decisions
Repository for New Ideas
Manage Stakeholder Expectations
On-Boarding New Personnel
Writing a Standards Document
Terse and Concise
Accessible with One or Two Clicks
Template Driven
Easily Updated and Extended
Google Docs
Summary
Appendix A: A Cloudy Crystal Ball
Appendix B: Things Not Covered
Introduction
Chapter 1: Design Trade-Offs
Chapter 2: Inside vs Outside of the Box
Chapter 3: Database Design for APEX
Chapter 4: Many Light Pages vs One Heavy Page
Chapter 5: Database Updates
Chapter 6: Cookie Applications
Chapter 7: Authorization
Chapter 8: GUI Design
Chapter 9: Error Handling
Chapter 10: Mobile
Chapter 11: Rules and Guidelines
Appendix A: A Cloudy Crystal Ball
Appendix B: Things Not Covered
Index
About the Author
About the Technical Reviewer
Acknowledgments
Introduction
Chapter 1: Design Trade-Offs
Stakeholders
Trade-Offs and Quality
The Human Side of Trade-Offs
Summary
Chapter 2: Inside vs Outside of the Box
Working Inside the Box
Historical Perspective
The Box: Pros and Cons
Designing Inside and Outside of the Box
Branding
User Experience (UX)
Updating the Database
Road Map for Stepping Outside the Box
Summary
Chapter 3: Database Design for APEX
Primary Keys
Column Name Lengths
Thick Database
Summary
Chapter 4: Many Light Pages vs One Heavy Page
APEX Wizards Build Many Light Pages
Merging Many Light Pages into a Few Heavy Pages
Light Pages vs Heavy Pages: Picking the Correct Strategy
Designing for End Users
Designing for Roles
Performance Issues
Summary
Chapter 5: Database Updates
Architecture
APEX in a Thick Database
DEV vs TEST and PROD Environments
TAPI Helper Tools
Optimistic Locking
Summary
Chapter 6: Cookie Applications
APEX Cookie Application Architecture
Cookie Name Attribute
Global Application Items
Login Application
Sharing Regions and Pages Among Cookie Apps
Parameters That Will Never Change
Substitution Strings
Application Items
Parameter Table
PL/SQL Constant Package
Designing Cookie Application Environments
Summary
Chapter 7: Authorization
The Need for Configuration
Built-in Access Control Page
Authorization Architecture
Binding APEX Users to Components
Finding the Value of APP_COMPONENT_NAME
Coding the Authorization Scheme
Authorization Granularity
Coarse Grained
Fine Grained
A Mixture of Coarse and Fine Grained Authorization
Authorization Configuration Pages
Component Names
Security
Training the Configuration Team
Authorization vs Conditions
Summary
Chapter 8: GUI Design
GUI Goals
The Invisible GUI
User Experience
Your GUI Budget
The Cost of a Click
The Sloppy GUI
Know Your User Community
GUI Design for Multiple User Groups
GUI Style: Conservative vs Trendy
GUI Layout and Terminology
Summary
Chapter 9: Error Handling
APEX Error Environment
System Errors
User Errors
JavaScript Validations
JavaScript Validations with AJAX Calls
APEX Computations and Validations
Transaction API and Constraints
APEX Error-Handling Function Mechanism
The Prime Directives of Validation Logic
Coding Errors
Syntax Errors
Logic Errors
Risk Management
Summary
Chapter 10: Mobile
Users First
Internal Company Employees
Retail Customers
Device Choices
Native vs Browser/Server
Native Applications
Browser/Server Applications
Hybrid Mobile Applications
APEX in a Mobile World
Responsive vs jQuery Mobile
One vs Two APEX Apps
Summary
Chapter 11: Rules and Guidelines
Why Standards?
Consistency
Standardize Low Value Decisions
Repository for New Ideas
Manage Stakeholder Expectations
On-Boarding New Personnel
Writing a Standards Document
Terse and Concise
Accessible with One or Two Clicks
Template Driven
Easily Updated and Extended
Google Docs
Summary
Appendix A: A Cloudy Crystal Ball
Appendix B: Things Not Covered