| 网络通信环境下的SQL数据库实时访问方式性能分析 |
| |
| 引用本文： | 阮丽华,赵旦峰,李超.网络通信环境下的SQL数据库实时访问方式性能分析[J].应用科技,2013(6):55-58. |
| |
| 作者姓名： | 阮丽华 赵旦峰 李超 |
| |
| 作者单位： | [1]西北工业大学电子信息学院,陕西西安710072 [2]哈尔滨工程大学信息与通信工程学院,黑龙江哈尔滨150001 |
| |
| 摘 要： | 为了探究网络通信环境中不同数据库动态访问方式的性能特点及适用情况，在MFC开发环境下分别基于UDP和TCP网络协议进行建模，分析数据库访问时延与数据包操作量的关系，对MFCODBC、MFCDAO和ADO这3种数据库访问方式的性能进行比较和评价，并定义波动百分比来衡量访问技术的稳定性．建模结果表明，3种访问方式在实时数据存储中稳定性较高，数据包量少于3000个时表现出相似性能．在实时数据读取中，ADO性能最优，并总结归纳了稳定性随数据量增加和网络通信协议变化的特点．
|
| 关 键 词： | 数据库动态访问 MFC TCP UDP 网络通信 性能 |
Performance analysis on the SQL database realtime access manner under network communication environment |
| |
| RUAN Lihua,＇,ZHAO Danfeng,LI Chao.Performance analysis on the SQL database realtime access manner under network communication environment[J].Applied Science and Technology,2013(6):55-58. |
| |
| Authors: | RUAN Lihua ＇ ZHAO Danfeng LI Chao |
| |
| Institution: | 1. College of Electronic and Information, Northwestern Polytechnical University, Xi＇an 710072, China 2. College of Information and Communication Engineering, Harbin Engineering University, Harbin 150001, China |
| |
| Abstract: | In order to explore the performance characteristics and application of different dynamic database access manners in network communication environment, under MFC development circumstances, a model is established on the basis of UDP and TCP network protocol. The relationship between the access delay and operation volume of the data packet is analyzed, and the performances of the three kinds of database access manners including MFC ODBC, MFC DAO and ADO are compared and assessed. In addition, the fluctuation percentage is defined to assess the sta- bility of access technology. The modeling results show that the three kinds of database access manners have high sta- bility in realtime data storage ; when the quantity of data packets is less than 3 000, they appear to be similar. As for the reading the increase of reahime data, ADO performance is the best. In addition, the characteristics of the stability following of data volume and the change of network communication protocol are summarized and induced. |
| |
| Keywords: | dynamic database access MFC TCP/UDP network communication performance |
| 本文献已被 维普 等数据库收录！ |
|
