Partial materialized views

Proceedings - International Conference on Data Engineering

Volumn , Issue , 2007, Pages 756-765

  Luo, Gang ^a  

^a IBM T J WATSON RESEARCH CENTER   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

ACCESS CONTROL; COMPUTER SIMULATION; PROBLEM SOLVING; RELATIONAL DATABASE SYSTEMS; STORAGE ALLOCATION (COMPUTER); TIME SHARING PROGRAMS;

MASSIVE DATA SETS; PARTIAL MATERIALIZED VIEW (PMV) METHOD; POSTGRESQL; THEORETICAL ANALYSIS;

QUERY PROCESSING;

EID: 34548729658     PISSN: 10844627     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1109/ICDE.2007.367921     Document Type: Conference Paper

References (33)

1. A. Aboulnaga, S. Chaudhuri. Self-tuning Histograms: Building Histograms without Looking at Data. SIGMOD Conf. 1999: 181-192.
2. S. Agrawal, S. Chaudhuri, and V.R. Narasayya. Automated Selection of Materialized Views and Indexes in SQL Databases. VLDB 2000: 496-505.
3. C. Bornhövd, M. Altinel, and S. Krishnamurthy et al. DBCaohe: Middle-tier Database Caching for Highly Scalable e-Business Architectures. SIGMOD Conf. 2003: 662.
4. N. Bruno, S. Chaudhuri, and L. Gravano. STHoles: A Multidimensional Workload-Aware Histogram. SIGMOD Conf. 2001: 211-222.
5. N. Bruno, S. Chaudhuri, and L. Gravano. Top-k Selection Queries over Relational Databases: Mapping Strategies and Performance Evaluation. TODS 27(2): 153-187, 2002.
6. S. Babu, K. Munagala, and J. Widom et al. Adaptive Caching for Continuous Queries. ICDE 2005: 118-129.
7. S. Chandrasekaran, O. Cooper, and A. Deshpande et al. TelegraphCQ: Continuous Dataflow Processing for an Uncertain World. CIDR 2003.
8. M.J. Carey, D. Kossmann. On Saying "Enough Already!" in SQL. SIGMOD Conf. 1997: 219-230.
9. S. Chaudhuri, R. Krishnamurthy, and S. Potamianos et al. Optimizing Queries with Materialized Views. ICDE 1995: 190-200.
10. S. Chaudhuri, R. Motwani, and V.R. Narasayya. On Random Sampling over Joins. SIGMOD Conf. 1999: 263-274.
11. J. Dougherty, R. Kohavi, and M. Sahami. Supervised and Unsupervised Discretization of Continuous Features. ICML 1995: 194-202.
12. D. Donjerkovic, R. Ramakrishnan. Probabilistic Optimization of Top N Queries. VLDB 1999: 411-422.
13. P. Deshpande, K. Ramasamy, and A. Shukla et al. Caching Multidimensional Queries Using Chunks. SIGMOD Conf. 1998: 259-270.
14. J. Goldstein, P. Larson. Optimizing Queries Using Materialized Views: A Practical, Scalable Solution. SIGMOD Conf. 2001: 331-342.
15. V. Ganti, M. Lee, and R. Ramakrishnan. ICICLES: Self-Tuning Samples for Approximate Query Answering. VLDB 2000: 176-187.
16. H. Guo, P. Larson, and R. Ramakrishnan et al. Relaxed Currency and Consistency: How to Say "Good Enough" in SQL. SIGMOD Conf. 2004: 815-826.
17. A. Gupta, I.S. Mumick. Materialized Views: Techniques, Implementations, and Applications. MIT Press, 1999.
18. A.Y. Halevy. Answering Queries Using Views: A Survey. VLDB J. 10(4): 270-294, 2001.
19. J.M. Hellerstein, P.J. Haas, and H. Wang. Online Aggregation. SIGMOD Conf. 1997: 171-182.
20. P.J. Haas, J.M. Hellerstein. Ripple Joins for Online Aggregation. SIGMOD Conf. 1999: 287-298.
21. R. Hull, G. Zhou. A Framework for Supporting Data Integration Using the Materialized and Virtual Approaches. SIGMOD Conf. 1996: 481-492.
22. I.F. Ilyas, W.G. Aref, and A.K. Elmagarmid. Supporting Top-k Join Queries in Relational Databases. VLDB J. 13(3): 207-221, 2004.
23. T. Johnson, D. Shasha. 2Q: A Low Overhead High Performance Buffer Management Replacement Algorithm. VLDB 1994: 439-450.
24. G. Luo, J.F. Naughton, and C.J. Ellmann et al. A Comparison of Three Methods for Join View Maintenance in Parallel RDBMS. ICDE 2003: 177-188.
25. G. Luo. Partial Materialized Views, full version. Available at http://www.cs.wisc.edu/~gangluo/partial_full.pdf, 2006.
26. F. Olken, D. Rotem. Maintenance of Materialized Views of Sampling Queries. ICDE 1992: 632-641.
27. Oracle Label Security, http://www.oracle.com/technology/docs/deploy/ security/pdf/olsag.pdf, 2000.
28. PostgreSQL homepage, 2005. http://www.postgresql.org.
29. A. Silberschatz, P. Galvin, and G. Gagne. Operating System Concepts, Sixth Edition. John Wiley, 2002.
30. P. Seshadri, A.N. Swami. Generalized Partial Indexes. ICDE 1995: 420-427.
31. M. Stonebraker: The Case for Partial Indexes. SIGMOD Record 18(4): 4-11, 1989.
32. TPC Homepage. TPC-R benchmark, www.tpc.org.
33. D.C. Zilio, J. Rao, and S. Lightstone et al. DB2 Design Advisor: Integrated Automatic Physical Database Design. VLDB 2004: 1087-1097.