pureXML(tm) is the name that IBM uses to talk about the ability to store XML natively. DB2 9 offers the ability to store XML "natively," and it also allows storage compression to save on disk space. In 2006, IBM announced "Viper," the codename for DB2 9 on distributed platforms and DB2 9 on z/OS. In 2001, IBM bought Informix and incorporated many of it's database features into the DB2 product suite. The Universal Server shifted the technology to an object-related SQL DBMS that allows developers to define their own data types from more primitive data types. During the 90s, IBM also introduced it's Universal Server. DB2 was the name given to the Database Management System in 1982, and it is the first database to use SQL.Īt first, DB2 was only available on IBM mainframes, but during the 1990's DB2 spread to many other platforms, LUW (Linux, Unix, Windows), mid-range computers i5/OS (formerly AS/400) and even on PDAs. IBM left the application of Codd's principles to a group of programmers that created a language that was eventually called SQL (Structured Query Language). Codd formally stated a number of algebraic rules that could be applied to data manipulation. The idea of a relational database first arose in 1970 when Dr.
#Ibm db2 universal database express edition code
For example, instead of storing the information that TN is the state Tennessee in every record, that information is pulled out of the original file and stored only once in a state code file. The related fields are pulled out of the original files in order to minimize redundancy in the data being stored. DB2 is a relational database management system produced by IBM that IBM refers to as a "data server." What is a relational database? A relational database is a set of files that has been analyzed for all of the relationships between fields.
0 kommentar(er)
