QUSER February - Meeting 2 of 2 SQL Workshop

Speaker:
Birgitta Hauser

Thursday, February 20, 2025 - 9:00am to 12:00pm

This is part two of a two-part SQL workshop, split up between February 18th, and February 20th. There is a lot of good stuff to cover!
Data-Centric Thinking: Moving Business Logic into the Database
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 … because we never can touch the database without respect to the application and vice versa. We have to move from application-centric thinking to 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? First, using encapsulated (complex) SQL Statements wrapped in SQL Views or User Defined Table Functions, externalizing Data Access. With these techniques the source code can be minimized. But what is coded in programs, views and SQL Routines can be circumvented. For keeping the data consistent and avoiding unauthorized access constraints and triggers should be added and Row And Column Access Control (RCAC) implemented
With all these techniques we cannot only reduce our source code to a minimum but also secure our data!

QUSER

Zoom

Zoom, MN 55344

United States

RSVP for this meeting!

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 still works as RPG Programmer but also as Database and Software Architect, focusing on IBM i application and database modernization.
Currently she is self-employed and works in Consulting and Application and Database Modernization on IBM i and Db2 for i.
She also works in education as a trainer for RPG and SQL developers on in person and remote workshops and has also recorded several classes and workshops.
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.
IBM Champion since 2020

Main menu

QUSER February - Meeting 2 of 2 SQL Workshop

Useful Links

Contact Us

Main menu

You are here

QUSER February - Meeting 2 of 2 SQL Workshop

Useful Links

Contact Us