Skip to Main content Skip to Navigation
Conference papers

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.
Complete list of metadatas

Cited literature [21 references]  Display  Hide  Download

https://hal.archives-ouvertes.fr/hal-01640072
Contributor : Laurent d'Orazio <>
Submitted on : Monday, November 20, 2017 - 4:36:25 PM
Last modification on : Friday, March 6, 2020 - 4:46:02 PM
Document(s) archivé(s) le : Wednesday, February 21, 2018 - 2:53:57 PM

File

PID5122071-1.pdf
Files produced by the author(s)

Identifiers

  • 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⟩

Share

Metrics

Record views

302

Files downloads

255