{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,1,23]],"date-time":"2026-01-23T00:10:19Z","timestamp":1769127019072,"version":"3.49.0"},"publisher-location":"New York, NY, USA","reference-count":22,"publisher":"ACM","license":[{"start":{"date-parts":[[2024,6,9]],"date-time":"2024-06-09T00:00:00Z","timestamp":1717891200000},"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":[],"published-print":{"date-parts":[[2024,6,9]]},"DOI":"10.1145\/3626246.3653374","type":"proceedings-article","created":{"date-parts":[[2024,5,23]],"date-time":"2024-05-23T10:26:39Z","timestamp":1716459999000},"page":"31-40","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":2,"title":["Measures in SQL"],"prefix":"10.1145","author":[{"ORCID":"https:\/\/orcid.org\/0009-0003-7857-7467","authenticated-orcid":false,"given":"Julian","family":"Hyde","sequence":"first","affiliation":[{"name":"Google Inc., San Francisco, CA, USA"}]},{"ORCID":"https:\/\/orcid.org\/0009-0002-6591-6370","authenticated-orcid":false,"given":"John","family":"Fremlin","sequence":"additional","affiliation":[{"name":"Google Inc., New York, NY, USA"}]}],"member":"320","published-online":{"date-parts":[[2024,6,9]]},"reference":[{"key":"e_1_3_2_1_1_1","volume-title":"Mondrian in Action: Open source business analytics","author":"Back William D","unstructured":"William D Back, Nicholas Goodman, and Julian Hyde. 2013. Mondrian in Action: Open source business analytics. Manning Publications Company."},{"key":"e_1_3_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.1145\/3183713.3190662"},{"key":"e_1_3_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1145\/362384.362685"},{"key":"e_1_3_2_1_4_1","volume-title":"Beyond decision support. Computerworld","author":"Codd Edgar F","year":"1993","unstructured":"Edgar F Codd. 1993. Beyond decision support. Computerworld (1993)."},{"key":"e_1_3_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1145\/234889.234901"},{"key":"e_1_3_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.1145\/3025171.3025227"},{"key":"e_1_3_2_1_7_1","volume-title":"Looker Open SQL interface. https:\/\/cloud.google.com\/looker\/docs\/sql-interface. [Online","year":"2024","unstructured":"Google. 2023. Looker Open SQL interface. https:\/\/cloud.google.com\/looker\/docs\/sql-interface. [Online; accessed 01-Apr-2024]."},{"key":"e_1_3_2_1_8_1","volume-title":"https:\/\/cloud.google.com\/looker. [Online","year":"2024","unstructured":"Google. 2024. Looker. https:\/\/cloud.google.com\/looker. [Online; accessed 12-Apr-2024]."},{"key":"e_1_3_2_1_9_1","volume-title":"Data cube: A relational aggregation operator generalizing group-by, cross-tab, and sub-totals. Data mining and knowledge discovery 1","author":"Gray Jim","year":"1997","unstructured":"Jim Gray, Surajit Chaudhuri, Adam Bosworth, Andrew Layman, Don Reichart, Murali Venkatrao, Frank Pellow, and Hamid Pirahesh. 1997. Data cube: A relational aggregation operator generalizing group-by, cross-tab, and sub-totals. Data mining and knowledge discovery 1 (1997), 29--53."},{"key":"e_1_3_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.1145\/1031763.1031779"},{"key":"e_1_3_2_1_11_1","unstructured":"Julian Hyde. 2021. WITHIN DISTINCT clause for aggregate functions. Feature request CALCITE-4483. Apache Calcite. https:\/\/issues.apache.org\/jira\/browse\/CALCITE-4483"},{"key":"e_1_3_2_1_12_1","unstructured":"Julian Hyde. 2022. Custom time frames. Feature request CALCITE-5155. Apache Calcite. https:\/\/issues.apache.org\/jira\/browse\/CALCITE-5155"},{"key":"e_1_3_2_1_13_1","unstructured":"JSR-69 2003. Java? OLAP Interface (JOLAP) final draft. Technical Report. JSR-69 Expert Group. https:\/\/jcp.org\/aboutJava\/communityprocess\/first\/jsr069\/index.html"},{"key":"e_1_3_2_1_14_1","volume-title":"The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling","author":"Kimball Ralph","unstructured":"Ralph Kimball and Margy Ross. 2002. The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (2nd ed.). John Wiley & Sons, Inc., USA.","edition":"2"},{"key":"e_1_3_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.3233\/IDA-163161"},{"key":"e_1_3_2_1_16_1","unstructured":"MDAPI-2.0 1998. MDAPI the OLAP Application Program Interface Version 2.0. Technical Report. The OLAP Council."},{"key":"e_1_3_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.1145\/1287620.1287623"},{"key":"e_1_3_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-540-74553-2_10"},{"key":"e_1_3_2_1_19_1","unstructured":"Mark Whitehorn Robert Zare and Mosha Pasumansky. 2004. Fast Track to MDX. https:\/\/api.semanticscholar.org\/CorpusID:61077971"},{"key":"e_1_3_2_1_20_1","volume-title":"Introduction to OLAP functions. Change proposal. ANS-NCTS H2--99--14 (April)","author":"Zemke Fred","year":"1999","unstructured":"Fred Zemke, Krishna Kulkarni, Andy Witkowski, and Bob Lyle. 1999. Introduction to OLAP functions. Change proposal. ANS-NCTS H2--99--14 (April) (1999)."},{"key":"e_1_3_2_1_21_1","unstructured":"Fred Zemke Andrew Witkowski Mitch Cherniak and Latha Colby. 2007. Pattern matching in sequences of rows. Change proposal for ISO 9075--1. ANSI INCITS."},{"key":"e_1_3_2_1_22_1","doi-asserted-by":"publisher","DOI":"10.1145\/872757.872840"}],"event":{"name":"SIGMOD\/PODS '24: International Conference on Management of Data","location":"Santiago AA Chile","acronym":"SIGMOD\/PODS '24","sponsor":["SIGMOD ACM Special Interest Group on Management of Data"]},"container-title":["Companion of the 2024 International Conference on Management of Data"],"original-title":[],"link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3626246.3653374","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3626246.3653374","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,8,22]],"date-time":"2025-08-22T11:29:42Z","timestamp":1755862182000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3626246.3653374"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2024,6,9]]},"references-count":22,"alternative-id":["10.1145\/3626246.3653374","10.1145\/3626246"],"URL":"https:\/\/doi.org\/10.1145\/3626246.3653374","relation":{},"subject":[],"published":{"date-parts":[[2024,6,9]]},"assertion":[{"value":"2024-06-09","order":3,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}