数据库应用系统优化方法的研究  

Research on Optimization Method of Database Application System

作　　者：夏义全[1] 

机构地区：[1]安徽建筑工业学院电子与信息工程学院,安徽合肥230601

出　　处：《计算机技术与发展》2008年第7期149-152,共4页Computer Technology and Development

基　　金：安徽省自然科学基金项目(2006KJ012C)

摘　　要：数据库应用系统开发的首要任务是对需求的充分分析,预见性地考虑并解决影响系统高效率的瓶颈问题。针对数据库应用系统开发过程中如何提高系统高效率的瓶颈问题,分析了引起效率瓶颈的原因,阐述了提高服务器性能的一些方法和技术,并利用这些方法和技术来优化复杂数据库应用系统的性能,大大地提高数据库存取、查询等效率。就本地表和临时表的使用、二进制大对象BLOB的存取策略及数据库数据的整理和分类的必要性等给予了探讨。The chief task in developing database application system is that the requirement of system should be analyzed , and the bottleneck is solved to improve the system efficiency. For the problem of how to promote system efficiency, analyzes the reasons of efficiency bottleneck, and expounds applications of some technology which can improve database server accessing efficiency. The performance of a complicated database system can be optimized ＇,y using these methods and technologies, and these methods can highly improve the effi- ciency of accessing and querying data. At the end, illustrate the following related queztions such as application of local table and temporary table, accessing tactic of BLOB and necessity of assorting and classifying data in database.

关 键 词：数据冗余 存储过程 二进制大对象 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论]