IBM Skip to main content
  Home     Products & services     Support & downloads     My account  
  Select a country  
Journals Home  
  Systems Journal  
  ·  Current Issue  
  ·  Recent Issues  
  ·  Papers in Progress  
  ·  Search/Index  
  ·  Orders  
  ·  Description  
  ·  Author's Guide  
Journal of Research
and Development
  Staff  
  Contact Us  
  Related links:  
   IBM Security  
   IBM DB2 Benchmarks  
   Paper: Analysis of the
 I/O Characteristics of
 Production Database
 Workloads and the
 TPC Benchmarks		  
IBM Systems Journal  
Volume 40, Number 3, 2001
End-to-End Security
 Table of contents: arrowHTML arrowPDF arrowASCII   This article: arrowHTML arrowPDF arrowASCII arrowCopyright info
   

Characteristics of production database workloads and the TPC benchmarks - References
by W. W. Hsu, A. J. Smith, and H. C. Young

Cited references

  1. TPC Benchmark C Standard Specification Revision 3.3.2, Transaction Processing Performance Council (June 1997).
  2. TPC Benchmark D Standard Specification Revision 1.3.1, Transaction Processing Performance Council (December 1997).
  3. A. J. Smith, “Trace-Driven Simulation in Research on Computer Architecture and Operating Systems,” Proceedings of the Conference on New Directions in Simulation for Manufacturing and Communications, Tokyo, Japan (August 1994), pp. 43–49.
  4. R. A. Uhlig and T. N. Mudge, “Trace-Driven Memory Simulation: A Survey,” ACM Computing Surveys 29, 128–170 (June 1997).
  5. W. W. Hsu, A. J. Smith, and H. C. Young, I/O Reference Behavior of Production Database Workloads and the TPC Benchmarks—An Analysis at the Logical Level, Technical Report CSD-99-1071, Computer Science Division, University of California, Berkeley, CA (November 1999). Also available as Research Report RJ 10166, IBM Almaden Research Center, San Jose, CA (November 1999). To appear in ACM Transactions on Database Systems.
  6. W. W. Hsu, A. J. Smith, and H. C. Young, “Results and Data for 'Analysis of the I/O Characteristics of Production Database Workloads and the TPC Benchmarks' ” (1999), see http://www.cs.berkeley.edu/~windsorh/DBChar.
  7. W. W. Hsu, A. J. Smith, and H. C. Young, Analysis of the Characteristics of Production Database Workloads and Comparison with the TPC Benchmarks, Technical Report CSD-99-1070, Computer Science Division, University of California, Berkeley, CA (November 1999). Also available as Research Report RJ 10165, IBM Almaden Research Center, San Jose, CA (November 1999).
  8. J. Rodriguez-Rosell, “Empirical Data Reference Behavior in Data Base Systems,” Computer 9, No. 11, 9 –13 (November 1976).
  9. A. J. Smith, “Sequentiality and Prefetching in Database Systems,” ACM Transactions on Database Systems 3, 223–247 (September 1978).
  10. P. Hawthorn and M. Stonebraker, “Performance Analysis of a Relational Data Base Management System,” Proceedings of the ACM SIGMOD International Conference on Management of Data, Boston, MA (May 1979), pp. 1–12.
  11. J. P. Kearns and S. DeFazio, “Locality of Reference in Hierarchical Database Systems,” IEEE Transactions on Software Engineering 19, 128–134 (March 1983).
  12. W. Effelsberg and M. E. S. Loomis, “Logical, Internal, and Physical Reference Behavior in CODASYL Database Systems,” ACM Transactions on Database Systems 9, 187–213 (June 1984).
  13. A. I. Verkamo, “Empirical Results on Locality in Database Referencing,” Proceedings of the ACM SIGMETRICS International Conference on Measurement and Modeling of Computer Systems, Austin, TX (August 1985), pp. 49–58.
  14. I. R. Casas and K. C. Sevcik, “A Buffer Management Model for Use in Predicting Overall Database System Performance,” Proceedings of the IEEE International Conference on Data Engineering, Los Angeles, CA (February 1989), pp. 463–469.
  15. J. P. Kearns and S. DeFazio, “Diversity in Database Reference Behavior,” Performance Evaluation Review 17, 11–19 (May 1989).
  16. B. T. Zivkov and A. J. Smith, “Disk Cache Design and Performance as Evaluated in Large Timesharing and Database Systems,” Proceedings of the CMG (Computer Measurement Group) Conference, Orlando, FL (December 1997), pp. 639–658. Abridged version published as “Disk Caching in Large Database and Timeshared Systems,” Proceedings of the 5th International Symposium on Modeling, Analysis, and Simulation of Computer and Telecommunication Systems, Haifa, Israel (January 1997), pp. 184–195. Extended version available as Technical Report CSD-96-913, Computer Science Division, University of California, Berkeley, CA (September 1996).
  17. V. Singhal and A. J. Smith, “Analysis of Locking Behavior in Three Real Database Systems,” The VLDB Journal 6, 40–52 (January 1997). Extended version available as Technical Report CSD-94-801, Computer Science Division, University of California, Berkeley, CA (April 1994).
  18. S. T. Leutenegger and D. M. Dias, “A Modeling Study of the TPC-C Benchmark,” Proceedings of the ACM SIGMOD International Conference on Management of Data, Washington, DC (May 1993), pp. 22–31.
  19. T.-F. Tsuei, A. N. Packer, and K.-T. Ko, “Database Buffer Size Investigation for OLTP Workloads,” Proceedings of the ACM SIGMOD International Conference on Management of Data, Tucson, AZ (May 1997), pp. 112–122.
  20. J. Doppelhammer, T. Höppler, A. Kemper, and D. Kossmann, “Database Performance in the Real World—TPC-D and SAP R/3,” Proceedings of the ACM SIGMOD International Conference on Management of Data, Tucson, AZ (May 1997), pp. 123–134.
  21. W. W. Hsu, A. J. Smith, and H. C. Young, “Projecting the Performance of Decision Support Workloads on Systems with Smart Storage (SmartSTOR),” Proceedings of the 7th IEEE International Conference on Parallel and Distributed Systems (July 2000), pp. 417–425. Also available as Research Report RJ 10145, IBM Almaden Research Center, San Jose, CA (July 1999) and Technical Report CSD-99-1057, Computer Science Division, University of California, Berkeley, CA (August 1999).
  22. K. K. Ramakrishnan, P. Biswas, and R. Karedla, “Analysis of File I/O Traces in Commercial Computing Environments,” Proceedings of the ACM SIGMETRICS International Conference on Measurement and Modeling of Computer Systems, Newport, RI (June 1992), pp. 78–90.
  23. S. Zhou, H. Da Costa, and A. J. Smith, “A File System Tracing Package for Berkeley UNIX,” Proceedings of the 10th Usenix Conference, Portland, OR (June 1985), pp. 407–419.
  24. J. Ousterhout, H. Da Costa, D. Harrison, J. Kunze, M. Kupfer, and J. Thompson, “A Trace-Driven Analysis of the UNIX 4.2 BSD File System,” Proceedings of the ACM SIGOPS Symposium on Operating System Principles, Orcas Island, WA (December 1985), pp. 15–24.
  25. J. G. Thompson, Efficient Analysis of Caching Systems, Ph.D. thesis, University of California, Berkeley, CA (1987). Available as Technical Report CSD 87/374, Computer Science Division, University of California, Berkeley, CA (October 1987).
  26. M. G. Baker, J. H. Hartman, M. D. Kupfer, K. W. Shirriff, and J. K. Ousterhout, “Measurements of a Distributed File System,” Proceedings of the ACM SIGOPS Symposium on Operating System Principles, Pacific Grove, CA (October 1991), pp. 198–212.
  27. J. Douceur and W. Bolosky, “A Large-Scale Study of File-System Contents,” Proceedings of the ACM SIGMETRICS International Conference on Measurement and Modeling of Computing Systems, Atlanta, GA (May 1999), pp. 59–70.
  28. R. A. Floyd and C. S. Ellis, “Directory Reference Patterns in Hierarchical File Systems,” IEEE Transactions on Knowledge and Data Engineering 1, 238–247 (June 1989).
  29. B. B. Welch, “Measured Performance of Caching in the Sprite Network File System,” Computing Systems 4, 315–342 (Summer 1991).
  30. DB2 UDB V5 Administration Guide, IBM Corporation (1997).
  31. DB2 for OS/390 V5 Installation Guide, IBM Corporation (1997).
  32. W. H. Press, B. P. Flannery, S. A. Teukolsky, and W. T. Vetterling, Numerical Recipes in C: The Art of Scientific Computing, Cambridge University Press, Cambridge, UK (1990).
  33. DB2 PM for OS/390 V5 Batch User's Guide, IBM Corporation (1997).
  34. W. Effelsberg and T. Haerder, “Principles of Database Buffer Management,” ACM Transactions on Database Systems 9, 560–595 (December 1984).
  35. J. Z. Teng and R. A. Gumaer, “Managing IBM Database 2 Buffers to Maximize Performance,” IBM Systems Journal 23, No. 2, 211–218 (1984).
  36. A. V. Hill, “The Combinations of Hemoglobin with Oxygen and Carbon Monoxide,” Biochemistry Journal 7, 471–480 (1913).
  37. K. P. Eswaran, J. N. Gray, R. A. Lorie, and I. L. Traiger, “The Notions of Consistency and Predicate Locks in a Database System,” Communications of the ACM 19, 624–633 (November 1976).
  38. A. Thomasian, “Performance Limits of Two-Phase Locking,” Proceedings of the IEEE International Conference on Data Engineering, Los Alamitos, CA (April 1991), pp. 426–435.
  39. M. K. McKusick, W. N. Joy, S. J. Leffler, and R. S. Fabry, “A Fast File System for UNIX,” ACM Transactions on Computer Systems 2, 181–197 (August 1984).
  40. A. J. Smith, “Disk Cache—Miss Ratio Analysis and Design Considerations,” ACM Transactions on Computer Systems 3, 161–203 (August 1985).
  41. A. V. Aho, P. J. Denning, and J. D. Ullman, “Principles of Optimal Page Replacement,” Journal of the ACM 18, 80–93 (January 1971).
  42. D. E. Knuth, “An Empirical Study of FORTRAN Programs,” Software—Practice and Experience 1, 105–133 (April/June 1971).
  43. G. M. Amdahl, “Storage and I/O Parameters and Systems Potential,” Proceedings of the IEEE International Computer Group Conference (Memories, Terminals, and Peripherals), Washington, DC (June 1970), pp. 371–372.
  44. J. L. Hennessy and D. A. Patterson, Computer Architecture: A Quantitative Approach, Second Edition, Morgan Kaufmann Publishers, Inc., San Francisco, CA (1996).
  45. D. E. Knuth, The Art of Computer Programming: Sorting and Searching, Vol. 3, Second Edition, Addison-Wesley Publishing Company, Reading, MA (1998).
  46. L. D. Shapiro, “Join Processing in Database Systems with Large Main Memories,” ACM Transactions on Database Systems 11, 239–264 (September 1986).
  47. K. Keeton, D. Patterson, Y. He, R. Raphael, and W. Baker, “Performance Characterization of a Quad Pentium Pro SMP Using OLTP Workloads,” Proceedings of the ACM SIGARCH International Symposium on Computer Architecture (ISCA), Barcelona, Spain (June 1998), pp. 15–26.
  48. A. Ailamaki, D. J. DeWitt, M. D. Hill, and D. A. Wood, “DBMSs on a Modern Processor: Where Does Time Go,” Proceedings of the International Conference on Very Large Data Bases (VLDB), Edinburgh, Scotland (September 1999), pp. 266–277.
  49. Y. Chen, W. W. Hsu, and H. C. Young, “Logging RAID—An Approach to Fast, Reliable and Low-Cost Disk Arrays,” Proceedings of the 6th International Euro-Par Conference (August 2000), pp. 1302–1311. Extended version available as Research Report RJ 10161, IBM Almaden Research Center, San Jose, CA (October 1999).
  50. R. Golding, P. Bosch, C. Staelin, T. Sullivan, and J. Wilkes, “Idleness Is Not Sloth,” Proceedings of the USENIX Technical Conference, New Orleans, LA (January 1995), pp. 201–212.
  51. J. N. Gray, R. A. Lorie, G. F. Putzolu, and I. L. Traiger, “Granularity of Locks and Degrees of Consistency in a Shared Data Base,” Modeling in Data Base Management Systems, IFIP TC-2, 365–394 (1976).
About IBM | Privacy | Legal | Contact