Meeting Information

Select Meeting  

Meeting Date
Wednesday, May 18, 2022

at the Virtual, room
in Westbury, Long Island

The Presession starts at 5pm
The Networking and Cocktail hour starts at 6pm

Registration link is not currently available, Please try later

Payment can be made at the door (cash or check only)!

4:00pm: Data Centric - Moving Business Logic into the Database

Birgitta Hauser

Presentation Description

When talking about application modernization database most think about converting from DDS to DDL and redesigning the database and yes, this might be the final goal. But there is much more! We have to move from an application-centric thinking to a data centric thinking. In short, instead of coding everything in whatever programming language, we should move as much business logic as possible into the database. It may even include foreign data that is provided and accessed by Web-Services. But what does that mean? At first, using encapsulated (complex) SQL Statements wrapped in SQL Views or User Defined Table Functions, externalizing Data Access, adding constraints and triggers, Row And Column Access Control (RCAC). With all these techniques we cannot only reduce our source code to a minimum but also secure our data!

About Birgitta Hauser

Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as a traditional RPG Programmer but also as a Database and Software Engineer, focusing on IBM i application and database modernization.
Currently she is an independent consultant and works in Consulting, Application Modernization on IBM i and especially Database Modernization on Db2 for i. She also provides individual programming on IBM i to her customers. Additionally, she also works in education as a trainer for RPG and SQL developers. Since 2002 she has frequently spoken at the COMMON User Groups and other IBM i and Power Conferences in Germany, other European Countries, USA and Canada. In addition, she is co-author of two IBM Redbooks and also the author of several articles and papers focusing on RPG and SQL for the ITP Verlag (a German publisher), IT Jungle Guru and IBM DeveloperWorks. In 2015 she received the John Earl Speaker Scholarship Award. In 2018 she received the Al Barsa Memorial Scholarship Award. ? and last not but least she is an IBM Champion since 2020