计算机技术与发展2018，Vol.28Issue(3)：11-14,4.DOI:10.3969/j.issn.1673-629X.2018.03.003
基于Postgres-XL的数据管理优化技术研究
Study on Optimization Technology of Data Management Based on Postgres-XL
摘要
Abstract
As the amount of data in the city grows rapidly,the performance of stand-alone database is clearly deficient.In order to solve problems of low performance,poor scalability and the security of database,it is necessary to use the open-source distributed database in data management.As an open source and horizontally-scalable database that meets the requirement of ACID and is secure for multiple tenancies,Postgres-XL can efficiently complete the data management.In order to further improve the efficiency of Postgres-XL,the ex-pansion and storage management modules of Postgres-XL are studied.Firstly we propose to utilize the table inheritance and other charac-teristics of Postgres-XL to complete the table split,then use Redis as the cache of Postgres-XL based on SQL/MED middleware,and in-crease SSD cache modules in the external memory management module of Postgres-XL in the end.Experiments show that proposed opti-mization strategies can effectively reduce the latency of the database request and improve the processing efficiency of Postgres-XL.关键词
Postgres-XL/二级缓存/分区表/Redis/SSDKey words
Postgres-XL/secondary cache/partition table/Redis/SSD分类
信息技术与安全科学引用本文复制引用
艾丽蓉,李凯..基于Postgres-XL的数据管理优化技术研究[J].计算机技术与发展,2018,28(3):11-14,4.基金项目
国家自然科学基金(61502371) （61502371）
