User Group Offerings - Tysor Database Modeling, Administration, and Development

User Group Offerings
(60 to 90 min.)
RECURSIVE SQL FOR DUMMIES:
Recursive SQL is a powerful construct used to solve many business problems. These problems previously required solutions using application logic containing many SQL statements. This presentation takes the mystery out of recursive SQL and shows how recursive SQL out performs application logic code.

What is Recursion

Coding a Successful Recursive Program

Basic Recursive SQL Statement

Examples of Recursive SQL Solutions

Performance and References

BEGINNING DB2, SQL and THINKING RELATIONALLY (or DB2 101):
Relational technology had a dramatic impact on proper design of software. This presentation will help IT professionals, new to relational technology, bridge the gap between Flat File, VSAM and IMS thinking to relational thinking. This also will be valuable to management in determining if prospective employees are relationally astute.

What Makes Relational Technology Different

Effect on Data Design (OLTP vs. OLAP)

Effect on System Design

Effect On Program Design and Implementation

Summary

LET CARTESIAN PRODUCTS BE YOUR FRIEND - BUT CAUTION:
Not including a proper join predicate in an SQL statement could produce an intermediate result set that "breaks the bank" in size and will not finish before retirement. This presentation explores examples of how to properly harness the awesome power of a Cartesian join to produce exceptionally useful result sets.

What is a Cartesian join

No Join Predicate Example

Partial Join Predicate Example

Earned Premium Example

Anticipating the Unexpected

IBM's DB2 DATABASE ADMINISTRATION and OBJECT COMPARE TOOLS:
IBM is now in the tools market. DB2 Database Administration and Object Compare Tools assist Application Developers, DBAs, and DB2 System Programmers in developing and explaining SQL, querying the catalog, creating and modifying objects, and migrating databases and database changes. This presentation will give an overview of how to use these tools to increase your productivity.

Querying the catalog

Creating and modifying objects

Performance and system level activities

Migrating databases and changes

Versioning and Work Statement Lists

SO YOU WANNA CONVERT YOUR IMS DATABASE TO DB2:
The purpose of this presentation is to share with the DB2 community the experiences of converting an IMS database to a DB2 database for an OLTP system. This will cover the effort from initial data modeling through final data conversion and system delivery to production.

SO YOU WANNA GET THE RIGHT ANSWERS-Numeric:
The purpose of this presentation is to share with the DB2 community the The use of finite arithmetic in computers can, for the unwary, result in wrong answers from code that would be mathematically correct if infinite precision were possible. Using scalar and columnar functions can unwittingly contribute to getting wrong answers. This presentation teaches SQL developers techniques that GET THE RIGHT ANSWER.

SO YOU WANNA HAVE A DATE (AND A GOOD TIMESTAMP):
Computations using Dates and times have always been a challenge. DB2 provides many facilities to help with these computations. This presentation will not only cover the internal and external representations of dates and times, but also their scalar functions, and examples of how to and how not to uses these in computations.