SolveDB+: SQL-based prescriptive analytics

Research output: Contribution to book/anthology/report/conference proceedingArticle in proceedingResearchpeer-review

1 Citation (Scopus)
62 Downloads (Pure)


Today, advanced data analysts make use of both predictive models and optimization problem solving to build data-driven decision making applications, a combination of technologies recently termed Prescriptive Analytics (PA). Current PA applications typically have multiple layers of poorly integrated components: a relational DBMS for data storage/management, ML tools for prediction, and specialized software packages for problem modeling and optimization problem solving. This complex stack leads to inefficient, labor-intensive, and error-prone PA workflows, blocking wider adoption of PA. In this paper, we present SolveDB+ -an RDBMS for PA applications which supports all PA steps with modeling, predictive, and optimization functionalities, and integrates these in a common SQL-based framework. Major SolveDB+ novelties are 1) a powerful SQL-based approach for PA problem specification and solving, 2) an extensible in-DBMS infrastructure for prediction and optimization solvers, and 3) in-DBMS modeling and management of PA models. SolveDB+ significantly improves both PA developer productivity and performance.

Original languageEnglish
Title of host publicationAdvances in Database Technology - EDBT 2021 : 24th International Conference on Extending Database Technology, Proceedings
EditorsYannis Velegrakis, Demetris Zeinalipour, Panos K. Chrysanthis, Francesco Guerra
Number of pages12
Publication date2021
ISBN (Electronic)978-3-89318-084-4
Publication statusPublished - 2021
EventAdvances in Database Technology - 24th International Conference on Extending Database Technology, EDBT 2021 - Virtual, Nicosia, Cyprus
Duration: 23 Mar 202126 Mar 2021


ConferenceAdvances in Database Technology - 24th International Conference on Extending Database Technology, EDBT 2021
CityVirtual, Nicosia
SponsorOracle, Snowflake, ZOOM, Zoom Video Communications, Inc.
SeriesAdvances in Database Technology

Bibliographical note

Publisher Copyright:
© 2021 Copyright held by the owner/author(s).


Dive into the research topics of 'SolveDB+: SQL-based prescriptive analytics'. Together they form a unique fingerprint.

Cite this