메뉴 건너뛰기




Volumn 1, Issue 1, 2007, Pages 1-140

Adaptive query processing

Author keywords

[No Author keywords available]

Indexed keywords

ADAPTIVE QUERY PROCESSING; ADAPTIVITY; CPU UTILIZATION; RESEARCH PROBLEMS; RUNTIMES;

EID: 50249126090     PISSN: 19317883     EISSN: 19317891     Source Type: Journal    
DOI: 10.1561/1900000001     Document Type: Article
Times cited : (259)

References (124)
  • 1
    • 0005334432 scopus 로고    scopus 로고
    • Self-tuning histograms: Building histograms without looking at data
    • A. Aboulnaga and S. Chaudhuri, "Self-tuning histograms: building histograms without looking at data," in SIGMOD '99: Proceedings of the 1999 ACM SIGMOD international conference on Management of data, (New York, NY, USA), pp. 181-192, ACM Press, 1999. (Pubitemid 129597334)
    • (1999) SIGMOD Record (ACM Special Interest Group on Management of Data) , vol.28 , Issue.2 , pp. 181-192
    • Aboulnaga, A.1    Chaudhuri, S.2
  • 3
    • 0001269082 scopus 로고    scopus 로고
    • Query processing and optimization in Oracle Rdb
    • G. Antoshenkov and M. Ziauddin, "Query processing and optimization in Oracle Rdb," The VLDB Journal, vol. 5, no. 4, pp. 229-237, 1996. (Pubitemid 126704140)
    • (1996) VLDB Journal , vol.5 , Issue.4 , pp. 229-237
    • Antoshenkov, G.1    Ziauddin, M.2
  • 4
    • 33745289988 scopus 로고    scopus 로고
    • The CQL continuous query language: Semantic foundations and query execution
    • DOI 10.1007/s00778-004-0147-z
    • A. Arasu, S. Babu, and J. Widom, "The CQL continuous query language: Semantic foundations and query execution," The VLDB Journal, vol. 15, no. 2, pp. 121-142, 2006. (Pubitemid 43938935)
    • (2006) VLDB Journal , vol.15 , Issue.2 , pp. 121-142
    • Arasu, A.1    Babu, S.2    Widom, J.3
  • 7
    • 29844440778 scopus 로고    scopus 로고
    • Towards a robust query optimizer: A principled and practical approach
    • DOI 10.1145/1066157.1066172, SIGMOD 2005: Proceedings of the ACM SIGMOD International Conference on Management of Data
    • B. Babcock and S. Chaudhuri, "Towards a robust query optimizer: a principled and practical approach," in SIGMOD '05: Proceedings of the 2005 ACM SIGMOD international conference on Management of data, (New York, NY, USA), pp. 119-130, ACM Press, 2005. (Pubitemid 43038922)
    • (2005) Proceedings of the ACM SIGMOD International Conference on Management of Data , pp. 119-130
    • Babcock, B.1    Chaudhuri, S.2
  • 9
    • 29844441228 scopus 로고    scopus 로고
    • Proactive re-optimization
    • DOI 10.1145/1066157.1066171, SIGMOD 2005: Proceedings of the ACM SIGMOD International Conference on Management of Data
    • S. Babu, P. Bizarro, and D. DeWitt, "Proactive re-optimization, " in SIGMOD '05: Proceedings of the 2005 ACM SIGMOD international conference on Management of data, Baltimore, MD, pp. 107-118, New York, NY: ACM Press, June 14-16 2005. (Pubitemid 43038921)
    • (2005) Proceedings of the ACM SIGMOD International Conference on Management of Data , pp. 107-118
    • Babu, S.1    Bizarro, P.2    DeWitt, D.3
  • 11
    • 28444460209 scopus 로고    scopus 로고
    • Adaptive caching for continuous queries
    • Proceedings - 21st International Conference on Data Engineering, ICDE 2005
    • S. Babu, K. Munagala, J. Widom, and R. Motwani, "Adaptive caching for continuous queries," in ICDE '05: Proceedings of the 21st International Conference on Data Engineering (ICDE'05), (Washington, DC, USA), pp. 118-129, IEEE Computer Society, 2005. (Pubitemid 41731120)
    • (2005) Proceedings - International Conference on Data Engineering , pp. 118-129
    • Babu, S.1    Munagala, K.2    Widom, J.3    Motwani, R.4
  • 14
  • 18
    • 84858645279 scopus 로고    scopus 로고
    • Adaptive and robust query processing with SHARP
    • University of Wisconsin - Madison, CS Dept.
    • P. Bizarro and D. DeWitt, "Adaptive and robust query processing with SHARP," Tech. Rep. 1562, University of Wisconsin - Madison, CS Dept., 2006.
    • (2006) Tech. Rep. , vol.1562
    • Bizarro, P.1    Dewitt, D.2
  • 20
    • 33747732870 scopus 로고
    • Horizontal decompositions and their impact on query solving
    • P. D. Bra and J. Paredaens, "Horizontal decompositions and their impact on query solving," SIGMOD Rec., vol. 13, no. 1, pp. 46-50, 1982.
    • (1982) SIGMOD Rec. , vol.13 , Issue.1 , pp. 46-50
    • Bra, P.D.1    Paredaens, J.2
  • 29
    • 0001891304 scopus 로고
    • An evaluation of buffer management strategies for relational database systems
    • Stockholm, Sweden: Morgan Kaufmann, August 21-23
    • H.-T. Chou and D. J. DeWitt, "An evaluation of buffer management strategies for relational database systems," in VLDB '85: Proceedings of 11th International Conference on Very Large Data Bases, pp. 127-141, Stockholm, Sweden: Morgan Kaufmann, August 21-23 1985.
    • (1985) VLDB '85: Proceedings of 11th International Conference on Very Large Data Bases , pp. 127-141
    • Chou, H.-T.1    Dewitt, D.J.2
  • 33
    • 79960099716 scopus 로고
    • A relational model of data for large shared data banks
    • ACM
    • E. F. Codd, "A relational model of data for large shared data banks," Commun. ACM, vol. 26, no. 1, pp. 64-69, 1983.
    • (1983) Commun. , vol.26 , Issue.1 , pp. 64-69
    • Codd, E.F.1
  • 35
    • 34250677320 scopus 로고    scopus 로고
    • Flow algorithms for two pipelined filter ordering problems
    • DOI 10.1145/1142351.1142379, Proceedings of the Twenty-Fifth ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems, PODS 2006
    • A. Condon, A. Deshpande, L. Hellerstein, and N. Wu, "Flow algorithms for two pipelined filter ordering problems," in PODS '06: Proceedings of the twenty-fifth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems, (New York, NY, USA), pp. 193-202, ACM Press, 2006. (Pubitemid 46946481)
    • (2006) Proceedings of the ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems , pp. 193-202
    • Condon, A.1    Deshpande, A.2    Hellerstein, L.3    Wu, N.4
  • 36
    • 0006013983 scopus 로고
    • Query compilation in a distributed database system
    • Research Report RJ 3423
    • D. Daniels, "Query compilation in a distributed database system," Tech. Rep., IBM, 1982. Research Report RJ 3423.
    • (1982) Tech. Rep., IBM
    • Daniels, D.1
  • 37
    • 14344264587 scopus 로고    scopus 로고
    • An initial study of overheads of eddies
    • DOI 10.1145/974121.974129
    • A. Deshpande, "An initial study of overheads of eddies," SIGMOD Rec., vol. 33, no. 1, pp. 44-49, 2004. (Pubitemid 40290239)
    • (2004) SIGMOD Record , vol.33 , Issue.1 , pp. 44-49
    • Deshpande, A.1
  • 39
    • 28444450448 scopus 로고    scopus 로고
    • Exploiting correlated attributes in acquisitional query processing
    • Proceedings - 21st International Conference on Data Engineering, ICDE 2005
    • A. Deshpande, C. Guestrin, W. Hong, and S. Madden, "Exploiting correlated attributes in acquisitional query processing," in ICDE '05: Proceedings of the 21st International Conference on Data Engineering (ICDE'05), (Washington, DC, USA), pp. 143-154, IEEE Computer Society, 2005. (Pubitemid 41731122)
    • (2005) Proceedings - International Conference on Data Engineering , pp. 143-154
    • Deshpande, A.1    Guestrin, C.2    Hong, W.3    Madden, S.4
  • 41
    • 52649123553 scopus 로고    scopus 로고
    • Flow algorithms for parallel query optimization
    • University of Maryland at College Park
    • A. Deshpande and L. Hellerstein, "Flow algorithms for parallel query optimization," Tech. Rep. CS-TR-4873, University of Maryland at College Park, 2007.
    • (2007) Tech. Rep. CS-TR-4873
    • Deshpande, A.1    Hellerstein, L.2
  • 42
    • 18744399033 scopus 로고    scopus 로고
    • Evaluating window joins over punctuated streams
    • CIKM 2004: Proceedings of the Thirteenth ACM Conference on Information and Knowledge Management
    • L. Ding and E. A. Rundensteiner, "Evaluating window joins over punctuated streams," in CIKM '04: Proceedings of the thirteenth ACM international conference on Information and knowledge management, (New York, NY, USA), pp. 98-107, ACM Press, 2004. (Pubitemid 40673428)
    • (2004) International Conference on Information and Knowledge Management, Proceedings , pp. 98-107
    • Ding, L.1    Rundensteiner, E.A.2
  • 45
    • 21044440739 scopus 로고    scopus 로고
    • Approximating min-sum set cover
    • U. Feige, L. Lov'asz, and P. Tetali, "Approximating min-sum set cover," Algorithmica, vol. 40, no. 4, pp. 219-234, 2004.
    • (2004) Algorithmica , vol.40 , Issue.4 , pp. 219-234
    • Feige, U.1    Lov'Asz, L.2    Tetali, P.3
  • 48
    • 33749618102 scopus 로고    scopus 로고
    • Simultaneous pipelining in QPipe: Exploiting work sharing opportunities across queries
    • DOI 10.1109/ICDE.2006.138, 1617530, Proceedings of the 22nd International Conference on Data Engineering, ICDE '06
    • K. Gao, S. Harizopoulos, I. Pandis, V. Shkapenyuk, and A. Ailamaki, "Simultaneous pipelining in QPipe: Exploiting work sharing opportunities across queries," in ICDE '06: Proceedings of the 22nd International Conference on Data Engineering (ICDE'06), (Washington, DC, USA), p. 162, IEEE Computer Society, 2006. (Pubitemid 44539954)
    • (2006) Proceedings - International Conference on Data Engineering , vol.2006 , pp. 162
    • Gao, K.1    Harizopoulos, S.2    Pandis, I.3    Shkapenyuk, V.4    Ailamaki, A.5
  • 50
    • 84994092452 scopus 로고    scopus 로고
    • DataGuides: Enabling query formulation and optimization in semistructured databases
    • Athens, Greece: Morgan Kaufman, August 25-29
    • R. Goldman and J. Widom, "DataGuides: Enabling query formulation and optimization in semistructured databases," in VLDB '97: Proceedings of 23rd International Conference on Very Large Data Bases, pp. 436-445, Athens, Greece: Morgan Kaufman, August 25-29 1997.
    • (1997) VLDB '97: Proceedings of 23rd International Conference on Very Large Data Bases , pp. 436-445
    • Goldman, R.1    Widom, J.2
  • 53
    • 0027608375 scopus 로고
    • Query evaluation techniques for large databases
    • G. Graefe, "Query evaluation techniques for large databases," ACM Comput. Surv., vol. 25, no. 2, pp. 73-169, 1993.
    • (1993) ACM Comput. Surv. , vol.25 , Issue.2 , pp. 73-169
    • Graefe, G.1
  • 54
    • 0001890225 scopus 로고
    • The Cascades framework for query optimization
    • G. Graefe, "The Cascades framework for query optimization," IEEE Data Engineering Bulletin, vol. 18, no. 3, pp. 19-29, 1995.
    • (1995) IEEE Data Engineering Bulletin , vol.18 , Issue.3 , pp. 19-29
    • Graefe, G.1
  • 56
    • 0027221223 scopus 로고
    • Volcano optimizer generator: Extensibility and efficient search
    • 1993 IEEE 9th International Conference on Data Engineering
    • G. Graefe and W. J. McKenna, "The Volcano optimizer generator: Extensibility and efficient search," in ICDE '93: Proceedings of the Ninth International Conference on Data Engineering, Vienna, Austria, pp. 209-218, IEEE Computer Society, April 19-23 1993. (Pubitemid 23674619)
    • (1993) Proceedings - International Conference on Data Engineering , pp. 209-218
    • Graefe Goetz1    McKenna William, J.2
  • 60
    • 0032083881 scopus 로고    scopus 로고
    • Optimization techniques for queries with expensive methods
    • J. M. Hellerstein, "Optimization techniques for queries with expensive methods," ACM Transactions on Database Systems, vol. 23, no. 2, pp. 113-157, 1998. (Pubitemid 128448477)
    • (1998) ACM Transactions on Database Systems , vol.23 , Issue.2 , pp. 113-157
    • Hellerstein, J.M.1
  • 62
    • 0032137328 scopus 로고    scopus 로고
    • Tracking the best expert
    • DOI 10.1023/A:1007424614876
    • M. Herbster and M. K.Warmuth, "Tracking the best expert," Machine Learning, vol. 32, pp. 151-178, August 1998. (Pubitemid 40626079)
    • (1998) Machine Learning , vol.32 , Issue.2 , pp. 151-178
    • Herbster, M.1    Warmuth, M.K.2
  • 63
    • 84938015047 scopus 로고
    • A method for the construction of minimum redundancy codes
    • D. A. Huffman, "A method for the construction of minimum redundancy codes," in Proc. Inst. Radio Eng., pp. 1098-1101, 1952.
    • (1952) Proc. Inst. Radio Eng. , pp. 1098-1101
    • Huffman, D.A.1
  • 65
    • 85011395182 scopus 로고    scopus 로고
    • AniPQO: Almost non-intrusive parametric query optimization for nonlinear cost functions
    • September 9-12, 2003, Berlin, Germany
    • A. Hulgeri and S. Sudarshan, "AniPQO: Almost non-intrusive parametric query optimization for nonlinear cost functions.," in VLDB '03: Proceedings of 29th International Conference on Very Large Data Bases, September 9-12, 2003, Berlin, Germany, pp. 766-777, 2003.
    • (2003) VLDB '03: Proceedings of 29th International Conference on Very Large Data Bases , pp. 766-777
    • Hulgeri, A.1    Sudarshan, S.2
  • 67
    • 0021497828 scopus 로고
    • On the optimal nesting order for computing N-relational joins
    • DOI 10.1145/1270.1498
    • T. Ibaraki and T. Kameda, "On the optimal nesting order for computing N-relational joins," ACM Transactions on Database Systems, vol. 9, no. 3, pp. 482-502, 1984. (Pubitemid 14646996)
    • (1984) ACM Transactions on Database Systems , vol.9 , Issue.3 , pp. 482-502
    • Ibaraki, T.1    Kameda, T.2
  • 68
    • 0000879737 scopus 로고    scopus 로고
    • Query optimization
    • Y. E. Ioannidis, "Query optimization," ACM Computing Surveys, vol. 28, no. 1, pp. 121-123, 1996. (Pubitemid 126499040)
    • (1996) ACM Computing Surveys , vol.28 , Issue.1 , pp. 121-123
    • Ioannidis, Y.E.1
  • 74
    • 84868288923 scopus 로고    scopus 로고
    • Sideways information passing for push-style query processing
    • University of Pennsylvania
    • Z. G. Ives and N. E. Taylor, "Sideways information passing for push-style query processing," Tech. Rep. MS-CIS-07-14, University of Pennsylvania, 2007.
    • (2007) Tech. Rep. MS-CIS-07-14
    • Ives, Z.G.1    Taylor, N.E.2
  • 75
    • 0032093823 scopus 로고    scopus 로고
    • Efficient mid-query re-optimization of sub-optimal query execution plans
    • N. Kabra and D. J. DeWitt, "Efficient mid-query re-optimization of suboptimal query execution plans," in SIGMOD '98: Proceedings of the 1998 ACM SIGMOD international conference on Management of data, (New York, NY, USA), pp. 106-117, ACM Press, 1998. (Pubitemid 128655961)
    • (1998) SIGMOD Record , vol.27 , Issue.2 , pp. 106-117
    • Kabra, N.1    DeWitt, D.J.2
  • 76
    • 33244464430 scopus 로고    scopus 로고
    • Learning with attribute costs
    • DOI 10.1145/1060590.1060644, STOC'05: Proceedings of the 37th Annual ACM Symposium on Theory of Computing
    • H. Kaplan, E. Kushilevitz, and Y. Mansour, "Learning with attribute costs," in STOC '05: Proceedings of the thirty-seventh annual ACM symposium on Theory of computing, (New York, NY, USA), pp. 356-365, ACM Press, 2005. (Pubitemid 43098606)
    • (2005) Proceedings of the Annual ACM Symposium on Theory of Computing , pp. 356-365
    • Kaplan, H.1    Kusnilevitz, E.2    Mansour, Y.3
  • 77
    • 0036832954 scopus 로고    scopus 로고
    • Near-optimal reinforcement learning in polynomial time
    • November
    • M. Kearns and S. Singh, "Near-optimal reinforcement learning in polynomial time," Machine Learning, vol. 49, pp. 260-268, November 2002.
    • (2002) Machine Learning , vol.49 , pp. 260-268
    • Kearns, M.1    Singh, S.2
  • 78
    • 0020182801 scopus 로고
    • On optimizing an SQL-like nested query
    • W. Kim, "On optimizing an SQL-like nested query," ACM Transactions on Database Systems, vol. 7, no. 3, pp. 443-469, 1982.
    • (1982) ACM Transactions on Database Systems , vol.7 , Issue.3 , pp. 443-469
    • Kim, W.1
  • 79
    • 0000500922 scopus 로고    scopus 로고
    • The state of the art in distributed query processing
    • D. Kossmann, "The state of the art in distributed query processing," ACM Comput. Surv., vol. 32, no. 4, pp. 422-469, 2000.
    • (2000) ACM Comput. Surv. , vol.32 , Issue.4 , pp. 422-469
    • Kossmann, D.1
  • 85
    • 0022821509 scopus 로고
    • R* optimizer validation and performance evaluation for distributed queries
    • San Francisco, CA, USA), Morgan Kaufmann Publishers Inc.
    • L. F. Mackert and G. M. Lohman, "R* optimizer validation and performance evaluation for distributed queries," in VLDB '86: Proceedings of the 12th International Conference on Very Large Data Bases, (San Francisco, CA, USA), pp. 149-159, Morgan Kaufmann Publishers Inc., 1986.
    • (1986) VLDB '86: Proceedings of the 12th International Conference on Very Large Data Bases , pp. 149-159
    • MacKert, L.F.1    Lohman, G.M.2
  • 91
    • 35448942744 scopus 로고    scopus 로고
    • Optimization of continuous queries with shared expensive filters
    • DOI 10.1145/1265530.1265561, Proceedings of the Twenty-sixth ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems, PODS 2007
    • K. Munagala, U. Srivastava, and J. Widom, "Optimization of continuous queries with shared expensive filters," in PODS '07: Proceedings of the twentysixth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems, (New York, NY, USA), pp. 215-224, ACM Press, 2007. (Pubitemid 47620896)
    • (2007) Proceedings of the ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems , pp. 215-224
    • Munagala, K.1    Srivastava, U.2    Widom, J.3
  • 93
    • 33745789673 scopus 로고    scopus 로고
    • Selectivity-based partitioning: A divide-and-union paradigm for effective query optimization
    • DOI 10.1145/1099554.1099730, CIKM'05 - Proceedings of the 14th ACM International Conference on Information and Knowledge Management
    • N. Polyzotis, "Selectivity-based partitioning: A divide-and-union paradigm for effective query optimization," in CIKM '05: Proceedings of the 14th ACM International Conference on Information and knowledge management, pp. 720-727, New York, NY: ACM Press, 2005. (Pubitemid 44022250)
    • (2005) International Conference on Information and Knowledge Management, Proceedings , pp. 720-727
    • Polyzotis, N.1
  • 103
    • 0023977778 scopus 로고
    • Multiple-query optimization
    • T. K. Sellis, "Multiple-query optimization," ACM Trans. Database Syst., vol. 13, no. 1, pp. 23-52, 1988.
    • (1988) ACM Trans. Database Syst. , vol.13 , Issue.1 , pp. 23-52
    • Sellis, T.K.1
  • 109
    • 0016556911 scopus 로고
    • Optimal problem-solving search: All-or-none solutions
    • H. Simon and J. Kadane, "Optimal problem-solving search: All-or-none solutions," Artificial Intelligence, vol. 6, pp. 235-247, 1975.
    • (1975) Artificial Intelligence , vol.6 , pp. 235-247
    • Simon, H.1    Kadane, J.2
  • 114
    • 33646702096 scopus 로고
    • InterViso: Dealing with the complexity of federated database access
    • M. Templeton, H. Henley, E. Maros, and D. J. V. Buer, "InterViso: Dealing with the complexity of federated database access," The VLDB Journal, vol. 4, no. 2, 1995.
    • (1995) The VLDB Journal , vol.4 , Issue.2
    • Templeton, M.1    Henley, H.2    Maros, E.3    Buer, D.J.V.4
  • 116
    • 0036210974 scopus 로고    scopus 로고
    • Exploiting punctuation semantics in data streams
    • P. A. Tucker and D. Maier, "Exploiting punctuation semantics in data streams," in ICDE '02: Proceedings of the 18th International Conference on Data Engineering, (Washington, DC, USA), p. 279, IEEE Computer Society, 2002. (Pubitemid 34278731)
    • (2002) Proceedings - International Conference on Data Engineering , pp. 279
    • Tucker, P.1    Maier, D.2
  • 117
    • 0002520588 scopus 로고    scopus 로고
    • XJoin: A reactively-scheduled pipelined join operator
    • T. Urhan and M. J. Franklin, "XJoin: a reactively-scheduled pipelined join operator," IEEE Data Engineering Bulletin, vol. 23, no. 2, pp. 27-33, 2000.
    • (2000) IEEE Data Engineering Bulletin , vol.23 , Issue.2 , pp. 27-33
    • Urhan, T.1    Franklin, M.J.2
  • 118
    • 0032093705 scopus 로고    scopus 로고
    • Cost-based query scrambling for initial delays
    • T. Urhan, M. J. Franklin, and L. Amsaleg, "Cost based query scrambling for initial delays," in SIGMOD '98: Proceedings of the 1998 ACM SIGMOD International Conference on Management of Data, pp. 130-141, Seattle, WA: ACM Press, June 2-4 1998. (Pubitemid 128655963)
    • (1998) SIGMOD Record , vol.27 , Issue.2 , pp. 130-141
    • Urhan, T.1    Franklin, M.J.2    Amsaleg, L.3
  • 122
    • 84976812728 scopus 로고
    • Decomposition - strategy for query processing
    • E. Wong and K. Youssefi, "Decomposition - strategy for query processing," ACM Transactions on Database Systems, vol. 1, no. 3, pp. 223-241, 1976.
    • (1976) ACM Transactions on Database Systems , vol.1 , Issue.3 , pp. 223-241
    • Wong, E.1    Youssefi, K.2
  • 123
    • 33749615208 scopus 로고    scopus 로고
    • Sliding window based multi-join algorithms over distributed data streams
    • DOI 10.1109/ICDE.2006.143, 1617507, Proceedings of the 22nd International Conference on Data Engineering, ICDE '06
    • D. Zhang, J. Li, K. Kimeli, and W. Wang, "Sliding window based multi-join algorithms over distributed data streams," in ICDE '06: Proceedings of the 22nd International Conference on Data Engineering (ICDE'06), (Washington, DC, USA), p. 139, IEEE Computer Society, 2006. (Pubitemid 44539931)
    • (2006) Proceedings - International Conference on Data Engineering , vol.2006 , pp. 139
    • Zhang, D.1    Li, J.2    Kimeli, K.3    Wang, W.4


* 이 정보는 Elsevier사의 SCOPUS DB에서 KISTI가 분석하여 추출한 것입니다.