{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,5,10]],"date-time":"2025-05-10T23:01:07Z","timestamp":1746918067662},"reference-count":11,"publisher":"Association for Computing Machinery (ACM)","issue":"12","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2017,8]]},"abstract":"<jats:p>Causal inference from observational data is a subject of active research and development in statistics and computer science. Many statistical software packages have been developed for this purpose. However, these toolkits do not scale to large datasets. We propose and demonstrate ZaliQL: a SQL-based framework for drawing causal inference from observational data. ZaliQL supports the state-of-the-art methods for causal inference and runs at scale within PostgreSQL database system. In addition, we built a visual interface to wrap around ZaliQL. In our demonstration, we will use this GUI to show a live investigation of the causal effect of different weather conditions on flight delays.<\/jats:p>","DOI":"10.14778\/3137765.3137818","type":"journal-article","created":{"date-parts":[[2017,9,7]],"date-time":"2017-09-07T13:35:53Z","timestamp":1504791353000},"page":"1957-1960","source":"Crossref","is-referenced-by-count":4,"title":["ZaliQL"],"prefix":"10.14778","volume":"10","author":[{"given":"Babak","family":"Salimi","sequence":"first","affiliation":[{"name":"University of Washington"}]},{"given":"Corey","family":"Cole","sequence":"additional","affiliation":[{"name":"University of Washington"}]},{"given":"Dan R. K.","family":"Ports","sequence":"additional","affiliation":[{"name":"University of Washington"}]},{"given":"Dan","family":"Suciu","sequence":"additional","affiliation":[{"name":"University of Washington"}]}],"member":"320","published-online":{"date-parts":[[2017,8]]},"reference":[{"key":"e_1_2_1_1_1","volume-title":"VLDB","author":"Fang M.","year":"1998","unstructured":"M. Fang , N. Shivakumar , H. Garcia-Molina , R. Motwani , and J. D. Ullman . Computing iceberg queries efficiently . In VLDB , 1998 . M. Fang, N. Shivakumar, H. Garcia-Molina, R. Motwani, and J. D. Ullman. Computing iceberg queries efficiently. In VLDB, 1998."},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.5555\/1293913.1293914"},{"key":"e_1_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1093\/pan\/mpl013"},{"key":"e_1_2_1_4_1","volume-title":"Causal inference without balance checking: Coarsened exact matching. Political analysis, page mpr013","author":"Iacus S. M.","year":"2011","unstructured":"S. M. Iacus , G. King , and G. Porro . Causal inference without balance checking: Coarsened exact matching. Political analysis, page mpr013 , 2011 . S. M. Iacus, G. King, and G. Porro. Causal inference without balance checking: Coarsened exact matching. Political analysis, page mpr013, 2011."},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.18637\/jss.v030.i09"},{"key":"e_1_2_1_6_1","volume-title":"PostGIS in action","author":"Obe R. O.","year":"2015","unstructured":"R. O. Obe and L. S. Hsu . PostGIS in action . Manning Publications Co. , 2015 . R. O. Obe and L. S. Hsu. PostGIS in action. Manning Publications Co., 2015."},{"key":"e_1_2_1_7_1","volume-title":"models, reasoning, and inference","author":"Pearl J.","year":"2000","unstructured":"J. Pearl . Causality : models, reasoning, and inference . Cambridge University Press , 2000 . J. Pearl. Causality: models, reasoning, and inference. Cambridge University Press, 2000."},{"key":"e_1_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.1080\/00031305.2014.876829"},{"key":"e_1_2_1_9_1","doi-asserted-by":"crossref","DOI":"10.1007\/978-1-4757-3692-2","volume-title":"Observational studies","author":"Rosenbaum P. R.","year":"2002","unstructured":"P. R. Rosenbaum . Observational studies . Springer , 2002 . P. R. Rosenbaum. Observational studies. Springer, 2002."},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.1093\/biomet\/70.1.41"},{"key":"e_1_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.1198\/016214504000001880"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3137765.3137818","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T10:11:26Z","timestamp":1672222286000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3137765.3137818"}},"subtitle":["causal inference from observational data at scale"],"short-title":[],"issued":{"date-parts":[[2017,8]]},"references-count":11,"journal-issue":{"issue":"12","published-print":{"date-parts":[[2017,8]]}},"alternative-id":["10.14778\/3137765.3137818"],"URL":"https:\/\/doi.org\/10.14778\/3137765.3137818","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2017,8]]}}}