[dira05] Karl Dias, Mark Ramacher, Uri Shaft, Venkateshwaran Venkataramani, and Graham Wood. Automatic performance diagnosis and tuning in Oracle. In Second Biennial Conference on Innovative Data Systems Research (CIDR'05), pages 84-94, 2005. [ bib | .pdf | .pdf ]
[nath05] Dushyanth Narayanan, Eno Thereska, and Anastassia Ailamaki. Continuous resource monitoring for self-predicting DBMS. In International Symposium on Modeling, Analysis, and Simulation of Computer and Telecommunication Systems (MASCOTS'05), pages 239-248, 2005. [ bib | .pdf ]
[cosu04] Glenn Colaco and Darrell Suggs. Database performance with NAS: Optimizing Oracle on NFS. Technical Report TR-3322, Network Applicance Corp., May 2004. [ bib | .pdf | .pdf ]
[brke03] R. Braumandl, A. Kemper, and D. Kossmann. Quality of service in an information economy. ACM Transactions on Internet Technology, 3(4):291-333, 2003. [ bib | .pdf ]
Discusses distributed query processing with QoS guarantees for each query (not query class). Query evaluation plans are adapted on-the-fly.
[dies03] Yixin Diao, Frank Eskesen, Steven Froehlich, Joseph L. Hellerstein, Lisa F. Spainhower, and Maheswaran Surendra. Generic online optimization of multiple configuration parameters with application to a database server. In Proc. 14th IFIP/IEEE International Workshop on Distributed Systems: Operations and Management (DSOM), number 2867 in Lecture Notes in Computer Science, pages 3-15. Springer-Verlag, 2003. [ bib | .pdf ]
A generic approach to feedback of control of systems based on the Nelder-Mead simplex method. Application is to buffer pool configuration.
[paro03] Sujay Parekh, Kevin Rose, Joseph L. Hellerstein, Sam Lightstone, Matthew Huras, and Victor Chang. Managing the performance impact of administrative utilities. In Self-Managing Distributed Systems - 14th IFIP/IEEE International Workshop on Distributed Systems: Operations and Management (DSOM 2003), number 2867 in Lecture Notes in Computer Science. Springer-Verlag, 2003. [ bib | .pdf ]
[wabu02] Wenguang Wang and Rick Bunt. A self-tuning page cleaner for DB2. In International Workshop on Modeling, Analysis, and Simulation of Computer and Telecommunication Systems (MASCOTS), October 2002. [ bib | .pdf | .pdf ]
[mapo02b] P. Martin, W. Powley, H. Li, and K. Romanufa. Managing database server performance to meet QoS requirements in electronic commerce systems. International Journal on Digital Libraries, 3(4):316-324, 2002. [ bib | .pdf | .pdf ]
Describes the Quartermaster system, with application to database buffer configuration.
[zama02] Hamzeh Zawawy, Pat Martin, and Hossam Hassanein. Capacity planning for database management systems using analytical modeling. In Proc. CASCON, 2002. [ bib ]
[chwe00] Surajit Chaudhuri and Gerhard Weikum. Rethinking database system architecture: Towards a self-tuning RISC-Style database system. In Proc. International Conference on Very Large Data Bases, pages 1-10, 2000. [ bib | .pdf ]
[chch99] Surajit Chaudhuri, Eric Christensen, Goetz Graefe, Vivek R. Narasayya, and Michael J. Zwilling. Self-tuning technology in Microsoft SQL Server. In Bulletin of the IEEE Technical Committee on Data Engineering [loch99], pages 20-26. [ bib ]
[scva99] K. Bernhard Schiefer and Gary Valentin. DB2 Universal Database performance tuning. In Bulletin of the IEEE Technical Committee on Data Engineering [loch99], pages 12-19. [ bib ]
[loch99] David Lomet and Surajit Chaudhuri, editors. Bulletin of the IEEE Technical Committee on Data Engineering, volume 22(2), June 1999. [ bib | .pdf ]
Special Issue on Self-Tuning Databases and Application Tuning
[vibr98] Radek Vingralek, Yuri Breitbart, and Gerhard Weikum. Snowball: Scalable storage on networks of workstations with balanced load. Distributed and Parallel Databases, 6(2):117-156, April 1998. [ bib | .ps.gz ]
[scwe98] Peter Scheuermann, Gerhard Weikum, and Peter Zabback. Data partitioning and load balancing in parallel disk systems. The VLDB Journal, 7(1):48-66, 1998. [ bib | .pdf ]
[brca96] Kurt P. Brown, Michael J. Carey, and Miron Livny. Goal-oriented buffer management revisited. In Proceedings of the 1996 ACM SIGMOD International Conference on Management of Data, pages 353-364, June 1996. [ bib | .pdf ]
Describes the class fencing technique buffer management technique.
[gaio96] Minos N. Garofalakis and Yannis E. Ioannidis. Multi-dimensional resource scheduling for parallel queries. In Proc. ACM SIGMOD Int'l Conference on Management of Data (SIGMOD'96), pages 365-376, June 1996. [ bib | DOI | .pdf ]
[dagr95] Diane L. Davison and Goetz Graefe. Dynamic resource brokering for multi-user query execution. In Proc. ACM SIGMOD Int'l Conference on Management of Data (SIGMOD'95), pages 281-292, 1995. [ bib | DOI | .pdf ]
[logh94] David Lomet and Shahram Ghandeharizadeh, editors. Bulletin of the IEEE Technical Committee on Data Engineering, volume 17(3), September 1994. [ bib | .pdf | .pdf ]
Special Issue on Data Placement for Parallelism
[scwe94] Peter Scheuermann, Gerhard Weikum, and Peter Zabback. “disk cooling” in parallel disk systems. In IEEE Data Engineering Bulletin [logh94], pages 29-40. [ bib ]
[brme94] Kurt P. Brown, Manish Mehta, Michael J. Carey, and Miron Livny. Towards automated performance tuning for complex workloads. In Proc. International Conference on Very Large Data Bases, pages 72-84, 1994. [ bib | .pdf ]
[scwe93] Peter Scheuermann, Gerhard Weikum, and Peter Zabback. Adaptive load balancing in disk arrays. In Proceedings of the 4th International Conference on Foundations of Data Organization and Algorithms (FODO'93), pages 345-360, 1993. [ bib | .ps ]
[hewa91] Hans-Ulrich Heiss and Roger Wagner. Adaptive load control in transaction processing systems. In 17th International Conference on Very Large Data Bases, pages 47-54, September 1991. [ bib | .PDF | .pdf ]
Feedback control of concurrency. Assumes that the relationship between level of concurrency and throughput is unimodal. Proposes two control mechanisms. Incremental steps is a proportional control mechanism. Parabolic approximation mechanism fits recent concurrency/throughput measurements to a parabola and uses the peak of the parabola to choose a target concurrency level. Considers the use of admission control and transaction aborts to achieve the target level of concurrency.
[mowe91] Axel Mönkeberg and Gerhard Weikum. Conflict-driven load control for the avoidance of data-contention thrashing. In Proceedings of the Seventh International Conference on Data Engineering, pages 632-639, April 1991. [ bib | .pdf ]
[ngfa91] Raymond Ng, Christos Faloutsos, and Timos Sellis. Flexible buffer allocation based on marginal gains. In Proc. ACM SIGMOD Int'l Conference on Management of Data (SIGMOD'91), pages 387-396, 1991. [ bib | DOI | .pdf ]
[cakr90] Michael J. Carey, Sanjay Krishnamurthi, and Miron Livny. Load control for locking: The 'half-and-half' approach. In Proceedings of the Ninth ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems, pages 72-84, April 1990. [ bib | .pdf ]
[lafo88] S. Lafortune. Modeling and analysis of transaction execution in database systems. IEEE Transactions on Automatic Control, 33(5):439-447, May 1988. [ bib | .pdf ]
Formulates the concurrency control problem as a control problem for discrete-event dynamical systems.