{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,3,30]],"date-time":"2026-03-30T13:38:42Z","timestamp":1774877922758,"version":"3.50.1"},"reference-count":45,"publisher":"Elsevier BV","issue":"1","license":[{"start":{"date-parts":[[2007,4,1]],"date-time":"2007-04-01T00:00:00Z","timestamp":1175385600000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.elsevier.com\/tdm\/userlicense\/1.0\/"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Data &amp; Knowledge Engineering"],"published-print":{"date-parts":[[2007,4]]},"DOI":"10.1016\/j.datak.2006.05.001","type":"journal-article","created":{"date-parts":[[2006,6,16]],"date-time":"2006-06-16T12:06:08Z","timestamp":1150459568000},"page":"114-136","source":"Crossref","is-referenced-by-count":10,"title":["Using grouping variables to express complex decision support queries"],"prefix":"10.1016","volume":"61","author":[{"given":"Damianos","family":"Chatziantoniou","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"78","reference":[{"key":"10.1016\/j.datak.2006.05.001_bib1","unstructured":"S. Agarwal, R. Agrawal, P. Deshpande, A. Gupta, J.F. Naughton, R. Ramakrishnan, S. Sarawagi, On the computation of multidimensional aggregates, in: 22nd VLDB Conferenceit, 1996, pp. 505\u2013521."},{"key":"10.1016\/j.datak.2006.05.001_bib2","unstructured":"R. Agrawal, A. Gupta, S. Sarawagi, Modeling multidimensional databases, in: IEEE International Conference on Data Engineering, 1997."},{"key":"10.1016\/j.datak.2006.05.001_bib3","unstructured":"M. Akinde, Complex and Distributed On-line Analytical Processing. PhD thesis, Department of Computer Science, Aalborg University, 2004."},{"key":"10.1016\/j.datak.2006.05.001_bib4","doi-asserted-by":"crossref","unstructured":"M. Akinde, M. Bohlen, Generalized MD-Joins: Evaluation and reduction to SQL, in: Databases in Telecommunications, 2001, pp. 52\u201367.","DOI":"10.1007\/3-540-45432-2_5"},{"key":"10.1016\/j.datak.2006.05.001_bib5","doi-asserted-by":"crossref","unstructured":"M. Akinde, M. Bohlen, J.T., L. Lakshmanan, D. Srivastava, Efficient OLAP query processing in distributed data warehouses, in: International Conference on Extending Database Technology, 2002, pp. 336\u2013353.","DOI":"10.1007\/3-540-45876-X_23"},{"issue":"1\u20132","key":"10.1016\/j.datak.2006.05.001_bib6","doi-asserted-by":"crossref","first-page":"111","DOI":"10.1016\/S0306-4379(02)00051-0","article-title":"Efficient OLAP query processing in distributed data warehouses","volume":"28","author":"Akinde","year":"2003","journal-title":"Information Systems"},{"key":"10.1016\/j.datak.2006.05.001_bib7","unstructured":"ANSI SQL Standards Committee. SQL AMENDMENT 1: On Line Analytical Processing (SQL\/OLAP), Supplement to ISO\/IEC 9075:1999. American National Standards Institute, 2001."},{"key":"10.1016\/j.datak.2006.05.001_bib8","doi-asserted-by":"crossref","unstructured":"B. Babcock, S. Babu, M. Datar, R. Motwani, J. Widom, Models and issues in data stream systems, in: Symposium on Principles of Database Systems (PODS), 2002, pp. 1\u201316.","DOI":"10.1145\/543613.543615"},{"issue":"3","key":"10.1016\/j.datak.2006.05.001_bib9","doi-asserted-by":"crossref","first-page":"109","DOI":"10.1145\/603867.603884","article-title":"Continuous queries over data streams","volume":"30","author":"Babu","year":"2001","journal-title":"SIGMOD Record"},{"key":"10.1016\/j.datak.2006.05.001_bib10","doi-asserted-by":"crossref","unstructured":"D. Chatziantoniou, Ad hoc OLAP: expression and evaluation, in: IEEE International Conference on Data Engineering (ICDE), 1999, p. 250.","DOI":"10.1109\/ICDE.1999.754930"},{"key":"10.1016\/j.datak.2006.05.001_bib11","doi-asserted-by":"crossref","unstructured":"D. Chatziantoniou, Evaluation of ad hoc OLAP: in-place computation, in: ACM\/IEEE International Conference on Scientific and Statistical Database Management (SSDBM), 1999, pp. 34\u201343.","DOI":"10.1109\/SSDM.1999.787619"},{"key":"10.1016\/j.datak.2006.05.001_bib12","doi-asserted-by":"crossref","unstructured":"D. Chatziantoniou, The PanQ tool and EMF SQL for complex data management, in: ACM International Conference on Knowledge Discovery and Data Mining (SIGKDD), 1999.","DOI":"10.1145\/312129.312308"},{"key":"10.1016\/j.datak.2006.05.001_bib13","doi-asserted-by":"crossref","unstructured":"D. Chatziantoniou, M. Akinde, T. Johnson, S. Kim, The MD-join: an operator for complex OLAP, in: IEEE International Conference on Data Engineering, 2001, pp. 524\u2013533.","DOI":"10.1109\/ICDE.2001.914866"},{"key":"10.1016\/j.datak.2006.05.001_bib14","doi-asserted-by":"crossref","unstructured":"D. Chatziantoniou, A. Anagnostopoulos, Hierarchical stream aggregates: querying nested stream sessions, in: International Conference on Scientific and Statistical Database Management (SSDBM), 2004, pp. 439\u2013441.","DOI":"10.1109\/SSDM.2004.1311249"},{"issue":"3","key":"10.1016\/j.datak.2006.05.001_bib15","doi-asserted-by":"crossref","first-page":"71","DOI":"10.1145\/1031570.1031586","article-title":"NESTREAM: querying nested streams","volume":"33","author":"Chatziantoniou","year":"2004","journal-title":"SIGMOD Record"},{"issue":"2","key":"10.1016\/j.datak.2006.05.001_bib16","doi-asserted-by":"crossref","first-page":"133","DOI":"10.1016\/j.is.2003.11.003","article-title":"Decision support queries on a tape-resident data warehouse","volume":"30","author":"Chatziantoniou","year":"2005","journal-title":"Information Systems"},{"key":"10.1016\/j.datak.2006.05.001_bib17","unstructured":"D. Chatziantoniou, K. Ross, Querying multiple features of groups in relational databases, in: 22nd International Conference on Very Large Databases (VLDB), 1996, pp. 295\u2013306."},{"key":"10.1016\/j.datak.2006.05.001_bib18","unstructured":"D. Chatziantoniou, K. Ross, Partitioned optimization of complex queries, Information Systems, accepted for publication."},{"key":"10.1016\/j.datak.2006.05.001_bib19","doi-asserted-by":"crossref","unstructured":"S. Chaudhuri, R. Kaushik, J. Naughton, On relational support for XML publishing: beyond sorting and tagging, in: ACM SIGMOD, Conference on Management of Data, 2003, pp. 611\u2013622.","DOI":"10.1145\/872830.872831"},{"key":"10.1016\/j.datak.2006.05.001_bib20","doi-asserted-by":"crossref","unstructured":"S. Chaudhuri, K. Shim, Optimizing queries with aggregate views, in: Extending Database Technology, 1996, pp. 167\u2013182.","DOI":"10.1007\/BFb0014151"},{"key":"10.1016\/j.datak.2006.05.001_bib21","series-title":"Fundamentals of Database Systems","author":"Elmasri","year":"2000"},{"key":"10.1016\/j.datak.2006.05.001_bib22","doi-asserted-by":"crossref","unstructured":"C. Galindo-Legaria, M. Joshi, Orthogonal optimization of subqueries and aggregation, in: ACM SIGMOD, Conference on Management of Data, 2001, pp. 571\u2013581.","DOI":"10.1145\/376284.375748"},{"key":"10.1016\/j.datak.2006.05.001_bib23","unstructured":"F. Gingras, L. Lakshmanan, nD-SQL: a multi-dimensional language for interoperability and OLAP, in: VLDB Conference, 1998, pp. 134\u2013145."},{"key":"10.1016\/j.datak.2006.05.001_bib24","unstructured":"G. Graefe, U. Fayyad, S. Chaudhuri, On the efficient gathering of sufficient statistics for classification from large SQL databases, in: International Conference on Knowledge Discovery and Data Mining, 1998, pp. 204\u2013208."},{"key":"10.1016\/j.datak.2006.05.001_bib25","doi-asserted-by":"crossref","unstructured":"J. Gray, A. Bosworth, A. Layman, H. Pirahesh, Datacube: a relational aggregation operator generalizing group-by, cross-tab, and sub-totals, in: IEEE International Conference on Data Engineering, 1996, pp. 152\u2013159.","DOI":"10.1109\/ICDE.1996.492099"},{"key":"10.1016\/j.datak.2006.05.001_bib26","unstructured":"A. Gupta, V. Harinarayan, D. Quass, Aggregate-query processing in data warehousing environments, in: VLDB Conference, 1995, pp. 358\u2013369."},{"key":"10.1016\/j.datak.2006.05.001_bib27","unstructured":"S. Johnson, D. Chatziantoniou, Extended SQL for manipulating clinical warehouse data, in: Annual Symposium of American Medical Informatics Association, 1999."},{"key":"10.1016\/j.datak.2006.05.001_bib28","doi-asserted-by":"crossref","unstructured":"T. Johnson, D. Chatziantoniou. Extending complex ad hoc OLAP, in: ACM Conference on Information and Knowledge Management (CIKM), 1999.","DOI":"10.1145\/319950.319975"},{"key":"10.1016\/j.datak.2006.05.001_bib29","series-title":"Databases in Telecommunications 1999 (VLDB co-located)","article-title":"Joining very large data sets","volume":"vol. 1819","author":"Johnson","year":"2000"},{"issue":"3","key":"10.1016\/j.datak.2006.05.001_bib30","doi-asserted-by":"crossref","first-page":"92","DOI":"10.1145\/211990.212023","article-title":"Why decision support fails and how to fix it","volume":"24","author":"Kimball","year":"1995","journal-title":"SIGMOD Record"},{"key":"10.1016\/j.datak.2006.05.001_bib31","doi-asserted-by":"crossref","unstructured":"N. Koudas, D. Srivastava, Data stream query processing: a tutorial, in: 29th International Conference on Very Large Databases (VLDB), 2003, p. 1149.","DOI":"10.1016\/B978-012722442-8\/50128-2"},{"key":"10.1016\/j.datak.2006.05.001_bib32","doi-asserted-by":"crossref","unstructured":"C. Li, S.W. Wang, A data model for supporting on-line analytical processing, in: International Conference on Information and Knowledge Management, 1996, pp. 81\u201388.","DOI":"10.1145\/238355.238444"},{"key":"10.1016\/j.datak.2006.05.001_bib33","doi-asserted-by":"crossref","unstructured":"G. Manku, S. Rajagopalan, B. Lindsay, Approximate medians and other quantiles in one pass and with limited memory, in: ACM SIGMOD, Conference on Management of Data, 1998, pp. 426\u2013435.","DOI":"10.1145\/276305.276342"},{"key":"10.1016\/j.datak.2006.05.001_bib34","unstructured":"Oracle. Analytic Functions for Oracle 8i. Oracle Corporation, 1999. Available from: <http:\/\/otn.oracle.com\/products\/oracle8i\/pdf\/8ifunctions.pdf>."},{"key":"10.1016\/j.datak.2006.05.001_bib35","doi-asserted-by":"crossref","unstructured":"M. Rafiq, M. O\u2019Connor, A. Das, Computational Method for Temporal Pattern Discovery in Biomedical Genomic Databases, in: IEEE Computational Systems Bioinformatics Conference (CSB2005), (2005).","DOI":"10.1109\/CSB.2005.25"},{"key":"10.1016\/j.datak.2006.05.001_bib36","unstructured":"C. Red Brick Systems, Los Gatos. RISQL Reference Guide, Red Brick Warehouse VPT Version 3, 1994."},{"key":"10.1016\/j.datak.2006.05.001_bib37","unstructured":"K. Ross, D. Srivastava, Fast computation of sparse datacubes, in: 23nd VLDB Conference, 1996, pp. 116\u2013125."},{"key":"10.1016\/j.datak.2006.05.001_bib38","doi-asserted-by":"crossref","unstructured":"K. Ross, D. Srivastava, D. Chatziantoniou, Complex aggregation at multiple granularities, in: Extending Database Technology (EDBT), Valencia, 1998, pp. 263\u2013277.","DOI":"10.1007\/BFb0100990"},{"key":"10.1016\/j.datak.2006.05.001_bib39","doi-asserted-by":"crossref","unstructured":"S. Sarawagi, S. Thomas, R. Agrawal. Integrating mining with relational database systems: alternatives and implications, in: ACM SIGMOD, Conference on Management of Data, 1998, pp. 343\u2013354.","DOI":"10.1145\/276305.276335"},{"key":"10.1016\/j.datak.2006.05.001_bib40","doi-asserted-by":"crossref","unstructured":"H. Steenhagen, P. Apers, H. Blanken, Optimization of nested queries in a complex object model, in: International Conference on Extending Database Technology (EDBT), Cambridge, 1994, pp. 337\u2013350.","DOI":"10.1007\/3-540-57818-8_62"},{"key":"10.1016\/j.datak.2006.05.001_bib41","doi-asserted-by":"crossref","unstructured":"D. Terry, D. Goldberg, D. Nichols, B. Oki, Continuous queries over append only databases, in: ACM SIGMOD, Conference on Management of Data, 1992, pp. 321\u2013330.","DOI":"10.1145\/141484.130333"},{"key":"10.1016\/j.datak.2006.05.001_bib42","unstructured":"H. Wang, C. Zaniolo, Database system extensions for decision support: the AXL approach, in: ACM SIGMOD Workshop on Research Issues in Data Mining and Knowledge Discovery, 2000, pp. 11\u201320."},{"key":"10.1016\/j.datak.2006.05.001_bib43","doi-asserted-by":"crossref","unstructured":"H. Wang, C. Zaniolo, User defined aggregates in object-relational systems, in: International Conference on Data Engineering (ICDE), 2000, pp. 135\u2013144.","DOI":"10.1109\/ICDE.2000.839400"},{"key":"10.1016\/j.datak.2006.05.001_bib44","doi-asserted-by":"crossref","unstructured":"A. Witkowski, S. Bellamkonda, T. Bozkaya, G. Dorman, N. Folkert, A. Gupta, L. Sheng, S. Subramanian, Spreadsheets in RDBMS for OLAP, in: ACM SIGMOD, Conference on Management of Data, 2003, pp. 52\u201363.","DOI":"10.1145\/872766.872767"},{"key":"10.1016\/j.datak.2006.05.001_bib45","unstructured":"W.P. Yan, P.-A. Larson, Eager aggregation and lazy aggregation, in: VLDB Conference, 1995, pp. 345\u2013357."}],"container-title":["Data &amp; Knowledge Engineering"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:S0169023X06000863?httpAccept=text\/xml","content-type":"text\/xml","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:S0169023X06000863?httpAccept=text\/plain","content-type":"text\/plain","content-version":"vor","intended-application":"text-mining"}],"deposited":{"date-parts":[[2025,1,9]],"date-time":"2025-01-09T11:41:39Z","timestamp":1736422899000},"score":1,"resource":{"primary":{"URL":"https:\/\/linkinghub.elsevier.com\/retrieve\/pii\/S0169023X06000863"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2007,4]]},"references-count":45,"journal-issue":{"issue":"1","published-print":{"date-parts":[[2007,4]]}},"alternative-id":["S0169023X06000863"],"URL":"https:\/\/doi.org\/10.1016\/j.datak.2006.05.001","relation":{},"ISSN":["0169-023X"],"issn-type":[{"value":"0169-023X","type":"print"}],"subject":[],"published":{"date-parts":[[2007,4]]}}}