首页 | 本学科首页   官方微博 | 高级检索  
     

数据库应用系统优化方法的研究
引用本文:夏义全.数据库应用系统优化方法的研究[J].微机发展,2008(7):149-152.
作者姓名:夏义全
作者单位:安徽建筑工业学院电子与信息工程学院 安徽合肥230601
基金项目:安徽省自然科学基金项目(2006KJ012C)
摘    要:数据库应用系统开发的首要任务是对需求的充分分析,预见性地考虑并解决影响系统高效率的瓶颈问题。针对数据库应用系统开发过程中如何提高系统高效率的瓶颈问题,分析了引起效率瓶颈的原因,阐述了提高服务器性能的一些方法和技术,并利用这些方法和技术来优化复杂数据库应用系统的性能,大大地提高数据库存取、查询等效率。就本地表和临时表的使用、二进制大对象BLOB的存取策略及数据库数据的整理和分类的必要性等给予了探讨。

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

Research on Optimization Method of Database Application System
XIA Yi-quan.Research on Optimization Method of Database Application System[J].Microcomputer Development,2008(7):149-152.
Authors:XIA Yi-quan
Affiliation:XIA Yi-quan (School of Electronics & Information Engineering, Anhui Institute of Architecture & Industry, Hefei 230601'China)
Abstract: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 by using these methods and technologies,and these methods can highly improve the efficiency of accessing and querying data.At the end,illustrate the following related questions such as application of local table and temporary table,accessing tactic of BLOB and necessity of assorting and classifying data in database.
Keywords:data redundancy  stored procedure  BLOB
本文献已被 CNKI 维普 等数据库收录!
设为首页 | 免责声明 | 关于勤云 | 加入收藏

Copyright©北京勤云科技发展有限公司  京ICP备09084417号