[PDF][PDF] sPaQLTooLs: a stochastic package query interface for scalable constrained optimization

M Brucato, M Mannino, A Abouzied, PJ Haas… - Proceedings of the …, 2020 - par.nsf.gov
Proceedings of the VLDB Endowment, 2020par.nsf.gov
Everyone needs to make decisions under uncertainty and with limited resources, eg, an
investor who is building a stock portfolio subject to an investment budget and a bounded risk
tolerance. Doing this with current technology is hard. There is a disconnect between
software tools for data management, stochastic predictive modeling (eg, simulation of future
stock prices), and optimization; this leads to cumbersome analytical workflows. Moreover,
current methods do not scale. To handle a broad class of uncertainty models, analysts …
Abstract
Everyone needs to make decisions under uncertainty and with limited resources, eg, an investor who is building a stock portfolio subject to an investment budget and a bounded risk tolerance. Doing this with current technology is hard. There is a disconnect between software tools for data management, stochastic predictive modeling (eg, simulation of future stock prices), and optimization; this leads to cumbersome analytical workflows. Moreover, current methods do not scale. To handle a broad class of uncertainty models, analysts approximate the original stochastic optimization problem by a large deterministic optimization problem that incorporates many “scenarios”, ie, sample realizations of the uncertain data values. For large problems, a huge number of scenarios is required, often causing the solver to fail. We demonstrate sPaQLTooLs, a system for in-database specification and scalable solution of constrained optimization problems. The key ingredients are (i) a database-oriented specification of constrained stochastic optimization problems as “stochastic package queries”(SPQs),(ii) use of a Monte Carlo database to incorporate stochastic predictive models, and (iii) a new SUMMARYSEARCH algorithm for scalably solving SPQs with approximation guarantees. In this demonstration, the attendees will experience first-hand the difficulty of manually constructing feasible and high-quality portfolios, using real-world stock market data. We will then demonstrate how SUMMARYSEARCH can easily and efficiently help them find very good portfolios, while being orders of magnitude faster than prior methods.
par.nsf.gov
Showing the best result for this search. See all results