企业级数据库云平台的建设与运维方案

doi:10.3969/j.issn.1000-0801.2012.02.028

Abstract

Abstract:

In recent years,cloud computing is gaining more and more concern especially in telecommunication company.When telecom company searches for a low-cost,centralized,the whole network of operation method,cloud computing is the most appreciated solution.In this paper,we describe cloud computing related requirements of telecommunications business,especially in database cloud area,the architecture of database cloud,and the best practice to realize those database cloud platform and architecture.We also analysis the change of operation and maintenance the database cloud bring to us.

Key words: cloud computing, telecom company, cloud database, PaaS

Yong Liang,Panxiang Zhang,Qiuhua Chen. Construction and Operation Program of Enterprise-Class Database Cloud Platform[J]. Telecommunications Science, 2012, 28(2): 146-155.

测试用例	生产运行时间	Exadata运行串行时间	性能提升比
告警SQL1	50 h	0:01:47	1 682倍
告警SQL2	193 min	0:01:31	127倍
告警SQL3	29 min	0:00:02	870倍
告警SQL4	17 min	0:00:01	1 020倍
告警SQL5	未执行完，运行了323 min，报错	0:01:08	无穷倍（至少285倍）
性能SQL1	8 min（每个进行平均时间）,47 min（6个并发进程总时间）	00:00:11	44倍
性能SQL2	6 750 s	0:00:01	6 750倍
性能SQL3	约12 h	0:00:12	3 600倍
性能SQL1-2	一个网元大约需3 min，一个时间点有693个网元，所有网元串行计算完大约需要2 000 min	0:01:16	40倍

压缩类型	记录数（个）	大小（MB）	压缩比（压缩前/压缩后）	表创建时间（s）
TFA_ALARM_CLR（非压缩表）	57 781 593	67 256		0:00:53
TFA_ALARM_CLR（压缩表）	57 781 593	9 722	7倍	0:01:26
FACT_NCELLREL_IN（非压缩表）	28 132 204	3 076		0:00:06
FACT_NCELLREL_IN（压缩表）	28 132 204	297	10倍	0:00:08

[1]	Xue HAN. Damage toughness assessment method of power backbone communication network based on power big data [J]. Telecommunications Science, 2023, 39(5): 136-143.
[2]	Jiangxing WU. Revolution of the development paradigm of network technology system—network of networks [J]. Telecommunications Science, 2022, 38(6): 3-12.
[3]	Wenjuan XING, Bo LEI, Qianying ZHAO. Development status and trend prospect of computing power infrastructure [J]. Telecommunications Science, 2022, 38(6): 51-61.
[4]	Pingke DENG, Tongxu ZHANG, Nanxiang SHI, Tong ZHANG, Tianzhu SHAO, Shaowen ZHENG. Computing satellite networks—the novel development of computing-empowered space-air-ground integrated networks [J]. Telecommunications Science, 2022, 38(6): 71-81.
[5]	Kun MA, Lingyu XU, Xiaoping SHEN, Zhicheng GONG, Jianping LAN, Shuangxi CHEN, Jun QIAN. Virtual machine scheduling model based on Shapley value modified genetic algorithm in cloud computing [J]. Telecommunications Science, 2022, 38(12): 1-10.
[6]	Zhihong CHEN, Yuan YAO. Research on integration of government information system based on cloud computing [J]. Telecommunications Science, 2021, 37(9): 118-128.
[7]	Zhiyong LIU, Zhongjiang HE, Yilong RUAN, Junfeng SHAN, Chao ZHANG. Big data security features and operation practices [J]. Telecommunications Science, 2021, 37(5): 160-169.
[8]	Jian XU,Li JIN. A quantifiable cloud computing platform security evaluation model [J]. Telecommunications Science, 2020, 36(7): 163-167.
[9]	Sining LUO,Hualong WANG,Hongyu LI,Wei PENG. Improved ant colony algorithm based cloud computing user task scheduling algorithm [J]. Telecommunications Science, 2020, 36(2): 95-100.
[10]	Bo LEI, Zengyi LIU, Xuliang WANG, Mingchuan ·ANG, ·unqing CHEN. Computing network:a new multi-access edge computing [J]. Telecommunications Science, 2019, 35(9): 44-51.
[11]	Yongmei GAO,Guanjie CHENG. Data-intensive service deployment based on edge computing [J]. Telecommunications Science, 2019, 35(7): 87-99.
[12]	Zelin LU,Qiangzhi LI. Evolutionary logic and operational mechanism of E-commerce platform [J]. Telecommunications Science, 2019, 35(7): 152-158.
[13]	Zhilan HUANG,Yongbing FAN,Ning FAN,Nan CHEN,Linze WU,Baohong LIN. Solution and key technology of integrating vFW in cloud platform [J]. Telecommunications Science, 2019, 35(5): 140-148.
[14]	Youkang ZHU,Guangxue YUE,Xiaohui YANG,Jiansheng LIU. A survey on edge computing offloading [J]. Telecommunications Science, 2019, 35(4): 74-94.
[15]	Guowei WU,Ning FAN,Laifu WANG,Shuai WANG,Jun SHEN,Huamin JIN. Accelerated algorithm in attribute-based encryption over cloud environment [J]. Telecommunications Science, 2019, 35(11): 101-107.

Construction and Operation Program of Enterprise-Class Database Cloud Platform

RichHTML

PDF下载

Knowledge

Cited

Abstract

Cite this article

share this article

Figures/Tables 16

References

Related Articles 15

Metrics

Recommended 0