结构化查询语言动态功耗解析及建模

doi:10.11772/j.issn.1001-9081.2015.12.3362

计算机应用 ›› 2015, Vol. 35 ›› Issue (12): 3362-3367.DOI: 10.11772/j.issn.1001-9081.2015.12.3362

结构化查询语言动态功耗解析及建模

国冰磊¹, 于炯¹, 廖彬², 杨德先¹

1. 新疆大学软件学院, 乌鲁木齐 830008;
2. 新疆财经大学统计与信息学院, 乌鲁木齐 830012

收稿日期:2015-05-25 修回日期:2015-07-18 出版日期:2015-12-10 发布日期:2015-12-10
通讯作者: 国冰磊(1991-),女,湖北襄阳人,硕士研究生,CCF会员,主要研究方向:云计算、绿色计算
作者简介:于炯(1964-),男,北京人,教授,博士生导师,博士,主要研究方向:云计算、大数据;杨德先(1991-),男,新疆塔城人,硕士研究生,主要研究方向:云计算、绿色计算;廖彬(1986-),男,四川内江人,副教授,博士,主要研究方向:数据库、绿色计算、数据挖掘。
基金资助:
国家自然科学基金资助项目(61462079,61363083,61262088);新疆自然科学基金资助项目(2011211A011)。

Dynamic power consumption profiling and modeling by structured query language

GUO Binglei¹, YU Jiong¹, LIAO Bin², YANG Dexian¹

1. School of Software, Xinjiang University, Urumqi Xinjiang 830008, China;
2. College of Statistics and Information, Xinjiang University of Finance and Economics, Urumqi Xinjiang 830012, China

Received:2015-05-25 Revised:2015-07-18 Online:2015-12-10 Published:2015-12-10

摘要/Abstract

摘要： 为构建节能的绿色数据库,提出一种基于结构化查询语言(SQL)资源(中央处理单元(CPU)、磁盘)消耗的最小单位的数据库动态能耗模型。该模型对系统动态能耗进行解析,将系统主要硬件(CPU、磁盘)的资源消耗映射成功率消耗,采用多元线性回归方法拟合模型关键参数,实时地估算系统动态功率,构建单位统一的动态功耗模型。实验结果表明,相比基于元组总数的模型,CPU指令总数能更好地反映CPU的功率消耗,所构模型在数据库管理系统(DBMS)独占系统资源的静态环境下,平均相对误差小于6%,绝对误差不超过9%。该动态功耗模型更适合于构建节能的绿色数据库。

关键词: 绿色计算, 查询处理, 执行计划, 结构化查询语言, 功耗建模

Abstract: In order to build energy-saving green database, a database model of dynamic power consumption based on the smallest unit of Structured Query Language (SQL) resource (Central Processing Unit (CPU), disk) consumption. The proposed model profiled the dynamic power consumption and mapped the main hardwares (CPU, disk) resource consumption to power consumption. Key parameters of the model were fitted by adopting the method of multiple linear regression to estimate the dynamic system power in real-time and build the unit-unified model of dynamic power consumption. The experimental results show that, compared with the model based on the total number of tuples, the total number of CPU instructions can better reflect the CPU power consumption. The average relative error of the constitutive model is less than 6% and the absolute error of the constitutive model is less than 9% while the DataBase Management System (DBMS) monopolizes system resources in the static environment. The proposed dynamic power consumption model is more suitable for building energy-saving green database.

Key words: green computing, query processing, execution plan, Structured Query Language (SQL), power consumption modeling

中图分类号:

TP315

国冰磊, 于炯, 廖彬, 杨德先. 结构化查询语言动态功耗解析及建模[J]. 计算机应用, 2015, 35(12): 3362-3367.

GUO Binglei, YU Jiong, LIAO Bin, YANG Dexian. Dynamic power consumption profiling and modeling by structured query language[J]. Journal of Computer Applications, 2015, 35(12): 3362-3367.

