IBM DB2 database Review: 40 years (1)

The following articles mainly describe the development history of IBM DB2 databases over the past 40 years. I saw the development history of IBM DB2 databases over the past 40 years on the relevant website two days ago, I think it's good. I just want to share it with you. I hope it will help you in this regard.

IBM, database, history, development

1968: IBM has successfully developed IMS V1 on IBM  computers. This is the industry's first hierarchical database management system and the most famous and typical hierarchical database. As relational databases are widely used today, many enterprises are still using this database, and its vitality is evident.

1970: this was an epoch year in the history of databases. E., a researcher at IBM. f. codd published the first paper "A Relational Model of Data for Large Shared Data Banks" about Relational database theory in the industry. It first proposed the concept of A Relational Model. This paper is one of the most important papers in the history of computer science. It also laid the role of Dr. Codd as "father of Relational Database.

1973: the IBM Research Center launched the System R project to explore and study the practical feasibility of multi-user and relational databases with a large amount of data. This project plays an important role in the development of DB2, it laid a good foundation for the advent of DB2. The project was awarded the ACM Software System Award in 1988 for a large number of achievements that play a key role in the development of IBM DB2 database technology.

1974: IBM researchers Don Chamberlin and Ray Boyce published the paper "SEQUEL: A Structured English Query Language" through the practice of the System R project ". The SEQUEL language proposed in this paper is a non-procedural query language that is more suitable for end users than relational calculus and relational algebra. The well-known SQL language is developed based on it.

1975: IBM researcher Don Chamberlin and Morton Astrahan's paper "Implentation of a Structured English Query Language" describes the first implementation scheme of the SQL Language based on SEQUEL. This is also one of the major achievements of the System R project.

1976: the IBM System R project team published the paper "A System R: Relational Approach to Database Management", describing A prototype of A Relational IBM DB2 Database.

1976: IBM researcher Jim Gray published a paper titled "Granularity of Locks and Degrees of Consistency in a Shared DataBase", formally defining the concept of DataBase transactions and the mechanism of data Consistency.

1977: The System R prototype was installed in three clients: Boeing, Pratt & Whitney, and Upjohn Pharmaceuticals. This indicates that System R is already a mature database System and can support important commercial applications.

1979: IBM researcher Pat Selinger described the industry's first Relational query optimizer in her paper "Access Path Selection in a Relational Database Management System.

1980: IBM released the S/38 System, which integrates a database server prototype of System R. To facilitate application transplantation, its APIs are the same as those of S/3 and S/32.

1981: because of the invention of the relational database model, IBM researcher E. F. Codd received the ACM Turing Award, which is the highest honor of the computer scientific community. Dr. Codd is also a computer scientist who has won this award for his great contributions to the database field following Charles mongoman Charles W. Bachman.

1982: the emergence of ibm pc marks the birth and development of the PC industry. Over a long period of time, the words "ibm pc Compatible" marked on PCs of various brands have witnessed IBM's brilliant achievements in this field.

1982: IBM released SQL/DS for VSE and VM. This is the industry's first commercial IBM DB2 database management system that uses SQL as an interface. The System is also designed based on the System R prototype.

1983: IBM released DATABASE 2DB2 In this year.) for MVS is codenamed "Eagle"), a long-lasting brand emerged.

1986: System/38 V7 released. The System is configured with a query optimizer for the first time to optimize the application's access plan.

1987: IBM released the OS/2 V1.0 extension with relational database capabilities. This is the first time that IBM has extended the processing capabilities of relational databases to the microcomputer system. This is also the prototype of DB2 for OS/2, Unix and Window.

1988: IDUG International DB2 user organization was established. This indicates that DB2 users have formed a considerable scale.