What is DB2? History, Editions, and Video Illustrations
- Date: 2007-08-26 - Word Count: 823
Share This!
Historical Background
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. The related fields are pulled out of the original files in order to minimize redundancy in the data being stored. 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 idea of a relational database first arose in 1970 when Dr. E.F. Codd formally stated a number of algebraic rules that could be applied to data manipulation. 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). DB2 was the name given to the Database Management System in 1982, and it is the first database to use SQL.
At 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. During the 90s, IBM also introduced it's Universal Server. 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.
In 2001, IBM bought Informix and incorporated many of it's database features into the DB2 product suite.
In 2006, IBM announced "Viper," the codename for DB2 9 on distributed platforms and DB2 9 on z/OS. DB2 9 offers the ability to store XML "natively," and it also allows storage compression to save on disk space. IBM refers to the ability to store XML as pureXML(tm).
IBM's biggest competitors are Teradata for Data Warehousing and Oracle. Microsoft's SQL Server and MySQL are serious competitors in the smaller environments.
Editions
IBM's Product Summary page for DB2 (http://www-306.ibm.com/software/data/db2/) allows one to download the various editions after registering. The DB2 Express-c edition is free, and the other editions allow you to have a 90-day free trial.
IBM will send you a free Discovery DVD (https://www14.software.ibm.com/webapp/iwm/web/preLogin.do?lang=en_US&source=swg-db2kit) that contains: # DB2 Express-C 9 (Linux and Windows), # DB2 Developer Workbench (Linux and Windows), # a comparison of all Editions from Express to Enterprise, # webcasts, tutorials, and much more!
Here is a list of some of the major features of several of the DB2 Editions:
1. DB2 9 Express for Linux, Sun Solaris x86, Windows is the ideal entry level data server. Suitable for transaction processing or complex query workloads on servers with up to two processors. (2 processors & 4 Gig RAM) Starting at $4,874 per processor of $165 per user (minimum of 5 users).
1.a. DB2 Express-C is a free version of DB2 Express Edition (DB2 Express) for the community. DB2 Express-C is a no-charge data server for use in development and deployment of applications including: XML, C/C++, Java, .NET, PHP, and more. DB2 Express-C can be run on up to 2 dual-core CPU servers, with up to 4 GB of memory, any storage system setup and with no restrictions on database size or any other artificial restrictions. (Linux and Windows)
2. DB2 9 Workgroup for LUW (Linux, Unix, and Windows Includes all of the features of DB2 Express with scalability to larger servers. (4 processors & 16 Gig RAM)
3. DB2 9 Enterprise for LUW - Includes all of the features of DB2 Workgroup plus features required to provide the scalability to handle high user loads and provide 24×7x365 availability. (No restrictions on number of processors or ram). Pricing is by users on CPU (25 minimum) or by number of CPUs.
4. DB2 Data Warehouse Enterprise Edition (DB2 DWE) - can run on LUW (Linux, Unix, and Windows) platforms, and it can be used with a mixed workload (OLTP and datawarehousing) or business intelligence implementations. Pricing starts at $4,874 per processor.
5. DB2 for z/OS - allows for storing of XML and also has improved dynamic warehousing and OLTP capabilities. Pricing starts at $4,450 per month.
6. DB2 Everyplace - features a small footprint relational database and high performance data synchronization solution that enables enterprise applications and data to be securely extended to mobile devices such as personal digital assistants (PDAs), smart phones and other embedded mobile devices.
Related Videos
IBM What Makes You Special DB2 Viper ..
5 min - Aug 30, 2006
IBM video ad highlighting Infomation On Demand (IOD) value in DB2 v9 Viper release as described by several customers and partners. Includes What Makes You Special ad
http://www.youtube.com/v/XqaHPuLpqww
DB2 Viper 2 Overview - Part I
8 min - Jul 17, 2007
Tim Vincent being interviewed by Rav Ahuja about Viper 2, the next release of DB2 on LUW currently in beta. Part I gives an overview and covers workload management enhancements.
http://www.youtube.com/v/wiPgBdpvZBM
DB2 Viper 2 Overview - Part II
10 min - Jul 17, 2007
Tim Vincent being interviewed by Rav Ahuja about Viper 2, the next release of DB2 on LUW.
http://www.youtube.com/v/7jYOVOrwbwc
IBM's DB2 Webcasts:
List of about 15 Webcasts by IBM on DB2 ChannelDB2.com
http://www-306.ibm.com/software/data/db2/9/webcasts.html
List of Videos from IBM in Toronto
http://channeldb2.ning.com/video
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. The related fields are pulled out of the original files in order to minimize redundancy in the data being stored. 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 idea of a relational database first arose in 1970 when Dr. E.F. Codd formally stated a number of algebraic rules that could be applied to data manipulation. 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). DB2 was the name given to the Database Management System in 1982, and it is the first database to use SQL.
At 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. During the 90s, IBM also introduced it's Universal Server. 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.
In 2001, IBM bought Informix and incorporated many of it's database features into the DB2 product suite.
In 2006, IBM announced "Viper," the codename for DB2 9 on distributed platforms and DB2 9 on z/OS. DB2 9 offers the ability to store XML "natively," and it also allows storage compression to save on disk space. IBM refers to the ability to store XML as pureXML(tm).
IBM's biggest competitors are Teradata for Data Warehousing and Oracle. Microsoft's SQL Server and MySQL are serious competitors in the smaller environments.
Editions
IBM's Product Summary page for DB2 (http://www-306.ibm.com/software/data/db2/) allows one to download the various editions after registering. The DB2 Express-c edition is free, and the other editions allow you to have a 90-day free trial.
IBM will send you a free Discovery DVD (https://www14.software.ibm.com/webapp/iwm/web/preLogin.do?lang=en_US&source=swg-db2kit) that contains: # DB2 Express-C 9 (Linux and Windows), # DB2 Developer Workbench (Linux and Windows), # a comparison of all Editions from Express to Enterprise, # webcasts, tutorials, and much more!
Here is a list of some of the major features of several of the DB2 Editions:
1. DB2 9 Express for Linux, Sun Solaris x86, Windows is the ideal entry level data server. Suitable for transaction processing or complex query workloads on servers with up to two processors. (2 processors & 4 Gig RAM) Starting at $4,874 per processor of $165 per user (minimum of 5 users).
1.a. DB2 Express-C is a free version of DB2 Express Edition (DB2 Express) for the community. DB2 Express-C is a no-charge data server for use in development and deployment of applications including: XML, C/C++, Java, .NET, PHP, and more. DB2 Express-C can be run on up to 2 dual-core CPU servers, with up to 4 GB of memory, any storage system setup and with no restrictions on database size or any other artificial restrictions. (Linux and Windows)
2. DB2 9 Workgroup for LUW (Linux, Unix, and Windows Includes all of the features of DB2 Express with scalability to larger servers. (4 processors & 16 Gig RAM)
3. DB2 9 Enterprise for LUW - Includes all of the features of DB2 Workgroup plus features required to provide the scalability to handle high user loads and provide 24×7x365 availability. (No restrictions on number of processors or ram). Pricing is by users on CPU (25 minimum) or by number of CPUs.
4. DB2 Data Warehouse Enterprise Edition (DB2 DWE) - can run on LUW (Linux, Unix, and Windows) platforms, and it can be used with a mixed workload (OLTP and datawarehousing) or business intelligence implementations. Pricing starts at $4,874 per processor.
5. DB2 for z/OS - allows for storing of XML and also has improved dynamic warehousing and OLTP capabilities. Pricing starts at $4,450 per month.
6. DB2 Everyplace - features a small footprint relational database and high performance data synchronization solution that enables enterprise applications and data to be securely extended to mobile devices such as personal digital assistants (PDAs), smart phones and other embedded mobile devices.
Related Videos
IBM What Makes You Special DB2 Viper ..
5 min - Aug 30, 2006
IBM video ad highlighting Infomation On Demand (IOD) value in DB2 v9 Viper release as described by several customers and partners. Includes What Makes You Special ad
http://www.youtube.com/v/XqaHPuLpqww
DB2 Viper 2 Overview - Part I
8 min - Jul 17, 2007
Tim Vincent being interviewed by Rav Ahuja about Viper 2, the next release of DB2 on LUW currently in beta. Part I gives an overview and covers workload management enhancements.
http://www.youtube.com/v/wiPgBdpvZBM
DB2 Viper 2 Overview - Part II
10 min - Jul 17, 2007
Tim Vincent being interviewed by Rav Ahuja about Viper 2, the next release of DB2 on LUW.
http://www.youtube.com/v/7jYOVOrwbwc
IBM's DB2 Webcasts:
List of about 15 Webcasts by IBM on DB2 ChannelDB2.com
http://www-306.ibm.com/software/data/db2/9/webcasts.html
List of Videos from IBM in Toronto
http://channeldb2.ning.com/video
Related Tags: ibm, sql, dbms, viper, db2, express-c
This article was written by Wade Harvey. His blog can be viewed at idealprogrammer.com Your Article Search Directory : Find in Articles
Recent articles in this category:
- Using Keywords Effectively For an SEO Campaign
Keyword research is one of the most crucial parts of an SEO campaign. If you end up choosing the wro - Search Engine Optimization Copywriting Tips
SEO copywriting is not as technical as it sounds but is different from traditional copywriting for t - 3 Tips to Make Money Using Videos
For the last five years video has been a real success in the internet. Now you can find video in alm - Is Social Media Networking Your Next Strategy For Your Online Marketing?
When you try to work on online promotion and online marketing, social media especially social media - Submitting a URL of Your Website
People who make a website usually do research on how to improve not only the quality of their websit - 5 Bad Habits of Article Marketing
There are many ways to advertise your company but having a highly ranked website is the best. Most p - Facts About SEO Services Company
SEO services companies are becoming very popular in the internet marketing world but there are some - 4 Ways Search Engine Optimization Can Be So Powerful
Whether you are an affiliate marketer, small businessman or a large organization, your first step wh - A List of 3 Options For Internet Business
The trend of making money through online business has become trendy now a day. People are shifting t - Getting the Best Affiliate Products For Your Site
Making money online was never so difficult before. There are numerous ways through which you can mak
Most viewed articles in this category:
- The Revolutionized Ebay Etailsolution Software
With the help of eBay, the auction business has received a new meaning. With the help of the many eB - Internet Millions - by Ryan Orrell - Honest Review
REVIEW: "Internet Millions", by Ryan Orrell, is a refreshing new kind of internet marketing e-bo - A Google Adsense Addiction
54% of all Google Adsense publishers admit addiction to click income. A recent online study conducte - Lead Generation for Top Residual Income
At the heart of any good residual income business is a person who knows how to generate leads. Lead - Make Money With Information Ebook Products: The Other End
I don't like thinking of myself as the kind of person that has made it rich on the internet, but in - Repeat Business Equals a Residual Income Stream
Residual income comes from other people reacting to a single action by the business owner. What bet - The NFL & United Way
There are many ways that NFL players help with the United Way. First of all, they donate a lot of th - Seo - Making Money Writing Seo Reviews
If you are a reviewer or critic you are likely to find work writing reviews of products and services - Understanding Perfume Types
Understanding the various varieties of perfume can help to cut through the difficulty in selecting a - Ecommerce Basics: Three Things To Avoid
When you decide to put your ecommerce website together there are a few mistakes that are easy to mak