article

Free access

IBM's relational DBMS products: features and technologies

Author:

C. MohanAuthors Info & Claims

ACM SIGMOD Record, Volume 22, Issue 2

Pages 445 - 448

https://doi.org/10.1145/170036.170129

Published: 01 June 1993 Publication History

Abstract

This paper very briefly summarizes the features and technologies implemented in the IBM relational DBMS products. The topics covered include record and index management, concurrency control and recovery methods, commit protocols, query optimization and execution techniques, high availability and support for parallelism and distributed data. Some indications of likely future product directions are also given.

References

[1]

Anderson, M., Cole, R., Davidson, W., Lee, W., Passe, P., Ricard, G., Youngren, L. Index Key Range Est imator, U.S. Patent 4,774,657, IBM, 1988.

[2]

Anderson, M., Cole, R. An Integrated Data Base, In IBM Application Systeml400 Technology, Document Number SA21-9540, ibM, June 1988.

[3]

Crus, R., Engles, R., Haderle, D., Herren, H. Method for Referential Constraint Enforcement in a Database Management System, U.S. Patent 4,947,320, IBM, 1990.

[4]

Chamberltn, D., Gilbert, A., Yost, R. A History of System R and SQL/Oata System, Prec. 7th International Conference on Very Large Data Bases, Cannes, September 1981.

[5]

Chang, J., Haderle, D., Hedges, R., lyer, B., Messinger, T., Mohan, C., Wang, Y. An Efficient Hybrid Join Algorithm: a OB2 Prototype, Prec. 7th International Conference on Data Engineering, Kobe, April 1991.

Digital Library

[6]

Choy, D., Mohan, C. An Efficient Indexing Method for Partitioned Data, IBM Research Report, IBM Almaden Research Center, January 1993.

[7]

Chang, P,Y., Myra, W.W, 05/Z EE Database Manager Overview and Techn icaI Highlights, IBM Systems Journal, Vol. 27, No. 2, 1988.

Digital Library

[8]

Clark, B.E., Corngan, M.J. AppZication System/400 Performance Characteristics, IBM Systems Journal, Vet. 28, No. 3, 1989.

Digital Library

[9]

Chang, J., Loosely, C., Shibamiya, A., Worthington, P. IBM Database 2 Performance: Des ign, Imp I ementat ion, and Tuning, IBM Systems Journal, Vol. 23, No. 2, 1984.

[10]

Crus, R., Haderle, D., Tang, J. Method for Minimizing Locking and Reading in a Segmented Storage Space, U.S. Patent 4,961,134, IBM, October 1990.

[11]

Crus, R. Data Recovery in IBM Database 2, IBM Systems Journal, Vol. 23, No. 2, 1984.

Digital Library

[12]

DeLorme, D., Holm, M., Lee, W., Passe, P., RIcard, G., Timms, Jr., G., Youngren, L. Database Index Journal ing for Enhanced Recovery, U.S. Patent 4,819,156, IBM, April 1989.

[13]

Gray, J., Mr Jones, P., Blasgen, M., Lindsay, B., Lone, R., Price, T., Putzotu, F., Tra#ger, !. The Recovery Manager of the System R Database Manager, ACM Computing Surveys, Vol. 13, No. 2, June 1981.

Digital Library

[14]

Distributed Relational Database Architecture Reference, Document Number SC26-4651, IBM, August 1990.

[15]

Systems Application Architecture Common Programming Interface Database Level 2 Reference, Document Number SC26-4798-01, IBM, July 1992.

[16]

Lehman, T., Lindsay, B. The Starburst Long Field Manager, Prec. 15th International Conference on Very Large Data Bases, Amsterdam, August 1989.

Digital Library

[17]

Lehman, G., Dndsay, B., Pirahesh, H., Schiefer, B. Extensions to Sterburst: Objects, Types, Functions, and Rules, Communications of the ACM, Vol. 34, Number 10, October 1991.

Digital Library

[18]

Mohan, C., Bntton, K., C#tron, A., Samaras, G. Generel ized Presumed Abort" Marrying Presumed Abort and SNA's LU 6,2 Commit Protocols, IBM Research Report RJ8684, IBM Almaden Research Center, March 1992.

[19]

