CN104503974B - 一种基于云平台的关系数据库自动优化方法 - Google Patents
一种基于云平台的关系数据库自动优化方法 Download PDFInfo
- Publication number
- CN104503974B CN104503974B CN201410652028.3A CN201410652028A CN104503974B CN 104503974 B CN104503974 B CN 104503974B CN 201410652028 A CN201410652028 A CN 201410652028A CN 104503974 B CN104503974 B CN 104503974B
- Authority
- CN
- China
- Prior art keywords
- workprocess
- database
- processes
- plug
- optimizing
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Expired - Fee Related
Links
- 238000000034 method Methods 0.000 title claims abstract description 68
- 238000005457 optimization Methods 0.000 title claims abstract description 38
- 230000008569 process Effects 0.000 claims abstract description 54
- 230000008859 change Effects 0.000 claims description 13
- 230000004087 circulation Effects 0.000 claims description 12
- 230000006870 function Effects 0.000 claims description 8
- 238000009434 installation Methods 0.000 claims description 2
- 230000007423 decrease Effects 0.000 description 7
- 239000002699 waste material Substances 0.000 description 3
- 241000208340 Araliaceae Species 0.000 description 2
- 235000005035 Panax pseudoginseng ssp. pseudoginseng Nutrition 0.000 description 2
- 235000003140 Panax quinquefolius Nutrition 0.000 description 2
- 230000009471 action Effects 0.000 description 2
- 230000006978 adaptation Effects 0.000 description 2
- 230000003466 anti-cipated effect Effects 0.000 description 2
- 238000013480 data collection Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 235000008434 ginseng Nutrition 0.000 description 2
- 230000009467 reduction Effects 0.000 description 2
- 230000032683 aging Effects 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/217—Database tuning
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (4)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410652028.3A CN104503974B (zh) | 2014-11-17 | 2014-11-17 | 一种基于云平台的关系数据库自动优化方法 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410652028.3A CN104503974B (zh) | 2014-11-17 | 2014-11-17 | 一种基于云平台的关系数据库自动优化方法 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN104503974A CN104503974A (zh) | 2015-04-08 |
CN104503974B true CN104503974B (zh) | 2017-07-18 |
Family
ID=52945372
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201410652028.3A Expired - Fee Related CN104503974B (zh) | 2014-11-17 | 2014-11-17 | 一种基于云平台的关系数据库自动优化方法 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN104503974B (zh) |
Families Citing this family (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105320569A (zh) * | 2015-11-04 | 2016-02-10 | 浪潮(北京)电子信息产业有限公司 | 一种提升数据库服务器性能的方法及*** |
CN108733750A (zh) * | 2018-04-04 | 2018-11-02 | 安徽水利开发股份有限公司 | 一种数据库优化方法 |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101059810A (zh) * | 2007-03-16 | 2007-10-24 | 华为技术有限公司 | 一种实现数据库***自动优化的***和方法 |
CN103064664A (zh) * | 2012-11-28 | 2013-04-24 | 华中科技大学 | 一种基于性能预估的Hadoop参数自动优化方法和*** |
CN103905234A (zh) * | 2012-12-28 | 2014-07-02 | 北京友友天宇***技术有限公司 | 提高分布式***中资源可用性的方法及*** |
Family Cites Families (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US8447776B2 (en) * | 2010-08-30 | 2013-05-21 | International Business Machines Corporation | Estimating and managing energy consumption for query processing |
-
2014
- 2014-11-17 CN CN201410652028.3A patent/CN104503974B/zh not_active Expired - Fee Related
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101059810A (zh) * | 2007-03-16 | 2007-10-24 | 华为技术有限公司 | 一种实现数据库***自动优化的***和方法 |
CN103064664A (zh) * | 2012-11-28 | 2013-04-24 | 华中科技大学 | 一种基于性能预估的Hadoop参数自动优化方法和*** |
CN103905234A (zh) * | 2012-12-28 | 2014-07-02 | 北京友友天宇***技术有限公司 | 提高分布式***中资源可用性的方法及*** |
Non-Patent Citations (2)
Title |
---|
基于Oracle数据库SQL查询优化研究;张学义 等;《制造业自动化》;20110131;第33卷(第1期);第116-118、121页 * |
基于Oracle数据库优化性能监控***的设计与实现;蒋林华;《井冈山大学学报》;20120331;第33卷(第2期);第68-71页 * |
Also Published As
Publication number | Publication date |
---|---|
CN104503974A (zh) | 2015-04-08 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US11714686B2 (en) | Resource oversubscription based on utilization patterns in computing systems | |
CN108173698B (zh) | 网络服务管理方法、装置、服务器及存储介质 | |
CN109508432B (zh) | 一种基于区块链的高性能faas*** | |
CN104133727A (zh) | 基于实时资源负载分配的方法 | |
WO2020186376A1 (en) | Techniques to forecast financial data using deep learning | |
CN114879948B (zh) | 基于WebAssembly的智能合约处理方法、装置、设备及存储介质 | |
CN110647392A (zh) | 一种基于容器集群的智能弹性伸缩方法 | |
CN108650334A (zh) | 一种会话失效的设置方法及装置 | |
CN104503974B (zh) | 一种基于云平台的关系数据库自动优化方法 | |
CN111510959A (zh) | 一种部署nRT RIC功能的方法和设备 | |
Gu et al. | Energy‐Efficient Computation Offloading and Transmit Power Allocation Scheme for Mobile Edge Computing | |
CN109271247A (zh) | 内存优化方法、装置、计算机装置以及存储介质 | |
US11455293B2 (en) | Counting method, counter and storage medium | |
US11232228B2 (en) | Method and device for improving data storage security | |
CN102427468A (zh) | 一种云计算操作***及其调度方法 | |
Yang et al. | Study on static task scheduling based on heterogeneous multi-core processor | |
US10572486B2 (en) | Data communication in a distributed data grid | |
CN114003238B (zh) | 一种基于转码卡的容器部署方法、装置、设备及存储介质 | |
CN116521358A (zh) | 一种实时***运行电力边缘计算芯片的方法及装置 | |
CN106708542A (zh) | 一种嵌入式操作***代码加载的方法及装置 | |
CN116841720A (zh) | 资源配置方法、装置、计算机设备、存储介质及程序产品 | |
CN111400034B (zh) | 一种面向多核处理器的波形资源分配方法 | |
CN114021833A (zh) | 一种线损预测方法、***、存储介质及计算设备 | |
CN108595367B (zh) | 一种基于局域网内计算机集群的服务器*** | |
CN109656697A (zh) | 一种双模式资源受限周期任务能耗优化方法 |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant | ||
CP02 | Change in the address of a patent holder |
Address after: 310000 room 821, building 1, Xinjun building, 330 Internet of things street, Xixing street, Binjiang District, Hangzhou City, Zhejiang Province Patentee after: HANGZHOU SKY NETWORK TECHNOLOGY CO.,LTD. Address before: 10, 310013, The Union Buildings, No. 2, Bauhinia Road, Hangzhou, Zhejiang, Xihu District Patentee before: HANGZHOU SKY NETWORK TECHNOLOGY CO.,LTD. |
|
CP02 | Change in the address of a patent holder | ||
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20210408 Address after: 355200 no.181 erbatou, taimuyang village, Qinyu Town, Fuding City, Ningde City, Fujian Province Patentee after: Chen Ximei Address before: Room 821, building 1, Xinjun building, 330 Internet of things street, Xixing street, Binjiang District, Hangzhou City, Zhejiang Province 310000 Patentee before: HANGZHOU SKY NETWORK TECHNOLOGY Co.,Ltd. |
|
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20210421 Address after: 101599 room 208-826, Jugezhuang town government, Miyun District, Beijing Patentee after: Beijing Zhongjing Century Technology Co.,Ltd. Address before: No. 181, erbatou, taimuyang village, Qinyu Town, Fuding City, Ningde City, Fujian Province Patentee before: Chen Ximei |
|
CF01 | Termination of patent right due to non-payment of annual fee | ||
CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20170718 |