More Web Proxy on the site http://driver.im/

article

Free access

Performance evaluation of extended storage architectures for transaction processing

Author:

Erhard RahmAuthors Info & Claims

ACM SIGMOD Record, Volume 21, Issue 2

Pages 308 - 317

https://doi.org/10.1145/141484.130329

Published: 01 June 1992 Publication History

Abstract

The use of non-volatile semiconductor memory within an extended storage hierarchy promises significant performance improvements for transaction processing. Although page-addressable semiconductor memories like extended memory, solid-state disks and disk caches are commercially available since several years, no detailed investigation of their use for transaction processing has been performed so far. We present a comprehensive simulation study that compares the performance of these storage types and of different usage forms. The following usage forms are considered: allocation of entire log and database files in non-volatile semiconductor memory, using a so-called write buffer to perform disk writes asynchronously, and caching of database pages at intermediate storage levels (in addition to main memory caching). Simulation results will be presented for the debit-credit workload frequently used in transaction processing benchmarks.

References

[1]

Anon et al.: A Measure of Transaction Processing Power. Datamation, 112-118, April 1985.

Digital Library

[2]

Bob.n, V.; H~der, T.; Rahm, E.: Extended Memory Support for High Performance Transaction Processing. Prec. 6th (German) Conf. on Measurement, Modelling and Evaluation of Computer Systems, Informatik-Fachberichte 286, Springer-Verlag, 199 I.

[3]

Cohen, E.I.; King, G.M.; Brady, J.T.: Storage Hierarchies. IBM Systems Journal 28 (1), 62-76, 1989.

Digital Library

[4]

Copeland, G.; Keller, T.; Krishnamurthy, R.; Smith, M.: The Case for Safe RAM. Prec. 15th VLDB, 1989.

Digital Library

[5]

Copeland, G.; Keller, T.; Smith, M.: Database Buffer and Disk Configuring and the Battle of the Bottlenecks. Prec. 4th int. Workshop on High Performance Transaction Systems, Asilomar, CA, Sep. 1991

[6]

DeWitt, D. et al.: Implementation Techniques for Main Memory Database Systems. Proc. ACM SIGMOD conf., 1-8, 1984.

Digital Library

[7]

Eich, M.: Main Memory Database Research Directions. Proc. 6th Int. Workshop on Database Machines, LNCS 368, Springer-Vetlag) 251-268, 1989.

Digital Library

[8]

Gray, L; Horst, B.; Walker, M.: Parity Striping of Disc Arrays: Low-Cost Reliable Storage with Acceptable Throughput. Proc. 16th VLDB, 148-161, 1990.

Digital Library

[9]

Garda-Molina, H.; Lipton, R.J.; Valdes) L: A Massive Memory Machine. IEEE Trans. on Computers 33 (5), 391-399, 1984.

[10]

Gray, J.; Putzolu, F.: The S Minute Rule for Trading Memory for Disk Accesses and the 10 Byte Rule for Trading Memory for CPU Time. Proc. ACM SIGMOD conf., 395-398, 1987.

Digital Library

[11]

Gray, J. (ed.): The Benchmark Handbook for Database and Tramaction Processing Systems. Morgan Kaufmann 1991.

Digital Library

[12]

Grossman, C.P.: Cache-DASD Storage Design for Improving System Performance. IBM Sys. Journal 24 (3/4), 316-334, 1985.

[13]

Grossman, C.P.: Evolution of the DASD Storage Control. IBM Systems Journal 28 (2), 196-226, 1989.

Digital Library

[14]

Htirder, T.; Reuter, A.: Principles of Transaction-Oriented Database Recovery. ACM Comp. Surveys 15 (4), 287-317, 1983.

Digital Library

[15]

Kull, D.: Busting the I/O Bottleneck. Computer & Communications Decisions, 101-109, May 1987.

[16]

Lehman, T.J.: Design and Performance Evaluation of a Main Memory Relational Database System. Ph.D. Thesis, Comp. Science Dept., Univ. of Wisconsin, Madison, 1986.

Digital Library

[17]

Livny, M.: DeNet User's Guide. Version 1.6, Comp. Science Dept., Univ. of Wisconsin, Madison, 1989.

[18]

Menon, J.; Hammg, M.: The IBM 3990 Disk Cache. Proc. IEEE Spring CompCon, 146-151, 1988.

[19]

Patterson, D.A.; Gibson, G.; Katz, R.H.: A Case for Redundant Arrays of Inexpensive Disks (RAID). Proc. ACM SIGMOD conf., 109-116, 1988.

Digital Library

[20]

Rahm, E.: Use of Global Extended Memory for Distributed Transaction Processing. Proc. of the 4th Int. Workshop on High Performance Transaction Systems, Asflomar, Sep. 1991.

[21]

Rahm, E.: Performance Evaluation of Extended Storage Architectures for Transaction Processing. TR 216/91, Dept. of Comp. Science, Univ. Kaiserslautem (extended version of this paper)

[22]

Rubsam, K.G.: MVS Data Services. IBM Systems Journal 28 (1), 151-164, 1989.

Digital Library

[23]

Smith, A.J.: Disk Cache - Miss Ratio Analysis and Design Considerations. ACM Trans. Comp. Systems 3 (3), 161-203, 1985.

Digital Library

Cited By

