IBM produced a relational database management system called DB2 that was referred to as a ‘data server’ by IBM. In order to understand the history of DB2, we first need to be familiar with the term relational database. What is a relational database? This is a set of files that has been evaluated for all of the associations between fields.  Redundancy is minimized in the data being stored when the related fields are pulled out of the original fields. For instance, repeating TN as the state of Tennessee can be avoided by storing it once in a state code file when the information is pulled out of the original field.

History of DB2 started in 1970 when the idea of a relational database was brought up by one Dr. E.F. Codd. He did this by coming up with numerous algebraic rules, which he found to be practical to data manipulation.  The application of Codd’s principles was presented to a group of programmers by IBM, who then came up with a language referred to as (structured query language) SQL.  In 1982 the first database management system to use structured query language was given the name DB2.

Initially, the IBM mainframes was the only platform that used DB2 but as time went by, precisely in the 1990’s this database management system spread to other platforms such as PDA’s, mid-range computers OS/i5- previously  AS/400- and even LUW (Linux, Unix, Windows). Within the same time span, a universal server was introduced by IBM, which permitted developers describe their own data types from the former data types that were considered more primitive. The universal server allowed this by transforming the technology to an object-related SQL DBMS.

The DB2 product suite was then upgraded by IBM in 2001 by buying and incorporating most of Informix’s database features in this database management system. Later in 2006 ‘viper’, the codename for DB2 9 on z/OS and DB2 on distributed platforms was announced by IBM.  DB2 9 allows storage compression to save on disc space and also provides ability to store XML ‘natively’. The ability to store XML natively is referred to as pureXML(tm) by IBM. IBM has many competitors but the biggest of all are Oracle and Teradata for data warehousing. On the other hand competitors in the smaller environments include MySQL and Microsoft’s SQL server.

I hope you enjoyed these tips. Follow our blog and stay on top of all the news.

By ,

August 19, 2013

a

You might also like…

How to Create and Read QR Codes and Barcodes

“Point your cell phone camera to read the QR code.” This phrase has been increasingly recurring...

Why is Low-Code essential for any business?

Low-Code is the IT term that refers to the process of using little code to develop software and app...

“The Preventus Medical Center system has more than 222,000 patients and 115 professionals.” (DRey Solutions)

Check out how DRey Solutions uses Scriptcase to streamline and synthesize the process of maintenanc...

You might also like…

Get new posts, resources, offers and more each week.

We will use the information you provide to update you about our Newsletter and Special Offers. You can unsubscribe any time you want by clinck in a link in the footer of any email you receive from us, or by contacting us at sales@scriptcase.net. Learn more about our Privacy Police.