Conference proceeding
The Sisyphus database retrieval software performance antipattern
Proceedings of the 3rd international workshop on software and performance, pp 10-16
24 Jul 2002
Abstract
In this paper we propose the Sisyphus database retrieval software performance antipattern. The antipattern occurs in application designs that process large, frequently accessed lists stored in a relational database, but display only a small subset to the user. Software Performance Engineering (SPE) techniques are used to analyze the antipattern. Four solutions are evaluated: rownum and index, upper/lower bound, sequence numbering, and caching. We discuss the real world challenges of correcting this antipattern early in the application life cycle.
Metrics
3 Record Views
14 citations in Scopus
Details
- Title
- The Sisyphus database retrieval software performance antipattern
- Creators
- Robert Dugan, JrEphraim Glinert - Rensselaer Polytechnic InstituteAli Shokoufandeh - Drexel University
- Publication Details
- Proceedings of the 3rd international workshop on software and performance, pp 10-16
- Conference
- 3rd international workshop on software and performance, 3rd
- Series
- WOSP '02
- Publisher
- Association for Computing Machinery (ACM)
- Number of pages
- 1
- Resource Type
- Conference proceeding
- Language
- English
- Academic Unit
- Computer Science (Computing)
- Scopus ID
- 2-s2.0-0036992634
- Other Identifier
- 991019173855404721