IBM DB2

related topics
{system, computer, user}
{company, market, business}
{math, number, function}
{work, book, publish}
{language, word, form}
{theory, work, human}
{film, series, show}

The IBM DB2 Enterprise Server Edition is a relational model database server developed by IBM. It primarily runs on Unix (namely AIX), Linux, IBM i (formerly OS/400), z/OS and Windows servers. DB2 also powers the different IBM InfoSphere Warehouse editions. Alongside DB2 is another RDBMS: Informix, which was acquired by IBM in 2001.

Contents

History

DB2 has a long history and is considered by many[who?] to have been the first database product to use SQL (also developed by IBM) although Oracle released a commercial SQL database product somewhat earlier than IBM did.

The name DB2 was first given to the Database Management System or DBMS in 1983 when IBM released DB2 on its MVS mainframe platform. Prior to this, a similar product was named SQL/DS on the VM platform. The earlier System 38 platform also contained a relational DBMS. System Relational, or System R, was a research prototype developed in the 1970s. DB2 has its roots back to the beginning of the seventies when E.F. Codd, working for IBM, described the theory of relational databases and in June 1970 published the model for data manipulation. To apply the model Codd needed a relational database language which he named Alpha. At the time IBM didn't believe in the potential of Codd's ideas, leaving the implementation to a group of programmers not under Codd's supervision, who violated several fundamentals of Codd's relational model; the result was Structured English QUEry Language or SEQUEL. When IBM released its first relational database product, they wanted to have a commercial-quality sublanguage as well, so it overhauled SEQUEL and renamed the basically new language(System Query Language) SQL to differentiate it from SEQUEL.

When Informix acquired Illustra and made their database engine an object-SQL DBMS by introducing their Universal Server, both Oracle and IBM followed suit by changing their database engines to be capable of object-relational extensions. In 2001, IBM bought Informix and in the following years incorporated Informix technology into the DB2 product suite. Today, DB2 can technically be considered to be an object-SQL DBMS.

Full article ▸

related documents
Netscape Navigator
MOS Technology
Communications on the Isle of Man
AdLib
Qt (toolkit)
GNU Hurd
Intel i860
System call
Configuration management
Integrated development environment
Linspire
Disk partitioning
Intranet
Non-return-to-zero
HP-UX
Multiplexer
NCUBE
Freeview (UK)
Portable Executable
Data warehouse
LaserWriter
Macintosh Classic
Carbon (API)
Dish Network
MX record
Intel 4004
Shareaza
L4 microkernel family
MMIX
JPEG 2000