Awesome and Dark Tactics
Homepage Catalog Tag Selection Contributions
All Tags AWS algorithm-design architecture cloud-principles cost-reduction data-centric data-compression data-processing deployment design edge-computing energy-footprint hardware libraries locality machine-learning management measured migration model-optimization model-training performance queries rebuilding scaling services strategies template workloads

<- Back to category

Tactic: Optimize search & query strategies

Tactic sort: Awesome Tactic
Type: Architectural Tactic
Category: resource-adaptation
Tags: queries  strategies 

Title

Optimize search & query strategies

Description

Search and query strategies can be optimized to increase efficiency and, therefore, reduce costs. AWS Athena is a query service to analyze data in Amazon S3 using standard SQL. Athena charges for the amount of data being scanned to retrieve the query data. Hence, to optimize the costs of a query, the developer needs to ensure that a minimum amount of data is scanned. For example, whenever a key is frequently positioned at a certain location, first, this location should be scanned to prevent redundant scans. Processing less data results in less computing power and memory usage. Thus, a reduction in energy usage is expected.

Participant

Cloud consumer

Related software artifact

Cloud databases

Context

Public cloud

Software feature

Searches and queries

Tactic intent

Optimizing search and query strategies to increase efficiency and reduce costs

Target quality attribute

Efficiency

Other related quality attributes

Cost-efficiency

Measured impact

< unknown >

Source

Master Thesis “Architectural Tactics to Optimize Software for Energy Efficiency in the Public Cloud” by Sophie Vos


Graphical representation

  • Contact person
  • Patricia Lago (VU Amsterdam)
  •  disc at vu.nl
  •  patricialago.nl

The Archive of Awesome and Dark Tactics (AADT) is an initiative of the Digital Sustainability Center (DiSC). It received funding from the VU Amsterdam Sustainability Institute, and is maintained by the S2 Group of the Vrije Universiteit Amsterdam.

Initial development of the Archive of Awesome and Dark Tactics by Robin van der Wiel