Keywordscpu power and energy
memory power and energy
MetadataShow full item record
PublisherThe University of Arizona.
RightsCopyright © is held by the author. Digital access to this material is made possible by the University Libraries, University of Arizona. Further transmission, reproduction, presentation (such as public display or performance) of protected items is prohibited except with permission of the author.
AbstractOver the last decade, use of data stores have increased considerably. From scientific research in different domains to marketing and analytics, the need for more data is becoming essential to understanding customer behavior and to push the frontier of research. This means that there is a need for more data stores which puts a lot of pressure on data centers to make sure that their costs with respect to energy and power are kept in check. We extend research in energy efficient database systems by analyzing SQL queries to save memory energy thereby saving overall energy of server systems and by optimizing query planning under peak shaving constraints thereby maintaining performance and in some cases show better performance by choosing a better query plan for an SQL query. As memory becomes cheaper, use of it has become more prominent in computer systems. This increase in number of memory modules increases the ratio of energy consumption by memory to the overall energy consumption of a computer system. As Database Systems become more memory centric and put more pressure on the memory subsystem, managing energy consumption of main memory is becoming critical. Therefore, it is important to take advantage of all memory idle times and lower power states provided by newer memory architectures by placing memory in low power modes using application level cues. While there have been studies on CPU power consumption in Database Systems, only limited research has been done on the role of memory in Database Systems with respect to energy management. We propose Query Aware Memory Energy Management (QAMEM) where the Database System provides application level cues to the memory controller to switch to lower power states using query information and performance counters. Our results show that by using QAMEM on TPC-H workloads one can save 25% of total system energy in comparison to the state of the art memory energy management mechanisms. Peak shaving is a common practice in data centers when overall power consump- tion has to be managed. Data centers send triggers to servers to reduce their CPU frequencies using DVFS mechanisms, which in turn reduce power consumption of servers, thereby reducing the power consumption of the entire data center. This reduction in CPU frequency of database servers have an adverse effect on perfor- mance of SQL queries executed. As database servers do not modify their internal query plan parameters under peak shaving constraints, they continue executing sub- optimal query plans. While there have been studies on incorporating query power consumption in Database systems for energy efficiency, only limited research has been done in creating better query plans when CPU frequencies are throttled. In this paper, we show that there exist better query plans for TPC-H workloads and that we can improve the performance of query execution by an average of 10% under peak shaving constraints.
Degree ProgramGraduate College
Degree GrantorUniversity of Arizona
Showing items related by title, author, creator and subject.
CONGRESS AND THE ENERGY DECADE: A ROLL-CALL ANALYSIS OF CONGRESSIONAL VOTING ON ENERGY RELATED QUESTIONS, 1973 - 1983.MECHAM, MILO ROSS.; Kenski, Henry; Ingram, Helen; Wahlke, John (The University of Arizona., 1987)This study examines individual roll call votes on energy issues taken in Congress during the years 1973 to 1983. Logit analysis is used to compare the influence of partisan identification; personal ideology, as measured by support and opposition to the conservative coalition; and district or state energy characteristics, including energy consumption and production. The potential for misleading results due to the multicollinearity of party and ideology is eliminated through the use of a residual variable representing the non-party component of ideology. The results indicate that members of Congress demonstrated considerable variability in voting on energy matters. The House of Representatives was more responsive to variations in energy constituencies. Both the House and the Senate showed a different response when the substantive character of energy issues varied. Questions with an economic impact were more influenced by partisanship, while environmentally related issues were more strongly influenced by ideology. The gross impact of changes in public opinion and changes in the presidency are noticeable throughout, but most especially after the election of Ronald Reagan, when many of the policy changes made previously were dismantled. The results of this study support the basic proposition that individual roll call votes are a product of constituency influence. The results also indicate that the political partisanship and ideology of members are representative of a member's supportive and reelection constituency. The statistical methods used allowed a direct comparison of the influence of party, ideology, and variables representing the characteristics of member's districts. The results obtained substantiate the importance of constituent influence in congressional voting.
Dark Energy Survey Year 1 Results: Cross-correlation between Dark Energy Survey Y1 galaxy weak lensing and South Pole Telescope+Planck CMB weak lensingRozo, E.; Marrone, D. P.; Univ Arizona, Dept Phys; Univ Arizona, Steward Observ (AMER PHYSICAL SOC, 2019-08-12)We cross-correlate galaxy weak lensing measurements from the Dark Energy Survey (DES) year-one data with a cosmic microwave background (CMB) weak lensing map derived from South Pole Telescope (SPT) and Planck data, with an effective overlapping area of 1289 deg(2). With the combined measurements from four source galaxy redshift bins, we obtain a detection significance of 5.8 sigma. We fit the amplitude of the correlation functions while fixing the cosmological parameters to a fiducial Lambda CDM model, finding A = 0.99 +/- 0.17. We additionally use the correlation function measurements to constrain shear calibration bias, obtaining constraints that are consistent with previous DES analyses. Finally, when performing a cosmological analysis under the Lambda CDM model, we obtain the marginalized constraints of Omega(m) = 0.261(-0.051)(+0.070) and S-8 = sigma(8)root Omega(m)/0.3 = 0.660(-0.100)(+0.085). These measurements are used in a companion work that presents cosmological constraints from the joint analysis of two-point functions among galaxies, galaxy shears, and CMB lensing using DES, SPT, and Planck data.