1968:IBM successfully developed IMS V 1 on IBM 360 computer, which is the first and most famous and typical hierarchical database management system. There are still enterprises using it now.
1970: This is an epoch-making year in database history. IBM researcher E.F.Codd published the first paper on relational database theory, which is a relational model for data in large-scale shared databases, and put forward the concept of relational model for the first time. This paper is one of the most important papers in the history of computer science, which established the position of the father of Codd doctoral relational database.
1973:IBM Research Center started the System R project to study the feasibility of a multi-user and large-volume relational database, which laid a good foundation for the birth of DB2. As a result, a large number of achievements that play a key role in the development of database technology have been obtained, and the project won the ACM software system award of 1988.
1974:IBM researchers Don Chamberlin and Ray Boyce published a paper SEQUEL: a structured English query language through the practice of System R project, and put forward Sequel language, which is the prototype of SQL language.
1975: The paper Meaning of Structured English Query Language by IBM researchers Don Chamberlin and Morton Astrahan describes the first implementation scheme of SQL language based on SEQUEL. This is also one of the main achievements of the System R project.
1976: The project team of IBM System R published the paper "System R: Relative Methods of Database Management", which described the prototype of relational database. Jim Gray, a researcher at IBM, published a paper entitled "The granularity and consistency of locks in shared databases", which formally defined the concept of database transactions and the mechanism of data consistency.
1977: The prototype of system R was installed in three customers, namely, Boeing Company and Pratt &; Whitney and Upjohn Pharmaceuticals. This shows that System R is a mature database system in technology and can support important business applications.
1979: Pat Selinger, an IBM researcher, described the first relational query optimizer in her paper "access path selection in relational database management system".
1980:IBM released the S/38 system, and integrated a database server based on System R. In order to facilitate the transplantation of applications, its API is consistent with S/3 and S/32.
198 1: For inventing the relational database model, IBM researcher E.F.Codd accepted the ACM Turing Award, which is the highest honor of computer science. Dr. Codd is another computer scientist who won this honor for his great contribution in the field of database after charles bachmann.
1982: The appearance of IBM PC marks the beginning of the development of PC industry. For a long time to come, the words IBM PC Compatible marked on various brands of personal computers witnessed the glory of IBM in this field.
1982:IBM released SQL/DS for VSE and virtual machines. This is the first commercial database management system in the industry with SQL as the interface. The system is also designed based on the System R prototype.
1983:IBM released DATABASE 2(DB2) for MVS (internal code is Eagle).
1986: released by system/38v7. The system is equipped with a query optimizer for the first time, which can optimize the access plan of applications.
1987:IBM released the extended version of OS/2 V 1.0, which is the first time that IBM extended the processing capability of relational database to microcomputer system. This is also the prototype of DB2 for OS/2, Unix and Window.
1988:IBM released SQL/400 to provide SQL support for AS/400 server integrated with relational database management system. IDUG (International DB2 User Organization) was established.
1989:IBM defined general SQL and IBM Distributed Relational Database Architecture (DRDA), and implemented them on all IBM relational database management systems. The first IDUG North America Congress was held in Chicago, USA. 1992: The first IDUG European Congress was held in Geneva, Switzerland. This marks the globalization of DB2 applications.
1993:
1.IBM released DB2 for OS/2 V 1(DB2 for OS/2 can be abbreviated as DB2/2) and DB2 forrs/6000v1(DB2 for RS/6000 can be abbreviated as DB2/6000), which is the first time that DB2 appeared on Intel and Unix platforms.
2. Louis v Guo Shina entered IBM.
1994:
1.DB2 For MVS V4 introduces distributed computing (data sharing) on the host by implementing parallel Sysplex technology.
2.IBM released a parallel version of DB2 V 1 running on RS/6000 SP2. Since then, DB2 has an extensible architecture, which can adapt to large data warehouses and complex query tasks. IBM extends DB2 public server to HP-UX and Sun Solaris. DB2 began to support UNIX platforms developed by other companies. DB2/400 integration is released in OS/400 V3. 1, and some mechanisms such as parallelism, stored procedures and referential integrity are introduced. At the same time, IBM announced that DB2 products on OS/2 and AIX platforms can support multimedia data and object-oriented applications.
1995:
1.IBM released DB2 universal server V2, which is the first object-relational database (ORDB) product that can run on multiple platforms and can fully support the Web. DataJoiner for AIX was also born in this year, which gave DB2 the ability to support heterogeneous databases. The first version of DB2 (DB2 V2) was released on Windows NT and SINIX platforms.
2.IBM released data mining technology on AIX and MVS platforms, which is an extender for managing large-scale text, image, audio, video and fingerprint information, and a visual warehouse that can visually build and manage data warehouses.
3.IBM released DB2 www connection v 1 for OS/2 and AIX. Data). This product can quickly publish the data in the database to the Web. The first IDUG Asia-Pacific Conference was held in Sydney, Australia. This year, IBM acquired Lotus Development Company.
1996:
1.IBM released DB2 V2. 1.2, which is the first database product that really supports JAVA and JDBC.
2.DataJoiner began to support access to non-relational databases (such as IMS and VSAM).
3.IBM released Intelligent Miner, which can mine data from DB2-based data sources.
4.IBM acquired Tivoli. IBM changed its name to DB2 Universal Database, which is the first RDBMS that can support multimedia and Web. The system has good scalability, which can be extended from desktop system to large enterprises, adapt to single processor, SMP and MPP computing environment, and can run on all mainstream operating systems and hardware platforms. DB2 V5 is a combination of two previous products: DB2 Common Server V 2. 1.2 and DB2 parallel version 1.2.
5.IBM released the digital library product, which is a multimedia asset management product and the predecessor of IBM Content Manager.
6. the first issue 6. DB2 Magzine was released, and DB2 has its own specialized technical publications.
1997:
1.IBM released DB2 for OS/390 V5 which supports the Web. It is the only database product that can support 64,000 concurrent users and 100 TB.
2.IBM released DB2 UDB for UNIX, Windows and OS/2. This product supports ROLLUP and CUBE functions, which is of great significance for on-line analytical processing (OLAP).
3. The first three. IDUG Technology Forum was held in Toronto, Canada.
4.IBM released EDMSuite for enterprise content management, including OnDemand for managing computer-generated reports and ImagePlus VisualInfo for managing images.
5.IBM's supercomputer Deep Blue based on RS/6000 SP architecture defeated Kasparov, the world chess king, in six games.
1998:
1.IBM released DB2 OLAP server, which is a complete OLAP solution based on DB2. This product was developed in cooperation with Arbor Software(Hyperion's predecessor).
2.IBM released DB2 data link technology to enable DB2 to manage external files.
3. The shareless cluster technology of 3.DB2 is extended to Windows and Solaris platforms.
4.IBM released DB2 Spatial Extender, which was jointly developed with ESRI on the basis of DataJoiner. This product enables DB2 to access geographic information data.
5.IBM released ContentConnect, the predecessor of EIP.
6.DB2 supports SCO UnixWare platform.
7.DB2 UDB V5.2 adds support for SQLJ, Java stored procedures and user-defined functions.
8.IBM released DB2 UDB for AS/400, making AS/400 a machine that fully supports e-commerce.
1999:
In order to support mobile computing, 1/IBM released satellite versions of DB2 UDB and DB2 Everywhere (this is a micro-relational database management system suitable for handheld devices, later called DB2 Everywhere).
2/IBM publishes enterprise information portal, which can provide unified and joint retrieval function across digital library and EDMSuite.
3/DB2 has added a text retrieval function that can recognize XML language, thus introducing XML support and starting the beta program of DB2 XML Extender.
4/IBM released DB2 UDB for Linux on Intel platform.
5/IBM Research Institute integrates the federated functions of DB2 and garlic technology (garlic aims to enable large-scale multimedia information systems) into DiscoveryLink, a life science solution.
2000:
1/IBM released DB2 XML Extender, becoming the first vendor in the industry to provide built-in XML support for databases.
2/IBM integrates visual warehouse into DB2, which provides DB2 with built-in data warehouse management function.
3/DB2' s support for Linux has been further enhanced, including support for Intel-based Linux clusters, and DB2 UDB for Linux that can run on the host and DB2 Everyplace that can run on embedded Linux have been released.
4/DB2 began to support NUMA-Q platform, which can run UNIX-like operating system DYNIX/PTX.
5/DB2 provides high-speed text retrieval in memory through the network. Search extender.
6/IBM started the business of database management tools, initially focusing on providing efficient management tools for IMS and DB2 on the host computer, and finally this business was extended to UNIX, Linux and Windows platforms. Informix database products are also supported.
7/IBM began to provide data Federation function by integrating DataJoiner in DB2.
8/IBM released a content manager for managing digital assets. Both IBM Digital Library and EDMSuite products are included in a framework to provide multimedia asset management and enterprise content management. Dutch National Library and Vatican Library were the earliest users.
9/DB2 sold its10000th license on the host.
200 1:
1/IBM acquired Informix's database business for 1 billion dollars, expanding IBM's distributed database business.
2/DB2 OLAP server adds data mining function.
3/IBM released the first DB2 tool that can support multiple platforms.
4/DB2 supports Web services based on SOAP. DB2 XML Extender and stored procedures can make DB2 a provider of Web services.
5/IBM scientists have made a breakthrough in the field of carbon nanotube transistor technology. IBM made the world's first batch of nano-transistors from carbon nanotubes-a small cylindrical structure composed of carbon atoms with a diameter of 10, which is 500 times smaller than today's silicon-based transistors.
6/DB2 extends its data federation ability to support WebSphere MQ message queues and files with specific formats in life sciences.
7/IBM released DB2 UDB for OS/390.
2002:
1/IBM has released Xperanto, a demonstration version of standards-based information integration middleware, which can be used to optimize access to distributed data sources. This demo version uses advanced technologies such as XML, Xquery, Web services, data federation and full-text retrieval.
2/IBM announced plans to acquire Rational Software Corp, so that IBM software can support the whole process from design, development and deployment to management and maintenance.
3/DB2 extends the ability of data federation through SOAP-based Web services. And can appear in the Web service architecture as consumers of Web services.
4/DB2 OLAP server adds mixed (multidimensional and relational) analysis function.
5/ As a part of IBM's autonomous computing strategy, SMART (self-management and resource adjustment) technology was formally applied in DB2 UDB V8. 1 for the first time.
6/IBM acquired Tarian Sotware, thus strengthening the function of the record management component in the content manager.
2003:
1/IBM renamed data management products as information management products, aiming at changing the impression of many users that DB2 family products can only complete single data management, and emphasizing the ability of DB2 family in information processing and integration.
2/DYNIX/ptxDB2 released DB2 Information Integrator (the product evolved from the previous DB2 DataJoiner and enterprise information portal) to help customers access, integrate, manage and analyze all kinds of information stored on any platform inside and outside the enterprise.
2004: IBM DB2 hit new highs in two tests of TPC, setting a new milestone in the history of computing field. Among them, in the test of TPC-C, it created a new world record in the field of computing speed, and completely shattered the limit of 3 million transactions per minute in this test.
2005: After five years of development, IBM DB2 9 combines the traditional high performance and ease of use with self-description and flexible XML, and turns it into an interactive dynamic data server.
2006: IBM released DB2 9, bringing the database field into the XML era. IT construction has entered the era of SOA (Service Oriented Architecture). To realize SOA, the core difficulty is to successfully solve the problem of data exchange between different applications. With its extensibility, platform independence and hierarchical structure, XML has become the mainstream language for data exchange between different applications when building SOA. How to store and manage geometric XML data and directly support native XML documents becomes the key to the efficiency and quality of SOA construction. In this case, IBM introduced DB2 9, which fully supported the original XML, solved the storage problem of XML data and created a new XML database era. In the same year, 65438+1October 30th, IBM released the free version of DB2, db2express-c.