|
 |
| Slide 1:
Wrangling With Oracle
|
|
 |
| Slide 2:
Introduction
|
|
 |
| Slide 3:
Complementing Model 204
|
|
 |
| Slide 4:
Supplementing Model 204
|
|
 |
| Slide 5:
Replacing Model 204
|
|
 |
| Slide 6:
Questions
|
|
 |
| Slide 7:
"Try it out" Approach - II
|
|
 |
| Slide 8:
Current Database
|
|
 |
| Slide 9:
Current Database
|
|
 |
| Slide 10:
Oracle Test Database
|
|
 |
| Slide 11:
Database Porting Issues
|
|
 |
| Slide 12:
Database Preparation
|
|
 |
| Slide 13:
Oracle Database Preparation
|
|
 |
| Slide 14:
Loading Oracle Test Database
|
|
 |
| Slide 15:
Space Usage
|
|
 |
| Slide 16:
Query Comparisons
|
|
 |
| Slide 17:
Timing Comparisons
|
|
 |
| Slide 18:
Query Scenario 1
|
|
 |
| Slide 19:
Query 1 - M204
|
|
 |
| Slide 20:
Query 1 - Oracle
|
|
 |
| Slide 21:
Query 1 - completed
|
|
 |
| Slide 22:
Query 1 - narrowed ranges
|
|
 |
| Slide 23:
Query 1 - Widened Ranges
|
|
 |
| Slide 24:
Query 2 - Simple Count
|
|
 |
| Slide 25:
Query 3 - Range Query
|
|
 |
| Slide 26:
Query 4 - Multiple criteria
|
|
 |
| Slide 27:
Query 4 - M204 version
|
|
 |
| Slide 28:
Query 5 - Scanning rows
|
|
 |
| Slide 29:
Query 6 - Is Present' Scan
|
|
 |
| Slide 30:
Query 7 - Extracting data
|
|
 |
| Slide 31:
Query 8 - Count of each value
|
|
 |
| Slide 32:
Changes since Wrangling I
|
|
 |
| Slide 33:
Changes to reduce Joins
|
|
 |
| Slide 34:
Changes - continued
|
|
 |
| Slide 35:
Observations: Space Mgmt
|
|
 |
| Slide 36:
Observations: Programming
|
|
 |
| Slide 37:
Living With Oracle vs M204
|
|
 |
| Slide 38:
Backup/Recovery
|
|
 |
| Slide 39:
System Administration
|
|
 |
| Slide 40:
DBMS Data Integrity Enforcement
|
|
 |
| Slide 41:
Should Wrangler be Ported?
|
|
 |
| Slide 42:
Complementing M204
|
|
 |
| Slide 43:
Supplementing M204
|
|
 |
| Slide 44:
Wrangler - Currently with Model 204
|
|
 |
| Slide 45:
Wrangler - relies on M204
|
|
 |
| Slide 46:
Connecting Wrangler
|
|
 |
| Slide 47:
Tangible Benefits ?
|
|
 |
| Slide 48:
Organizational Benefits?
|
|
 |
| Slide 49:
Intangible Benefits?
|
|
 |
| Slide 50:
OS/390 Oracle and Wrangler
|
|
 |
| Slide 51:
"Mainframe" Oracle
|
|
 |
| Slide 52:
Oracle for Ad-hoc support?
|
|
 |
| Slide 53:
M204 - Alive and well
|
|
 |
| Slide 54:
M204 - Alive and Well
|
|
 |
| Slide 55:
Porting to Oracle?
|
|
 |
| Slide 56:
Technical Observations
|
|
 |
| Slide 57:
Living with Oracle - 1
|
|
 |
| Slide 58:
Living with Oracle - 2
|
|
 |
| Slide 59:
Living with Oracle - 3
|
|
 |
| Slide 60:
Living with Oracle - 4
|
|
 |
| Slide 61:
Unexpected findings
|
|
 |
| Slide 62:
What's Next ?
|
|
