DB2 History -- A Timeline

From IBM Database Magazine Wiki

Jump to: navigation, search

Milestones in the development of IBM DB2 and related technologies.


Contents

Early Events

1968

  • IBM ships IMS V1 – the industry’s first hierarchical database management system.

1970

  • IBM computers assist flight controllers in the dramatic rescue of the Apollo 13 astronauts.

1973

  • System R project is established at IBM Research to build a relational database management system.

1974

1975

  • IBM’s Don Chamberlin and Morton Astrahan’s paper “Implementation of a Structured English Query Language” describes the first implementation of SQL as part of System R work.

1976

  • The IBM System R team publishes “A System R: Relational Approach to Database Management,” a paper describing their relational database prototype.
  • IBM’s Jim Gray publishes “Granularity of Locks and Degrees of Consistency in a Shared Data Base,” describing the formal definition of a database transaction and degrees of consistency.

1977

  • System R prototype is installed at three IBM customer locations: Boeing (Seattle, WA), Pratt & Whitney (Hartford, CT), and Upjohn Drug Co. (Kalamazoo, MI).

1979

  • IBM’s Pat Selinger writes about the industry’s first relational query optimizer in her paper, “Access Path Selection in a Relational Database Management System.”

1980

  • IBM delivers S/38 with an integrated database server based on IBM’s System R prototype. The API is consistent with the S/3, S/32 API to support application migration.

1981

  • IBM’s E.F. Codd receives the ACM Turing Award for the invention of the relational model. The debut of the IBM Personal Computer electrifies the fledgling personal computer industry.

1982

  • IBM ships SQL/DS for VSE and VM as the first commercially available relational database with a SQL interface based on System R.


DB2 Debuts

1983

  • IBM gives DATABASE 2 (DB2) for MVS (once known internally as Eagle) its wings, shipping V1.

1986

  • System/38 V7 ships with the first optimizer.

1987

  • IBM announces OS/2 V1.0 Extended Edition, with relational database capabilities, a precursor to DB2 on OS/2, Unix, and Windows.

1988

1989

  • First IDUG North American Conference takes place in Chicago, IL.

1992

  • First IDUG European Conference takes place in Geneva, Switzerland.

1993

  • IBM announces and ships DB2 for OS/2 V1 (DB2/2) and DB2 for AIX V1 (DB2/6000).

1994

  • DB2 for MVS V4 introduces distributed computing (data sharing) on the mainframe with Parallel Sysplex technology.
  • IBM announces DB2 Parallel Edition V1 for the RS/6000 SP2 platform, marking the birth of IBM’s clustered, highly scalable architecture with focus on large data warehouses for complex query work. IBM extends DB2 V1 to non-IBM Unix platforms, delivering DB2 Common Server technology on HP-UX and Sun-Solaris platforms.
  • DB2/400 ships with OS/400 V3.1 and introduces parallelism, stored procedures, and referential integrity. IBM announces DB2 support for multimedia data types and object-oriented application capabilities on OS/2 and AIX.

1995

  • IBM ships both DB2 Common Server V2, the first object-relational Web-enabled database for multiple platforms, and DataJoiner for AIX, which introduces heterogeneous RDBMS support.DB2 debuts on Windows NT and SINIX platforms (DB2 V2). IBM announces data mining technology built on DB2 for AIX and MVS; DB2 Extenders to manage text, image, audio, video, and fingerprint data; and Visual Warehouse for data warehouse management.
  • IBM announces DB2 WWW Connection V1 for OS/2 and AIX (later called Net.Data) for connecting databases to Web applications. First IDUG Asia Pacific Conference takes place in Sydney, Australia.
  • IBM acquires [1] Lotus Development Corp.


DB2 for Distributed Platforms Arrives

1996

  • IBM ships DB2 V2.1.2, the first database with Java and JDBC support.
  • IBM announces DB2 Universal Database (UDB), the first multimedia, Web-ready relational database management system that could scale from desktops to the entire enterprise in uniprocessor, SMP, or MPP computing environments, with multivendor, multiplatform open connectivity. DB2 UDB V5 is formed from the merging of two DB2 technology branches: DB2 V2.1.2 (which contributed fullfunction SQL and multi-platform support) and DB2 Parallel Edition V1.2 (which contributed clustered scalability).
  • IBM Chairman Louis V. Gerstner, Jr., who joined IBM in 1993, commits IBM to open standards-based computing in a keynote address at Uniforum in San Francisco.
  • IBM Digital Library ships. The multimedia asset management product evolves into IBM Content Manager.
  • DataJoiner brings access to non-relational data sources (such as IMS and VSAM).
  • IBM announces Intelligent Miner, which delivers discovery-oriented data mining based on DB2.


Early OLAP Developments

