Transcript Document 7823781

Solutions for evolving
IDMSX applications
Adrian Thompson
and Richard Halsey
www.xitec-software.com
Visionary software for a changing world
© Xitec Software plc
Who are Xitec
•
•
•
•
•
Founded 1994
Based in UK and USA
Work with over 30 companies worldwide
Partnerships include ICL, EDS, HPS…
Solutions include
–
–
–
–
Off Mainframe Development
Data Mining Pathway
Visualisation
Migration
www.xitec-software.com
Visionary software for a changing world
© Xitec Software plc
Off Mainframe Development Benefits
• People
– Increase productivity
– Boost morale
• Value
– Enhance application quality
– Improve return on investment
• Skills
– Move towards modern technology
– Retain existing skills
www.xitec-software.com
Visionary software for a changing world
© Xitec Software plc
Off-mainframe development
VME Mainframe
DDCL
CLUC
Application Source
Copy Libraries
Productivity
Open Systems
C2 COBOL
Pre-processing to
High functionality
Test/Animation/
Debug
Environment
TP Parameter Files
SCL
Data
www.xitec-software.com
Visual
TPMS Service
+
Screen Painter
Xitec
Distributed
System
Dictionary
Visual
Application Master
Jackson Style
Structure Diagram
Visionary software for a changing world
OpenSCL
Partnership with
EBE Computing
IDMSX on a
Relational Database
© Xitec Software plc
Xitec Dictionary
• Graphical dictionary
– Central repository for all definitions
– Complete fast import
• DDCL, CLUC, TPMS parameter files
– Latest, intuitive interface
• Fast dynamic, familiar, full function definition entry
• Tree structure, tabbed property pages
• Syntax checks and prepares TPMS/IDMSX/AM in seconds
– Holds relational database mapping definitions
– Stored in a relational database
www.xitec-software.com
Visionary software for a changing world
© Xitec Software plc
Database Structure Diagram
Produced from IDMSX database
definitions in the dictionary
Select from
drop down
menu
www.xitec-software.com
Visionary software for a changing world
© Xitec Software plc
View Record Structure
From DDCL structure
At the click of a mouse
To COBOL structure
www.xitec-software.com
Visionary software for a changing world
© Xitec Software plc
Automatic RDBMS Mapping
Graphical Dictionary Interface
Windows Explorer Style
Visual
Flexible
System Dictionary Definitions
Schema
Storage-schema
Records
Keys
Subschema
Pointers
Application
(program interface)
Run-Time
Transparent
Access
Relational Database
www.xitec-software.com
Visionary software for a changing world
© Xitec Software plc
IDMSX Loader
•
•
•
•
•
Populate IDMSX db from mainframe block dump of data files
Structure taken from Xitec Dictionary
EBCDIC <-> ASCII conversion, integrity check, partial load
Very fast, easy to use and effective
Re-run anytime, saves time, costs and help meet schedules
Mainframe
Auto Conversion
EBCDIC - ASCII
IDMSX
RDBMS
www.xitec-software.com
Visionary software for a changing world
© Xitec Software plc
IDMSX Explorer
• Display data
• Explorer style
or DML
navigation
• Modify data
• Check results
www.xitec-software.com
Visionary software for a changing world
© Xitec Software plc
TPMS Emulation
Client
Processes
Network
Created from
Control Virtual
Machine
Routing
Reply
Handler
AVM
Control
current
definitions
www.xitec-software.com
Source Line Debug
Visionary software for a changing world
Application
Virtual
Machine
Application
Virtual
Machine
Application
Virtual
Machine
© Xitec Software plc
TPMS Screen Painter
Drag and drop
Alignment
From dictionary
definitions
Prototyping
www.xitec-software.com
Visionary software for a changing world
© Xitec Software plc
AM - Dictionary
• Load from
mainframe
• Easy to
visualise
• Fast and
intuitive to
use
www.xitec-software.com
• Easy to edit
• Tabbed property pages
Visionary software for a changing world
© Xitec Software plc
Visual AM
• Modern tools
for fast AM
programming
• Understand
AM structures
and flows
• Click to edit
current
structures
www.xitec-software.com
• Add new structures
• Updates dictionary
Visionary software for a changing world
© Xitec Software plc
AM Debug
• Fast debug tools
for TP and batch
• Step through AM
• View variables
• Conditional
breaks
www.xitec-software.com
Visionary software for a changing world
© Xitec Software plc
Summary of Benefits
• People
– Increase productivity
– Boost morale
• Value
– Enhance application quality
– Improve return on investment
• Skills
– Move towards modern technology
– Retain existing skills
www.xitec-software.com
Visionary software for a changing world
© Xitec Software plc
Data Mining Pathway
Business Benefits
• Provide more accurate and timely management
information about your customers, products and business
performance
Spin-offs
• Production of ad-hoc reports, reducing the IT burden
• Investigation of mainframe database issues
• Store archive data with faster access on cheaper medium
• Merge some flat files into the database
www.xitec-software.com
Visionary software for a changing world
© Xitec Software plc
Data Mining Pathway
Transfer Data
Mainframe
Transfer
Definitions
Load /
Convert Data
Graphical
Dictionary
Interface
Xitec
Loader
RDBMS
Automatically
create
e-business
applications
Business
Intelligence
Tools
Tables
Programs
Open Systems Flexibility
www.xitec-software.com
Visionary software for a changing world
© Xitec Software plc
Data Mining Pathway
To this …
From this …
Customer
Alpha
Bravo
Charlie
Delta
Echo
www.xitec-software.com
Orders
15
14
56
3
26
Visionary software for a changing world
© Xitec Software plc
Data Mining Pathway
• Xitec dds populated
from mainframe ddcl
• Relational model
generated from IDMS
database
• Mapping mechanism
established to define
data migration rules
• Scripts to create
relational tables,
indexes etc
automatically created
www.xitec-software.com
Visionary software for a changing world
© Xitec Software plc
Data Mining Pathway
• 1 table created for
each IDMS record
• 1 column for each
item
• 1 relationship per set
• Sequence & foreign
key columns
generated
• Integrity rules
replicated
www.xitec-software.com
Visionary software for a changing world
© Xitec Software plc
Data Mining Pathway
• Input from mainframe
database dump for bulk load,
or IDMS journal for updates
• Full or partial load
• Output to bulk load files
• Reformats EBCDIC to ASCII
• Allows remapping of data
in-flight
• drop records / fields
• split / merge records
• concatenate / split fields
• Configurable - session based
www.xitec-software.com
Visionary software for a changing world
© Xitec Software plc
Summary Data Transfer Process
Image Copy
File transfer
Alternative
Compressed
input
IDMSX Loader
Format Loader
Export
Files
Relational database load files
File transfer
RDBMS
Relational
Database
Load
www.xitec-software.com
Visionary software for a changing world
© Xitec Software plc
Summary of Benefits
•
•
•
•
•
•
•
Retain familiarity of existing database
Faster, flexible access to mainframe data
Little or no additional mainframe loading
Choice of modern reporting and interrogation tools
Take advantage of relational database technology
Reduced filestore costs > increased data capacity
Easy scalability
www.xitec-software.com
Visionary software for a changing world
© Xitec Software plc
Questions?
www.xitec-software.com
Visionary software for a changing world
© Xitec Software plc
For further information…
www.xitec-software.com
www.xitec-software.com
Visionary software for a changing world
© Xitec Software plc