Middleware of Database System Fragmentation
DOI:
CSTR:
Author:
Affiliation:

Clc Number:

Fund Project:

  • Article
  • |
  • Figures
  • |
  • Metrics
  • |
  • Reference
  • |
  • Related
  • |
  • Cited by
  • |
  • Materials
  • |
  • Comments
    Abstract:

    As the successively implementation of State Grid's information system first-degree deployment, the tables in database become much more than before, the datas in table become very large. Massive data storage and access caused considerable load on the database, data processing capacity and access encounter bottlenecks. The amount of data is growing rapidly based on State Grid first-degree deployment, this paper proposed data fragmentation middleware UAPDS (UAP DB Sharding) technology. UAPDS provides multiple split solutions, such as separated of reading and writing, divided into multiple tables in a database or in multiple databases, by router, partition, shard three layer split mode, the data cut into different databases or tables according to certain rules, effectively relieve the pressure on the database, improved the efficiency of data access, achieved better in the practical application effect.

    Reference
    Related
    Cited by
Get Citation

王亚玲,杨超,章名尚.数据库系统应用分片中间件.计算机系统应用,2015,24(10):74-79

Copy
Share
Article Metrics
  • Abstract:
  • PDF:
  • HTML:
  • Cited by:
History
  • Received:January 29,2015
  • Revised:April 02,2015
  • Adopted:
  • Online: October 17,2015
  • Published:
Article QR Code
You are the firstVisitors
Copyright: Institute of Software, Chinese Academy of Sciences Beijing ICP No. 05046678-3
Address:4# South Fourth Street, Zhongguancun,Haidian, Beijing,Postal Code:100190
Phone:010-62661041 Fax: Email:csa (a) iscas.ac.cn
Technical Support:Beijing Qinyun Technology Development Co., Ltd.

Beijing Public Network Security No. 11040202500063