Oracle Application Express 5.1 - PowerPoint Presentation

Slide1
Slide2

Oracle Application Express 5.1Overview

[Name][Title][Date]Slide3

IntroductionOracle Application ExpressSlide4

Oracle Application ExpressDatabase-centric web application

development framework

Develop desktop and mobile web apps

Visualize and maintain

database data

Leverage SQL Skills and database capabilitiesSlide5

Oracle Application ExpressDistinguishing Characteristics

App Development IDE is a web browser. No client software needed

App definitions are stored in the database as meta data.

Declarative – No code generation

Page generation is efficient with only one request and one response.

Data processing done in the DatabaseSlide6

Oracle Application ExpressDevelop faster, release more frequently

Develop

Customize

Deliver

Pre-built controls for security, authentication, database interaction, validation, session management and more

…

Go from prototype to production in minutesSlide7

User Interface

Browser Client Interaction

Business Logic

Oracle Application Express

Declarative high productivity App Dev with optional snippet and procedural coding for high control

Components & Data Access

Component Library + Wizards

pages, reports, charts, grids, forms

Component

Properties

Plug-in Development

Analytics, Multimedia

T

ext, Spatial

Simple

V

alidations

and Computations

Modal

Dialogs

Page Branching

Navigation & Page Flow

Conditional Display Logic

Drag & Drop

Layout

User Interface Themes

Icon Library Integration

Input Fields

text area, select list, checkbox, switches, shuttle, radio group

Access Control &

Session Management

Declarative Client Actions

Conditional Flows & Branching

PL/SQL

JavaScript Snippets

3

rd

Party JavaScript

Programs + Libraries Integration

Declarative Theming

CSS Snippets

Menu

Navigation

Lists Component

Template and Theme Development

HTML & CSS

Authentication

Authorizations

Punch-outs and

Call Backs

REST

SQL

Declarative Styling

Collections

Automatic Session Management

Custom

Authentication

Drill Down

Links

PL/SQL

Snippets

No Code

High Productivity

Citizen Developer

4GL meta-data driven development

Programmatic

High Control

IT

Professional

3GL Procedural Code / Libraries

Low Code

More Control

Power User / Departmental Developer

Extend using code snippets and plug-insSlide8

Oracle Application ExpressUse Cases

Developing opportunistic & self service web apps

Extending enterprise application solutions

Migrating file based and client server apps to the webSlide9

Oracle Application Express

No-cost fully supported feature

Any number of apps, developers & end-users

Specialized Oracle Support Team

11gR1, 11gR2, 12c

All DB editions: EE, SE, SE1, XE

Included with Oracle Cloud Services

Schema Service

Exadata Express Service

Database as a Service

No cost evaluation

http://apex.oracle.com

Easy to install

Included by default with all editions of Oracle database

Download latest release from

http://otn.oracle.com/apex

No cost feature of the Oracle DatabaseSlide10

Oracle Application Express3 Tier Architecture

Browser

Mid Tier

Database Tier

Oracle APEX

Engine

Oracle

Database

Data

Schemas

10

ORDS = Oracle REST Data ServicesSlide11

2012

2013

2014

2015

2016

2017

Oracle Application Express

11

1.5

2.0

3.0

4.0

5.0

2.1

2.2

3.1

3.2

4.1

4.2

5.1

Oracle Database Cloud Services

with

Application Express

History

Schema

Service

DBaaS

Exadata

Express

Exadata

ServiceSlide12

C

ustomers

who want a “slice” of the database for

development and deployment of departmental apps.

Don’t want to manage any aspects

of the

database.

Database Schema or PDB available as a monthly Subscription by Size (5, 20, 50, 250*, 500GB*, 1TB*)

Oracle Managed Database

Highly available and scalable infrastructure

Also underpins

the BI, Document, Mobile, Java and other Cloud offerings

Full Instance

Schema / PDB

C

ustomers

who want a

dedicated database

for

dev

/test or production applications.

Want control of database while automating

many

routine tasks

.

Full database available as a metered

