2017 March Meeting: Database Revitalization

  • -

2017 March Meeting: Database Revitalization

Category : Meeting

It has been more than a decade since IBM published the redbook which covered DDS to DDL modernization.  In the same period, IBM has shipped numerous releases and many technology refreshes which include many enhancements that simplify database reengineering and make SQL more attractive as a data centric development language.  So what does modernization mean today?  Is it a simple matter of transforming our objects from their old DDS definitions to new SQL definitions?  It can and should be so much more.  This presentation provides an overview of “low impact” modernization which includes both data definition and data access.  It also describes the core fundamentals which can revitalize your database while improving programmer productivity and database integrity.  This includes datacentric programming, autogenerated columns, constraints, writing better set-based SQL, OLAP enhancements, programming in SQL, and more.  The emphasis will be on pragmatic and practical solutions which you can start implementing now to create a robust modern database that is extendable and scalable.

Jim Denton is a senior consultant in the Lab Services DB2 for i team where his responsibilities include both customized skills transfer and hands on consulting.  Jim specializes in SQL performance, data-centric programming, and database modernization.  Jim has been with IBM since 1981 when he was a S/38 operating system programmer.

Before joining the consulting team, his key assignments included ten years as a systems performance specialist, five years as the lead “JDE on i” performance analyst, three years as a consultant at the IBM Benchmark and Briefing Center in Montpellier France, and a total of eleven years as an operating system developer, including five years designing and implementing enhancements to DB2 for i.

Date:
March 14, 2017

Time:
6:00 P.M.  Networking & Social
6:30 P.M.  Dinner
7:15 P.M.  Speaker

Location:
Goeglein’s Reserve
7311 Maysville Road
Fort Wayne, IN

Menu (buffet):
Marinated Vegetables
Creamy Cole Slaw
Rosemary Chicken
Swiss Steak
Whipped Potatoes & Gravy
Whole Kernel Corn
Dinner Rolls & Butter
Assorted Cookies

Cost:
$25.00 per person, Status members
$35.00 per person, Non-members

To make your reservation, click here:
Meeting Reservation