编程实现数据库的查询优化

Application of Inquiry Optimization Technology in Database System to Programming

数据库系统是管理信息系统的核心 ,基于数据库的联机事务处理 (OLTP)以及联机分析处理 (OLAP)是银行、企业、政府等部门最为重要的计算机应用之一 .从大多数系统的应用实例来看 ,查询操作在各种数据库操作中所占据的比重最大 ,其效率的高低直接影响到数据库系统的性能的好坏 .本文以应用实例为基础 ,结合数据库理论 ,介绍查询优化技术在现实系统中的运用 .

Database System is the focus of Information-management System. OLTP(online transaction processing) and OLAP(online analysis processing) based on database is one of the most important Computer applications which is widely used in bank,enterprise.,government ect. Inquire operations occupy a great position in various database operations,as the results obtained from most systems in used ,and the efficiency of Inquire operation will directly affects the performance of a database system..Based on applied examples and theory of database,this article will introduce the application of Inquire Optimization Teachnology in a real system.