Partition Technology and Application in Large Scale Population Information System
This paper proposes a solution to improve the efficiency of querying and processing large-scale data using partition technologies. The database physical design, partitioning principle and strategy are presented. With a Nation-wide Population Information System as a case study, three partitioning strategies are rigorously analyzed to fulfill the requirements of the real-world system. According to each partitioning strategy, a method of partitioning tables and index is also presented. The whole solution is validated in a simulation environment. The simulation results demonstrate the practical usage of the solution proposed. Moreover, the experience from this project provides guidelines of applying partition technology for other similar systems that have querying requirement on large-scale data.
Partition Technology Partitioned Tables Optimization Large Scale Population System
Zhaoxia Lu Jie Xi Jian Wang
Software Center, Northeastern University Shenyang, Liaoning 110004, China College of Information Science of Engineering, Northeastern University Shenyang, Liaoning 110004, Ch
国际会议
杭州
英文
958-960
2006-10-12(万方平台首次上网日期,不代表论文的发表时间)