dueling middleware wavv 2000, colorado springs. middleware defined lan dbms web browser client...
DESCRIPTION
Significant Investments Hardware Hardware Data Data Applications Applications People People Hardware Hardware Data Data Applications Applications People PeopleTRANSCRIPT
![Page 1: Dueling Middleware WAVV 2000, Colorado Springs. Middleware Defined LAN DBMS Web Browser Client Workstation Local Area Network Middleware Web Server S/390](https://reader036.vdocuments.us/reader036/viewer/2022062311/5a4d1b4f7f8b9ab0599a6f40/html5/thumbnails/1.jpg)
Dueling Middleware
WAVV 2000, Colorado SpringsWAVV 2000, Colorado Springs
![Page 2: Dueling Middleware WAVV 2000, Colorado Springs. Middleware Defined LAN DBMS Web Browser Client Workstation Local Area Network Middleware Web Server S/390](https://reader036.vdocuments.us/reader036/viewer/2022062311/5a4d1b4f7f8b9ab0599a6f40/html5/thumbnails/2.jpg)
Middleware Defined
LAN DBMSLAN DBMS
Web BrowserWeb Browser
Client WorkstationClient Workstation
Local Area Network
MiddlewareMiddleware
Web ServerWeb Server
S/390
![Page 3: Dueling Middleware WAVV 2000, Colorado Springs. Middleware Defined LAN DBMS Web Browser Client Workstation Local Area Network Middleware Web Server S/390](https://reader036.vdocuments.us/reader036/viewer/2022062311/5a4d1b4f7f8b9ab0599a6f40/html5/thumbnails/3.jpg)
Significant Investments
HardwareHardware DataData ApplicationsApplications PeoplePeople
![Page 4: Dueling Middleware WAVV 2000, Colorado Springs. Middleware Defined LAN DBMS Web Browser Client Workstation Local Area Network Middleware Web Server S/390](https://reader036.vdocuments.us/reader036/viewer/2022062311/5a4d1b4f7f8b9ab0599a6f40/html5/thumbnails/4.jpg)
Low-tech Middleware
3270 Emulation3270 Emulation FTP FTP Screen ScrapersScreen Scrapers Sneaker NetSneaker Net
![Page 5: Dueling Middleware WAVV 2000, Colorado Springs. Middleware Defined LAN DBMS Web Browser Client Workstation Local Area Network Middleware Web Server S/390](https://reader036.vdocuments.us/reader036/viewer/2022062311/5a4d1b4f7f8b9ab0599a6f40/html5/thumbnails/5.jpg)
Viaserv Over The Years
Liberating Enterprise Data
![Page 6: Dueling Middleware WAVV 2000, Colorado Springs. Middleware Defined LAN DBMS Web Browser Client Workstation Local Area Network Middleware Web Server S/390](https://reader036.vdocuments.us/reader036/viewer/2022062311/5a4d1b4f7f8b9ab0599a6f40/html5/thumbnails/6.jpg)
Solutions Over The Years
Client/ServerClient/Server Decision SupportDecision Support Data WarehousingData Warehousing Business IntelligenceBusiness Intelligence E-BusinessE-Business Enterprise Information PortalsEnterprise Information Portals
![Page 7: Dueling Middleware WAVV 2000, Colorado Springs. Middleware Defined LAN DBMS Web Browser Client Workstation Local Area Network Middleware Web Server S/390](https://reader036.vdocuments.us/reader036/viewer/2022062311/5a4d1b4f7f8b9ab0599a6f40/html5/thumbnails/7.jpg)
It Still Comes Down To Basics
ODBC and JDBC access toODBC and JDBC access toS/390 data and applicationsS/390 data and applications
![Page 8: Dueling Middleware WAVV 2000, Colorado Springs. Middleware Defined LAN DBMS Web Browser Client Workstation Local Area Network Middleware Web Server S/390](https://reader036.vdocuments.us/reader036/viewer/2022062311/5a4d1b4f7f8b9ab0599a6f40/html5/thumbnails/8.jpg)
A Relational Layer
RelationalRelationalEngineEngine
VSAMVSAMIMSIMSDD
![Page 9: Dueling Middleware WAVV 2000, Colorado Springs. Middleware Defined LAN DBMS Web Browser Client Workstation Local Area Network Middleware Web Server S/390](https://reader036.vdocuments.us/reader036/viewer/2022062311/5a4d1b4f7f8b9ab0599a6f40/html5/thumbnails/9.jpg)
Two Very Different Approaches
S/390
RelationalRelationalEngineEngine
S/390RelationalRelational
EngineEngine
CICS
11 22Standalone Engine CICS-Coupled Engine
![Page 10: Dueling Middleware WAVV 2000, Colorado Springs. Middleware Defined LAN DBMS Web Browser Client Workstation Local Area Network Middleware Web Server S/390](https://reader036.vdocuments.us/reader036/viewer/2022062311/5a4d1b4f7f8b9ab0599a6f40/html5/thumbnails/10.jpg)
So What’s Important?
Full SQL DML supportFull SQL DML support CICS control of filesCICS control of files Transaction management Transaction management Programmatic accessProgrammatic access Data movementData movement SecuritySecurity ScalabilityScalability Advanced featuresAdvanced features
![Page 11: Dueling Middleware WAVV 2000, Colorado Springs. Middleware Defined LAN DBMS Web Browser Client Workstation Local Area Network Middleware Web Server S/390](https://reader036.vdocuments.us/reader036/viewer/2022062311/5a4d1b4f7f8b9ab0599a6f40/html5/thumbnails/11.jpg)
Full DML Support
SELECTSELECT INSERTINSERT UPDATEUPDATE DELETEDELETE
![Page 12: Dueling Middleware WAVV 2000, Colorado Springs. Middleware Defined LAN DBMS Web Browser Client Workstation Local Area Network Middleware Web Server S/390](https://reader036.vdocuments.us/reader036/viewer/2022062311/5a4d1b4f7f8b9ab0599a6f40/html5/thumbnails/12.jpg)
CICS Control of Files
VSAM shareoptions are problematicVSAM shareoptions are problematic Robust transaction managementRobust transaction management Standard security featuresStandard security features Concurrency controlsConcurrency controls
![Page 13: Dueling Middleware WAVV 2000, Colorado Springs. Middleware Defined LAN DBMS Web Browser Client Workstation Local Area Network Middleware Web Server S/390](https://reader036.vdocuments.us/reader036/viewer/2022062311/5a4d1b4f7f8b9ab0599a6f40/html5/thumbnails/13.jpg)
Transaction Management
Read and write capabilitiesRead and write capabilities Transaction managementTransaction management Long and short transactionsLong and short transactions
![Page 14: Dueling Middleware WAVV 2000, Colorado Springs. Middleware Defined LAN DBMS Web Browser Client Workstation Local Area Network Middleware Web Server S/390](https://reader036.vdocuments.us/reader036/viewer/2022062311/5a4d1b4f7f8b9ab0599a6f40/html5/thumbnails/14.jpg)
Programmatic Access
LAN clients access CICS resourcesLAN clients access CICS resources access any S/390 data store utilize existing business logic special processing
CICS clients access LAN resourcesCICS clients access LAN resources mainframe is central SQL access to LAN-based DBMS utilize newly-evolved business logic data distribution
![Page 15: Dueling Middleware WAVV 2000, Colorado Springs. Middleware Defined LAN DBMS Web Browser Client Workstation Local Area Network Middleware Web Server S/390](https://reader036.vdocuments.us/reader036/viewer/2022062311/5a4d1b4f7f8b9ab0599a6f40/html5/thumbnails/15.jpg)
Data Movement Move data directly into target DBMSMove data directly into target DBMS Bi-directionalBi-directional Ideally, SQL is used to select the dataIdeally, SQL is used to select the data
VSAM
DL/IOther
Oracle
OtherSQLServer
![Page 16: Dueling Middleware WAVV 2000, Colorado Springs. Middleware Defined LAN DBMS Web Browser Client Workstation Local Area Network Middleware Web Server S/390](https://reader036.vdocuments.us/reader036/viewer/2022062311/5a4d1b4f7f8b9ab0599a6f40/html5/thumbnails/16.jpg)
Security
Workstation-sideWorkstation-side support for user authentication
Server-sideServer-side use standard CICS security support SQL GRANT and REVOKE
![Page 17: Dueling Middleware WAVV 2000, Colorado Springs. Middleware Defined LAN DBMS Web Browser Client Workstation Local Area Network Middleware Web Server S/390](https://reader036.vdocuments.us/reader036/viewer/2022062311/5a4d1b4f7f8b9ab0599a6f40/html5/thumbnails/17.jpg)
Scalability
Multi-user, multi-tasking serverMulti-user, multi-tasking server Multiple users serviced by one Multiple users serviced by one
address space or partitionaddress space or partition
![Page 18: Dueling Middleware WAVV 2000, Colorado Springs. Middleware Defined LAN DBMS Web Browser Client Workstation Local Area Network Middleware Web Server S/390](https://reader036.vdocuments.us/reader036/viewer/2022062311/5a4d1b4f7f8b9ab0599a6f40/html5/thumbnails/18.jpg)
Advanced Features
Client-idle timeoutClient-idle timeout Data compressionData compression Cross-datasource joinsCross-datasource joins Cursors and dynamic eventsCursors and dynamic events
![Page 19: Dueling Middleware WAVV 2000, Colorado Springs. Middleware Defined LAN DBMS Web Browser Client Workstation Local Area Network Middleware Web Server S/390](https://reader036.vdocuments.us/reader036/viewer/2022062311/5a4d1b4f7f8b9ab0599a6f40/html5/thumbnails/19.jpg)
So What’s Important?
Full SQL DML supportFull SQL DML support CICS control of filesCICS control of files Transaction management Transaction management Programmatic accessProgrammatic access Data movementData movement SecuritySecurity ScalabilityScalability Advanced featuresAdvanced features
![Page 20: Dueling Middleware WAVV 2000, Colorado Springs. Middleware Defined LAN DBMS Web Browser Client Workstation Local Area Network Middleware Web Server S/390](https://reader036.vdocuments.us/reader036/viewer/2022062311/5a4d1b4f7f8b9ab0599a6f40/html5/thumbnails/20.jpg)
Liberating Enterprise Data
Desktop Access Desktop Access Web IntegrationWeb Integration Data Staging and MovementData Staging and Movement Multi-tiered ApplicationsMulti-tiered Applications
S/390
![Page 21: Dueling Middleware WAVV 2000, Colorado Springs. Middleware Defined LAN DBMS Web Browser Client Workstation Local Area Network Middleware Web Server S/390](https://reader036.vdocuments.us/reader036/viewer/2022062311/5a4d1b4f7f8b9ab0599a6f40/html5/thumbnails/21.jpg)
Liberating Enterprise Data
ServicesProfessional
![Page 22: Dueling Middleware WAVV 2000, Colorado Springs. Middleware Defined LAN DBMS Web Browser Client Workstation Local Area Network Middleware Web Server S/390](https://reader036.vdocuments.us/reader036/viewer/2022062311/5a4d1b4f7f8b9ab0599a6f40/html5/thumbnails/22.jpg)
Liberating Enterprise DataLiberating Enterprise Data