计算机与数字工程2017，Vol.45Issue(2)：272-278,7.DOI:10.3969/j.issn.1672-9722.2017.02.015
基于表分区和内存数据库的族谱生成系统优化
Genealogy Generation System Optimization Based on Table Partition andMain Memory Database
徐明民 1彭中华 2王黎维2
作者信息
- 1. 武汉大学计算机学院 武汉 430072
- 2. 武汉大学国际软件学院 武汉 430072
- 折叠
摘要
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.关键词
族谱/PostgreSQL/表分区/内存数据库/SQLiteKey words
genealogy/PostgreSQL/table partition/main memory database/SQLite 分类
信息技术与安全科学引用本文复制引用
徐明民,彭中华,王黎维..基于表分区和内存数据库的族谱生成系统优化[J].计算机与数字工程,2017,45(2):272-278,7.