参考文献

[1] KATZ R H. TechTitans building boom[J]. IEEE Spectrum, 2009, 46(2):40-54.
[2] BROWN R E, MASANET E, NORDMAN B, et al. Report to congress on server and data center energy efficiency, Public Law 109-431[R]. Berkeley:Lawrence Berkeley National Laboratory, 2007.
[3] GLANZ J. Power, pollution and the Internet[N]. The New York Times, 2012-09-22.
[4] Global Action Plan. An inefficient truth[EB/OL].[2015-05-01]. http://globalactionplan.org.uk.
[5] JIN P, XING B, JIN Y, et al. Survey on energy-aware green databases[J]. Journal of Computer Applications, 2014, 34(1):46-53. (金培权,邢宝平,金勇,等.能耗感知的绿色数据库研究综述[J].计算机应用,2014,34(1):46-53.)
[6] GRAY J. Tape is dead, disk is tape, flash is disk, RAM locality is king[EB/OL].[2015-05-01]. http://www.csd.uoc.gr/~hy460/pdf/Flash_is_Good.pdf.
[7] WANG J, LAI W, MENG X. Flash-based database:studies, techniques and forecasts[J]. Chinese Journal of Computers, 2013, 36(8):1549-1567. (王江涛,赖文豫,孟小峰.闪存数据库:现状、技术与展望[J].计算机学报,2013,36(8):1549-1567.)
[8] KANSAL A, ZHAO F, LIU J, et al. Virtual machine power metering and provisioning[C]//Proceedings of the 1st ACM Symposium on Cloud Computing. New York:ACM, 2010:39-50.
[9] LIAO B, YU J, ZHANG T, et al. Energy-efficient algorithms for distributed file system HDFS[J]. Chinese Journal of Computers, 2013, 36(5):1047-1064. (廖彬,于炯,张陶,等.基于分布式文件系统HDFS的节能算法[J].计算机学报,2013,36(5):1047-1064.)
[10] LIAO B, YU J, SUN H, et al. Energy-efficient algorithms for distributed storage system based on data storage structure reconfiguration[J]. Journal of Computer Research and Development, 2013, 50(1):3-18. (廖彬,于炯,孙华,等.基于存储结构重配置的分布式存储系统节能算法[J].计算机研究与发展,2013,50(1):3-18.)
[11] LIAO B, YU J, ZHANG T, et al. Novel energy-efficient metadata dynamic modeling and management approach for cloud storage system[J]. Journal of Chinese Computer Systems, 2013, 24(10):2407-2412. (廖彬,于炯,张陶,等.一种适应节能的云存储系统元数据动态建模与管理方法[J].小型微型计算机系统,2013,24(10):2407-2412.)
[12] SCHALL D, HUDLET V, HÄRDER T. Enhancing energy efficiency of database applications using SSDs[C]//C3S2E'10:Proceedings of the 3rd C^* Conference on Computer Science and Software Engineering. New York:ACM, 2010:1-9.
[13] LEE S-W, MOON B. Design of flash-based DBMS:an in-page logging approach[C]//Proceedings of the 2007 ACM SIGMOD International Conference on Management of Data. New York:ACM, 2007:55-66.
[14] LEE S-W, MOON B, PARK C, et al. A case for flash memory SSD in enterprise database applications[C]//Proceedings of the 2008 ACM SIGMOD International Conference on Management of Data. New York:ACM, 2008:1075-1086.
[15] TSIROGIANNIS D, HARIZOPOULOS S, SHAH M A. Analyzing the energy efficiency of a database server[C]//SIGMOD'10:Proceedings of the 2010 ACM SIGMOD International Conference on Management of Data. New York:ACM, 2010:231-242.
[16] RODRIGUEZ-MARTINEZ M, VALDIVIA H, SEGUEL J, et al. Estimating power/energy consumption in database servers[J]. Procedia Computer Science, 2011, 6(1):112-117.
[17] XU Z. Building a power-aware database management system[C]//Proceedings of the 4th SIGMOD PhD Workshop on Innovative Database Research. New York:ACM, 2010:1-6.
[18] XU Z, TU Y-C, WANG X. Exploring power-performance tradeoffs in database systems[C]//Proceedings of the 2010 IEEE 26th International Conference on Data Engineering. Piscataway:IEEE, 2010:485-496.
[19] XU Z, TU Y-C, WANG X. PET:reducing database energy cost via query optimization[J]. Proceedings of the VLDB Endowment, 2012, 5(12):1954-1957.
[20] LANG W, PATEL J. Towards eco-friendly database management systems[C/OL]//Proceedings of the 4th Biennial Conference on Innovative Data Systems Research. Asilomar:[s.n.], 2009.[2015-05-01]. http://pages.cs.wisc.edu/~wlang/ecodb.pdf.
[21] YANG L, ZHU H. Whole system realtime power profiling and modeling[J]. Computer Science, 2014, 41(9):32-37. (杨良怀,朱红燕.整机系统实时功率剖析与建模[J].计算机科学,2014,41(9):32-37.)

