sigmod_1997_elementary.txt

利用lwp：：get写的

In this paper we propose a method of maintaining aggregate views (the summary-delta table method), and use it to solve two problems in maintaining summary tables in a warehouse: (1) how to efficiently maintain a summary table while minimizing the batch window needed for maintenance, and (2) how to maintain a large set of summary tables defined over the same base tables.
While several papers have addressed the issues relating to choosing and materializing a set of summary tables, this is the first paper to address maintaining summary tables efficiently.</abstract></paper><paper><title>Database buffer size investigation for OLTP workloads</title><author><AuthorName>Thin-Fong Tsuei</AuthorName><institute><InstituteName>Sun Microsystems, Inc.</InstituteName><country></country></institute></author><author><AuthorName>Allan N. Packer</AuthorName><institute><InstituteName>Sun Microsystems, Inc.</InstituteName><country></country></institute></author><author><AuthorName>Keng-Tai Ko</AuthorName><institute><InstituteName>Sun Microsystems, Inc.</InstituteName><country></country></institute></author><year>1997</year><conference>International Conference on Management of Data</conference><citation><name>Amdahl, G.,"Validity of the Single Processor Approach to Achieving Large Scale Computing Capabilities", AFIPS Conf. Proceedings, 1967</name><name>Artis, H.,"Quantifying Multiprocessor Overheads", Proceedings of CMG Conference, 1991.</name><name>Chou, H. and DeWitt, D., "An Evaluation of Buffer Management Strategies for Relational Database Systems", Prigs of VLDB, 1985.</name><name>"IBM DB2 Administration Guide for Common Sewers", IBM Corp. 1995.</name><name>"IBM DB2 Information and Concepts Guide for Common Sewers", IBM Corp. 1995</name><name>Asit Dan , Don Towsley, An approximate analysis of the LRU and FIFO buffer replacement schemes, Proceedings of the 1990 ACM SIGMETRICS conference on Measurement and modeling of computer systems, p.143-152, April 1990, Univ. of Colorado, Boulder, Colorado, United States</name><name>Asit Dan , Philip S. Yu , Jen-Yao Chung, Database Access Characterization for Buffer Hit Prediction, Proceedings of the Ninth International Conference on Data Engineering, p.134-143, April 19-23, 1993</name><name>"DamDesk Statistic Guide", Data Description, Inc.</name><name>Draper, N. and Smith, H., "Applied Regression Analysis", seexmd edition, John Wtley&amp; Sons, 1981.</name><name>Wolfgang Effelsberg , Theo Haerder, Principles of database buffer management, ACM Transactions on Database Systems (TODS), v.9 n.4, p.560-595, Dec. 1984</name><name>Jim Gray, Benchmark Handbook: For Database and Transaction Processing Systems, Morgan Kaufmann Publishers Inc., San Francisco, CA, 1992</name><name>Gunther, N., "A Simple Capacity Model for Massivdy Parallel Transaction Systems", proceedings of CMG, 1993.</name><name>Gunther, N., "Understanding The MP Effect: Multiprocessing in Pictures", to appear in Proee, edings of CMG, 1996.</name><name>Edward D. Lazowska , John Zahorjan , G. Scott Graham , Kenneth C. Sevcik, Quantitative system performance: computer system analysis using queueing network models, Prentice-Hall, Inc., Upper Saddle River, NJ, 1984</name><name>Scott T. Leutenegger , Daniel Dias, A modeling study of the TPC-C benchmark, Proceedings of the 1993 ACM SIGMOD international conference on Management of data, p.22-31, May 25-28, 1993, Washington, D.C., United States</name><name>McGalliard, J'., "Case Study of Table-Top Sizing with Workload-Specific Estimates of the Multiprocessor Effect", proceeAings of CMG Conference, 1995.</name><name>C. Mohan , Don Haderle , Bruce Lindsay , Hamid Pirahesh , Peter Schwarz, ARIES: a transaction recovery method supporting fine-granularity locking and partial rollbacks using write-ahead logging, ACM Transactions on Database Systems (TODS), v.17 n.1, p.94-162, March 1992</name><name>Michael Stonebraker, Operating system support for database management, Communications of the ACM, v.24 n.7, p.412-418, July 1981</name><name>TIC Benchmark C Standard Specification Revision 3.0", Transaction Processing Performance Council, February 15, 1995.</name></citation><abstract>It is generally accepted that On-Line Transaction Processing (OLTP) systems benefit from large database memory buffers. As enterprise database systems become larger and more complex, hardware vendors are building increasingly large systems capable of supporting huge memory configurations. Database vendors in turn are developing buffer schemes to exploit this physical memory.