Tuning in action

Wei Cao, Dennis Shasha

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Abstract

Imagine that your database has all the right indexes. Its buffer manager has been tuned to give a high hit ratio, the buffer fits in RAM, and the data is well distributed on disk. You're done, right? Well, no, because the application code might be poorly written. It might include delinquent design patterns. The demoed tuning tool AppSleuth will find those delinquent design patterns but it is the demo visitor's job to fix them.

Original languageEnglish (US)
Title of host publicationAdvances in Database Technology - EDBT 2013: 16th International Conference on Extending Database Technology, Proceedings
Pages737-740
Number of pages4
DOIs
StatePublished - 2013
Event16th International Conference on Extending Database Technology, EDBT 2013 - Genoa, Italy
Duration: Mar 18 2013Mar 22 2013

Other

Other16th International Conference on Extending Database Technology, EDBT 2013
CountryItaly
CityGenoa
Period3/18/133/22/13

Fingerprint

Tuning
Random access storage
Managers

Keywords

  • application-level optimization
  • database tuning
  • performance tool

ASJC Scopus subject areas

  • Human-Computer Interaction
  • Computer Networks and Communications
  • Computer Vision and Pattern Recognition
  • Software

Cite this

Cao, W., & Shasha, D. (2013). Tuning in action. In Advances in Database Technology - EDBT 2013: 16th International Conference on Extending Database Technology, Proceedings (pp. 737-740) https://doi.org/10.1145/2452376.2452468

Tuning in action. / Cao, Wei; Shasha, Dennis.

Advances in Database Technology - EDBT 2013: 16th International Conference on Extending Database Technology, Proceedings. 2013. p. 737-740.

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Cao, W & Shasha, D 2013, Tuning in action. in Advances in Database Technology - EDBT 2013: 16th International Conference on Extending Database Technology, Proceedings. pp. 737-740, 16th International Conference on Extending Database Technology, EDBT 2013, Genoa, Italy, 3/18/13. https://doi.org/10.1145/2452376.2452468
Cao W, Shasha D. Tuning in action. In Advances in Database Technology - EDBT 2013: 16th International Conference on Extending Database Technology, Proceedings. 2013. p. 737-740 https://doi.org/10.1145/2452376.2452468
Cao, Wei ; Shasha, Dennis. / Tuning in action. Advances in Database Technology - EDBT 2013: 16th International Conference on Extending Database Technology, Proceedings. 2013. pp. 737-740
@inproceedings{63188361269c4f05910da7c3848ba8f6,
title = "Tuning in action",
abstract = "Imagine that your database has all the right indexes. Its buffer manager has been tuned to give a high hit ratio, the buffer fits in RAM, and the data is well distributed on disk. You're done, right? Well, no, because the application code might be poorly written. It might include delinquent design patterns. The demoed tuning tool AppSleuth will find those delinquent design patterns but it is the demo visitor's job to fix them.",
keywords = "application-level optimization, database tuning, performance tool",
author = "Wei Cao and Dennis Shasha",
year = "2013",
doi = "10.1145/2452376.2452468",
language = "English (US)",
isbn = "9781450315975",
pages = "737--740",
booktitle = "Advances in Database Technology - EDBT 2013: 16th International Conference on Extending Database Technology, Proceedings",

}

TY - GEN

T1 - Tuning in action

AU - Cao, Wei

AU - Shasha, Dennis

PY - 2013

Y1 - 2013

N2 - Imagine that your database has all the right indexes. Its buffer manager has been tuned to give a high hit ratio, the buffer fits in RAM, and the data is well distributed on disk. You're done, right? Well, no, because the application code might be poorly written. It might include delinquent design patterns. The demoed tuning tool AppSleuth will find those delinquent design patterns but it is the demo visitor's job to fix them.

AB - Imagine that your database has all the right indexes. Its buffer manager has been tuned to give a high hit ratio, the buffer fits in RAM, and the data is well distributed on disk. You're done, right? Well, no, because the application code might be poorly written. It might include delinquent design patterns. The demoed tuning tool AppSleuth will find those delinquent design patterns but it is the demo visitor's job to fix them.

KW - application-level optimization

KW - database tuning

KW - performance tool

UR - http://www.scopus.com/inward/record.url?scp=84876792282&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=84876792282&partnerID=8YFLogxK

U2 - 10.1145/2452376.2452468

DO - 10.1145/2452376.2452468

M3 - Conference contribution

SN - 9781450315975

SP - 737

EP - 740

BT - Advances in Database Technology - EDBT 2013: 16th International Conference on Extending Database Technology, Proceedings

ER -