Mohan, C., Haderte, D., Lindsay, B., Pirahesh, H., Schwarz, P. ARIES: A Transaction Recovery Method Supporting Fine-Granularity Locking end Partial RotZbacks Using Write-Ahead Logging, ACM Transactions on Database Systems, Vol. 17, No. I, March 1992.

Digital Library

[20]

Mohan, C., Haderle, D., Wang, Y., Chang, J. Single Table Access Using Multiple Indexes: Optimization, Execution, and Concurrency Control Techniques, Prec. International Conference on Extending Data Base Technology, Venice, March 1990.

Digital Library

[21]

Mohan, C. ARIES/KVL: A Key-Value Locking Method for Concurrency Control of MuZtiaction Transactions Operating on B-Tree Indexes, Prec. 16th International Conference on Very Large Data Bases, Brisbane, August 1990.

Digital Library

[22]

Mohan, C. Commit_LSN: A Novel and Simple Method for Reducing Locking and Latching in Transaction Processing Systems, Prec. 16th International Conference on Very Large Data Bases, Brisbane, August 1990.

Digital Library

[23]

Mohan, C. Interactions Between Query Optimization and Concurrency Centre Z, Prec. 2nd international Workshop on Research Issues on Data Engineering: Transaction and Query Processing, Tempe, February 1992. Also available as IBM Research Report RJ8681, IBM Almaden Research Center, March 1992.

[24]

Mohan, C., Levlne, F. ARIES/IM: An Efficient and High Concurrency Index Management Method Us ing Write-Ahead Logging, Prec. ACM SIGMOD International Conference on Management of Data, San Diego, June 1992.

Digital Library

[25]

Mohan, C., Lindsay, B., Obermarck, R. Transaction Management in the R* Distributed Data Base Management System, ACM Transactions on Database Systems, Vol. 11, No. 4, December 1986.

Digital Library

[26]

Mohan, C., Narang, I. Recovery and Coherency-Control Protocols for Fast Intersystem Page Transfer and Fine-Granularity Locking in a Shared Disks Transact ion Environment, Proc. 17th International Conference on Very Large Data Bases, Barcelona, September 1991.

Digital Library

[27]

Mohan, C_, Narang, I. An Efj'icient and Flexible Method for Archiving a Data Bose, Prec. ACM SIGMOD International Conference on Management of Data, Washington, D.C., May 1993.

Digital Library

[28]

Tang, J., Gumaer, R. Managing IBM Database Z Buffers to Maximize Performance, IBM Systems Journal, Vol. 23, No. 2, 1984.

Cited By

An MPark JWang TNam BLee S(2023)NV-SQL: Boosting OLTP Performance with Non-Volatile DIMMsProceedings of the VLDB Endowment10.14778/3583140.358315916:6(1453-1465)Online publication date: 1-Feb-2023
https://dl.acm.org/doi/10.14778/3583140.3583159
Kodandaramaih RKodavalla HVenkataramanappa G(2020)Concurrent updates to pages with fixed-size rows using lock-free algorithmsProceedings of the VLDB Endowment10.14778/3415478.341554413:12(3195-3203)Online publication date: 14-Sep-2020
https://dl.acm.org/doi/10.14778/3415478.3415544
Sockut GIyer B(2009)Online reorganization of databasesACM Computing Surveys10.1145/1541880.154188141:3(1-136)Online publication date: 30-Jul-2009
https://dl.acm.org/doi/10.1145/1541880.1541881
Show More Cited By

Index Terms

IBM's relational DBMS products: features and technologies
1. Information systems
  1. Data management systems
    1. Database management system engines
      1. Database query processing
      2. Parallel and distributed DBMSs
    2. Query languages
2. Theory of computation
  1. Theory and algorithms for application domains
    1. Database theory
      1. Database query languages (principles)
      2. Database query processing and optimization (theory)

Recommendations

IBM's relational DBMS products: features and technologies
SIGMOD '93: Proceedings of the 1993 ACM SIGMOD international conference on Management of data

This paper very briefly summarizes the features and technologies implemented in the IBM relational DBMS products. The topics covered include record and index management, concurrency control and recovery methods, commit protocols, query optimization and ...
IBM Relational Database Systems: The Early Years

