Generating Power-Efficient Query Execution Plan

被引：0

作者：

Liu, Xiaowei ^{[1
]}

Wang, Jinbao ^{[1
]}

Wang, Haijie ^{[2
]}

Gao, Hong ^{[1
]}

机构：

[1] Harbin Inst Technol, Mass Data Comp Res Lab, Harbin, Heilongjiang, Peoples R China

[2] Harbin Inst Technol, Internet & Informat Ctr, Harbin, Heilongjiang, Peoples R China

来源：

PROCEEDINGS OF THE 2ND INTERNATIONAL CONFERENCE ON ADVANCES IN COMPUTER SCIENCE AND ENGINEERING (CSE 2013) | 2013年 / 42卷

关键词：

query execution plan; power-efficiency; power model;

D O I：

暂无

中图分类号：

TP18 [人工智能理论];

学科分类号：

081104 ; 0812 ; 0835 ; 1405 ;

摘要：

As more and more power is consumed in servers, growing attention has been paid to power management. However, little work has been dated on the power-efficiency of query execution plans generated by the DBMS. Traditional optimal query execution plan does not take power-efficiency into account. This paper tries to generate a power-efficient query execution plan by redesigning the query optimizer of the database. We build a power model to estimate the power consumption of a query execution plan and propose an algorithm to generate the power-efficient query execution plan. Using two experiments based on the TPC-H benchmark, we evaluate the accuracy of our power model and compare the power-efficient query execution plan with the traditional optimal query execution plan.

引用

页码：284 / 288

页数：5

共 50 条

[31] Power-Efficient Heterogeneous Many-Core Design With NCFET Technology [J].

Salamin, Sami ;

Rapp, Martin ;

Pathania, Anuj ;

Maity, Arka ;

Henkel, Joerg ;

Mitra, Tulika ;

Amrouch, Hussam .

IEEE TRANSACTIONS ON COMPUTERS, 2021, 70 (09) :1484-1497

[32] Low-voltage power-efficient BiDPL adder for VLSI applications [J].

Margala, M ;

Durdle, NG .

MICROELECTRONICS JOURNAL, 1999, 30 (02) :193-197

[33] GoSafe: A Power-Efficient Android Application for Road Fvents Signaling and Notification [J].

Tahan, Oussama ;

Rima, Reina ;

Bakri, Samira ;

Merhi, Zaher ;

El Deck, Saleem .

PROCEEDINGS OF THE 18TH MEDITERRANEAN ELECTROTECHNICAL CONFERENCE MELECON 2016, 2016,

[34] Circuit Design Considerations for Power-Efficient and Safe Implantable Electrical Neurostimulators [J].

Guan, Rui ;

Zufiria, Pedro G. ;

Giagka, Vasiliki ;

Serdijn, Wouter A. .

2020 IEEE 11TH LATIN AMERICAN SYMPOSIUM ON CIRCUITS & SYSTEMS (LASCAS), 2020,

[35] Recent Applications of Interfacial Exciplex as Ideal Host of Power-Efficient OLEDs [J].

Zhang, Baohua ;

Xie, Zhiyuan .

FRONTIERS IN CHEMISTRY, 2019, 7

[36] Power-Efficient Beam Pattern Synthesis via Dual Polarization Beamforming [J].

Petersson, Sven O. .

2020 14TH EUROPEAN CONFERENCE ON ANTENNAS AND PROPAGATION (EUCAP 2020), 2020,

[37] Power-Efficient Spectrum Sharing for Noncooperative Underwater Acoustic Communication Systems [J].

Pottier, Antony ;

Socheleau, Francois-Xavier ;

Laot, Christophe .

OCEANS 2016 MTS/IEEE MONTEREY, 2016,

[38] Power-Efficient Live Virtual Reality Streaming Using Edge Offloading [J].

Zhu, Zichen ;

Feng, Xianglong ;

Tang, Zhongze ;

Jiang, Nan ;

Guo, Tian ;

Xu, Lisong ;

Wei, Sheng .

PROCEEDINGS OF THE 32ND WORKSHOP ON NETWORK AND OPERATING SYSTEMS SUPPORT FOR DIGITAL AUDIO AND VIDEO, NOSSDAV 2022, 2022, :57-63

[39] Power-Efficient Accelerator Design for Neural Networks Using Computation Reuse [J].

Yasoubi, Ali ;

Hojabr, Reza ;

Modarressi, Mehdi .

IEEE COMPUTER ARCHITECTURE LETTERS, 2017, 16 (01) :72-75

[40] Power-efficient and Predictable Data Centers with Sliding Scheduled Tenant Requests [J].

Dalvandi, Aissan ;

Gurusamy, Mohan ;

Chua, Kee Chaing .

2014 IEEE 6TH INTERNATIONAL CONFERENCE ON CLOUD COMPUTING TECHNOLOGY AND SCIENCE (CLOUDCOM), 2014, :547-554

← 1 2 3 4 5 →