| Oracle分区技术在公共卫生数据共享中的应用研究 |
| |
| 引用本文： | 王松旺,张英杰,樊秀娥.Oracle分区技术在公共卫生数据共享中的应用研究[J].中国卫生工程学,2010(2):88-90. |
| |
| 作者姓名： | 王松旺 张英杰 樊秀娥 |
| |
| 作者单位： | 中国疾病预防控制中心信息中心; |
| |
| 摘 要： | 目的提高公共卫生数据共享过程中海量历史数据的读写性能和可维护性。方法应用Oracle表分区技术和索引分区技术对公共卫生数据共享系统管理系统进行了优化。结果大大改善了系统性能,成倍提高了查询和统计的速度;提高了系统的可用性,数据备份与恢复工作更宜操作。结论采用有效合理的分区管理策略,能显著提高海量数据的读写性能和可维护性。
|
| 关 键 词： | 海量数据管理 Oracle分区表 索引分区 公共卫生数据共享 |
Application Research on Oracle Database Partitioning Technology in Public Health Data Sharing |
| |
| WANG Song-wang,ZHANG Ying-jie,FAN Xiu-e.Chinese Center for Disease Control , Prevention,Beijing ,China.Application Research on Oracle Database Partitioning Technology in Public Health Data Sharing[J].Chinese Journal of Public Health Engineering,2010(2):88-90. |
| |
| Authors: | WANG Song-wang ZHANG Ying-jie FAN Xiu-eChinese Center for Disease Control Prevention Beijing China |
| |
| Institution: | WANG Song-wang,ZHANG Ying-jie,FAN Xiu-e.Chinese Center for Disease Control , Prevention,Beijing 102206,China |
| |
| Abstract: | Objective To improve massive historical data read-write performance and maintainability in public health data sharing.Methods The public health data sharing system was optimized by applying oracle partitioning and partitioned index technology.Results Performance and availability was greatly improved,the speed of the query and statistical was raised several times,data backup and recovery has become easier to operate.Conclusion The partitioning technology can obviously enhance the magnanimous data the read-wr... |
| |
| Keywords: | Massive data management Oracle partitioning Partitioned index Public health data sharing |
| 本文献已被 CNKI 维普 等数据库收录！ |