The relational data model, proposed by E.F. Codd in 1970, inspired several research projects at IBM and elsewhere. Among these was System R, which demonstrated the commercial viability of relational database systems. This article describes the research ...
Preserving Aggregation in an Object-Relational DBMS
ADVIS '02: Proceedings of the Second International Conference on Advances in Information Systems

Aggregation is an important concept in database design where composite objects can be modelled during the design of database applications. Therefore, preserving the aggregation concept in database implementation is essential. In this paper, we propose ...

Comments

Information & Contributors

Information

Published In

cover image ACM SIGMOD Record

ACM SIGMOD Record Volume 22, Issue 2

June 1, 1993

558 pages

ISSN:0163-5808

DOI:10.1145/170036

Editors:
Peter Buneman
Univ. of Pennsylvania
,
Sushil Jajodia,
Won Kim
UniSQL, Inc., Austin, TX

Issue’s Table of Contents

SIGMOD '93: Proceedings of the 1993 ACM SIGMOD international conference on Management of data
June 1993
566 pages
ISBN:0897915925
DOI:10.1145/170035
Editors:
Peter Buneman
Univ. of Pennsylvania
,
Sushil Jajodia

Copyright © 1993 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 1993

Published in SIGMOD Volume 22, Issue 2

Check for updates

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

12
Total Citations
View Citations
925
Total Downloads

Downloads (Last 12 months)74
Downloads (Last 6 weeks)14

Reflects downloads up to 07 Nov 2024

Other Metrics

View Author Metrics

Citations

Cited By

An MPark JWang TNam BLee S(2023)NV-SQL: Boosting OLTP Performance with Non-Volatile DIMMsProceedings of the VLDB Endowment10.14778/3583140.358315916:6(1453-1465)Online publication date: 1-Feb-2023
https://dl.acm.org/doi/10.14778/3583140.3583159
Kodandaramaih RKodavalla HVenkataramanappa G(2020)Concurrent updates to pages with fixed-size rows using lock-free algorithmsProceedings of the VLDB Endowment10.14778/3415478.341554413:12(3195-3203)Online publication date: 14-Sep-2020
https://dl.acm.org/doi/10.14778/3415478.3415544
Sockut GIyer B(2009)Online reorganization of databasesACM Computing Surveys10.1145/1541880.154188141:3(1-136)Online publication date: 30-Jul-2009
https://dl.acm.org/doi/10.1145/1541880.1541881
Mohan CHaderle D(2005)Algorithms for flexible space management in transaction systems supporting fine-granularity lockingAdvances in Database Technology — EDBT '9410.1007/3-540-57818-8_47(131-144)Online publication date: 3-Jun-2005
https://doi.org/10.1007/3-540-57818-8_47
Mohan C(2005)A survey of DBMS research issues in supporting very large tablesFoundations of Data Organization and Algorithms10.1007/3-540-57301-1_19(279-300)Online publication date: 4-Jun-2005
https://doi.org/10.1007/3-540-57301-1_19
Mohan C(1999)Repeating History Beyond ARIESProceedings of the 25th International Conference on Very Large Data Bases10.5555/645925.671526(1-17)Online publication date: 7-Sep-1999
https://dl.acm.org/doi/10.5555/645925.671526
Wiener JNaughton J(1995)OODB Bulk Loading RevisitedProceedings of the 21th International Conference on Very Large Data Bases10.5555/645921.673168(30-41)Online publication date: 11-Sep-1995
https://dl.acm.org/doi/10.5555/645921.673168
Mohan C(1995)Disk read-write optimizations and data integrity in transaction systems using write-ahead loggingProceedings of the Eleventh International Conference on Data Engineering10.1109/ICDE.1995.380378(324-331)Online publication date: 1995
https://doi.org/10.1109/ICDE.1995.380378
Wiener JNaughton J(1994)Bulk Loading into an OODBProceedings of the 20th International Conference on Very Large Data Bases10.5555/645920.672979(120-131)Online publication date: 12-Sep-1994
https://dl.acm.org/doi/10.5555/645920.672979
Mohan C(1993)A Cost-Effective Method for Providing Improved Data Availability During DBMS Restart Recovery After a FailureProceedings of the 19th International Conference on Very Large Data Bases10.5555/645919.672810(368-379)Online publication date: 24-Aug-1993
https://dl.acm.org/doi/10.5555/645919.672810
Show More Cited By

View Options

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Get Access

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