where do we go from here - sage computing · 2007-10-21 · where do we go from here? why many it...

www.sagecomputing.com.auwww.sagecomputing.com.au

Where Do We Go From Here? Where Do We Go From Here? Why Many IT Staff are Living in the Why Many IT Staff are Living in the

PastPast

Chris Muir – Senior Consultant

SAGE Computing ServicesSAGE Computing ServicesCustomised Oracle Training WorkshopsCustomised Oracle Training Workshops

and Consultingand Consultingwww.sagecomputing.com.auwww.sagecomputing.com.au


Oracle technology latest directions – overview

DatabaseHow to monitor your whole environmentMaintaining performance levelsEnd to end monitoring in a three tier environmentFeatures coming in version 11

Development toolsDemo of Oracle JDeveloperHow to move to JDeveloper from traditional Oracle toolsOracle Application ExpressDemo of APEXHow to use APEX for fast lightweight web developmentSkill set required

SummaryHow to select an approachWhen to use JDeveloper/APEX/Traditional Oracle tools

AgendaAgenda


Technology DirectionsTechnology DirectionsDatabase1979 2007

Application Server

Character development

Client/server development

Web development

SOA


Technology Directions Technology Directions --DatabaseDatabase

Database1979 2007

Significant increases in storage capacity

Large object support

Management tools

XML support

Grid computing


Technology Directions Technology Directions ––Application ServerApplication Server

Internet Application Server2000 2007

Forms and Reports services

Portal

BPEL

J2EE

Web Services


Technology Directions Technology Directions ––Development ToolsDevelopment Tools

Development tools1986 2007

Character development (Forms/Reports)

SOAJDeveloper

Client/server development (Forms/Reports)

Web developmentApex/JDeveloper


ObsolescenceObsolescence

2010SQL*Plus GUI version

Client/server development (Forms/Reports)

2008

Transition from web development (Forms/Reports) to Apex/JDeveloper


Oracle Enterprise Manager is now usableServer collects comprehensive statisticsOEM provides tuning advice (Automated Database Diagnostics Monitor ADDM)SQL Tuning Advisor recommends tuning techniques for SQLTroubleshooting is easierMulti tier monitoring is supported (if developers are recording the right information)

Managing the DatabaseManaging the Database


Report Policy Violations

Report Storage Problems

Report Backup Status

Report Alerts


End to End tracingEnd to End tracing

DB SESSIONS

GENERIC

GENERIC

GENERIC

GENERIC

APPUSER1

APPUSER2

APPUSER3

APPUSER4

APPUSER5


End to End tracingEnd to End tracing

dbms_application_info.set_module(module_name=>'RESBOOK',action_name=>'UPDATEBOOK');

dbms_session.set_identifier(‘CHRIS');

GENERICAPPUSER1

V$SESSIONCLIENT_IDSERVICE_NAMEMODULEACTION


BetaReplay of workloadEnhanced optimiser plan management

Recognise and trial new plans

Data CompressionOnline upgradeSecurity and audit improvementsI/O Performance enhancements

Expected in Release 11Expected in Release 11


Application ExpressApplication Express


Comes with the databaseFree with Oracle Express EditionWizard driven development environmentEntirely within the Oracle databaseDeclarative approach – rapid developmentTargeted at hosted small-medium systems developmentOracle 10g (but can run on 9i)Metalink is written in Apex

Apex OverviewApex Overview


MetadataBrowser

ApexApex

Apache mod_plsql

Apex ArchitectureApex Architecture

Lightweight rapid web developmentHTML pages generated from meta data


Template Driven Template Driven User Interface User Interface


Customise templatesBuild common objects

Navigation barsLists of valuesWeb Services

Start with Wizard ApproachAdd custom validationAdd custom processing

Building an ApplicationBuilding an Application


Add validation

Add processes

Customisenavigation

Edit properties


SQLPL/SQLHTMLJavaScriptEasily learnt by Oracle developers with traditional skills

Apex Skill SetApex Skill Set


Spend time creating UI TemplatesStart with a small internal applicationUse it to refine standards/UIMake the product widely availableAim to get rid of all the isolated small systems

ApproachApproach


JDeveloperJDeveloper


Java based J2EE technologyEntirely more sophisticated approachEntirely more complex approachUses an MVC architecture utilising ADF Business Component and ADF FacesSupports failover, huge scalabilityOracle’s direction of Fusion and EBSThe successor of FormsUtilises many wizards to reduce learning curve

JDeveloperJDeveloper


JDeveloper DemoJDeveloper Demo


SQLHTML + HTTP Request/ResponseJavaJavaServer FacesJSF Expression LanguageJAAS/JAZN SecurityJavaScript + Some AJAXJ2EE/OC4J Containers

JDeveloper Skill SetJDeveloper Skill Set


Select approach based onFunctional requirementsOrganisation’s technical architectureSkill set of staff

Apex is good for smaller organisations with traditional skills and small/medium systems requriementsJDeveloper ADF is the long term development environmentJDev complexity shouldn’t be shied away from – introduce in a controlled fashion

SummarySummary


Thank YouFor Your Attention

[email protected]

SAGE Computing ServicesSAGE Computing ServicesCustomised Oracle Training WorkshopsCustomised Oracle Training Workshops

and Consultingand Consultingwww.sagecomputing.com.auwww.sagecomputing.com.au

where do we go from here - sage computing · 2007-10-21 · where do we go from here? why many it...

Documents