DB2 Memorabilia _DB2

The DB2 tutorial being read is: DB2 memorabilia.

1968:IBM has successfully developed IMS V1 on IBM 360 computers, the first hierarchical database management system in the industry and the most famous and typical in hierarchical databases. In the relational database in the way of today, many enterprises still use the database, its vitality can be seen.

1970: This is a landmark year in the history of the database, IBM researcher E.f.codd published the industry's first paper on relational database theory "a relational Model of data for Large Shared Data Banks", the first proposed The concept of a relational model. This paper is one of the most important papers in the history of computer science, and it also lays the Codd of "father of relational database".

1970: The Apollo 13th spacecraft failed to reach the moon, and IBM computers played an important role in the rescue of astronauts.

The 1973:IBM Research Center launched the System R project, which aims to explore and study the practical feasibility of a relational database with a large number of users and data, which plays an important role in the development of DB2, which lays a good foundation for the advent of DB2. The project was awarded the ACM Software System Award in 1988 because of a large number of results that have been crucial to the development of the database technology.

1974:IBM researcher Don Chamberlin and Ray Boyce published the paper "Sequel:a Structured Chinese Query Language" through the practice of the System R project. The SEQUEL language presented in this paper is a non programmed query language which is more suitable for end users than relational calculus and relational algebra, and the SQL language we know now is based on it.

1975:IBM's researcher Don Chamberlin and Morton Astrahan's paper "Implentation of a structured Chinese Query Language" describes SQL on a SEQUEL basis The first implementation of the language. This is also one of the major achievements of the System R project.

The 1976:IBM System R project team published the paper "a system r:relational approach to Database Management", which describes the prototype of a relational database.

1976:IBM's researcher, Jim Gray, published a paper entitled "Granularity of Locks and Degrees of consistency in a Shared database," which formally defines the concepts and data consistency of the databases transaction. Mechanism.

The 1977:system R prototype was installed at 3 customers: Boeing, Pratt & Whitney, and Upjohn Pharmaceutical Co., Ltd. This indicates that system R is technically a more mature database system that can support important commercial applications.

1979:IBM's 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 with System R as its prototype. For ease of application porting, its APIs are consistent with S/3, S/32 APIs.

1981: Thanks to the invention of the relational database model, IBM researcher E.f.codd accepted the ACM Turing Award, which is the highest honor in the computer science community. Dr. Codd, after Charles Bachmann, another computer scientist who has made a huge contribution to the field of database Bachman.

The emergence of the 1982:IBM pc marks the beginning of the development of the PC industry. For a long time to come, the words "IBM PC compatible" marked on various brands of PCs attest to IBM's brilliance in this field.

1982:IBM released the sql/ds for VSE and VM. This is the industry's first commercial database management system with SQL as its interface. The system is also designed based on the systems R prototype.

1983: Long-awaited started out, IBM in this year released the Database 2 (DB2) for MVS (internal code "Eagle"), a prosperous brand has emerged.

1986:SYSTEM/38 V7 release, the system configured the query optimizer for the first time to optimize the application's access plan.

1987:IBM publishes OS/2 V1.0 extensions with relational database capabilities, the first time IBM has extended relational database processing capabilities to a microcomputer system. This is also the embryonic form of DB2 for OS/2, Unix and Windows.

1988:IBM released sql/400, which provides SQL support for AS/400 servers that have integrated relational database management systems.

1988:idug (International DB2 User organization) was established. This marks the DB2 users have formed a considerable scale.

1989:IBM defines the Common SQL and IBM Distributed Relational Database Architecture (DRDA) and is implemented on all IBM relational database management systems.

1989: The first IDUG North American Congress was held in Chicago, USA.

1992: The first IDUG European Conference is held in Geneva, Switzerland. This marks the globalization trend of DB2 application.

1993:IBM released DB2 for OS/2 V1 (DB2 for OS/2 can be abbreviated as DB2/2) and DB2 for rs/6000 V1 (DB2 for rs/6000 can be abbreviated for db2/6000), which is the first time DB2 in Intel and UNIX platforms.

1993: Gerstner (Louis v. Gerstner) into IBM. Under the command of the master of Management, IBM has made drastic reforms to turn the tide.

1994:DB2 for MVS V4 introduces distributed computing (data sharing) on the host computer through the implementation of parallel Sysplex technology.

1994:IBM publishes DB2 parallel version running on rs/6000 SP2, which has a scalable architecture that adapts to large data warehouses and complex query tasks.

1994:IBM extends DB2 Common Server to HP-UX and Sun Solaris. DB2 began supporting UNIX platforms developed by other companies.

1994:DB2/400 integration is published in os/400 V3.1 and introduces mechanisms such as parallelism, stored procedures, and referential integrity.

1994:IBM announces that DB2 products on OS/2 and AIX platforms can support multimedia data and object-oriented applications.

1995:IBM publishes the DB2 Common Server V2, the first object-relational database product that can run on multiple platforms, and is able to provide full support to the WEB. Datajoiner for AIX was also born in this year, the product gives DB2 the ability to support heterogeneous databases.

1995:DB2 is released on the first version (DB2 V2) on Windows NT and Sinix platforms.