An Overview of Data Warehousing and OLAP Technology

SIGMOD Record (ACM Special Interest Group on Management of Data)

Volumn 26, Issue 1, 1997, Pages 65-74

  Chaudhuri, Surajit ^b   Dayal, Umeshwar ^a  

^a HEWLETT PACKARD LABORATORIES   (United States)

^b NONE

Author keywords

[No Author keywords available]

Indexed keywords

EID: 0344811122     PISSN: 01635808     EISSN: None     Source Type: Journal    
DOI: 10.1145/248603.248616     Document Type: Article

References (34)

1. Inmon, W.H., Building the Data Warehouse. John Wiley, 1992.
2. http://www.olapcouncil.org
3. Codd, E.F., S.B. Codd, C.T. Salley, "Providing OLAP (On-Line Analytical Processing) to User Analyst: An IT Mandate." Available from Arbor Software's web site http://www.arborsoft.com/OLAP.html.
4. http://pwp.starnetinc.com/larryg/articles.html
5. Kimball, R. The Data Warehouse Toolkit. John Wiley, 1996.
6. Barclay, T., R. Barnes, J. Gray, P. Sundaresan, "Loading Databases using Dataflow Parallelism." SIGMOD Record, Vol. 23, No. 4, Dec. 1994.
7. Blakeley, J.A., N. Coburn, P. Larson. "Updating Derived Relations: Detecting Irrelevant and Autonomously Computable Updates." ACM TODS, Vol.4, No. 3, 1989.
8. Gupta, A., I.S. Mumick, "Maintenance of Materialized Views: Problems, Techniques, and Applications." Data Eng. Bulletin, Vol. 18, No. 2, June 1995.
9. Zhuge, Y., H. Garcia-Molina, J. Hammer, J. Widom, "View Maintenance in a Warehousing Environment, Proc. of SIGMOD Conf., 1995.
10. Roussopoulos, N., et al., "The Maryland ADMS Project: Views R Us." Data Eng. Bulletin, Vol. 18, No.2, June 1995.
11. O'Neil P., Quass D. "Improved Query Performance with Variant Indices", To appear in Proc. of SIGMOD Conf., 1997.
12. O'Neil P., Graefe G. "Multi-Table Joins through Bitmapped Join Indices" SIGMOD Record, Sep 1995.
13. Harinarayan V., Rajaraman A., Ullman J.D. "Implementing Data Cubes Efficiently" Proc. of SIGMOD Conf., 1996.
14. Chaudhuri S., Krishnamurthy R., Potamianos S., Shim K. "Optimizing Queries with Materialized Views" Intl. Conference on Data Engineering, 1995.
15. Levy A., Mendelzon A., Sagiv Y. "Answering Queries Using Views" Proc. of PODS, 1995.
16. Yang H.Z., Larson P.A. "Query Transformations for PSJ Queries", Proc. of VLDB, 1987.
17. Kim W. "On Optimizing a SQL-like Nested Query" ACM TODS, Sep 1982.
18. Ganski, R., Wong H.K.T., "Optimization of Nested SQL Queries Revisited" Proc. of SIGMOD Conf., 1987.
19. Dayal, U., "Of Nests and Trees: A Unified Approach to Processing Queries that Contain Nested Subqueries, Aggregates and Quantifiers" Proc. VLDB Conf., 1987.
20. Murlaikrishna, "Improved Unnesting Algorithms for Join Aggregate SQL Queries" Proc. VLDB Conf., 1992.
21. Seshadri P., Pirahesh H., Leung T. "Complex Query Decorrelation" Intl. Conference on Data Engineering, 1996.
22. Mumick I.S., Pirahesh H. "Implementation of Magic Sets in Starburst" Proc. of SIGMOD Conf., 1994.
23. Chaudhuri S., Shim K. "Optimizing Queries with Aggregate Views", Proc. of EDBT, 1996.
24. Chaudhuri S., Shim K. "Including Group By in Query Optimization", Proc. of VLDB, 1994.
25. Yan P., Larson P.A. "Eager Aggregation and Lazy Aggregation", Proc. of VLDB, 1995.
26. Gupta A., Harinarayan V., Quass D. "Aggregate-Query Processing in Data Warehouse Environments", Proc. of VLDB, 1995.
27. Chaudhuri S., Shim K. "An Overview of Cost-based Optimization of Queries with Aggregates" IEEE Data Enginering Bulletin, Sep 1995.
28. Dewitt D.J., Gray J. "Parallel Database Systems: The Future of High Performance Database Systems" CACM, June 1992.
29. Gray J. et.al. "Data Cube: A Relational Aggregation Operator Generalizing Group-by, Cross-Tab and Sub Totals" Data Mining and Knowledge Discovery Journal, Vol 1, No 1, 1997.
30. Agrawal S. et.al. "On the Computation of Multidimensional Aggregates" Proc. of VLDB Conf., 1996.
31. Kimball R., Strehlo., "Why decision support fails and how to fix it", reprinted in SIGMOD Record, 24(3), 1995.
32. Chatziantoniou D., Ross K. "Querying Multiple Features in Relational Databases" Proc. of VLDB Conf., 1996.
33. Widom, J. "Research Problems in Data Warehousing." Proc. 4th Intl. CIKM Conf., 1995.
34. Wu, M-C., A.P. Buchmann. "Research Issues in Data Warehousing." Submitted for publication.