Three Tier Approach of KBC GSE 24112005

1
Three Tier Approach of KBCGSE 24/11/2005
Dirk Beauson
2
Agenda

• Production Systems KBC-Bank
• KBC Three Tier Approach
• Old Architecture
• Needs to change
• New Architecture
• How do we get our Data out of DB2 Using our
  Three Tier Approach ?
• 3 cases

3
Agenda

• Production Systems KBC-Bank
• KBC Three Tier Approach
• Old Architecture
• Needs to change
• New Architecture
• How do we get our Data out of DB2 Using our
  Three Tier Approach ?
• 3 cases

4
Production Systems KBC
SCOPE
IMS IPC1DB2 DPC1 Trx ATMs Trx KBC-online
24/24 7/7
IMS SIPC DB2 SDPC Batch Programs 3270 Trx
Head Quarters Trx Branches
Trx1 Trx2 Trx3 Trx4 Trx5 Trx6
Trx1 Trx2 Trx3 Trx4 Trx5 Trx6
IMS IPC2DB2 DPC2 Trx ATMs Trx KBC-online
24/24 7/7
zzzzzzzzzzz
5
Agenda

• Production Systems KBC-Bank
• KBC Three Tier Approach
• Old Architecture
• Needs to change
• New Architecture
• How do we get our Data out of DB2 Using our
  Three Tier Approach ?
• 3 cases

6
Old architecture
Heavy Backend Services
ATM Frontend
Card validation
FAT client
Security
Account info

• Business logic
• Channel logic
• Device Operations

• Data
• Business logic
• Complex Flow Control using TRX switches

7
Example Old card validation
8
Needs Electronic Banking

• Home Enterprisebanking
• Internet banking KBC Online, KBC Online for
  Business
• Lobby banking
• Statement printer (printing statements of
  account)
• ATM (KBC_at_Matic)
• Same Internet technology !
• Web-enabled ATMs offer the potential for channel
  integration as no other technological innovation
• Consistent look and feel between online and
  lobbybanking

9
Project New ArchitectureScope

• Build a framework for multi channel synchronous
  user-facing applications- based on open
  internet standards- reuse existing backend
  business logic
• Stability
• Static sql !!!
• Proven technology
• Migrate all existing distribution channels to the
  framework- E-commerce- Branches- ATMs

10
Idea -gt Multitier application integration
Multiple backend Bank, Insurance,
Other Backend systems
MVS
Application serverTransaction flow, routing,GUI
Branches
ATM
E-commerce
Multiple channels
Multiple devices
11
Application logic
Client
Presentation logic (HTML, Applets,Javascript)Val
idation logic simple field validaton
Midtier
- transaction flow - assembling logic-
presentation logic- additional business logic-
simple validation logic
Backend
- core business logic- validation logic
(business data)
12
New Architecture
LIGHT Backend Services
Mid-Tier
Smart Client?
WAS
Card validation
Applet
Security

• Device operations
• Recovery logic
• No business logic
• No channel logic

Account info

• Data
• Business logic
• NO Channel logic
• No Flow control

• Channel logic
• Flow control
• NO business logic

13
Example New card validation
DEP-NT
BANKSYS
D-platform
D-platform
KPN- OPAD
KPN- OPAD
OLTB-BAPO
OLTB- BAPO
KON-KRT D-plat
KON-KRT D-plat
8
7
MQ
MQ
12
13
MQ
KON-KRT
PROTON REGUL
3
6
4
15
11
14
Web Application Server
2
5
24
18
20
KBC- M_at_tic
KBC- M_at_tic
KBC- M_at_tic
19
1
Card introduction
Pin Entry
Menu
14
Agenda

• Production Systems KBC-Bank
• KBC Three Tier Approach
• Old Architecture
• Needs to change
• New Architecture
• How do we get our Data out of DB2 Using our
  Three Tier Approach ?
• 3 cases

15
How do we get our Data out of DB2 Using our
Three Tier Approach ?

• 3 examples
• Retrieving and managing std business data
• Retrieving special business data
• BLOBs
• Large textfiles stored in a DB2-table split over
  several 100 of rows

16
Retrieving/managing std business data
Identify customer and show me all his accounts
Branche Browser
WAS
IMS connect
Backend
Execute trx A Identify customer on SIPC/SDPC for
customer 1
IMS Trx A identify customer -gt access DB2
Store data of customer 1
ATM
Execute trx B get account info on SIPC/SDPC for
customer 1
IMS Trx B get account info -gt access DB2
KBC Online Customer Browser
Store account data of customer 1

Prepare HTML-page and sent to requester
17
Retrieving/managing std business data

• This is 99,9 how we work
• Why ???
• Proven technologie (Trx on the mainframe)
• Reuse of the same trx for different channels
  (ATM, Branches, Online, )
• Static SQL
• Trx flow managed by WAS -gt less complex than Trx
  flow on the mainframe using Trx Switches.

18
Retrieving BLOB data

• Some of our documents for customers and branches
  are PDF, AFP,
• Special formats mostly build outside Mainframe.
• At KBC we consider these kinds of doc as binary
  data -gt BLOBs.
• These docs are transferred to the mainframe and
  loaded into a DB2-table as a BLOB column.

19
Retrieving BLOB data
Get PDF
Branche Browser
WAS
DB2 connect
Backend
Java Pgm -gt JDBC Select BLOB with key A
Read DB2-table x with key A and return BLOB
column which contains the PDF
KBC Online Customer Browser
If needed format document and Send to requester

20
Retrieving Large textfiles stored in a DB2-table

• Some documents for customers and branches are
  build on the mainframe. NO special formatting.
• These docs are stored in a DB2-table
• Column Name ColNo Datatyp Length
• ----1----v----2----v----3----v----4----v
• ROT_NR 1 INTEGER 4
• BSD_REG_DS 2 TIMESTMP 10
• VLG_NR 3 INTEGER 4
• TK_ZN 4 VARCHAR 3000
• One document can contain several hundreds of
  rows.
• On the WAS a document is formatted out of all
  these rows.

21
Retrieving Large textfiles stored in a DB2-table
Get doc B
Branche Browser
WAS
DB2 connect
Backend
Java-pgm To GET doc B, Call STOPROC C
Execute STOPROC C Opens a cursor on table x
KBC Online Customer Browser
Fetch cursor until no more rows Close cursor

If needed, format document and send to requester
22
??????