| 一种高效的SQL语句执行线程 |
| |
| 引用本文： | 洪承煜,杨尚琴,陈浩.一种高效的SQL语句执行线程[J].计算机系统应用,2014,23(1):162-165. |
| |
| 作者姓名： | 洪承煜 杨尚琴 陈浩 |
| |
| 作者单位： | 中国石化石油物探技术研究院, 南京 211103;中国石化石油物探技术研究院, 南京 211103;中国石化石油物探技术研究院, 南京 211103 |
| |
| 摘 要： | 在采集、处理、解释一体化软件平台中, 不可避免地有大量的SQL 语句执行, 而在这些SQL 语句执行中, 不需要返回的SQL 语句又占主要比例. 通过设计SQL 语句缓存区, 并把不需要返回的SQL 语句实时放入此缓存区, 最后通过设计高效的执行线程, 对此缓存区内的SQL 语句进行实时的处理. 这种方法既分离了业务与数据库操作, 也提高了业务对数据库操作请求的效率.
|
| 关 键 词： | SQL语句 线程 缓存区 |
| 收稿时间： | 2013/6/21 0:00:00 |
| 修稿时间： | 2013/7/22 0:00:00 |
Efficient SQL Statement Execution Threads |
| |
| HONG Cheng-Yu,YANG Shang-Qin and CHEN Hao.Efficient SQL Statement Execution Threads[J].Computer Systems& Applications,2014,23(1):162-165. |
| |
| Authors: | HONG Cheng-Yu YANG Shang-Qin and CHEN Hao |
| |
| Affiliation: | SINOPEC Geophysical Research Institute, Nanjing 211103, China;SINOPEC Geophysical Research Institute, Nanjing 211103, China;SINOPEC Geophysical Research Institute, Nanjing 211103, China |
| |
| Abstract: | During the acquisition, processing and interpretation integrated software platform, there are a large number of SQL statements inevitably executed, while running these SQL statements, SQL statements that do not need to return occupy to a major proportion. This paper designs the SQL statements cache and SQL statements that do not need to return real-time put into this cache, and finally by designing the thread of executing SQL statements, SQL statements in the cache real-time process. This method does not only the separation of business and database operations, but also improves the business efficiency of requests for database operations. |
| |
| Keywords: | SQL statements threads cache |
| 本文献已被 CNKI 维普 等数据库收录！ |
| 点击此处可从《计算机系统应用》浏览原始摘要信息 |
|
点击此处可从《计算机系统应用》下载全文 |
|
