Advanced SQL modeling in RDBMS

ACM Transactions on Database Systems

Volumn 30, Issue 1, 2005, Pages 83-121

  Witkowski, Andrew ^a   Bellamkonda, Srikanth ^a   Bozkaya, Tolga ^a   Folkert, Nathan ^a   Gupta, Abhinav ^a   Haydu, John ^a   Sheng, Lei ^a   Subramanian, Sankar ^a  

^a ORACLE CORPORATION   (United States)

Author keywords

Analytic computations; Excel; OLAP; Spreadsheet

Indexed keywords

ANALYTIC COMPUTATIONS; EXCEL; OLAP;

CALCULATIONS; COMPUTER OPERATING SYSTEMS; OPTIMIZATION; PARAMETER ESTIMATION; PROBLEM SOLVING; QUERY LANGUAGES; SPREADSHEETS;

RELATIONAL DATABASE SYSTEMS;

EID: 23944519449     PISSN: 03625915     EISSN: None     Source Type: Journal    
DOI: 10.1145/1061318.1061321     Document Type: Review

References (21)

1. BALMIN, A., PAPADIMITRIOU, T., AND PAPAKONSTANTINOU, Y. 2000. Hypothetical queries in an OLAP environment. In Proceedings of the 26th International Conference on Very Large Data Bases (Cairo, Egypt). 220-231.
2. BECKMANN, N., KRIEGEL, H. P., SCHNEIDER, R., AND SEEGER, B. 1990. The R*-tree: An efficient and robust access method for points and rectangles. In Proceedings of the ACM SIGMOD International Conference on Management of Data (Atlantic City, NJ). 322-331.
3. BELLO, R. G., ET AL. 1998. Materialized views in oracle. In Proceedings of the 24th International Conference on Very Large Data Bases (New York, NY). 659-664.
4. BLAKELEY, J. A., LARSON, P., AND TOMPA, F. W. 1986. Efficiently updating materialized views. In Proceedings of the ACM SIGMOD International Conference on Management of Data (Washington, DC). 61-71.
5. BLATTNER, P. 1999. Microsoft Excel Functions in Practice. Que Publishing, Indianapolis, IN.
6. GRAY, J., BOSWORTH, A., LAYMAN, A., AND PIRAHESH, H. 1996. Data cube: A relational operator generalizing group-by, cross tab and sub-totals. In Proceedings of the International Conference on Data Engineering (New Orleans, LA). 152-159.
7. GUPTA, A., MUMICK, I. S., AND SUBRAHMANIAN, V. S. 1993. Maintaining views incrementally. In Proceedings of the ACM SIGMOD International Conference on Management of Data (Washington, DC). 157-166.
8. GUTTMAN, A. 1984. R-trees: A dynamic index structure for spatial searching. In Proceedings of the ACM SIGMOD International Conference on Management of Data (Boston, MA). 47-57.
9. HOWSON, C. 2002. Business Objects: The Complete Reference. McGraw-Hill/Osborne, New York, NY.
10. LAKSHMANAN, L., PEI, J., AND ZHAO, Y. 2003. QC-trees. Efficient summary structure for semantic OLAP. In Proceedings of the ACM SIGMOD International Conference on Management of Data (San Diego, CA). 64-75.
11. LEVY, A. Y., MUMICK, I. S., AND SAGIV, Y. 1994. Query optimization by predicate move-around. In Proceedings of the 20th International Conference on Very Large Data Bases (Santiago, Chile). 96-107.
12. MUMICK, I. S., FINKELSTEIN, S., PIRAHESH, H., AND RAMAKRISHNAN, R. 1990. Magic is relevant. In Proceedings of the ACM SIGMOD International Conference on Management of Data (Atlantic City, NJ). 247-258.
13. Olap Application Developer's Guide. 2004. Oracle Database 10g Release 1 (10.1) Documentation. 2004. Oracle, Redwood Shores, CA.
14. PETERSON, T. AND PINKELMAN, J. 2000. Microsoft OLAP Unleashed. SAMS Publishing, Indianapolis, IN.
15. SIMON, J. 2000. Excel 2000 in a Nutshell. O'Reilly & Associates, Sebastopol, CA.
16. SISMANIS, Y., ROUSSOPOULOS, N., DELIGIANNAKIS, A., AND KOTIDIS Y. 2002. Dwarf: Shrinking the petacube. In Proceedings of the ACM SIGMOD International Conference on Management of Data (Madison, WI). 464-475.
17. SRIVASTAVA, D. AND RAMAKRISHNAN, R. 1992. Pushing constraint selections. In Proceedings of the Eleventh Symposium on Principles of Database Systems (PODS) (San Diego, CA). 301-315.
18. TARJAN, R. 1972. Depth-first search and linear graph algorithms. SIAM J. Comput. 1, 2, 146-160.
19. THOMSEN, E., SPOFFORD, G., CHASE, D. 1999. Microsoft OLAP Solutions. John Willey & Sons, New York, NY.
20. WITKOWSKI, A., BELLAMKONDA, B., BOZKAYA, T., DORMAN, G., FOLKERT, N., GUPTA, A., SHENG, L., AND SUBRAMANIAN, S. 2003. Spreadsheets in RDBMS for OLAP. In Proceedings of the ACM SIGMOD International Conference on Management of Data (San Diego, CA). 52-63.
21. ZEMKE, F., KULKARNI, K., WITKOWSKI, A., AND LYLE, B. 1999. Introduction to OLAP function. Change proposal. ANS-NCTS H2-99-14 (April).