Agile Oracle Database Modeling and Development (#AgileOracleDatabase) – I’m a speaker at #DOAG2019

We try to be agile in developing and merging our features into branches when they are ready for use.

Test Driven Development is on everyone’s lips with Java and other languages.

Whether we develop ADF or JET or Spring, we try to apply these techniques in many places.

But what is the real basis of most of our applications?
This is the Oracle database with its data model and programming language PL/SQL!

Again and again we hear that merging data model scripts and PL/SQL programs is not practicable.

But how are we supposed to develop our frontend according to these techniques, if we don’t start with it in the backend?

In the lecture and the demo’s I will show you how you can further develop your data model and your programs in the database agile and test driven from requirement till refactoring.

You can see how tools like Git, Liquibase, utPLSQL and Jenkins work together.

If you speak german and you are interested in some of this, you should come and attend my presentation at DOAG 2019 Nuremberg on Wednesday, Nov. 20, 17:00 in room Istanbul. 

“Regulatorics: Offside is when the referee whistles” – I’m a speaker at #DOAG2018

Today my presentation is confirmed: “Regulatorics: Offside is when the referee whistles”. Maybe the German title will be  better understood: “Regulatorik: Abseits ist, wenn der Schiedsrichter pfeift”

The regulatory system has more and more influence on our software development.

Regulatory authorities, external and internal Auditors are increasingly examining our IT and not longer only our business processes and balance sheets.
Some of them have better trained IT experts as we can find on the free market.

General standards such as ISO/IEC 2700X but also banking-specific standards such as BAIT and MaRisk now pose challenges that generally only large software manufacturers know.
Approximately 40 % of our projects are now regulatory-driven.

Therefore, we are currently redefining our development process in order to implement the following requirements, among others
– Unchangeability of the tested artefacts after the test
– Functional segregation
– Detection of accidental changes or intentional manipulations of the application

The lecture shows the vision of such a safe process. It shows the current status of implementation in SOA and ADF development, for example

– Migration of version management to GIT in Atlassian BitBucket
– Application and selection criteria for a branching model
– Mandatory code reviews in Atlassian BitBucket
– Build and Deployment Pipelines in Jenkins
– Automatic documentation in JIRA Issue via Bitbucket and Jenkins.

Maybe you too can minimize the additional work and continue to work agile to meet such requirements.

If you speak german and you are interested in some of this, you should come and attend DOAG 2018.