Affiliation:
1. RelationalAI, Inc., Berkeley, CA
2. University of Michigan, Ann Arbor, MI
3. University of Oxford, Oxford, UK
Abstract
Integrated solutions for analytics over relational databases are of great practical importance as they avoid the costly repeated loop data scientists have to deal with on a daily basis: select features from data residing in relational databases using feature extraction queries involving joins, projections, and aggregations; export the training dataset defined by such queries; convert this dataset into the format of an external learning tool; and train the desired model using this tool. These integrated solutions are also a fertile ground of theoretically fundamental and challenging problems at the intersection of relational and statistical data models.
This article introduces a unified framework for training and evaluating a class of statistical learning models over relational databases. This class includes ridge linear regression, polynomial regression, factorization machines, and principal component analysis. We show that, by synergizing key tools from database theory such as schema information, query structure, functional dependencies, recent advances in query evaluation algorithms, and from linear algebra such as tensor and matrix operations, one can formulate relational analytics problems and design efficient (query and data) structure-aware algorithms to solve them.
This theoretical development informed the design and implementation of the AC/DC system for structure-aware learning. We benchmark the performance of AC/DC against R, MADlib, libFM, and TensorFlow. For typical retail forecasting and advertisement planning applications, AC/DC can learn polynomial regression models and factorization machines with at least the same accuracy as its competitors and up to three orders of magnitude faster than its competitors whenever they do not run out of memory, exceed 24-hour timeout, or encounter internal design limitations.
Funder
European Union’s Horizon 2020 research and innovation programme
Publisher
Association for Computing Machinery (ACM)
Reference70 articles.
1. Research directions for principles of data management (dagstuhl perspectives workshop 16151);Abiteboul Serge;Dagstuhl Manifestos,2018
2. S. Abiteboul R. Hull and V. Vianu. 1995. Foundations of Databases. Addison-Wesley. 94019295 Retrieved from https://books.google.com/books?id=HN9QAAAAMAAJ. S. Abiteboul R. Hull and V. Vianu. 1995. Foundations of Databases. Addison-Wesley. 94019295 Retrieved from https://books.google.com/books?id=HN9QAAAAMAAJ.
3. AC/DC: In-database learning thunderstruck;Khamis Mahmoud Abo;Proceedings of the DEEM.,2018
4. In-Database Learning with Sparse Tensors
Cited by
19 articles.
订阅此论文施引文献
订阅此论文施引文献,注册后可以免费订阅5篇论文的施引文献,订阅后可以查看论文全部施引文献