In Search of the 64-Bit “Killer App”

• Conventional Wisdom Says It’s an RDBMS for Data Warehousing (ie. Lots of potential I/O to be avoided)

• Actual Practice Suggests Otherwise

• RDBMS Vendors Have Overcome the I/O Problems

  • Partitioned Tables
  • Parallel I/O
  • Background Reads/Writes

• Buffer “Hits” in an RDBMS are Already High

  • Data Locality and Aging Algorithms do a Good Job
  • If Buffer Hits = 90%, You Can Only Improve by 10/90 = 11%

Previous slide

Next slide

Back to first slide

View graphic version

Send email to Interex or to theWebmaster
©Copyright 1998 Interex. All rights reserved.