Articles & Content


Embedding Business Rules in a Data Structure (F06)

Topic: 2006 NA

Subtopic: Cross Platform DB2 for z/OS & LUW

DATE: 2006-05-09 (01:00 PM - 02:10 PM)
SPEAKERS: Steve Grimes (Washington University in St. Louis)

SP’s, Triggers and Check Constraints all provide ways to integrate business rules into the database. This talk will demonstrate how business rules can be coded directly into a row/column data structure. "Rule_Weight" and "Not_Rule" columns are offered to implement a table-driven logic solution that provides AND/OR and IF/ELSE relationships. Organizational control over embedded business rules is enhanced as a result.

EXP. LEVEL: Beginner,Intermediate,Advanced


The Row as a "Rule"

Rule_Weight & "Not_Rule" constructs

The Table as Business Logic

SQL to make it work

Auditing, Reporting & Maintenance

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.