基于表分区和内存数据库的族谱生成系统优化

摘要

论文为现有的族谱系统数据存储提出一种优化的存储方案--基于表分区的存储方案.分析现有的族谱系统在数据存储方案上的不足,参考PostgreSQL的表分区技术,使用表分区方案来对族谱人物及关系数据重新建模和存储,提高了对族谱数据的管理和操作效率;基于现有族谱生成系统在族谱生成过程中对数据处理的特点,引入内存数据库技术,采用内存数据库SQLite在数据处理过程中存储数据,提高了对数据的处理效率.实验部分测试了使用表分区和内存数据库技术的可行性和性能影响,实验结果表明,使用表分区方案和内存数据库技术方案可以支持族谱数据的存储和族谱生成过程中内存数据的处理需求,并且在一定程度上优化族谱生成系统的性能.%This paper proposes an optimal storage solution for the genealogy data storage system-storage solution based on the table partition.The shortage of existing data storage solution on the genealogy system is analyzed, the genealogy data is re-modeled and storaged with the help of the PostgreSQL table partition.This method improves the management and operational efficiencyof genealogy data, based on the characteristics of data processing in the existing system , inmain memory database technology is brought.Thus, using SQLite database to store data in memory can improve the efficiency ofdata processing.Experiments test the feasibility and properties of table partition and main memory database technology.It turns out that the use of table partition scheme and main memory database technology can support the storage and processing requirements and partly optimize the performance of genealogy system.