{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,5,19]],"date-time":"2026-05-19T07:14:33Z","timestamp":1779174873467,"version":"3.51.4"},"reference-count":23,"publisher":"Association for Computing Machinery (ACM)","issue":"1","license":[{"start":{"date-parts":[[2020,9,4]],"date-time":"2020-09-04T00:00:00Z","timestamp":1599177600000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.acm.org\/publications\/policies\/copyright_policy#Background"}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":["SIGMOD Rec."],"published-print":{"date-parts":[[2020,9,4]]},"abstract":"<jats:p>We explore the close relationship between the tensor-based computations performed during modern machine learning, and relational database computations. We consider how to make a very small set of changes to a modern RDBMS to make it suitable for distributed learning computations. Changes include adding better support for recursion, and optimization and execution of very large compute plans. We also show that there are key advantages to using an RDBMS as a machine learning platform. In particular, DBMSbased learning allows for trivial scaling to large data sets and especially large models, where different computational units operate on different parts of a model that may be too large to fit into RAM.<\/jats:p>","DOI":"10.1145\/3422648.3422659","type":"journal-article","created":{"date-parts":[[2020,9,4]],"date-time":"2020-09-04T10:09:28Z","timestamp":1599214168000},"page":"43-50","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":14,"title":["Declarative Recursive Computation on an RDBMS"],"prefix":"10.1145","volume":"49","author":[{"given":"Dimitrije","family":"Jankov","sequence":"first","affiliation":[{"name":"Rice University"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Shangyu","family":"Luo","sequence":"additional","affiliation":[{"name":"Rice University"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Binhang","family":"Yuan","sequence":"additional","affiliation":[{"name":"Rice University"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Zhuhua","family":"Cai","sequence":"additional","affiliation":[{"name":"Arizona State University"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Jia","family":"Zou","sequence":"additional","affiliation":[{"name":"Arizona State University"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Chris","family":"Jermaine","sequence":"additional","affiliation":[{"name":"Rice University"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Zekai J.","family":"Gao","sequence":"additional","affiliation":[{"name":"Rice University"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2020,9,4]]},"reference":[{"key":"e_1_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.1145\/237814.237823"},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.1145\/2463676.2465283"},{"key":"e_1_2_1_3_1","unstructured":"J. Chen X. Pan R. Monga S. Bengio and R. Jozefowicz. Revisiting distributed synchronous sgd. arXiv preprint arXiv:1604.00981 2016.  J. Chen X. Pan R. Monga S. Bengio and R. Jozefowicz. Revisiting distributed synchronous sgd. arXiv preprint arXiv:1604.00981 2016."},{"key":"e_1_2_1_4_1","unstructured":"T. Chen M. Li Y. Li M. Lin N. Wang M. Wang T. Xiao B. Xu C. Zhang and Z. Zhang. MXNet: A Flexible and Efficient Machine Learning Library for Heterogeneous Distributed Systems. arXiv preprint arXiv:1512.01274 2015.  T. Chen M. Li Y. Li M. Lin N. Wang M. Wang T. Xiao B. Xu C. Zhang and Z. Zhang. MXNet: A Flexible and Efficient Machine Learning Library for Heterogeneous Distributed Systems. arXiv preprint arXiv:1512.01274 2015."},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.5555\/3042817.3043086"},{"key":"e_1_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.5555\/3026877.3026899"},{"key":"e_1_2_1_7_1","unstructured":"M. A. et al. TensorFlow: Large-Scale Machine Learning on Heterogeneous Distributed Systems. arXiv preprint arXiv:1603.04467 2016.  M. A. et al. TensorFlow: Large-Scale Machine Learning on Heterogeneous Distributed Systems. arXiv preprint arXiv:1603.04467 2016."},{"key":"e_1_2_1_8_1","unstructured":"A. L. Gaunt M. A. Johnson M. Riechert D. Tarlow R. Tomioka D. Vytiniotis and S. Webster. AMPNet: Asynchronous Model-Parallel Training for Dynamic Neural Networks. arXiv preprint arXiv:1705.09786 2017.  A. L. Gaunt M. A. Johnson M. Riechert D. Tarlow R. Tomioka D. Vytiniotis and S. Webster. AMPNet: Asynchronous Model-Parallel Training for Dynamic Neural Networks. arXiv preprint arXiv:1705.09786 2017."},{"key":"e_1_2_1_9_1","unstructured":"P. Goyal P. Doll\u00e1r R. Girshick P. Noordhuis L. Wesolowski A. Kyrola A. Tulloch Y. Jia and K. He. Accurate large minibatch sgd: training imagenet in 1 hour. arXiv preprint arXiv:1706.02677 2017.  P. Goyal P. Doll\u00e1r R. Girshick P. Noordhuis L. Wesolowski A. Kyrola A. Tulloch Y. Jia and K. He. Accurate large minibatch sgd: training imagenet in 1 hour. arXiv preprint arXiv:1706.02677 2017."},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.1145\/3316781.3317903"},{"key":"e_1_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.5555\/70405.70408"},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1145\/276305.276315"},{"key":"e_1_2_1_13_1","unstructured":"A. Krizhevsky. One weird trick for parallelizing convolutional neural networks. arXiv preprint arXiv:1404.5997 2014.  A. Krizhevsky. One weird trick for parallelizing convolutional neural networks. arXiv preprint arXiv:1404.5997 2014."},{"key":"e_1_2_1_14_1","unstructured":"C.-G. Lee and Z. Ma. The generalized quadratic assignment problem. 01 2004.  C.-G. Lee and Z. Ma. The generalized quadratic assignment problem. 01 2004."},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.5555\/2685048.2685095"},{"key":"e_1_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.1145\/3277006.3277013"},{"key":"e_1_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.5555\/2986459.2986537"},{"key":"e_1_2_1_18_1","unstructured":"S. Ruder. An overview of gradient descent optimization algorithms. arXiv preprint arXiv:1609.04747 2016.  S. Ruder. An overview of gradient descent optimization algorithms. arXiv preprint arXiv:1609.04747 2016."},{"key":"e_1_2_1_19_1","unstructured":"N. Shazeer A. Mirhoseini K. Maziarz A. Davis Q. V. Le G. E. Hinton and J. Dean. Outrageously large neural networks: The sparsely-gated mixture-of-experts layer. CoRR abs\/1701.06538 2017.  N. Shazeer A. Mirhoseini K. Maziarz A. Davis Q. V. Le G. E. Hinton and J. Dean. Outrageously large neural networks: The sparsely-gated mixture-of-experts layer. CoRR abs\/1701.06538 2017."},{"key":"e_1_2_1_20_1","doi-asserted-by":"publisher","DOI":"10.14778\/1920841.1920931"},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.5555\/3295222.3295349"},{"key":"e_1_2_1_22_1","unstructured":"E. W. Weisstein. Einstein summation. 2014.  E. W. Weisstein. Einstein summation. 2014."},{"key":"e_1_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.1109\/TBDATA.2015.2472014"}],"container-title":["ACM SIGMOD Record"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3422648.3422659","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3422648.3422659","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,17]],"date-time":"2025-06-17T21:31:29Z","timestamp":1750195889000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3422648.3422659"}},"subtitle":["or, Why You Should Use a Database For Distributed Machine Learning"],"short-title":[],"issued":{"date-parts":[[2020,9,4]]},"references-count":23,"journal-issue":{"issue":"1","published-print":{"date-parts":[[2020,9,4]]}},"alternative-id":["10.1145\/3422648.3422659"],"URL":"https:\/\/doi.org\/10.1145\/3422648.3422659","relation":{},"ISSN":["0163-5808"],"issn-type":[{"value":"0163-5808","type":"print"}],"subject":[],"published":{"date-parts":[[2020,9,4]]},"assertion":[{"value":"2020-09-04","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}