[1]张国华.一种改进查询优化算法的具体应用[J].计算机技术与发展,2016,26(07):112-115.
　ZHANG Guo-hua. A Specific Application for Improved Query Optimization Algorithm[J].,2016,26(07):112-115.
点击复制

一种改进查询优化算法的具体应用()
分享到：

《计算机技术与发展》[ISSN:1006-6977/CN:61-1281/TN]

卷:
26
期数:
2016年07期
页码:
112-115
栏目:
应用开发研究
出版日期:
2016-07-10

文章信息/Info

Title:
 A Specific Application for Improved Query Optimization Algorithm
文章编号:
1673-629X（2016)07-0112-05
作者:
 张国华
 南京师范大学泰州学院
Author(s):
 ZHANG Guo-hua
关键词:
 ; 新农合; 分布式数据库; 连接优化; 算法时间代价
Keywords:
 ; NCMS; distributed database; connection optimization; algorithm time cost
分类号:
TP311
文献标志码:
A
摘要:
 我国新型农村合作医疗系统(以下简称新农合)采用了分布式数据库系统，即数据分布在不同的主管部门与不同的数据库服务器上，各个部门对于数据的查询频率及数据的反馈速度要求较高，但业务流程中在涉及查询时的数据来源复杂，传统的一些查询算法所消耗的时间代价、空间代价过高。针对上述问题，文中通过对分布式数据库系统的简化，建模出代价模型查询图，提出基于贪婪的优化算法并给出了数据查询迭代方案，解决了在分布式数据库查询连接优化的问题。实验结果表明，改进后的优化算法能明显缩短查询时间，并通过系统上线测试对比，证明该算法是有效可行的。
Abstract:
 China’s New Rural Cooperative Medical System ( NRCMS) adopts the distributed database system. Data distribution in differ-ent authorities with different database servers,each department for the query frequency and data feedback speed has higher requirements, which involves complicated data resources in the working process,but the traditional query algorithm costs too much time and space. Ai-ming at these problems,through a distributed database system simplification,modeling query image of cost model,an optimization algo-rithm based on the greedy is proposed and the iterative scheme for data query is given,which solves the problem of connection in a dis-tributed database query optimization. The experiments show that the improved optimization algorithm can significantly shorten the query time,and the on-line system test comparison demonstrates the algorithm is effective and feasible.

相似文献/References:

[1]张志宏,吴庆波,邵立松,等.基于飞腾平台TOE协议栈的设计与实现[J].计算机技术与发展,2014,24(07):1.
　ZHANG Zhi-hong,WU Qing-bo,SHAO Li-song,et al. Design and Implementation of TCP/IP Offload Engine Protocol Stack Based on FT Platform[J].,2014,24(07):1.
[2]梁文快,李毅. 改进的基因表达算法对航班优化排序问题研究[J].计算机技术与发展,2014,24(07):5.
　LIANG Wen-kuai,LI Yi. Research on Optimization of Flight Scheduling Problem Based on Improved Gene Expression Algorithm[J].,2014,24(07):5.
[3]黄静,王枫,谢志新,等. EAST文档管理系统的设计与实现[J].计算机技术与发展,2014,24(07):13.
　HUANG Jing,WANG Feng,XIE Zhi-xin,et al. Design and Implementation of EAST Document Management System[J].,2014,24(07):13.
[4]侯善江[],张代远[][][]. 基于样条权函数神经网络P2P流量识别方法[J].计算机技术与发展,2014,24(07):21.
　HOU Shan-jiang[],ZHANG Dai-yuan[][][]. P2P Traffic Identification Based on Spline Weight Function Neural Network[J].,2014,24(07):21.
[5]李璨,耿国华,李康,等. 一种基于三维模型的文物碎片线图生成方法[J].计算机技术与发展,2014,24(07):25.
　LI Can,GENG Guo-hua,LI Kang,et al. A Method of Obtaining Cultural Debris’ s Line Chart Based on Three-dimensional Model[J].,2014,24(07):25.
[6]翁鹤,皮德常. 混沌RBF神经网络异常检测算法[J].计算机技术与发展,2014,24(07):29.
　WENG He,PI De-chang. Chaotic RBF Neural Network Anomaly Detection Algorithm[J].,2014,24(07):29.
[7]刘茜[],荆晓远[],李文倩[],等. 基于流形学习的正交稀疏保留投影[J].计算机技术与发展,2014,24(07):34.
　LIU Qian[],JING Xiao-yuan[,LI Wen-qian[],et al. Orthogonal Sparsity Preserving Projections Based on Manifold Learning[J].,2014,24(07):34.
[8]尚福华,李想,巩淼. 基于模糊框架-产生式知识表示及推理研究[J].计算机技术与发展,2014,24(07):38.
　SHANG Fu-hua,LI Xiang,GONG Miao. Research on Knowledge Representation and Inference Based on Fuzzy Framework-production[J].,2014,24(07):38.
[9]叶偲,李良福,肖樟树. 一种去除运动目标重影的图像镶嵌方法研究[J].计算机技术与发展,2014,24(07):43.
　YE Si,LI Liang-fu,XIAO Zhang-shu. Research of an Image Mosaic Method for Removing Ghost of Moving Targets[J].,2014,24(07):43.
[10]余松平[][],蔡志平[],吴建进[],等. GSM-R信令监测选择录音系统设计与实现[J].计算机技术与发展,2014,24(07):47.
　YU Song-ping[][],CAI Zhi-ping[] WU Jian-jin[],GU Feng-zhi[]. Design and Implementation of an Optional Voice Recording System Based on GSM-R Signaling Monitoring[J].,2014,24(07):47.
[11]张国华,徐建军,刘丽娟. 基于NoSQL的新农合高效云存储方法[J].计算机技术与发展,2017,27(10):197.
　ZHANG Guo-hua,XU Jian-jun,LIU Li-juan. An Efficient Cloud Storage Method with NoSQL for New Rural Cooperative Medical Care[J].,2017,27(07):197.

更新日期/Last Update: 2016-09-28