Predictive Query Language: A Domain-Specific Language for Predictive Modeling on Relational Databases
Fuente:
arXiv
Enregistré dans:
| Auteurs principaux: | , , , , , , , |
|---|---|
| Format: | Preprint |
| Publié: |
2026
|
| Sujets: | |
| Accès en ligne: | |
| Tags: |
Ajouter un tag
Pas de tags, Soyez le premier à ajouter un tag!
|
| _version_ | 1866910022917685248 |
|---|---|
| author | Kocijan, Vid Sunil, Jinu Lenssen, Jan Eric Deb, Viman Xe, Xinwei Gomez, Federico Reyes Fey, Matthias Leskovec, Jure |
| author_facet | Kocijan, Vid Sunil, Jinu Lenssen, Jan Eric Deb, Viman Xe, Xinwei Gomez, Federico Reyes Fey, Matthias Leskovec, Jure |
| contents | The purpose of predictive modeling on relational data is to predict future or missing values in a relational database, for example, future purchases of a user, risk of readmission of the patient, or the likelihood that a financial transaction is fraudulent. Typically powered by machine learning methods, predictive models are used in recommendations, financial fraud detection, supply chain optimization, and other systems, providing billions of predictions every day. However, training a machine learning model requires manual work to extract the required training examples - prediction entities and target labels - from the database, which is slow, laborious, and prone to mistakes. Here, we present the Predictive Query Language (PQL), an SQL-inspired declarative language for defining predictive tasks on relational databases. PQL allows specifying a predictive task in a single declarative query, enabling the automatic computation of training labels for a large variety of machine learning tasks, such as regression, classification, time-series forecasting, and recommender systems. PQL is already successfully integrated and used in a collection of use cases as part of a predictive AI platform. The versatility of the language can be demonstrated through its many ongoing use cases, including financial fraud, item recommendations, and workload prediction. We demonstrate its versatile design through two implementations; one for small-scale, low-latency use and one that can handle large-scale databases. |
| format | Preprint |
| id |
arxiv_https___arxiv_org_abs_2602_09572 |
| institution | arXiv |
| publishDate | 2026 |
| record_format | arxiv |
| spellingShingle | Predictive Query Language: A Domain-Specific Language for Predictive Modeling on Relational Databases Kocijan, Vid Sunil, Jinu Lenssen, Jan Eric Deb, Viman Xe, Xinwei Gomez, Federico Reyes Fey, Matthias Leskovec, Jure Databases Artificial Intelligence Machine Learning The purpose of predictive modeling on relational data is to predict future or missing values in a relational database, for example, future purchases of a user, risk of readmission of the patient, or the likelihood that a financial transaction is fraudulent. Typically powered by machine learning methods, predictive models are used in recommendations, financial fraud detection, supply chain optimization, and other systems, providing billions of predictions every day. However, training a machine learning model requires manual work to extract the required training examples - prediction entities and target labels - from the database, which is slow, laborious, and prone to mistakes. Here, we present the Predictive Query Language (PQL), an SQL-inspired declarative language for defining predictive tasks on relational databases. PQL allows specifying a predictive task in a single declarative query, enabling the automatic computation of training labels for a large variety of machine learning tasks, such as regression, classification, time-series forecasting, and recommender systems. PQL is already successfully integrated and used in a collection of use cases as part of a predictive AI platform. The versatility of the language can be demonstrated through its many ongoing use cases, including financial fraud, item recommendations, and workload prediction. We demonstrate its versatile design through two implementations; one for small-scale, low-latency use and one that can handle large-scale databases. |
| title | Predictive Query Language: A Domain-Specific Language for Predictive Modeling on Relational Databases |
| topic | Databases Artificial Intelligence Machine Learning |
| url | https://arxiv.org/abs/2602.09572 |