Improving user interaction in mobile-cloud database query processing

Abstract : When running queries on a database, choosing an optimal query execution plan to minimize query costs is crucial for the query optimizer. This is especially true in mobile-cloud database systems, where there are multiple costs to execute a query plan such as money, time and energy. In order to fulfill different cost objectives for different users, some query optimizers allow users to select the query execution plan from a Pareto Set based on Skyline queries. The users must select from a potentially large quantity of options, and these options present the values of costs. It is not straightforward to the users how to compare these values in such a way to choose the option that suits their needs best. This increases the possibility for users to choose in-optimal options, and the amount of time spent to make that choice. However, the existing user interaction model during multi-objective query processing is unable to solve this issue. To fill this gap, this paper presents a new user interaction model in multi-objective query processing. This model introduces the administrators, or super users, to the user interaction process, allowing them to preset Weight Profiles and their logical descriptions. Weight Profiles contain objective preferences for the users before the query is executed. By using this model, the users can select a Weight Profile that will obtain their optimal query execution plan, and the process of choosing will be more accurate and efficient.
Type de document :
Communication dans un congrès
Workshop on Scalable Cloud Data Management, Dec 2017, Boston, United States
Liste complète des métadonnées

Littérature citée [21 références]  Voir  Masquer  Télécharger

https://hal.archives-ouvertes.fr/hal-01640072
Contributeur : Laurent D'Orazio <>
Soumis le : lundi 20 novembre 2017 - 16:36:25
Dernière modification le : jeudi 23 novembre 2017 - 01:13:00

Fichier

PID5122071-1.pdf
Fichiers produits par l'(les) auteur(s)

Identifiants

  • HAL Id : hal-01640072, version 1

Citation

Chenxiao Wang, Jason Arenson, Florian Helff, Le Gruenwald, Laurent D'Orazio. Improving user interaction in mobile-cloud database query processing. Workshop on Scalable Cloud Data Management, Dec 2017, Boston, United States. 〈hal-01640072〉

Partager

Métriques

Consultations de la notice

49

Téléchargements de fichiers

14