{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,5,7]],"date-time":"2026-05-07T16:32:46Z","timestamp":1778171566637,"version":"3.51.4"},"publisher-location":"New York, NY, USA","reference-count":39,"publisher":"ACM","license":[{"start":{"date-parts":[[2023,6,18]],"date-time":"2023-06-18T00:00:00Z","timestamp":1687046400000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.acm.org\/publications\/policies\/copyright_policy#Background"}],"funder":[{"DOI":"10.13039\/100004344","name":"Adobe Systems","doi-asserted-by":"publisher","id":[{"id":"10.13039\/100004344","id-type":"DOI","asserted-by":"publisher"}]},{"DOI":"10.13039\/100000001","name":"National Science Foundation","doi-asserted-by":"publisher","award":["1845638, 2008295, 2106197, 2103794"],"award-info":[{"award-number":["1845638, 2008295, 2106197, 2103794"]}],"id":[{"id":"10.13039\/100000001","id-type":"DOI","asserted-by":"publisher"}]},{"name":"Amazon"}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":[],"published-print":{"date-parts":[[2023,6,18]]},"DOI":"10.1145\/3597465.3605224","type":"proceedings-article","created":{"date-parts":[[2023,7,21]],"date-time":"2023-07-21T16:07:26Z","timestamp":1689955646000},"page":"1-7","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":2,"title":["Aggregation Consistency Errors in Semantic Layers and How to Avoid Them"],"prefix":"10.1145","author":[{"ORCID":"https:\/\/orcid.org\/0009-0002-6613-0337","authenticated-orcid":false,"given":"Zezhou","family":"Huang","sequence":"first","affiliation":[{"name":"Columbia University"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0009-0009-2825-0793","authenticated-orcid":false,"given":"Pavan Kalyan","family":"Damalapati","sequence":"additional","affiliation":[{"name":"Columbia University"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-4254-6688","authenticated-orcid":false,"given":"Eugene","family":"Wu","sequence":"additional","affiliation":[{"name":"DSI, Columbia University"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2023,7,21]]},"reference":[{"key":"e_1_3_2_1_1_1","unstructured":"2012. Joins cause incorrect values with aggregated measures. https:\/\/community.tableau.com\/s\/question\/0D54T00000C5aT5SAJ\/joins-cause-incorrect-values-with-aggregated-measures-can-i-specify-aggregation-before-i-calculate-a-sum."},{"key":"e_1_3_2_1_2_1","unstructured":"2014. Aggregate after join without duplicates. https:\/\/stackoverflow.com\/questions\/26799813\/aggregate-after-join-without-duplicates."},{"key":"e_1_3_2_1_3_1","unstructured":"2017. Merge two tables while summing values from subtable. https:\/\/community.powerbi.com\/t5\/Desktop\/Merge-two-tables-while-summing-values-from-subtable\/m-p\/201112."},{"key":"e_1_3_2_1_4_1","unstructured":"2020. Blend Your Data. https:\/\/help.tableau.com\/current\/pro\/desktop\/en-us\/multiple_connections.htm."},{"key":"e_1_3_2_1_5_1","unstructured":"2020. Looker data modeling. https:\/\/www.looker.com\/platform\/data-modeling\/."},{"key":"e_1_3_2_1_6_1","unstructured":"2020. Lookup Join. https:\/\/help.sigmacomputing.com\/hc\/en-us\/articles\/4408784908819-Lookup-Join."},{"key":"e_1_3_2_1_7_1","unstructured":"2020. Microstrategy Semantic Graph. https:\/\/www.microstrategy.com\/pt\/resources\/video\/what-is-a-semantic-graph."},{"key":"e_1_3_2_1_8_1","unstructured":"2020. Relationships: Data modeling in Tableau. https:\/\/www.tableau.com\/blog\/relationships-tableau-data-model."},{"key":"e_1_3_2_1_9_1","unstructured":"2020. The Tableau Data Model. https:\/\/help.tableau.com\/current\/online\/en-us\/datasource_datamodel.htm."},{"key":"e_1_3_2_1_10_1","unstructured":"2021. Kimball in the context of the modern data warehouse: what's worth keeping and what's not. https:\/\/www.youtube.com\/watch?v=3OcS2TMXELU."},{"key":"e_1_3_2_1_11_1","unstructured":"2021. Left join not operating correctly appears to be working as an inner join. https:\/\/community.looker.com\/lookml-5\/left-join-not-operating-correctly-appears-to-be-working-as-an-inner-join-18211."},{"key":"e_1_3_2_1_12_1","unstructured":"2022. Aggregate functions gone bad and the joins who made them that way. https:\/\/community.looker.com\/blog-archives-1027\/aggregate-functions-gone-bad-and-the-joins-who-made-them-that-way-29370?postid=54109#post54109."},{"key":"e_1_3_2_1_13_1","unstructured":"2022. Tackling the complexity of joining snapshots. https:\/\/docs.getdbt.com\/blog\/joining-snapshot-complexity."},{"key":"e_1_3_2_1_14_1","unstructured":"2023. BI solution architecture in the Center of Excellence. https:\/\/learn.microsoft.com\/en-us\/power-bi\/guidance\/center-of-excellence-business-intelligence-solution-architecture."},{"key":"e_1_3_2_1_15_1","unstructured":"2023. The dbt Semantic Layer. https:\/\/www.getdbt.com\/product\/semantic-layer\/."},{"key":"e_1_3_2_1_16_1","unstructured":"2023. Malloy. https:\/\/github.com\/malloydata\/malloy."},{"key":"e_1_3_2_1_17_1","unstructured":"Dr Saif Abed. 2020. Tweet. https:\/\/twitter.com\/Saif_Abed\/status\/1328488315771817988."},{"key":"e_1_3_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.1145\/2902251.2902280"},{"key":"e_1_3_2_1_19_1","unstructured":"Gleb B. Alex B. 2020. https:\/\/rubygarage.org\/blog\/database-denormalization-with-examples. https:\/\/rubygarage.org\/blog\/database-denormalization-with-examples."},{"key":"e_1_3_2_1_20_1","doi-asserted-by":"publisher","DOI":"10.1145\/2882903.2915210"},{"key":"e_1_3_2_1_21_1","unstructured":"Itzik Ben-Gan. 2019. T-SQL bugs pitfalls and best practices -- joins. https:\/\/sqlperformance.com\/2019\/06\/sql-performance\/t-sql-bugs-pitfalls-best-practices-joins."},{"key":"e_1_3_2_1_22_1","doi-asserted-by":"publisher","DOI":"10.1287\/mksc.2018.1104"},{"key":"e_1_3_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.datak.2012.04.002"},{"key":"e_1_3_2_1_24_1","unstructured":"Claire Carroll. 2020. Modeling marketing attribution. https:\/\/www.getdbt.com\/blog\/modeling-marketing-attribution\/."},{"key":"e_1_3_2_1_25_1","volume-title":"EDBT\/ICDT Workshops.","author":"Chatziantoniou Damianos","year":"2020","unstructured":"Damianos Chatziantoniou and Verena Kantere. 2020. Data Virtual Machines: Data-Driven Conceptual Modeling of Big Data Infrastructures.. In EDBT\/ICDT Workshops."},{"key":"e_1_3_2_1_26_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-540-74976-9_43"},{"key":"e_1_3_2_1_27_1","first-page":"42","article-title":"An overview of classification algorithms for imbalanced datasets","volume":"2","author":"Ganganwar Vaishali","year":"2012","unstructured":"Vaishali Ganganwar. 2012. An overview of classification algorithms for imbalanced datasets. International Journal of Emerging Technology and Advanced Engineering 2, 4 (2012), 42--47.","journal-title":"International Journal of Emerging Technology and Advanced Engineering"},{"key":"e_1_3_2_1_28_1","doi-asserted-by":"publisher","DOI":"10.1145\/1265530.1265535"},{"key":"e_1_3_2_1_29_1","doi-asserted-by":"publisher","DOI":"10.5555\/3225625.3225695"},{"key":"e_1_3_2_1_30_1","volume-title":"Aggregations over generalized hypertree decompositions. arXiv preprint arXiv:1508.07532","author":"Joglekar Manas","year":"2015","unstructured":"Manas Joglekar, Rohan Puttagunta, and Christopher R\u00e9. 2015. Aggregations over generalized hypertree decompositions. arXiv preprint arXiv:1508.07532 (2015)."},{"key":"e_1_3_2_1_31_1","volume-title":"The data warehouse toolkit: the complete guide to dimensional modeling","author":"Kimball Ralph","unstructured":"Ralph Kimball and Margy Ross. 2011. The data warehouse toolkit: the complete guide to dimensional modeling. John Wiley & Sons."},{"key":"e_1_3_2_1_32_1","volume-title":"Probabilistic graphical models: principles and techniques","author":"Koller Daphne","unstructured":"Daphne Koller and Nir Friedman. 2009. Probabilistic graphical models: principles and techniques. MIT press."},{"key":"e_1_3_2_1_33_1","unstructured":"lloyd tabb. 2022. Tweet. https:\/\/twitter.com\/lloydtabb\/status\/1557032026976313345."},{"key":"e_1_3_2_1_34_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.datak.2009.07.010"},{"key":"e_1_3_2_1_35_1","doi-asserted-by":"publisher","DOI":"10.14778\/3476249.3476299"},{"key":"e_1_3_2_1_36_1","doi-asserted-by":"publisher","DOI":"10.1145\/3183713.3183758"},{"key":"e_1_3_2_1_37_1","doi-asserted-by":"publisher","DOI":"10.1145\/2882903.2882939"},{"key":"e_1_3_2_1_38_1","doi-asserted-by":"publisher","DOI":"10.1145\/3448016.3457302"},{"key":"e_1_3_2_1_39_1","volume-title":"Controlling the Correctness of Aggregation Operations During Sessions of Interactive Analytic Queries. ACM Journal of Data and Information Quality","author":"Simon Eric","year":"2022","unstructured":"Eric Simon, Bernd Amann, Rutian Liu, and St\u00e9phane Gan\u00e7arski. 2022. Controlling the Correctness of Aggregation Operations During Sessions of Interactive Analytic Queries. ACM Journal of Data and Information Quality (2022)."}],"event":{"name":"SIGMOD\/PODS '23: International Conference on Management of Data","location":"Seattle WA USA","acronym":"SIGMOD\/PODS '23","sponsor":["SIGMOD ACM Special Interest Group on Management of Data"]},"container-title":["Proceedings of the Workshop on Human-In-the-Loop Data Analytics"],"original-title":[],"link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3597465.3605224","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3597465.3605224","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,17]],"date-time":"2025-06-17T17:48:45Z","timestamp":1750182525000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3597465.3605224"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2023,6,18]]},"references-count":39,"alternative-id":["10.1145\/3597465.3605224","10.1145\/3597465"],"URL":"https:\/\/doi.org\/10.1145\/3597465.3605224","relation":{},"subject":[],"published":{"date-parts":[[2023,6,18]]},"assertion":[{"value":"2023-07-21","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}