Decision support queries on a tape-resident data warehouse

Information Systems

Volumn 30, Issue 2, 2005, Pages 133-149

  Chatziantoniou, Damianos ^a   Johnson, Theodore ^b  

^a ATHENS UNIVERSITY OF ECONOMICS AND BUSINESS   (Greece)

^b AT AND T LABS RESEARCH   (United States)

Author keywords

Data warehousing; Decision support; Query processing; Tape databases

Indexed keywords

ALGORITHMS; DATA ACQUISITION; DATA STORAGE EQUIPMENT; DATABASE SYSTEMS; DECISION SUPPORT SYSTEMS; INFORMATION ANALYSIS; QUERY LANGUAGES;

DECISION SUPPORT QUERIES; EXTENDED MULTI FEATURE QUERY LANGUAGE (EMF SQL); QUERY PROCESSING; TAPE DATABASES;

DATA WAREHOUSES;

EID: 5644288888     PISSN: 03064379     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.is.2003.11.003     Document Type: Article

References (31)

1. J. Myllymaki, M. Livny, Relational joins for data on tertiary storage, in: Proceedings of the International Conference on Data Engineering, 1997.
2. Gray J., Graefe G. The five-minute rule ten years later, and other computer storage rules of thumb. SIGMOD Record. 26(4):1997;63-68.
3. T. Johnson, E. Miller, Benchmarking tape system performance, in: Proceedings of the IEEE Conference on Mass Storage Systems/NASA Goddard Conference on Mass Storage Systems and Technologies, 1998.
4. D. Chatziantoniou, Ad hoc OLAP: expression and evaluation, in: IEEE International conference on Data Engineering, 1999, p. 250.
5. D. Chatziantoniou, Evaluation of ad hoc OLAP: in-place computation, in: ACM/IEEE International Conference on Scientific and Statistical Database Management, 1999.
6. D. Chatziantoniou, The PanQ Tool and EMF SQL for complex data management, in: ACM International Conference on Knowledge Discovery and Data Mining (SIGKDD), 1999.
7. M.S.S. Sarawagi, Reordering query execution in tertiary memory databases, in: Proceedings of the 22nd Very Large Database Conference, 1996.
8. Kimball R., Strehlo K. Why decision support fails and how to fix it. SIGMOD Record. 24(3):1995;92-97.
9. S. Chaudhuri, K. Shim, Including group-by in query optimization, in: VLDB Conference, 1994, pp. 354-366.
10. Y. Zhao, P. Deshpande, J. Naughton, A. Shukla, Simultaneous optimization and evaluation of multiple dimensional queries, in: ACM SIGMOD, Conference on Management of Data, 1998, pp. 271-282.
11. D. Chatziantoniou, K. Ross, Groupwise processing of relational queries, in: 23rd VLDB Conference, 1997.
12. 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.
13. D. Chatziantoniou, K. Ross, Querying multiple features of groups in relational databases, in: 22nd VLDB Conference, 1996, pp. 295-306.
14. 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.
15. S. Johnson, D. Chatziantoniou, Extended SQL for manipulating clinical warehouse data, Annual Symposium of American Medical Informatics Association, 1999.
16. Oracle. Analytic Functions for Oracle 8i. 1999. http://otn.oracle.com/ products/oracle8i/pdf/8ifunctions.pdf.
17. S. Bellamkonda, T. Borzkaya, B. Ghosh, A. Gupta, J. Haydu, S. Subramanian, A. Witkowski, Analytic functions in Oracle 8i. Available at: http://wwwdb.stanford.edu/dbseminar/Archive/SpringY2000/speakers/agupta/paper. pdf.
18. F. Zemke, K. Kulkarni, A. Witkowski, B. Lyle, Introduction to OLAP Functions, 1999. ISO/IEC JTC1/SC32 WG3: YGJ-068 = ANSI NCITS H2-99-154r2.
19. P. O'Neil, D. Quass, Improved query performance with variant indices, in: Proceedings of the ACM SIGMOD, 1997.
20. D. Schneider, The ins and outs (and everything inbetween) of data warehousing, in: Proceedings of the 23rd International Conference on Very Large Data Bases, 1997, pp. 1-32. (in Tutorials).
21. M. Carey, L. Haas, M. Livny, Tapes hold data too: challenges of tuples on tertiary storage, in: Proceedings of the ACM SIGMOD, 1993, pp. 413-418.
22. S. Sarawagi, Query processing in tertiary memory databases, in: Proceedings of the 21st Very Large Database Conference, 1995, pp. 585-596.
23. F. Carino, J. Burgess, StorHouse/relational manager (RM) - active storage hierarchy database system and applications, in: 17th IEEE Mass Storage Systems Symposium, 2000, pp. 179-186.
24. F. Carino, P. Kostamaa, A. Kaufmann, J. Burgess, StorHouse metanoia - new applications for database, storage and data warehousing, in: ACM SIGMOD, Conference on Management of Data, 2001, pp. 521-531.
25. M. Sullican, A. Heybey, Tribeca: a system for managing large databases of network traffic, Technical Report, Bellcore, 1996.
26. Graefe G. Query evaluation techniques for large databases. ACM Comput. Surveys. 25(2):1993;73-170.
27. W.P. Yan, P.-A. Larson, Eager aggregation and lazy aggregation, in: VLDB Conference, 1995, pp. 345-357.
28. P. Seshadri, M. Livny, R. Raghu, The design and implementation of a sequence database system, in: Proceedings of the 22nd VLDB Conference, 1996.
29. 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.
30. 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.
31. Babu S., Widom J. Continuous queries over data streams. Sigmod Record. 30(3):2001;109-120.