Volume 31 Issue 3
Jan.  2018
Article Contents
Article Navigation >  Journal of University of Electronic Science and Technology of China  > 2002  >  31(3): 255-261

Wu Yue, Qiu Huizhong, Yu Shui, Yu Yuanhui. Performance Tuning for Web Based Databases[J]. Journal of University of Electronic Science and Technology of China, 2002, 31(3): 255-261.
Citation: Wu Yue, Qiu Huizhong, Yu Shui, Yu Yuanhui. Performance Tuning for Web Based Databases[J]. Journal of University of Electronic Science and Technology of China, 2002, 31(3): 255-261.
shu

Performance Tuning for Web Based Databases

  • 1.

    College of Computer Science and Engineering,UEST of China Chengdu 61005

Funds:

The project supported by the National Natural Science Foundation of China, No:69871005

  • Received Date: 2001-08-30
  • Publish Date: 2002-06-15
  • The traditional C/S database systems often suffer from the poor performance in the environment of Web applications because the number of users and the frequency or the times of accessing to a Web application are very difficult to be determined in advance.In this paper,a new method is proposed for the design,implementation and tuning of the Web based database system.This approach focuses on the configuration of RDBMS,the design of application model, and programming.By optimization on memory,on fragmentation,on disk parameters and on time related parameters,a better running environment of RDBMS can be set up.By reducing the CONNECT and DISCONNECT operations,creating suitable indexes,using more stored procedure and optimization on SQL,good performance can be got at programming step.By optimization on business logic and denormalization,the system performance can be greatly improved at design step.
  • 加载中
通讯作者: 陈斌, bchen63@163.com
  • 1. 

    沈阳化工大学材料科学与工程学院 沈阳 110142

  1. 本站搜索
  2. 百度学术搜索
  3. 万方数据库搜索
  4. CNKI搜索
Get Citation
PDF
XML

Article Metrics

Article views(3699) PDF downloads(44) Cited by()

Related
Proportional views

Performance Tuning for Web Based Databases

  • 1. College of Computer Science and Engineering,UEST of China Chengdu 61005
Funds:

The project supported by the National Natural Science Foundation of China, No:69871005

  • Received Date: 2001-08-30
  • Publish Date: 2002-06-15

Abstract: The traditional C/S database systems often suffer from the poor performance in the environment of Web applications because the number of users and the frequency or the times of accessing to a Web application are very difficult to be determined in advance.In this paper,a new method is proposed for the design,implementation and tuning of the Web based database system.This approach focuses on the configuration of RDBMS,the design of application model, and programming.By optimization on memory,on fragmentation,on disk parameters and on time related parameters,a better running environment of RDBMS can be set up.By reducing the CONNECT and DISCONNECT operations,creating suitable indexes,using more stored procedure and optimization on SQL,good performance can be got at programming step.By optimization on business logic and denormalization,the system performance can be greatly improved at design step.

Wu Yue, Qiu Huizhong, Yu Shui, Yu Yuanhui. Performance Tuning for Web Based Databases[J]. Journal of University of Electronic Science and Technology of China, 2002, 31(3): 255-261.
Citation: Wu Yue, Qiu Huizhong, Yu Shui, Yu Yuanhui. Performance Tuning for Web Based Databases[J]. Journal of University of Electronic Science and Technology of China, 2002, 31(3): 255-261.
shu

    HTML

Catalog

    Journal Online

    Author's Notes

    Links

    Copyright © 《电子科技大学学报》编辑部

    Address: Room 350, central building, University of Electronic Science and Technology, No.4, Section 2, Jianshe North Road, Chengdu Tel: 028-83202308,83207559 Email: xuebao@uestc.edu.cn

    本系统由 北京仁和汇智信息技术有限公司 开发 

    /

    DownLoad:  Full-Size Img  PowerPoint
    Return
    Return