1997

  • IBM ships Web-ready DB2 for OS/390 V5, the only database that supported up to 64,000 concurrent users and hundreds of terabytes. IBM ships DB2 UDB for Unix, Windows, and OS/2, with integrated ROLLUP and CUBE functions for online analytic processing (OLAP).
  • First IDUG Technical Symposium takes place in Toronto, Canada.
  • IBM ships EDMSuite for enterprise content management, which contains OnDemand for computer generated report management and Image Plus Visual Info for image management.
  • Deep Blue, IBM’s chess-playing RS/6000 SP supercomputer, defeats chess grand master Garry Kasparov in a six game match.
  • RS/6000 technology is tapped for the onboard flight computer that helps NASA’s Pathfinder land on Mars.

1998

  • IBM ships DB2 OLAP Server, jointly developed with Arbor Software (now Hyperion), as a complete OLAP solution built on DB2.
  • ContentConnect, which will evolve into Enterprise Information Portal, ships.
  • DB2 expands to the UnixWare platform.
  • DB2 V5.2 adds SQLJ support, building on existing JDBC, Java stored procedure, and UDF capabilities.
  • IBM ships DB2 UDB for AS/400 with ebusiness enablers.
  • IBM ships DB2 UDB with Data Links technology to manage data in files.
  • DB2’s shared-nothing clustering capabilities extend to Windows and Solaris platforms.
  • IBM ships DB2 Spatial Extender, developed jointly with ESRI and built on DataJoiner.


DB2 Gets Mobile

1999

  • IBM introduces DB2 Satellite Edition for mobile computing, and DB2 Everywhere (now called DB2 Everyplace), a small footprint DBMS for handheld and mobile devices.
  • IBM delivers Enterprise Information Portal, which provides a unified and federated search capability across Digital Library and EDMSuite.
  • DB2 introduces XML support in the form of XML-aware text searching, and beta program for DB2 XML Extender begins.
  • IBM delivers DB2 for Linux on Intel platforms.


Early XML Support

2000

  • IBM delivers DB2 XML Extender, providing the first native XML support in the data management industry.
  • IBM integrates Visual Warehouse into DB2 for data warehouse management.
  • IBM delivers DB2 support for Intelbased Linux clusters; DB2 UDB for Linux on the mainframe; and DB2 Everyplace for embedded Linux.
  • DB2 supports the NUMA-Q platform on its Unix-like operating system, DYNIX/ptx.
  • DB2 gets in-memory high-speed text search capabilities through DB2 Net Search Extender.
  • IBM launches its data management tools business with tools for IMS and DB2 on the mainframe (eventually expanding to include Unix, Linux, and Windows and support for Informix and IMS databases).
  • IBM begins integrating DataJoiner into DB2 to provide federation capabilities.
  • IBM unveils Content Manager, based on DB2, to manage digital content. DB2 Digital Library and EDMSuite products are now contained in a single architecture that spans multimedia asset management and enterprise content management. The Dutch National Library, the National Palace Museum in Taiwan, the Vatican Library, and the State Hermitage Museum in St. Petersburg, Russia are early customers.
  • DB2 earns its 10,000th license on the mainframe.


Informix Acquisition

2001

  • IBM completes $1 billion acquisition of Informix database assets, doubling IBM’s distributed data business.
  • IBM ships IDS V9.3 in October, followed in 2002 by Informix Dynamic Server V7.31, Informix Extended Parallel Server V8.4 and Informix Red Brick Warehouse V6.2 releases.
  • DB2 OLAP Server gains data mining capability.
  • IBM ships first DB2 tools for multiple platforms.
  • Intelligent Miner Scoring Services debuts with real-time data mining features implemented as a DB2 Extender and as an Oracle DataCartridge.
  • DB2 delivers first SOAP-based Web services support.
  • DB2 XML Extenders and stored procedures make DB2 a Web service provider.
  • DB2 extends federation capability to WebSphere MQ message queues and life sciences industry file data.
  • IBM ships DB2 UDB for OS/390.
  • IBM scientists develop a breakthrough transistor technology out of carbon nanotubes (tiny cylinders of carbon atoms that are 500 times smaller than silicon-based transistors).


Expanding Influences

2002

  • IBM unveils “Xperanto”, a demonstration of new standards-based information integration middleware that optimizes access to diverse data sources. The demo uses XML and style sheet processing, XQuery, Web services, federation, and full-text search technologies. 2002:
  • DB2 broadens its federated capability in SOAP-based Web services, adding Web services consumer support.
  • DB2 OLAP Server adds hybrid (multidimensional and relational) analysis capability.

2004

  • IBM delivered DB2 for z/OS Version 8 beginning the transition to 64 bit addressing with a dramatic reengineering of DB2 capabilities.

2006

  • IBM introduces DB2 9 (codenamed "Viper") for Linux, Unix, and Windows--the first hybrid data server that enables management of conventional relational data and XML data without requiring the XML

to be reformatted or placed into a large object within the database.

  • IBM announced DB2 9 for z/OS, with the same pureXML(tm)hybrid relational-XML storage and management capabilities available on the distributed platforms.

2007

  • DB2 9 for z/OS became generally available.
Retrieved from "http://wiki.ibmdatabasemag.com/index.php/DB2_History_--_A_Timeline"
Personal tools