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

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

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)

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

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

Enquiries@sagecomputing.com.au

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

account information: manage bank feeds · sage xero canada...

sage summit san diego sage summit atlanta · additional...

all you (ever) needed to know about java - sage...

sage inspire tour: sage 50 and sage one roadmap

sage computing services customised oracle training workshops...

da virtualização ao cloud computing - reditus€¦ ·...

high throughput computing on campus high throughput...

sage computing...

quantum computing is here - entrust.com

oracle application express workshop - sage · pdf...

preparing for 2010 - sage...

www.sagecomputing.com.au penny.cookson@sagecomputing.com.au...

oracle jdeveloper 11gr1 - sage computing services

sage hrms 2016€¦ · percentage. note that sage hrms...

sage business cloud: acceleration starts here

sage sage reference online collections sage reference online

sage 9.1 reference manual: parallel computing ·...

sage crm saleslogix - sage software: sage 100, sage 500...

sage reference manual: parallel...

report designer for sage mas intelligence 90/200 -...