s

ervice (Hourly or Monthly)

Choice of customer or Oracle Managed Database

Choice of general purpose or mission-critical infrastructure

Choice of editions to meet different customer requirements

* Planned for a future release.

Database Cloud Service – Multitenant and Single Tenant

Application Express in the Oracle CloudSlide13

Oracle Database Cloud ServicesFull Spectrum of Database Cloud Offerings

Free

Schema

/ Exadata Express Service

Standard & Enterprise

Managed Enterprise

Exadata

Managed

Exadata

Editions

EE with lockdown

EE

with Lockdown

SE,

EE, HP, EP

EE, HP, EP

EP

EP

Implementation

1 Schema

1 Schema /

PDB

1 Dedicated DB

1 Dedicated DB

1+ Dedicated DBs

1+ Dedicated DBs

Management

Oracle

Oracle

Customer

Oracle

Customer

Oracle

Max Storage

100MB

5, 20,

50

GB,

250GB*

50GB

– 4.6TB

50GB

– 4.6TB

42TB – 168TB

42TB – 168TB

Max CPU

< 1

~1

1 – 32

4 – 3228 – 27228 - 272Price / month

$0$175 - $2,000$200 - $5,000TBD*

$70K – $560KTBD*More Storage

N/AUp to 1TB*$0.50 per GB$0.50 per GBN/A

N/AAvailability2017*

Q3 2012 / 2016Q3 20142017*

Q3 20152017*

AccessHTTPsHTTPsFull AccessNearly Full Access

Full AccessNearly Full Access

2017*

* Future Release

2017*

2017*Slide14

Data SourcesUtilize the Oracle Database / Web ServicesSlide15

Single Database Instance / Multiple Workspaces

Workspaces used to define application definitions / Schemas hold data

Many-to-many relationship between Workspaces and Schemas

Instance Administrators manage the environment and schema access

Departments can request more space, and access to a new schema

For example,

http://apex.oraclecorp.com

has over 3,000 Workspaces for every line of business in Oracle

Easily managed with optional self-service provisioningSlide16

Development / Deployment OptionsLocal

Install on stand-alone laptops using Oracle Express Edition (XE) or full database versionSimply upgrade APEX to the required versionCan work completely disconnected

On-Premise

Typically run by the IT Department

IT generally both production operations service, and a service provider

Departments responsible for application development

Cloud

Deploy Internet applications

Leveraged for fast application development, user acceptance and training.

Prototyping & Proof-of-Concept

Consulting

companies

develop for

deployment on

customer premise

Browser based

application

development framework enables efficient development & deployment

Shoot someone a URL – Check this out – Application DevelopmentSlide17

Over 400,00 developers worldwide

Estimated from support requests, downloads, conferences, discussion forum activity

More than 100 active bloggers

http://odtug.com/apex

http://

apex.oracle.com

/community

Consulting companies, books, success stories, quotes, commercial apps

17

Community

Oracle Application ExpressSlide18

http://builtwithapex.com

Showcases large diversity of types of applications and different themes

Launched October, 2016

> 100 sites published,

more being added daily

18

Internet Sites built with Oracle APEX

Oracle Application ExpressSlide19

http://apex.world

Community-authored site providing:

Plug-ins

Slack discussion channels

Twitter feeds

News

Jobs

Conferences

Meetups

19

Community site built by the community for the community

Oracle Application ExpressSlide20

Useful LinksOracle Technology Network http://otn.oracle.com/apex

APEX Community http://apex.oracle.com/communityOracle Learning Library http://www.oracle.com/

oll

Hosted

evaluation

site

http

://

apex.oracle.com APEX Cloud Service

http://cloud.oracle.com

Collateral, Resources and Hosted ServicesSlide21

Product ComponentsOracle Application Express

SkipSlide22

Home PageComprehensive Development IDE, Web Application Development, and SQL Database DevelopmentSlide23

Application BuilderIntegrated Development Environment (IDE) with Application Development Graphical “Page Designer” Features tight SQL and PL/SQL integrationSlide24

