Using grouping variables to express complex decision support queries

Data and Knowledge Engineering

Volumn 61, Issue 1, 2007, Pages 114-136

  Chatziantoniou, Damianos ^a  

^a ATHENS UNIVERSITY OF ECONOMICS AND BUSINESS   (Greece)

Author keywords

Decision support queries; OLAP; Query processing; Relational algebra; SQL

Indexed keywords

ALGORITHMS; DECISION SUPPORT SYSTEMS; ENTERPRISE RESOURCE PLANNING; LINGUISTICS; OPTIMIZATION; SOCIETIES AND INSTITUTIONS; STANDARDIZATION;

BIOINFORMATICS; DECISION SUPPORT QUERIES; QUERY PROCESSING; RELATIONAL ALGEBRA;

QUERY LANGUAGES;

EID: 33847112494     PISSN: 0169023X     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.datak.2006.05.001     Document Type: Article

References (45)

1. 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-521.
2. R. Agrawal, A. Gupta, S. Sarawagi, Modeling multidimensional databases, in: IEEE International Conference on Data Engineering, 1997.
3. M. Akinde, Complex and Distributed On-line Analytical Processing. PhD thesis, Department of Computer Science, Aalborg University, 2004.
4. M. Akinde, M. Bohlen, Generalized MD-Joins: Evaluation and reduction to SQL, in: Databases in Telecommunications, 2001, pp. 52-67.
5. 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-353.
6. Akinde M., Bohlen M., Lakshmanan J.T.L., and Srivastava D. Efficient OLAP query processing in distributed data warehouses. Information Systems 28 1-2 (2003) 111-135
7. ANSI SQL Standards Committee. SQL AMENDMENT 1: On Line Analytical Processing (SQL/OLAP), Supplement to ISO/IEC 9075:1999. American National Standards Institute, 2001.
8. 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-16.
9. Babu S., and Widom J. Continuous queries over data streams. SIGMOD Record 30 3 (2001) 109-120
10. D. Chatziantoniou, Ad hoc OLAP: expression and evaluation, in: IEEE International Conference on Data Engineering (ICDE), 1999, p. 250.
11. 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-43.
12. D. Chatziantoniou, The PanQ tool and EMF SQL for complex data management, in: ACM International Conference on Knowledge Discovery and Data Mining (SIGKDD), 1999.
13. 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-533.
14. D. Chatziantoniou, A. Anagnostopoulos, Hierarchical stream aggregates: querying nested stream sessions, in: International Conference on Scientific and Statistical Database Management (SSDBM), 2004, pp. 439-441.
15. Chatziantoniou D., and Anagnostopoulos A. NESTREAM: querying nested streams. SIGMOD Record 33 3 (2004) 71-78
16. Chatziantoniou D., and Johnson T. Decision support queries on a tape-resident data warehouse. Information Systems 30 2 (2005) 133-149
17. D. Chatziantoniou, K. Ross, Querying multiple features of groups in relational databases, in: 22nd International Conference on Very Large Databases (VLDB), 1996, pp. 295-306.
18. D. Chatziantoniou, K. Ross, Partitioned optimization of complex queries, Information Systems, accepted for publication.
19. 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-622.
20. S. Chaudhuri, K. Shim, Optimizing queries with aggregate views, in: Extending Database Technology, 1996, pp. 167-182.
21. Elmasri R., and Navathe S. Fundamentals of Database Systems (2000), Addison-Wesley Publishing
22. C. Galindo-Legaria, M. Joshi, Orthogonal optimization of subqueries and aggregation, in: ACM SIGMOD, Conference on Management of Data, 2001, pp. 571-581.
23. F. Gingras, L. Lakshmanan, nD-SQL: a multi-dimensional language for interoperability and OLAP, in: VLDB Conference, 1998, pp. 134-145.
24. 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-208.
25. 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-159.
26. A. Gupta, V. Harinarayan, D. Quass, Aggregate-query processing in data warehousing environments, in: VLDB Conference, 1995, pp. 358-369.
27. S. Johnson, D. Chatziantoniou, Extended SQL for manipulating clinical warehouse data, in: Annual Symposium of American Medical Informatics Association, 1999.
28. T. Johnson, D. Chatziantoniou. Extending complex ad hoc OLAP, in: ACM Conference on Information and Knowledge Management (CIKM), 1999.
29. Johnson T., and Chatziantoniou D. Joining very large data sets. Databases in Telecommunications 1999 (VLDB co-located). Lecture Notes in Computer Science vol. 1819 (2000), Springer
30. Kimball R., and Strehlo K. Why decision support fails and how to fix it. SIGMOD Record 24 3 (1995) 92-97
31. N. Koudas, D. Srivastava, Data stream query processing: a tutorial, in: 29th International Conference on Very Large Databases (VLDB), 2003, p. 1149.
32. 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-88.
33. 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-435.
34. Oracle. Analytic Functions for Oracle 8i. Oracle Corporation, 1999. Available from: .
35. M. Rafiq, M. O'Connor, A. Das, Computational Method for Temporal Pattern Discovery in Biomedical Genomic Databases, in: IEEE Computational Systems Bioinformatics Conference (CSB2005), (2005).
36. C. Red Brick Systems, Los Gatos. RISQL Reference Guide, Red Brick Warehouse VPT Version 3, 1994.
37. K. Ross, D. Srivastava, Fast computation of sparse datacubes, in: 23nd VLDB Conference, 1996, pp. 116-125.
38. K. Ross, D. Srivastava, D. Chatziantoniou, Complex aggregation at multiple granularities, in: Extending Database Technology (EDBT), Valencia, 1998, pp. 263-277.
39. 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-354.
40. 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-350.
41. 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-330.
42. 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-20.
43. H. Wang, C. Zaniolo, User defined aggregates in object-relational systems, in: International Conference on Data Engineering (ICDE), 2000, pp. 135-144.
44. 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-63.
45. W.P. Yan, P.-A. Larson, Eager aggregation and lazy aggregation, in: VLDB Conference, 1995, pp. 345-357.