The Community for Technology Leaders
RSS Icon
Issue No.02 - April-June (2013 vol.35)
pp: 54-66
Donald J. Haderle , Haderle Consulting
IBM's Database 2 (DB2) relational database management system (RDBMS) shipped in the early 1980s and drove billions of dollars of revenue to IBM and other firms within its first decade. The product spawned a wealth of add-on tools, shaped the future of mainframe computing, and provided independent software vendors with a strong, reliable, and scalable platform for mission-critical applications. Today, DB2 spans multiple operating systems and is widely deployed across a broad spectrum of industries. This article explores the beginnings of DB2 and traces its rise to prominence.
Decision support systems, Database systems, Companies, Marketing and sales, History, mainframe computing, history of computing, IBM, relational database management systems, DB2
Donald J. Haderle, Cynthia M. Saracco, "The History and Growth of IBM's DB2", IEEE Annals of the History of Computing, vol.35, no. 2, pp. 54-66, April-June 2013, doi:10.1109/MAHC.2012.55
1. "Relational Data Base Management System Announced for Large Enterprises," press release ISG047, IBM, June 1983.
2. E.F. Codd, "A Relational Model of Data for Large Shared Data Banks," Comm. ACM, vol. 13, no. 6, 1970, pp. 377–387.
3. M. Stonebraker, "Retrospection on a Database System," ACM Trans. Database Systems (TODS), vol. 5, no. 2, 1980, pp. 225–240.
4. D.D. Chamberlin et al., "SEQUEL 2: A Unified Approach to Data Definition, Manipulation, and Control," IBM J. Research and Development, vol. 20, no. 6, 1976, pp. 560–575.
5. S.J.P. Todd, "The Peterlee Relational Test Vehicle − A System Overview," IBM Systems J., vol. 15, no. 4, pp. 285–308.
6. M.W. Blasgen et al., "System R: An Architectural Overview," IBM Systems J., vol. 20, no. 1, 1981, pp. 41–62.
7. Donald Chamberlin and Raymond Boyce invented SQ L. For his efforts, Chamberlin was named IBM Fellow in 2003, ACM Fellow in 1994, IEEE Fellow in 2007, and CHM Fellow in 2009.
8. In 1978, IBM announced S/38, which featured a relational DBM S. General availability occurred in 1980.
9. Frost and Sullivan, "Data Base Management Services Software Market," report A747, 1979, pp. 208–213.
10. Chris Date worked on Eagle's development of the Unified Data Language (UDL)i, a single data language that would encompass all data models. Franco Putzolu from IBM Research worked with Dick Crus and others to extend System R's data manager to support multiple data models. Don Haderle led the design for the overall subsystem. See C.J. Date "An Introduction to the Unified Database Language (UDL)" Proc. 6th Int'l Conf. Very Large Data Bases, 1980.
11. Even today, firms' appetites appear to be insatiable. Chris Murphy, "IT Is Too Darn Slow," InformationWeek,28 Feb. 2011.
12. R.A. Crus, "Data Recovery in IBM Database 2," IBM System J., vol. 23, no. 2, 1984, pp. 178–188.
13. J.A. Teng and R.A. Gumaer, "Managing IBM Database 2 Buffers to Maximize Performance," IBM Systems J., vol. 23, no. 2, 1984, pp. 211–218.
14. DB2 was written in PL/S, a 3GL similar to PL/1 but with language constructs that allow system privileged requests (e.g., changing protect keys). By contrast, the System R prototype was written in PL/1.
15. D.J. Haderle and R D. Jackson, "IBM Database 2 Overview," IBM Systems J., vol. 23, no. 2, 1984, pp. 112–125.
16. C. Loosley, "IBM Database 2 Performance Measurements," Info IMS, vol. 5, no. 1, 1985.
17. J.J. Sordi, "The Query Management Facility," IBM Systems J., vol. 23, no. 2, 1984, pp. 126–150.
18. J. Boyle et al., "QMF Usability: How it Really Happened," Proc. IFIP INTERACT: Human-Computer Interaction, IFIP, 1984, pp. 877–882.
19. J. Zachman, "Business Systems Planning and Business Information Control Study: A Comparison," IBM Systems J., vol. 21, no. 1, 1982, pp. 31–53.
20. Leading IBM's early participation in SQL standards efforts were Bob Engles (who wrote the first draft of the ANSI SQL standard submission) and Phil Shaw (who was IBM's initial representative on the ANSI SQL committee). In later years, IBM's key contributors to the SQL standards efforts included Hugh Darwen, Nelson Mattos, and Mel Zimowski.
21. In 1985, IBM's 3081 processor executed 5 to 10 MIPs (million instructions per second) with 32 Mbytes of main memory. In 2011, IBM constructed Watson to compete on the game show Jeopardy using 10 racks of IBM Power 750s with 2870 processor cores able to execute 80 TIPs (trillion instructions per second) with 15 Tbytes of main memory.
22. "IBM Database 2 (DB2) Is Announced with Availability Planned for Third Quarter 1984," announcement letter 5740-XYR, IBM, 1984. (General availability actually occurred in 1985.)
23. Chris Loosely led this effort.
24. Jim Ruddy, who worked for the Boeing database team from 1978 to 1995, provided valuable insight. In 1995 he joined IBM DB2 development, where he helped to make life better for DB2 DBAs.
25. John Naumann and others departed to Tandem; Jerry Baker, John Mortenson, and David Beech joined Oracle; and Marilyn Bohl moved to Digital Research. In addition, E.F. Codd and Chris Date formed a consulting company, as did Colin White and Chris Loosely.
26. Bob Ojala and Fred Orosco streamlined the interfaces between IMS, CICS, and DB2.
27. D. Hauser and A. Shibamiya, "Evolution of DB2 Performance," InfoDB, vol. 6, no. 4, 1992, pp. 2–13.
28. C. Mohan et al., "ARIES: A Transaction Recovery Method Supporting Fine-Granularity Locking and Partial Rollbacks Using Write-Ahead Logging," ACM Trans. Database Systems (TODS), vol. 17, no. 1, 1992, pp. 94–162.
29. P.E. O'Neil, "Model 204 Architecture and Performance," High Performance Transaction Systems, LNCS 359, Springer-Verlag, 1989, pp. 40–59.
30. Steindel and Madson published the benchmark in a paper in 1987. Neither they nor we have been able to resurrect a copy of that paper.
31. C. Mohan et al., "Single Table Access Using Multiple Indexes: Optimization, Execution, and Concurrency Control Techniques," EDBT, 1990, pp. 29–43.
32. J.M. Cheng et al., "An Efficient Hybrid Join Algorithm: A DB2 Prototype," Proc. 7th Int'l Conf. Data Eng. (ICDE), IEEE CS, 1991, pp. 171–180.
33. In particular, Charles Bontempo of IBM's Systems Research Institute taught database management courses to IBM's best and brightest.
34. Warren Lucas, one of IBM's first software sales specialists, was instrumental in driving DB2 into New York accounts and vital to DB2's success.
35. Controversy about compliance with E.F. Codd's 12 rules for relational technology arose in the trade press, including Computerworld's Oct. 14 and 21, 1985 issues. However, this had little impact on DB2 sales because potential customers gave higher priority to serviceability, availability, performance, efficiency, and other areas.
36. Vern Watts, one of the founding fathers of IMS, was an ardent DB2 supporter who helped IMS customers distinguish use cases for DL/1 versus DB2. He helped DB2 establish a foothold in many IMS accounts.
37. O. Stevens Jr., "The History of Datacom/DB," IEEE Annals of the History of Computing, vol. 31, no. 4, 2009, pp. 87–91.
38. As a humorous aside, the hardware divisions paid for DB2 development costs. Just as it was about to be cash positive, DB2 was moved into PRGS (software division), which then reaped the benefits. To this day, IBM hardware venture capitalists remind Haderle how the software division "stole" their investment. Ironically, sales from DB2 on z/OS have since been underwriting other IBM software development projects for years.
39. B.R. Iyer and D. Wilhite, "Data Compression Support in Databases," Proc. 20th Int'l Conf. Very Large Data Bases (VLDB), Morgan Kaufman, 1994, pp. 695–704.
40. P.J. Varman, B.R. Iyer, and D.J. Haderle, "Parallel Merging on Shared and Distributed Memory Computers," PARBASE / Architectures, 1990, pp. 231–249.
41. P. Gassner et al., "Query Optimization in the IBM DB2 Family," IEEE Data Eng. Bull., vol. 16, no. 4, 1993, pp. 4–18.
42. R. Williams et al., "R*: An Overview of the Architecture," Proc. Int'l Conf. Data and Knowledge Bases (JCDKB), 1982, pp. 1–27.
43. B.G. Lindsay, "A Retrospective of R*: A Distributed Database Management System," Proc. IEEE, vol. 75, no. 5, 1987, pp. 668–673.
44. R. Reinsch, "Distributed Database for SAA," IBM System J., vol. 27, no. 3, 1988, pp. 362–369.
45. George Zagelow managed this effort. The technical cross divisional lead was Roger Reinsch. DBTI contributed as well from IBM Research, particularly Pat Selinger and Bruce Lindsay.
46. J.W. Josten et al., "DB2's Use of the Coupling Facility for Data Sharing," IBM System J., vol. 36, no. 2, 1997, pp. 327–351.
47. "S/390 Sysplex Cluster," IBM Systems J., vol. 36, no. 2, 1997 contains nine articles providing an overview of the technology.
48. Y. Wang, "DB2 Query Parallelism: Staging and Implementation," Proc. 21th Int'l Conf. Very Large Data Bases (VLDB), Morgan Kaufman, 1995, pp. 686–691.
49. C. Mohan et al., "Parallelism in Relational Database Management Systems," IBM System J., vol. 33, no. 2, 1994, pp. 349–371.
50. L.M. Haas et al., "Extensible Query Processing in Starburst," Proc. 1989 ACM SIGMOD Int'l Conf. Management of Data, ACM, 1995, pp. 377–388.
51. C.K. Baru and G. Fecteau, "An Overview of DB2 Parallel Edition," Proc. 1995 ACM SIGMOD Int'l Conf. Management of Data, ACM, 1995, pp. 460–462.
52. V. Josifovski et al., "Garlic: A New Flavor of Federated Query Processing for DB2," Proc. 2002 ACM SIGMOD Int'l Conf. Management of Data, ACM, 2002, pp. 524–532.
354 ms
(Ver 2.0)

Marketing Automation Platform Marketing Automation Tool