Application Builder - Page DesignerMultiple trees to view the page componentsVisualization of the page within the Grid Layout, and associated Gallery, allowing you to drag and drop componentsUpdate multiple attributes without leaving the page in the Property Editor Advanced Code Editor for defining SQL, HTML, CSS and text sectionsHighly configurable user interface:

Customize and refine view of page specific to current focusSlideable panelsDrag and drop tabs

Powerful browser-based IDESlide25
Slide26

Application Builder – Code EditorSyntax HighlightingUndo / RedoFind/ReplaceAuto completionCode validationUsed in Page Designer,

Component View and SQL Workshop

Available

for maintaining SQL, PL/SQL, JavaScript, HTML, CSS, and large text sectionsSlide27

Application Builder - Universal ThemeNew default theme for APEX applicationsUses responsive HTML5 templatesGrid-layout for HTML formsModern flat-lookShips with a variety of pre-built theme stylesOlder themes still available as legacy themes, and will remain part of the product for backwards compatibility

OverviewSlide28

Application Builder - Universal ThemeDeclarative CSS modifiers for HTML5 templatesEnables developers to declaratively apply styles like borders, padding, icons, colors, size, etc.

Uses easy-to-understand, descriptive namesAvailable for most template types:Page, Region, Report, Breadcrumb, List, Item, ButtonSignificantly reduces the number of required templates for a theme

Template OptionsSlide29

Application Builder - Universal ThemeTheme Styles provide a variety of different color schemes and styles for a single themeDefined as CSS file that is included in addition to the theme’s base CSS fileUniversal Theme includes several pre-built stylesAdditional styles can be easily generated using the built-in Theme Roller utility

Theme Styles and Theme RollerSlide30

SQL WorkshopBrowser based maintenance of database objects and dataDesigned to meet application developers’ needs, especially in hosted environmentsSlide31

Team DevelopmentCollaborate with colleges, track project details with associations to application pages. Life cycle development: design, develop, deploy, view customer feedback, enhance, re-deploy.Slide32

Packaged ApplicationsRobust suite of productivity and sample applications.

Illustrates best practices and design patterns.Template to start customization (e.g. unlock your packaged app). Upgraded with every release.Slide33

FeaturesOracle Application Express

SkipSlide34

Interactive ReportsPowerful Reporting capabilities  End-user customizableSlide35

Interactive Grid Modern, rich & interactive multi-row editing componentUse of existing Item typesDeclarative support for Cascading LOVs and Dynamic ActionsUpgrade utility for Tabular FormsMaster Detail / Detail

35Slide36

Interactive Grid 36

Master Detail Layout

–

N-levels wide or deepSlide37

Charting EngineBased on Oracle JET Data Visualization ComponentsOracle Jet (JavaScript Extension Toolkit) is open source JavaScript-based solution, data being provided in JSON formatHighly CustomizableUsing ‘JavaScript code’ to provide function to be called when chart is initialized

Using Dynamic Actions to add interactive behaviorBuilt-in Accessibility SupportBuilt-in Responsive Design SupportDeclarative support for Oracle JET Data Visualization Components

37Slide38

Charting EngineDeclarative support for Oracle JET Data Visualization Components38Slide39

CalendarsDifferent views, drag and drop capability, with mobile specific templatesSlide40

List-based Navigation MenusAlternative to using traditional tabsAvailable as top navigation menu and side menuImplemented as standard APEX listsSupports multi-level hierarchical menu structuresProvides accessible pull-down menusType of navigation determined by themes – Universal Theme uses listsMigration of older one-level tabs to lists when switching themes Slide41

Dynamic ActionsDeclaratively define rich client-side interactivity without writing JavaScript or AJAXSlide42

Modal DialogsReplacement for Popup WindowsA modal dialog is a stand-alone page, not a region on a page

Any page be created as a dialog pageSupports all the functionality of a regular page, incl. computations, validations, processes, and branchesReadily switch between normal, modal, and non-modal page modeSlide43

