dgmsHICSS-INFS740

dgmsHICSS-INFS740 - Decision-Guidance Management Systems...

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Decision-Guidance Management Systems (DGMS): Toward Unified Data Acquisition, Learning, Prediction and Optimization Alex Brodsky Dept. of Computer Science, George Mason University Joint work with X, Sean Wang Dept. of Computer Science, University of Vermont Presentation Outline Motivation and Challenges by Example Stochastic Relational Model Dependency Graph and Transformers Stochastic Prediction in DG-SQL Decision Optimization in DG-SQL Regression Learning in DG-SQL Conclusions and Future Work Motivation and Challenges by Example Dairy Delicious, Inc. produces and sells 2 products pA and pB using 3 ingredients i1, i2 and i3 Dairy Delicious, Inc. maintains a historical DB, and maintains DB views, including: Sales ( week, marketID, marketIndex, priceA, priceB, qtyA, qtyB, revA,revB ) Production( week, marketID, qtyA, qtyB, manufCost, qty1, cost1, qty2, cost2, qty3, cost3, ingredIndex ) To support managements decisions, develop a To support managements decisions, develop a decision-guidance solution to answer queries decision-guidance solution to answer queries such as: such as: Q1 : Given specific prices for ABCs products, what will the expected cost, revenue and profit be, both in total and in each market? Q2 : Given specific prices for ABCs products, in each market, what are (i) the probability of financial loss and (ii) the probability that the demand will be below 2000 units of product pA? Q3 : Given specific prices for ABCs products, find all the markets in which the expected revenue exceeds $2M and the probability of cost exceeding $1.5M is bounded by 5%. Q4 : What should the prices for ABCs products be in each market (except for New York City market), so as to maximize the expected total profit, yet ensure that the probability of cost exceeding $1.5M is bounded by 5% in each market? DGMS High Level View Presentation Outline Motivation and Challenges by Example Stochastic Relational Model Dependency Graph and Transformers Stochastic Prediction in DG-SQL Decision Optimization in DG-SQL Regression Learning in DG-SQL Conclusions and Future Work Stochastic Relational Model Stochastic schema S = { 1:T1, , n:Tn}, where i (i=1, , n) - an attribute Ti (i=1, , n) - a domain type SReg = {...
View Full Document

Page1 / 21

dgmsHICSS-INFS740 - Decision-Guidance Management Systems...

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online