SolveDB+: SQL-based prescriptive analytics

Publikation: Bidrag til bog/antologi/rapport/konference proceedingKonferenceartikel i proceedingForskningpeer review

1 Citationer (Scopus)
70 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.

TitelAdvances in Database Technology - EDBT 2021 : 24th International Conference on Extending Database Technology, Proceedings
RedaktørerYannis Velegrakis, Demetris Zeinalipour, Panos K. Chrysanthis, Francesco Guerra
Antal sider12
ISBN (Elektronisk)978-3-89318-084-4
StatusUdgivet - 2021
BegivenhedAdvances in Database Technology - 24th International Conference on Extending Database Technology, EDBT 2021 - Virtual, Nicosia, Cypern
Varighed: 23 mar. 202126 mar. 2021


KonferenceAdvances in Database Technology - 24th International Conference on Extending Database Technology, EDBT 2021
ByVirtual, Nicosia
SponsorOracle, Snowflake, ZOOM, Zoom Video Communications, Inc.
NavnAdvances in Database Technology

Bibliografisk note

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


Dyk ned i forskningsemnerne om 'SolveDB+: SQL-based prescriptive analytics'. Sammen danner de et unikt fingeraftryk.