the point on the web oracle tools today
Post on 14-Jan-2016
35 Views
Preview:
DESCRIPTION
TRANSCRIPT
The Point on the The Point on the Web Oracle Tools TodayWeb Oracle Tools Today
Eric GrancherEric GrancherIT/ASD-DBIT/ASD-DB
Eric.Grancher@cern.chEric.Grancher@cern.ch
Agenda of the Agenda of the presentationpresentation
Oracle Web Application ServerOracle Web Application Server PL/SQL cartridgePL/SQL cartridge
– PL/SQL by hand & Designer/2000 web PL/SQL by hand & Designer/2000 web generatorgenerator
Java and perl cartridgesJava and perl cartridges Forms cartridgeForms cartridge
– SchemaSchema– RestrictionsRestrictions– StatusStatus
Advantages / drawbacksAdvantages / drawbacks
Oracle Web Application Oracle Web Application ServerServer
Network Computing ArchitectureNetwork Computing Architecture Three-tier architectureThree-tier architecture TerminologyTerminology
– Client (browser, Java capable)Client (browser, Java capable)– Web Application Server (ex web server)Web Application Server (ex web server)– Database serverDatabase server
Client/Browser
ORB Services
Application Server Database
PL/SQL CartridgePL/SQL Cartridge
PL/SQL stored procedures produce PL/SQL stored procedures produce HTML which is sent back to the HTML which is sent back to the browserbrowser
PL/SQL code can bePL/SQL code can be– Typed by handTyped by hand– Generated by designer/2000 v1.3.2 Generated by designer/2000 v1.3.2
Client/Browser Application Server Database
URLURL
HTMLHTMLPL/SQLPL/SQLSQL*NeSQL*Ne
ttHTTPHTTP
execute proc1;execute proc1;
HTMLHTML
PL/SQL
Application Server
Java/perl CartridgeJava/perl Cartridge
Java classes run in a JVM on the Java classes run in a JVM on the application server, JDK 1.0.2 is application server, JDK 1.0.2 is supportedsupported
Perl scripts run on the application Perl scripts run on the application serverserver
Client/Browser Database
SQL*NeSQL*Nett
URLURL
HTMLHTML
HTTPHTTP
perl JVM
Perl scriptsPerl scripts
Java .classJava .class
Forms CartridgeForms Cartridge
User-interface is moved to the browserUser-interface is moved to the browser
Client/Browser Application Server Database
Forms
Forms 4.5Forms 4.5
SQL*NeSQL*Nett
DatabaseGUI/text client
SQL*NeSQL*Nett
User interface layerUser interface layer
Application LogicApplication Logic
Data ManagerData ManagerPL/SQL enginePL/SQL engine
User interface layerUser interface layer Application LogicApplication Logic
Data ManagerData ManagerPL/SQL enginePL/SQL engine
Web-forms RestrictionsWeb-forms Restrictions
ActiveX, OCX, OLE, VBXActiveX, OCX, OLE, VBX MDI window MDI window When-Mouse-% triggersWhen-Mouse-% triggers
UnsupportedUnsupported
FontsFonts TimersTimers Level of validationLevel of validation
Critical AreaCritical Area
Bubble helpBubble help Combo boxesCombo boxes Menu acceleratorsMenu accelerators
Developer/2000 2.0
Display in consoleDisplay in console USER_EXIT, ORA_FFI, USER_EXIT, ORA_FFI,
HOSTHOST Iconic button in GIF Iconic button in GIF
formatformat
RestrictedRestricted
http://oraweb01:9000/database/http://oraweb01:9000/database/
Status of Web FormsStatus of Web Forms
Client/browserClient/browser– No JDK 1.1.2 compatible browserNo JDK 1.1.2 compatible browser
OWAS / Developer/2000OWAS / Developer/2000– 1.5 (NT) : not ready for production1.5 (NT) : not ready for production– 1.5.1 (Solaris) : not received1.5.1 (Solaris) : not received– Need of a new architectureNeed of a new architecture– Security ?Security ?
PlansPlans– Production around Q1 1998Production around Q1 1998– Think about it from NOW onThink about it from NOW on
Advantages/drawbacksAdvantages/drawbacks
PL/SQL, perl, JavaPL/SQL, perl, Java Web Web FormsForms
Interaction levelInteraction level CharacterCharacter PixelPixel
BandwidthBandwidth Very Very lowlow -> -> inter/extra-netinter/extra-net
High High ->intranet->intranet
TransactionTransaction Manual (- Manual (- Des/2k)Des/2k) AutomaticAutomatic
AvailabilityAvailability NowNow Q1 1998Q1 1998
http://wwwinfo/~grancher/http://wwwinfo/~grancher/odf/odf/http://oraweb01:9000/http://oraweb01:9000/database/database/
Eric.Grancher@cern.chEric.Grancher@cern.ch
top related