Plug-InsExtend applications with custom components such as items and regionsSlide44

RESTful Web ServicesEmit RESTful Web Services from the database for use in your SOA environment

Interaction with data sources through use of Uniform Resource Identifiers (URIs)

Standard method of accessing data in the Oracle Cloud

Ability to create services which implement any SQL statement or PL/SQL procedure

Data returned in JSON or CSV format, or additionally through PL/SQLSlide45

WebsheetsAllow end-users to build / maintain WIKI like pages with database capabilities

Database enabled WIKI

Annotations

(easily add files, links,

notes, and tags)

Use [[SQL ]] tag

Presentation mode

Multi userSlide46

Examples of how Oracle uses Oracle APEXOracle Application Express

SkipSlide47

http://shop.oracle.com

Oracle Store [Internet Application]Slide48

http://www.oracle.com/ollOracle Learning Library [Internet Application]Slide49

ARIA PeopleHR Directory [Internal Only – Intranet Application]

Nightly download of HR data

Employees can update profile, upload picture, add links ...

Used to contact employees, see Org. Chart, etc.

Average ~ 1.5 million

page views / day

( > 50 page views / sec for hours )

Median execution time of

0.04 secondsSlide50

“Sailors have access to an Oracle Application Express–based mobile app that automates the 250-item checklist necessary to prep the boat for sailing. “It’s a perfect use of database and mobile technology,” says Burns. “Oracle Application Express is really a powerful tool for widespread mobile data access.”Ian “Fresh” BurnsDesign Team Coordinator

Oracle Team USAPortals and Mobile Solutions

ORACLE TEAM

USA

Oracle Application Express – Success StorySlide51

Leveraging Oracle Database FeaturesOracle Application Express

SkipSlide52

Oracle Application Express (APEX 5)

Security features of the Oracle Database

52

Works with APEX

Transparent Data Encryption

Database Vault

Audit Vault

Database Firewall

Key Vault

Data Redaction

Data Masking

AuditingSlide53

Real Application Clusters

Data Guard

Active Data Guard

Golden Gate

Secure Backup

Online Reorganization

Edition-Based Redefinition

Flashback, Total Recall

Automated Rolling Upgrade of Database

Oracle Database as a Service

High

Availability features of the Oracle Database

53

Failover to the Cloud

Works with APEXSlide54

Oracle Application Express (APEX 5)

High Performance features of the Oracle Database

54

Multi version read consistency

Row level locking

In-Memory

Compression

Partitioning

Hadoop

, Big Data SQL, R

Cost based query optimizer

Scale-out with Oracle RAC

Exadata

Smartscan

&

Infiniband

Works with APEXSlide55

Oracle Application Express (APEX 5)

Simplified consolidation and deployment with Oracle Multitenant

55

PDB Deployment

PDB Cloning

PDB Self Service App

PDB Migration

High Density Consolidation

Automated Provisioning and Configuration

PDB Resource Management

Works with APEXSlide56

Oracle Application Express (APEX 5)

Database Application Development Features

56

SQL and PL/SQL

Java in Database

Analytics

Text

Regular Expressions

Spatial

Pattern Matching

Database XML

Database JSON

SQL

PL/SQL

AQ

Works with APEXSlide57

SummaryOracle Application ExpressSlide58

Oracle Application ExpressUsed by real customers for real applications: Used for both opportunistic

and mission critical apps that service tens of thousands of users.

Well Established Product :

First released

in 2004

Continually growing

:

Oracle install base is adopting Oracle APEX for increasing numbers of projects, and is increasingly an approved corporate IT standard

.

SummarySlide59

Oracle Application ExpressAligned with industry trends: Strong support for HTML5 development frameworks,

Modern & responsive CSS3 UI, integrated JavaScript libraries, Browser-based, self-service provisioning, flexible development and deployment including cloud services.

Consistent with Oracle developers skill

set:

SQL, PL/SQL, Oracle Database.

Proficiency in

the Oracle

database easily translates into an ability to develop web applications

.

SummarySlide60
Slide61
Slide62