| 基于统计的关系数据库查询优化器模型分析与研究 |
| |
| 引用本文： | 王兰春. 基于统计的关系数据库查询优化器模型分析与研究[J]. 现代计算机, 2011, 0(11): 13-16,33 |
| |
| 作者姓名： | 王兰春 |
| |
| 作者单位： | 山西忻州师范学院计算机科学与技术系 |
| |
| 摘 要： | 如果没有良好的查询优化器,即使是小型的数据库也会表现出非常明显的性能低下。由于实际优化器的内部结构所涉及的功能和过程异常复杂,通常的商业数据库的查询优化器至少需要50人/年的开发量。主要分析研究关系数据库中的查询优化技术,提出基于统计的、适应于关系数据库的查询优化器设计模型。
|
| 关 键 词： | 数据库管理系统 查询优化 组合优化 QEP |
Research on Relational Database Query Optimizer Model Based on Statistical and Analysis |
| |
| WANG Lan-chun. Research on Relational Database Query Optimizer Model Based on Statistical and Analysis[J]. Modem Computer, 2011, 0(11): 13-16,33 |
| |
| Authors: | WANG Lan-chun |
| |
| Affiliation: | WANG Lan-chun(Department of Computer Science and Technology,Xinzhou Teacher’s University,Xinzhou 034000) |
| |
| Abstract: | Without a favourable query optimizer,even if a minitype database behaves remarkable low performance.Because of designing an actural query optimizer is unconventionally complex,usualquery optimizers of commereial databases require at least fifty person/year workload.Emphasizesparticularly on academic research.Studying the technology of query optimization in relationaldatabase,contrasts the virtue and disadvantage of all kinds of current tcehnology,presents amodel of the based-statistieal query optimizer which can be fit for the relational databases. |
| |
| Keywords: | Database Management System Query Optimization Combinatorial Optimization QEP |
| 本文献已被 CNKI 等数据库收录！ |
|
