When

Thursday December 8, 2016 from 4:30 PM to 9:00 PM CST
Add to Calendar 

Where

Aliotos 
3041 North Mayfair Road
Wauwatosa, WI 53222  

 
Driving Directions 

Contact

Sue Zimmermann 
Wisconsin Midrange Computer Professional Association 
 
vicepres@wmcpa.org 
 

December 2016 Dinner Meeting - Daniel (Dan) Cruikshank 

Our December meeting will feature  Dan Cruikshank, IBM Sr. Consultant at IBM.

Dan is an IBM Sr. Consultant and is a member of the IBM Rochester DB2 for i Lab Services team. Dan has published several articles relating to IBM i performance analysis, database optimization and database reengineering. More recently he has done webinars and user group presentations on application development methodologies and database re-engineering topics (e.g. DDS to DDL, RPG Open Access). Dan’s main role is to illuminate, educate and enable IBM i customers in how to take advantage of this remarkable system and it’s integrated, state of the art relational database.

Session I - Database Re-engineering Strategy - 2016

It has now been 11 years since the DDS to DDL Modernization strategy was published in the Redbook “Modernizing IBM eServer iSeries Application Data Access - A Roadmap Cornerstone”. Since then, there have been over 6 new releases of the IBM i operating system.With each release, DB2 for i has provided many new enhancements that has simplified the database reengineering process and made SQL more attractive as a data centric development language.

The session will cover the process of building a solid database foundation using a physical, virtual and data access layer framework. In addition, minimizing the impact of change via the use of bridge techniques such as “surrogate” files (LFs, indexes, aliases and views), RPG Open Access, Global Variables with Triggers, and Instead of Triggers (i.e. creating updateable SQL Join views) will be discussed.The SQL Procedures Language (SQL PL) is a high-level, SQL-based programming language which you can use to create stored procedures, functions, and triggers.  
The following is the agenda for this session:
  • Overview of the IBM Re-engineering Strategy;
  • Reverse Engineering an Existing Database
  • Refactoring Data Access
  • Restructuring the Tables
Session II - Re-engineering Database Objects Using IBM Data Studio

IBM Data Studio (IDS) is a no-charge downloadable database modeling, re-engineering and management tool. It is based on the Eclipse framework and can be installed in the same package group as Rdi. This session will cover how IDS can be used to reverse engineer existing DB2 for i files (or tables) into a graphical data model and subsequently modify those tables based on the concepts discussed in the Database Reengineering Strategy sessions.

The folowing will be discussed:

  • Creating a data model template consisting of the core fundamental items
  • Reverse engineering a DB2 for i database (DDS or DDL defined) into a graphical data model
  • Adding core fundamental items to the reverse engineered tables
  • Generating DDL from the graphical data model
  • Migrating the data from the old files (tables) to the new re-engineered tables