CN104503974A - 一种基于云平台的关系数据库自动优化方法 - Google Patents
一种基于云平台的关系数据库自动优化方法 Download PDFInfo
- Publication number
- CN104503974A CN104503974A CN201410652028.3A CN201410652028A CN104503974A CN 104503974 A CN104503974 A CN 104503974A CN 201410652028 A CN201410652028 A CN 201410652028A CN 104503974 A CN104503974 A CN 104503974A
- Authority
- CN
- China
- Prior art keywords
- workprocess
- database
- code
- plug
- automatic
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 60
- 238000005457 optimization Methods 0.000 title claims abstract description 37
- 230000006870 function Effects 0.000 claims description 8
- 238000013404 process transfer Methods 0.000 claims description 8
- 238000010586 diagram Methods 0.000 description 3
- 239000002699 waste material Substances 0.000 description 3
- 230000003750 conditioning effect Effects 0.000 description 2
- 238000013480 data collection Methods 0.000 description 2
- 230000032683 aging Effects 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 230000007423 decrease Effects 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 230000000694 effects 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 true CN104503974A (zh) | 2015-04-08 |
CN104503974B 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) |
Cited By (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 (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101059810A (zh) * | 2007-03-16 | 2007-10-24 | 华为技术有限公司 | 一种实现数据库***自动优化的***和方法 |
US20120054514A1 (en) * | 2010-08-30 | 2012-03-01 | International Business Machines Corporation | Estimating and managing energy consumption for query processing |
CN103064664A (zh) * | 2012-11-28 | 2013-04-24 | 华中科技大学 | 一种基于性能预估的Hadoop参数自动优化方法和*** |
CN103905234A (zh) * | 2012-12-28 | 2014-07-02 | 北京友友天宇***技术有限公司 | 提高分布式***中资源可用性的方法及*** |
-
2014
- 2014-11-17 CN CN201410652028.3A patent/CN104503974B/zh not_active Expired - Fee Related
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101059810A (zh) * | 2007-03-16 | 2007-10-24 | 华为技术有限公司 | 一种实现数据库***自动优化的***和方法 |
US20120054514A1 (en) * | 2010-08-30 | 2012-03-01 | International Business Machines Corporation | Estimating and managing energy consumption for query processing |
CN103064664A (zh) * | 2012-11-28 | 2013-04-24 | 华中科技大学 | 一种基于性能预估的Hadoop参数自动优化方法和*** |
CN103905234A (zh) * | 2012-12-28 | 2014-07-02 | 北京友友天宇***技术有限公司 | 提高分布式***中资源可用性的方法及*** |
Non-Patent Citations (2)
Title |
---|
张学义 等: "基于Oracle数据库SQL查询优化研究", 《制造业自动化》 * |
蒋林华: "基于Oracle数据库优化性能监控***的设计与实现", 《井冈山大学学报》 * |
Cited By (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 | 安徽水利开发股份有限公司 | 一种数据库优化方法 |
Also Published As
Publication number | Publication date |
---|---|
CN104503974B (zh) | 2017-07-18 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US11797343B2 (en) | Data management for edge architectures | |
Damaskinos et al. | Fleet: Online federated learning via staleness awareness and performance prediction | |
CN102495857B (zh) | 一种分布式数据库的负载均衡方法 | |
CN103218175B (zh) | 多租户的云存储平台访问控制*** | |
CN103078933B (zh) | 一种确定数据迁移时机的方法和装置 | |
Jie et al. | Game-theoretic online resource allocation scheme on fog computing for mobile multimedia users | |
US9244520B2 (en) | Techniques for managing power and performance of multi-socket processors | |
CN103617211A (zh) | 一种HBase加载数据的导入方法 | |
CN103037109B (zh) | 多核设备能耗管理方法及装置 | |
CN103700041A (zh) | 基于云计算的智能电网负荷预测管理平台 | |
CN103631894A (zh) | 一种基于hdfs的动态副本管理方法 | |
CN105094997A (zh) | 一种云计算主机节点间物理内存共享方法和*** | |
WO2021114025A1 (zh) | 增量数据确定方法、确定装置、服务器及终端设备 | |
WO2015051685A1 (zh) | 一种任务调度方法、装置及*** | |
CN103744618A (zh) | 实现团队共享存储的方法及*** | |
CN114879948B (zh) | 基于WebAssembly的智能合约处理方法、装置、设备及存储介质 | |
Wang et al. | A Data-Aware Remote Procedure Call Method for Big Data Systems. | |
CN103023802B (zh) | 一种面向web集群的低能耗调度***和方法 | |
Spivak et al. | Data preloading and data placement for MapReduce performance improving | |
CN104503974A (zh) | 一种基于云平台的关系数据库自动优化方法 | |
CN108287876B (zh) | 支持多种格式的电能质量数据服务质量检测方法和装置 | |
Riaz | Energy consumption in hand-held mobile communication devices: A comparative study | |
WO2021120068A1 (zh) | 管理存储器供电状态的方法及芯片 | |
Ramesh et al. | Energy management in embedded systems: Towards a taxonomy | |
CN104111892A (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 |