Demonstrating SolveDB: An SQL-Based DBMS for Optimization Applications

In this demo, we present SolveDB - the first purely SQL-based DBMS for optimization problem solving and solver integration. SolveDB provides (1) an SQL-based syntax for optimization problem specification, (2) an extensible infrastructure of solvers for different classes of problems (e.g., linear programming), and (3) query optimization techniques to achieve the best execution performance and/or result quality. We demonstrate how our PostgreSQL-based SolveDB implementation allows simplifying specifications of data-driven optimization problems and increasing overall solving performance for (1) traditional well-known optimization problems, (2) "how-to" problems based on TPC-H, and (3) a complex energy planning problem with interlinked energy forecasting and load scheduling.