Hybrid Storage Strategy with MongoDB and MySQL for E-government

doi:10.3969/j.issn.1006-2475.2014.08.014

Abstract

Abstract:

For the defects of relational database used in traditional e-government platform when storing

unstructured data, the advantages of MongoDB in storing mass unstructured data are used to put forward a hybrid

storage strategy with MongoDB and MySQL. MongoDB is responsible for storing unstructured data such as pictures,

video. MySQL is responsible for storing structured data such as user registration information, payroll. Both

of them work together to provide data cloud storage services and query operations of e-government data, thereby

reducing the load on the database server of MySQL, saving the storage space and enhancing the scalability of e-

government back-end database. Comparative tests show that the hybrid strategy can greatly improve the query

efficiency of e-government platform.

Key words:

electronic government, relational database, MongoDB, MySQL, structured data, unstructured data, query

efficiency

CLC Number:

TP391

WU Xiu-jun. Hybrid Storage Strategy with MongoDB and MySQL for E-government[J]. Computer and Modernization, doi: 10.3969/j.issn.1006-2475.2014.08.014.

References ［17］

［1］	蒋兴龙. 电子政务个性化服务体系结构研究［D］. 成都:电子科技大学, 2006.
［2］	傅荣校,叶斌. 政务信息管理与数据库管理技术的适用性研究［J］. 档案学通讯, 2007(6):64-68.
［3］	Grimes S. Structure, Models and Meaning: Is “Unstructured” Data Merely Unmodeled?［DB/OL］.
	http://www.informationweekcom/software/information-management/structure-models-and-meaning/d/d-id/1030187?,
20	05-07-02.
［4］	工业和信息化部信息化推进司. 基于云计算的电子政务公共平台顶层设计指南［DB/OL］.
	http://www.zbeic.gov.cn/art/2013/3/18/art_2304_147320.html, 2013-03-18.
［5］	陈金水,王崟. 非结构化数据存储管理的实用化方法［J］. 计算机与现代化, 2006(8):25-28.
［6］	Plugge E, Membrey P, Hawkins T. The Definitive Guide to MongoDB: The NoSQL Database for Cloud and Desktop
	Computing［M］. APress, 2010:106-107.
［7］	张俊,周新,于素华,等. NoSQL数据管理技术［J］. 科研信息化技术与应用, 2013,4(1):3-11.
［8］	秦秀磊,张文博,魏峻,等. 云计算环境下分布式缓存技术的现状与挑战［J］. 软件学报, 2013,24(1):50-66.
［9］	Liu Yimeng. Research on the improvement of MongoDB auto-sharding in cloud environment［J］. Computer
	Science & Education, 2012,7(2):851-854.
［10］	覃雄派,王会举,杜小勇,等. 大数据分析——RDBMS与MapReduce的竞争与共生［J］. 软件学报, 2012,23(1):32-45.
［11］	Krill P. MongoDB Co-author: Enterprises to Start Adding NoSQL［DB/OL］. http://www.infoworld.com/d/data-
	management/mongodb-co-author-enterprises-start-adding-nosql-170766, 2011-08-24.
［12］	张华强. 关系型数据库与NoSQL 数据库［J］. 电脑知识与技术, 2011,7(20):4802-4804.
［13］	王珊,萨师煊. 数据库系统概论［M］. 北京:高等教育出版社, 2007:41-42.
［14］	陈莉莹,双锴. NoSQL数据库综述［DB/OL］. http://wenku.baidu.com/link?url=XZrUxsHGkYWUCfli4Ma06M8AE-
	pI8l5q1gn0JLnMqq1-fAHFDShKSs0az1Aw1PECyhm01dzqrLb-WrsGQ-WYuIjrE4XcxiEmWDiA_Odv3Vx5q, 2013-11-09.
［15］	孟小峰,慈祥. 大数据管理:概念、技术与挑战［J］. 计算机研究与发展, 2013,50(1):146-169.
［16］	Brewer E A. Towards robust distributed systems［C］// Proceedings of the 19th Annual ACM Symposium on
	Principles of Distributed Computing. 2000:7-10.
［17］	刘一梦. 基于MongoDB的云数据管理技术的研究与应用［D］. 北京:北京交通大学, 2012.

[1]	HUANG AN-qi, MIAO Fang, YANG Wen-hui, NI Ya-ting, JIANG Yuan. Design of Structured Data Registration Engine Based on Data Architecture [J]. Computer and Modernization, 2022, 0(05): 82-89.
[2]	CHEN Hao, ZHANG Ya, LUO Xi-chang, ZHANG Ya-li, LIU Wen-jing. Meteorological Data Storage and Retrieval System Based on MongoDB [J]. Computer and Modernization, 2020, 0(08): 100-104.
[3]	LIU Si-tong1, LUO Jun1, ZHAN Huo-mu2. Research on Mapping and Storing OWL File to Relational Database [J]. Computer and Modernization, 2017, 0(5): 83-87.
[4]	WU Fei, MAO Yu-guang. A Multi-null Value Estimation Method Based on Multi-table Relationship Information in Relational Database [J]. Computer and Modernization, 2016, 0(6): 117-122.
[5]	LI Wei-yao, ZHAO Kai. Network Hot Event Mining Algorithm Based on Feature Extraction [J]. Computer and Modernization, 2015, 0(5): 17-20.
[6]	GUO Qi-zhi, CHEN Guang, REN Zhuo-jun, LUO Jin-long. Laboratory Management System Based on Android Smart Phone [J]. Computer and Modernization, 2015, 0(10): 73-76.
[7]	LIU Jun-xia;;WANG Lei;ZHOU Xi. Research on Electronic Government Cloud Platform for Mass Data [J]. Computer and Modernization, 2013, 1(7): 164-168.
[8]	CHEN Chao. Spanner Database Trial [J]. Computer and Modernization, 2013, 1(4): 70-72.
[9]	DONG Zhangzhuo;KONG Yongchao;LUO Ning;ZHAO Yuanpeng. Design of CIM Storage Solution in Relational Database [J]. Computer and Modernization, 2013, 1(11): 128-132.
[10]	JIANG Hui;WANG Da-ju. Design and Implementation of Online Judge System [J]. Computer and Modernization, 2012, 198(2): 111-115.
[11]	ZHAO Feng. Research and Implementation of Aviation Insurance Agent Sales System Based on LAMP [J]. Computer and Modernization, 2011, 193(9): 191-194.
[12]	XU You-fang. Design and Implementation of Admissions Management System of Undergraduate Degree for College Student Based on B/S [J]. Computer and Modernization, 2011, 1(8): 104-106.
[13]	LIU Zhen;YANG Sheng-bin;ZHANG Jin-hong. Design and Development of Online Assignment Management System Based on J2EE [J]. Computer and Modernization, 2011, 7(7): 154-156.
[14]	HUANG Wei. Intelligent Retrieval System of Enterprise Information [J]. Computer and Modernization, 2011, 1(6): 203-4.
[15]	WANG Fang;CHEN Hai-jian. Research on Keyword Search over Relational Database [J]. Computer and Modernization, 2011, 1(11): 142-4.