COMMON POWERUp 2021

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. _x000D_ 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._x000D_ 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) … _x000D_ With all these techniques we cannot only reduce our source code to a minimum but also secure our data! _x000D_

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.