AppSleuth

A tool for database tuning at the application level

Wei Cao, Dennis Shasha

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

Abstract

Excellent work ([1]-[6]) has shown that memory management and transaction concurrency levels can often be tuned automatically by the database management systems. Other excellent work ([7]]-[14]) has shown how to use the optimizer to do automatic physical design or to make the optimizer itself more self-adaptive ([15]-[17]). Our performance tuning experience across various industries (finance, gaming, data warehouses, and travel) has shown that enormous additional tuning benefits (sometimes amounting to orders of magnitude) can come from reengineering application code and table design. The question is: can a tool help in this effort? We believe so. We present a tool called AppSleuth that parses application code and the tracing log for two popular database management systems in order to lead a competent tuner to the hot spots in an application. This paper discusses (i) representative application "delinquent design patterns", (ii) an application code parser to find them, (iii) a log parser to identify the patterns that are critical, and (iv) a display to give a global view of the issue. We present an extended sanitized case study from a real travel application to show the results of the tool at different stages of a tuning engagement, yielding a 300 fold improvement. This is the first tool of its kind that we know of.

Original languageEnglish (US)
Title of host publicationAdvances in Database Technology - EDBT 2013: 16th International Conference on Extending Database Technology, Proceedings
Pages589-600
Number of pages12
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
Reengineering
Data warehouses
Finance
Display devices
Data storage equipment
Industry

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). AppSleuth: A tool for database tuning at the application level. In Advances in Database Technology - EDBT 2013: 16th International Conference on Extending Database Technology, Proceedings (pp. 589-600) https://doi.org/10.1145/2452376.2452445

AppSleuth : A tool for database tuning at the application level. / Cao, Wei; Shasha, Dennis.

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

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

Cao, W & Shasha, D 2013, AppSleuth: A tool for database tuning at the application level. in Advances in Database Technology - EDBT 2013: 16th International Conference on Extending Database Technology, Proceedings. pp. 589-600, 16th International Conference on Extending Database Technology, EDBT 2013, Genoa, Italy, 3/18/13. https://doi.org/10.1145/2452376.2452445
Cao W, Shasha D. AppSleuth: A tool for database tuning at the application level. In Advances in Database Technology - EDBT 2013: 16th International Conference on Extending Database Technology, Proceedings. 2013. p. 589-600 https://doi.org/10.1145/2452376.2452445
Cao, Wei ; Shasha, Dennis. / AppSleuth : A tool for database tuning at the application level. Advances in Database Technology - EDBT 2013: 16th International Conference on Extending Database Technology, Proceedings. 2013. pp. 589-600
@inproceedings{1b7a67b1823c480b9da6d1a9c54080f2,
title = "AppSleuth: A tool for database tuning at the application level",
abstract = "Excellent work ([1]-[6]) has shown that memory management and transaction concurrency levels can often be tuned automatically by the database management systems. Other excellent work ([7]]-[14]) has shown how to use the optimizer to do automatic physical design or to make the optimizer itself more self-adaptive ([15]-[17]). Our performance tuning experience across various industries (finance, gaming, data warehouses, and travel) has shown that enormous additional tuning benefits (sometimes amounting to orders of magnitude) can come from reengineering application code and table design. The question is: can a tool help in this effort? We believe so. We present a tool called AppSleuth that parses application code and the tracing log for two popular database management systems in order to lead a competent tuner to the hot spots in an application. This paper discusses (i) representative application {"}delinquent design patterns{"}, (ii) an application code parser to find them, (iii) a log parser to identify the patterns that are critical, and (iv) a display to give a global view of the issue. We present an extended sanitized case study from a real travel application to show the results of the tool at different stages of a tuning engagement, yielding a 300 fold improvement. This is the first tool of its kind that we know of.",
keywords = "application-level optimization, database tuning, performance tool",
author = "Wei Cao and Dennis Shasha",
year = "2013",
doi = "10.1145/2452376.2452445",
language = "English (US)",
isbn = "9781450315975",
pages = "589--600",
booktitle = "Advances in Database Technology - EDBT 2013: 16th International Conference on Extending Database Technology, Proceedings",

}

TY - GEN

T1 - AppSleuth

T2 - A tool for database tuning at the application level

AU - Cao, Wei

AU - Shasha, Dennis

PY - 2013

Y1 - 2013

N2 - Excellent work ([1]-[6]) has shown that memory management and transaction concurrency levels can often be tuned automatically by the database management systems. Other excellent work ([7]]-[14]) has shown how to use the optimizer to do automatic physical design or to make the optimizer itself more self-adaptive ([15]-[17]). Our performance tuning experience across various industries (finance, gaming, data warehouses, and travel) has shown that enormous additional tuning benefits (sometimes amounting to orders of magnitude) can come from reengineering application code and table design. The question is: can a tool help in this effort? We believe so. We present a tool called AppSleuth that parses application code and the tracing log for two popular database management systems in order to lead a competent tuner to the hot spots in an application. This paper discusses (i) representative application "delinquent design patterns", (ii) an application code parser to find them, (iii) a log parser to identify the patterns that are critical, and (iv) a display to give a global view of the issue. We present an extended sanitized case study from a real travel application to show the results of the tool at different stages of a tuning engagement, yielding a 300 fold improvement. This is the first tool of its kind that we know of.

AB - Excellent work ([1]-[6]) has shown that memory management and transaction concurrency levels can often be tuned automatically by the database management systems. Other excellent work ([7]]-[14]) has shown how to use the optimizer to do automatic physical design or to make the optimizer itself more self-adaptive ([15]-[17]). Our performance tuning experience across various industries (finance, gaming, data warehouses, and travel) has shown that enormous additional tuning benefits (sometimes amounting to orders of magnitude) can come from reengineering application code and table design. The question is: can a tool help in this effort? We believe so. We present a tool called AppSleuth that parses application code and the tracing log for two popular database management systems in order to lead a competent tuner to the hot spots in an application. This paper discusses (i) representative application "delinquent design patterns", (ii) an application code parser to find them, (iii) a log parser to identify the patterns that are critical, and (iv) a display to give a global view of the issue. We present an extended sanitized case study from a real travel application to show the results of the tool at different stages of a tuning engagement, yielding a 300 fold improvement. This is the first tool of its kind that we know of.

KW - application-level optimization

KW - database tuning

KW - performance tool

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

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

U2 - 10.1145/2452376.2452445

DO - 10.1145/2452376.2452445

M3 - Conference contribution

SN - 9781450315975

SP - 589

EP - 600

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

ER -