arrow
Return

Query-centric regression

delete2022-02-01
delete1
PRE
AI
Q
Qingzhi Ma *
P
Peter Triantafillou
DOI:10.1016/j.is.2021.101736delete
deleteOriginal
deleteOriginal request for help
deleteShare
deleteSave
Abstract

Abstract

En 中文
Regression Models (RMs) and Machine Learning models (ML) in general, aim to offer high prediction accuracy, even for unforeseen queries/datasets. This depends on their fundamental ability to generalize. However, overfitting a model, with respect to the current DB state, may be best suited to offer excellent accuracy. This overfit-generalize divide bears many practical implications faced by a data analyst. The paper will reveal, shed light, and quantify this divide using a large number of real world datasets and a large number of RMs. It will show that different RMs occupy different positions in this divide, which results in different RMs being better suited to answer queries on different parts of the same dataset (as queries typically target specific data subspaces defined using selection operators on attributes). It will study in detail 8 real-life data sets and from the TPC-DS benchmark and experiment with various dimensionalities therein. It will employ new appropriate metrics that will reveal the performance differences of RMs and will substantiate the problem across a wide variety of popular RMs, ranging from simple linear models to advanced, state-of-the-art, ensembles (which enjoy excellent generalization performance). It will put forth and study a new, query-centric, model that addresses this problem, improving per-query accuracy, while also offering excellent overall accuracy. Finally, it will study the effects of scale on the problem and its solutions. (C) 2021 Elsevier Ltd. All rights reserved.
Keywords:
Query-centric
Regression for DBMSs
Predictive analytics

Journal

Enterprise Information Systems cover
Enterprise Information Systems
IF:
3.9
Papers:
2.8K
Citations:
1.8K

Organization

U
University of Warwick
Scholars:
2.2W
Papers: 2.2W
Citations: 85
Cited Papers

Cited Papers

Bayesian Variable Selection in Linear Regression in One Pass for Large Datasets
err2014-08-25
err6
errOAAI
errOrdonez, Carlos; Garcia-Alvarado, Carlos; Baladandayuthapani, Veerabhadaran
errShare
errSave
A randomized comparison of the right- and left-sided approaches to ablation of the atrioventricular junction
err1993-12-01
err0
errOAAI
errSteven J. Kalbfleisch; Brian Williamson; K.Ching Man; Vicken Vorperian; John D. Hummel; Hugh Calkins; S.Adam Strickberger; Jonathan J. Langberg; Fred Morady
errShare
errSave
Synthesis, crystal structure and magnetic properties of μ4-oxo-centered tetranuclear lanthanide clusters
err2001-01-01
err0
PREAI
errAlex Wai-Hing Lam; Wing-Tak Wong; Gehui Wen; Xi-Xiang Zhang; Song Gao
errShare
errSave
Differential functional effects of novel mutations of the transcription factor FOXL2 in BPES patients
err2008-08-01
err0
errOAAI
errJeyabalan Nallathambi; Paul Laissue; Frank Batista; Bérénice A. Benayoun; Corinne Lesaffre; Lara Moumné; PJ Eswari Pandaranayaka; Kim Usha; Sankaran Krishnaswamy; Periasamy Sundaresan; Reiner A. Veitia
errShare
errSave
researcher View more