Oracle分区技术在公共卫生数据共享中的应用研究

Application Research on Oracle Database Partitioning Technology in Public Health Data Sharing

目的提高公共卫生数据共享过程中海量历史数据的读写性能和可维护性。方法应用Oracle表分区技术和索引分区技术对公共卫生数据共享系统管理系统进行了优化。结果大大改善了系统性能,成倍提高了查询和统计的速度;提高了系统的可用性,数据备份与恢复工作更宜操作。结论采用有效合理的分区管理策略,能显著提高海量数据的读写性能和可维护性。

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-write performance and the maintainability.