Articles & Content

Archives

Building Flexible Database Systems: A Review (E01)

Topic: 2008 EU

Subtopic: DB2 for z/OS



DATE: 2008-10-13 (11:15 - 12:15)
SPEAKERS: Dirk Beauson (KBC Global Services NV)

At KBC we had to devellop a new project to contain all Non Life Insurances.Has to contain Belgium, Polish and in the future .... Non Life Insurances. (cars, houses, ...).Has to be very very flexibel, other companies, other needs (columns, authorisations, ...).So our database has to deal a lot with flexibel flavours.I will show the possibilities we POC-ed.And desdcribe how we tried to solve this, trying to be as performant as possible.We also needed to introduce fine grained authorisation. So some users can see things on the browser that other may not see.I will also try to explain what solution we selected and why (create and consult environment).

EXP. LEVEL: Beginner,Intermediate

OBJECTIVES:

Some techniques handling your data in a flexible way

Advantages an disadvantages of the different techniques

Restictions when you are bound to applicative release moments (on the fly alter table add columns can not be used)

You can combine different flexibility techniques in your solution. One won't fit everywhere -> IT DEPENDS ;o)

Flexibility and performance aren't always good friends



This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.