结构化查询语言动态功耗解析及建模

Dynamic power consumption profiling and modeling by structured query language

PDF

可视化

摘要/Abstract

引用本文

使用本文

参考文献

相关文章 14

编辑推荐

Metrics

[1]	刘专, 韩瑞琛, 张延松, 陈跃国, 张宇. 面向多核CPU和GPU平台的数据库星形连接优化[J]. 计算机应用, 2021, 41(3): 611-617.
[2]	裴泽锋, 牛保宁, 张锦文, Amjad Muhammad. 并行查询下查询执行计划的选择[J]. 计算机应用, 2020, 40(2): 420-425.
[3]	关皓元, 朱斌, 李冠宇, 蔡永嘉. 基于资源描述框架图切分与顶点选择性的高效子图匹配方法[J]. 计算机应用, 2019, 39(2): 360-369.
[4]	李树, 于炯, 国冰磊, 蒲勇霖, 杨德先, 刘粟. 基于SSD数据库负载的SQL能耗感知模型[J]. 计算机应用, 2019, 39(1): 205-212.
[5]	关皓元, 朱斌, 李冠宇, 赵玲. 基于RDF图结构切分的高效子图匹配方法[J]. 计算机应用, 2018, 38(7): 1898-1904.
[6]	何志学, 廖湖声. 基于列表的可扩展标记语言流数据查询处理方法[J]. 计算机应用, 2016, 36(3): 665-669.
[7]	林基明, 班文娇, 王俊义, 童记超. 基于并行遗传最大最小蚁群算法的分布式数据库查询优化[J]. 计算机应用, 2016, 36(3): 675-680.
[8]	杜垚郭涛陈俊杰. 云环境下机群弹性负载均衡机制[J]. 计算机应用, 2013, 33(03): 830-833.
[9]	冯丽云洪玫杨秋辉周洪宇臧康. 基于逆向查询处理算法的数据库系统测试数据生成方法[J]. 计算机应用, 2011, 31(04): 948-951.
[10]	赵尔平王聪华雒伟群党红恩张兆基. 基于自动机XML正则路径表达式查询研究[J]. 计算机应用, 2010, 30(9): 2317-2320.
[11]	谢志军王雷. 传感器网络中基于域的聚集算法[J]. 计算机应用, 2008, 28(2): 350-354.
[12]	张胜舒坚包晓玲. XML文档压缩技术比较研究[J]. 计算机应用, 2008, 28(10): 2537-2540.
[13]	huguoling. 基于主动数据库的移动P2P查询处理[J]. 计算机应用, 2007, 27(5): 1089-1091.
[14]	张晶张云生 . 基于关系数据库的实时XML数据查询处理[J]. 计算机应用, 2006, 26(7): 1679-1681.