计算机工程 ›› 2010, Vol. 36 ›› Issue (2): 13-14.doi: 10.3969/j.issn.1000-3428.2010.02.005

• 博士论文 • 上一篇    下一篇

数据库结果集的一种块状读取算法

张西广1,2,3,陈 涛1,吕卫忠1,阎保平1

  

  1. (1. 中国科学院计算机网络信息中心,北京 100190;2. 中国科学院研究生院,北京 100039;3. 中原工学院,郑州 450007)

  • 收稿日期:1900-01-01 修回日期:1900-01-01 出版日期:2010-01-20 发布日期:2010-01-20

Block Reading Algorithm for Database Result Set

ZHANG Xi-guang1,2,3, CHEN Tao1, LV Wei-zhong1, YAN Bao-ping1   

  1. (1. Computer Network Information Center, Chinese Academy of Sciences, Beijing 100190; 2. Graduate School of Chinese Academy of Sciences, Beijing 100039; 3. Zhongyuan Institute of Technology, Zhengzhou 450007)

  • Received:1900-01-01 Revised:1900-01-01 Online:2010-01-20 Published:2010-01-20

摘要: 在基于Web的数据库应用中,读取和传输含有大对象(LOB)类型数据的查询结果集时若采用传统的方法易导致服务器端内存不足和网络拥塞。提出一种数据结果集块状读取(SBBR)算法,可以基于动态设定的内存块大小来读取结果集。该算法已应用到科学数据网格的数据访问中间件DAS系统中。测试结果表明,SBBR算法能较好地处理包含LOB数据的结果集。

关键词: 数据库, 数据查询, 数据结果集

Abstract: In the application of database on Web, when Large OBject(LOB) type columns exist in the result set of a database querying, it can easily result in some problems like running out of memory of server and network traffic if using the general methods to read and transfer the result set in the network. A novel algorithm——SBBR is provided to avoid those problems, it can handle the result set in chunks and the block size can be dynamically set. SBBR is implemented in the grid middleware-DAS of science data grid. Test results show it can handle the result set which includes LOB well.

Key words: database, data querying, data result set

中图分类号: