Show simple item record

AuthorAli, Asim
AuthorJia, Rui
AuthorErradi, Abdelkarim
AuthorAbdelwahed, Sherif
AuthorHadjidj, Rachid
Available date2023-04-10T09:10:03Z
Publication Date2013
Publication Name8th International Workshop on Feedback Computing
ResourceScopus
URIhttp://hdl.handle.net/10576/41790
URIhttps://www.usenix.org/conference/feedbackcomputing13/workshop-program/presentation/ali
AbstractThe performance of a database can significantly deteriorate due to the fragmentation of data/index files. Manual database defragmentation and performance optimization remain time consuming and even infeasible as it requires knowledge of the complicated behavior of fragmentation and its relationships with system parameters. We propose a model-based detection and management framework for the database fragmentation which can automatically optimize database performance, detect the fault existence, estimate its future impact on system performance and recover the system back to normal. A predictive controller is designed to take proper actions to guarantee the QoS and remedy faults. Experimental studies on a realistic test-bed show the applicability and effectiveness of our approach. 8th International Workshop on Feedback Computing 2013. All rights reserved.
SponsorThis paper was made possible by NPRP grant # NPRP 09-778-2299 from the Qatar National Research Fund (a member of Qatar Foundation). The statements made herein are solely the responsibility of the authors.
Languageen
PublisherUSENIX Association
SubjectConsumer behavior
Database performance
De-fragmentation
Management frameworks
Model-based management
Model-based OPC
Performance optimizations
Predictive controller
Database systems
TitleTowards model-based management of database fragmentation
TypeConference Paper
dc.accessType Open Access


Files in this item

Thumbnail

This item appears in the following Collection(s)

Show simple item record