Back to the Roots : Decision Trees within Modern Database Systems
Wolfschmidt, Lena Renate; Schüle, Maximilian Emanuel (2025): Back to the Roots : Decision Trees within Modern Database Systems, in: Datenbanksysteme für Business, Technologie und Web: Bamberg, 3.-7. März 2025 : Proceedings, Bonn: Gesellschaft für Informatik, S. 687–695, doi: 10.18420/btw2025-37.
Details
- Faculty/Chair
- Faculty/Professorship
- Author
- Wolfschmidt, Lena Renate
- Title of the compilation
- Datenbanksysteme für Business, Technologie und Web: Bamberg, 3.-7. März 2025 : Proceedings
- Publisher Information
- Gesellschaft für Informatik : Bonn
- Year of publication
- 2025
- Language
- English
- DOI
- Abstract
HUK-COBURG relies on decision trees to classify e-mails into topics. As the data is stored within relational database systems, this paper investigates the performance improvement of in-database evaluation of decision trees. The paper first summarises the theory behind binary decision trees, then describes the implementation as SQL case-when statements. The evaluation shows the benefit of the in-database application of decision trees by eliminating expensive extraction-transform-load time. In the future, we intend to optimise the training as well as inference of decision trees in SQL to fully eliminate the need for data extraction.
- Type
- Conferenceobject
- URI
- Activation date
- 2025-02-28