Genealogy Generation System Optimization Based on Table Partition andMain Memory Database
XU Mingmin
PENG Zhonghua
WANG Liwei
Abstract：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.
Keywords：genealogyPostgreSQLtable partitionmain memory databaseSQLite
Publication Date：2017-01-01
Online Publishing Date：2025-08-15(First online date of this platform, not the publication date of the document)
Pages：7( 272-278 )