Martin JVázquez NCorbacho JPuigjaner R(2000)Extending SMART2 to Predict the Behaviour of PL/SQL-based ApplicationsComputer Performance Evaluation10.1007/3-540-68061-6_24(292-305)Online publication date: 16-Mar-2000
https://doi.org/10.1007/3-540-68061-6_24
Salem KAkyürek S(1995)Management of Partially Safe BuffersIEEE Transactions on Computers10.1109/12.37203244:3(394-407)Online publication date: 1-Mar-1995
https://dl.acm.org/doi/10.1109/12.372032
Rahm ERahm E(1993)LiteraturHochleistungs-Transaktionssysteme10.1007/978-3-322-84931-1_10(269-279)Online publication date: 1993
https://doi.org/10.1007/978-3-322-84931-1_10
Show More Cited By

Index Terms

Performance evaluation of extended storage architectures for transaction processing
1. Information systems
  1. Data management systems
    1. Database management system engines
      1. Database transaction processing
  2. Information storage systems
    1. Record storage systems
    2. Storage management
2. Software and its engineering
  1. Software organization and properties
    1. Contextual software domains
      1. Operating systems
        File systems management
        Memory management

Recommendations

Performance evaluation of extended storage architectures for transaction processing
SIGMOD '92: Proceedings of the 1992 ACM SIGMOD international conference on Management of data

The use of non-volatile semiconductor memory within an extended storage hierarchy promises significant performance improvements for transaction processing. Although page-addressable semiconductor memories like extended memory, solid-state disks and disk ...
File system performance and transaction support
System Performance and Transaction Support

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

cover image ACM SIGMOD Record

ACM SIGMOD Record Volume 21, Issue 2

June 1, 1992

415 pages

ISSN:0163-5808

DOI:10.1145/141484

Editor:
Michael Stonebraker

Issue’s Table of Contents

SIGMOD '92: Proceedings of the 1992 ACM SIGMOD international conference on Management of data
June 1992
416 pages
ISBN:0897915216
DOI:10.1145/130283
Editor:
Michael Stonebraker
Univ. of California at Berkeley

Copyright © 1992 ACM.

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 01 June 1992

Published in SIGMOD Volume 21, Issue 2

Check for updates

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

17
Total Citations
View Citations
134
Total Downloads

Downloads (Last 12 months)86
Downloads (Last 6 weeks)6

Reflects downloads up to 13 Dec 2024

Other Metrics

View Author Metrics

Citations

Cited By

Martin JVázquez NCorbacho JPuigjaner R(2000)Extending SMART2 to Predict the Behaviour of PL/SQL-based ApplicationsComputer Performance Evaluation10.1007/3-540-68061-6_24(292-305)Online publication date: 16-Mar-2000
https://doi.org/10.1007/3-540-68061-6_24
Salem KAkyürek S(1995)Management of Partially Safe BuffersIEEE Transactions on Computers10.1109/12.37203244:3(394-407)Online publication date: 1-Mar-1995
https://dl.acm.org/doi/10.1109/12.372032
Rahm ERahm E(1993)LiteraturHochleistungs-Transaktionssysteme10.1007/978-3-322-84931-1_10(269-279)Online publication date: 1993
https://doi.org/10.1007/978-3-322-84931-1_10
Shen Gao Jianliang Xu Harder TBingsheng He Choi BHaibo Hu (2015)PCMLogging: Optimizing Transaction Logging and Recovery Performance with PCMIEEE Transactions on Knowledge and Data Engineering10.1109/TKDE.2015.245315427:12(3332-3346)Online publication date: 1-Dec-2015
https://dl.acm.org/doi/10.1109/TKDE.2015.2453154
Gao SXu JHe BChoi BHu H(2011)PCMLoggingProceedings of the 20th ACM international conference on Information and knowledge management10.1145/2063576.2063977(2401-2404)Online publication date: 24-Oct-2011
https://dl.acm.org/doi/10.1145/2063576.2063977
Kohno KKameda H(2005)The effects on responsiveness of priority scheduling of packet transmissions in parallel OLTP systemsHigh-Performance Computing and Networking10.1007/BFb0031670(968-969)Online publication date: 25-Jun-2005
https://doi.org/10.1007/BFb0031670
Boulos JBoudigue D(2005)An application of SMART2: A tool for performance evaluation of relational database programsQuantitative Evaluation of Computing and Communication Systems10.1007/BFb0024304(11-25)Online publication date: 9-Jun-2005
https://doi.org/10.1007/BFb0024304
Sivasankaran RRamamritham KStankovic J(2002)System Failure and RecoveryReal-Time Database Systems10.1007/0-306-46988-X_9(109-124)Online publication date: 2002
https://doi.org/10.1007/0-306-46988-X_9
Venkataraman SNaughton JLivny M(1998)Remote load-sensitive caching for multi-server database systemsProceedings 14th International Conference on Data Engineering10.1109/ICDE.1998.655814(514-521)Online publication date: 1998
https://doi.org/10.1109/ICDE.1998.655814
Ng WChen P(1997)Integrating Reliable Memory in DatabasesProceedings of the 23rd International Conference on Very Large Data Bases10.5555/645923.673643(76-85)Online publication date: 25-Aug-1997
https://dl.acm.org/doi/10.5555/645923.673643
Show More Cited By

View Options

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

Media

Figures

Other

Tables

View Issue’s Table of Contents