NEUGC - 2022 has ended
Back To Schedule
Tuesday, April 12 • 10:15am - 11:15am
Data Centric – Moving Business Logic into the Database

Sign up or log in to save this to your schedule, view media, check-in, leave feedback and see who's attending!

Feedback form is now closed.
 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!
Learning Objectives:
                Discover how to move business logic into the database, what methods are available and learn how the applications can be slowly transformed from application centric to data centric.
Audience:             IT Managers, project leaders, programmers and database administrators who are currently working with an old “grown over time” databases and applications want to modernize their application with regard to the data (and database). Programmers who just want to reduce their source code.

avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, Birgitta Hauser - Modernization - Education - Consulting on IBM i
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 traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM  i application... Read More →

Tuesday April 12, 2022 10:15am - 11:15am EDT
Grand Centre

Attendees (7)