Application Research on Oracle Database Partitioning Technology in Public Health Data Sharing
Fan Xiu · Chinese Journal of Public Health Engineering · 2010
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.