System for optimizing query processing in a relational database
作者： Kazuhiko Ohmachi , Masashi Tsuchida
DOI:
关键词: Query expansion 、 Database tuning 、 Query optimization 、 Information retrieval 、 View 、 Sargable 、 Query by Example 、 Online aggregation 、 Data mining 、 Materialized view 、 Computer science
摘要: A method for processing a database analyzing query to the from user determine an internal procedure therefor and executing it comprises steps of preparing single or plurality procedures based on analysis result including variable inputted in preprocess step statistical information system, selecting optimum one value substituted execution stage accordance with selected procedure.
lens.org 参考文章(7)
Nancy L. Green, Database query code generation and optimization based on the cost of alternate access methods ,(1984)
Irving L. Traiger, Joseph J. Sordi, Philip S. Shaw, Apparatus and method for synthesizing a query for accessing a relational data base ,(1983)
Murari Kumpati, Database management system with active data dictionary ,(1985)
M. Schkolnick, P. Tiberio, Estimating the cost of updates in a relational database ACM Transactions on Database Systems. ,vol. 10, pp. 163- 179 ,(1985) , 10.1145/3857.3863
John Miles Smith, Philip Yen-Tang Chang, Optimizing the performance of a relational algebra database interface Communications of the ACM. ,vol. 18, pp. 568- 579 ,(1975) , 10.1145/361020.361025
P. Griffiths Selinger, M. M. Astrahan, D. D. Chamberlin, R. A. Lorie, T. G. Price, Access path selection in a relational database management system Proceedings of the 1979 ACM SIGMOD international conference on Management of data - SIGMOD '79. pp. 23- 34 ,(1979) , 10.1145/582095.582099