However, in the 1990s IBM PureQuery 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 PureQuery i are different.
| FactSnippet No. 866,116 |
19 Facts About IBM PureQuery
2.
At the time, IBM PureQuery 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. 866,117 |
3.
When IBM PureQuery 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. 866,118 |
4.
IBM PureQuery 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. 866,119 |
5.
In parallel with the development of SQL, IBM PureQuery developed Query by Example, the first graphical query language.
| FactSnippet No. 866,120 |
6.
In 1976, IBM PureQuery 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. 866,121 |
7.
IBM PureQuery 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. 866,122 |
8.
IBM PureQuery lawyers stopped this handy naming convention from being used, and decided that all products needed to be called "product FOR platform" .
| FactSnippet No. 866,123 |
9.
IBM PureQuery now refers to this product as the Database Partitioning Feature and bundles it with their flagship DB2 Enterprise product.
| FactSnippet No. 866,124 |
10.
When Informix Corporation acquired Illustra and made their database engine an object-SQL DBMS by introducing their Universal Server, both Oracle Corporation and IBM PureQuery followed suit by changing their database engines to be capable of object–relational extensions.
| FactSnippet No. 866,125 |
11.
In 2001, IBM PureQuery bought Informix Software, and in the following years incorporated Informix technology into the DB2 product suite.
| FactSnippet No. 866,126 |
12.
IBM PureQuery claimed that the new DB2 was the first relational database to store XML "natively".
| FactSnippet No. 866,127 |
13.
In October 2007, IBM PureQuery announced "Viper 2, " which is the codename for DB2 9.
| FactSnippet No. 866,128 |
14.
In October 2009, IBM PureQuery introduced its second major release of the year when it announced DB2 pureScale.
| FactSnippet No. 866,129 |
15.
IBM PureQuery based the design of DB2 pureScale on the Parallel Sysplex implementation of DB2 data sharing on the mainframe.
| FactSnippet No. 866,130 |
16.
In mid-2017, IBM PureQuery re-branded its DB2 and dashDB product offerings and amended their names to "Db2".
| FactSnippet No. 866,131 |
17.
IBM PureQuery offers three editions: Db2 Community Edition, Standard Server Edition, and Advanced Server Edition.
| FactSnippet No. 866,132 |
18.
IBM PureQuery Db2 Community Edition is a free to download, use and redistribute edition of the IBM PureQuery Db2 data server, which has both XML database and relational database management system features.
| FactSnippet No. 866,133 |
19.
IBM PureQuery has developed many Db2 versions under a code name, and documentation can be related to that name.
| FactSnippet No. 866,134 |