052 - Decision Trees - Master Data Management In SQL

Instead of making complex procedures to handle otherwise simple decisions, the Master Data Management way tells use to be more abstract, and more data-driven. Therefore, we can create really powerful decisions (with priorities) and run through them with ease. The data driven approach allows us to keep our code small, and to increase our flexibility by adding data, and not updating schemas. 00:33 Recap of model 02:00 What the tables do 02:00 Decision Subject 02:30 DecisionParameter Subject 05:16 Analysis and Outcome Subjects 09:00 Print outputs of the whole process 11:11 How a DecisionPathString is built 14:50 Procedure 1 - Top level 'analyze this transaction' 15:55 Procedure 2 - Gather External Data to use 17:15 Procedure 3 - Iterate through Outcomes 18:06 Procedure 4 - Process the Outcome 18:40 Procedure 5 - Creating the DecisionPathString 21:25 Procedure 6 - Getting the Value for the PathString 23:05 Unpivot view of some analysis 24:33 Functions used by Decisions (just a few ways to gather data) --==================== LINKS ====================-- Ko-fi (Donate/Download Code): https://ko-fi.com/elricsims/ --==================== AFFILIATES ====================-- SQL Complete Affiliate Link: https://secure.2checkout.com/order/cart.php?PRODS=5023603&QTY=1&AFFILIATE=114121&__c=1