17 Facts About IBM DB2

1.

However, in the 1990s IBM changed track and produced a Db2 common product, designed with a mostly common code base for L-U-W ; DB2 for System z and DB2 for IBM i are different.

FactSnippet No. 871,489
2.

At the time, IBM DB2 didn't believe in the potential of Codd's ideas, leaving the implementation to a group of programmers not under Codd's supervision.

FactSnippet No. 871,490
3.

When IBM DB2 released its first relational-database product, they wanted to have a commercial-quality sublanguage as well, so it overhauled SEQUEL, and renamed the revised language Structured Query Language to differentiate it from SEQUEL and because the acronym "SEQUEL" was a trademark of the UK-based Hawker Siddeley aircraft company.

FactSnippet No. 871,491
4.

IBM DB2 bought Metaphor Computer Systems to utilize their GUI interface and encapsulating SQL platform that had already been in use since the mid 80's.

FactSnippet No. 871,492
5.

In parallel with the development of SQL, IBM DB2 developed Query by Example, the first graphical query language.

FactSnippet No. 871,493
6.

In 1976, IBM DB2 released Query by Example for the VM platform where the table-oriented front-end produced a linear-syntax language that drove transactions to its relational database.

FactSnippet No. 871,494
7.

Later, the QMF feature of IBM DB2 produced real SQL, and brought the same "QBE" look and feel to IBM DB2.

FactSnippet No. 871,495
8.

IBM DB2 extended the functionality of Database Manager a number of times, including the addition of distributed database functionality by means of Distributed Relational Database Architecture that allowed shared access to a database in a remote location on a LAN.

FactSnippet No. 871,496
9.

When Informix Corporation acquired Illustra and made their database engine an object-SQL DBMS by introducing their Universal Server, both Oracle Corporation and IBM DB2 followed suit by changing their database engines to be capable of object–relational extensions.

FactSnippet No. 871,497
10.

In 2001, IBM bought Informix Software, and in the following years incorporated Informix technology into the DB2 product suite.

FactSnippet No. 871,498
11.

IBM claimed that the new DB2 was the first relational database to store XML "natively".

FactSnippet No. 871,499
12.

In October 2007, IBM announced "Viper 2, " which is the codename for DB2 9.

FactSnippet No. 871,500
13.

In October 2009, IBM introduced its second major release of the year when it announced DB2 pureScale.

FactSnippet No. 871,501
14.

IBM DB2 pureScale is a cluster database for non-mainframe platforms, suitable for Online transaction processing workloads.

FactSnippet No. 871,502
15.

In mid-2017, IBM re-branded its DB2 and dashDB product offerings and amended their names to "Db2".

FactSnippet No. 871,503
16.

Db2 Hosted: Formally named “IBM DB2 on Cloud”, Db2 Hosted is an unmanaged, hosted version of Db2 on Cloud's transactional, SQL cloud database.

FactSnippet No. 871,504
17.

IBM DB2 has native implementation of XML data storage, where XML data is stored as XML for faster access using XQuery.

FactSnippet No. 871,505