Ibm DB2 RDBMS

IBM DB2
A COMMERCIALLY USED
RDBMS
Group 10
15012
15020
15027
15054
15062
ARJUN P.S
GAIRIKA DEY
KALSANK AKSHAY PAI
SONAL GANGWAR
VISHNU PRASAD C
Introduction
The database products for servers produced by IBM is known as IMB DB2 series of
databases.
The IBM database is primarily used in Mainframe servers.
The DB2 primarily does tasks such as data storage, data analysis, data retrieval in an
efficient manner.
The IBM DB2 or IBM Database 2, which is a relational database (RDBMS) is considered
today as an Object-SQL Database.
The DB2 was a product developed by IBM as platform specific to their servers and
proprietary OS.
In 1990 DB2 evolved as Universal Database DB2 Server.
The goal was to make IMB DB2 work as a cross platform database and was intended to
work on any OS such as Linux, UNIX, AIX and Windows. The latest version of IBM DB2 is
10.5 and is used by multiple companies today
Version history of IBM DB2 family
Architecture and working of IBM

DB2
Selecting IBM DB2 for organizations
Organizations consider its features as well as the requirement for selecting the
required version
Different versions of IBM DB2
Advanced Enterprise Server Edition and Enterprise Server Edition (AESE / ESE)
Workgroup Server Edition (WSE)
Express C Edition
Express editions
Enterprise Developer Edition
Companies that use IBM DB2
Morgan Stanley
Post bank
Ceca bank
Coca Cola
Advantages Of IBM DB2

Multiple Platform Support
Several versions of DB2 are produced by IBM which run on all known platforms, other than Windows based
platform.
AIX, Linux & Sun are some of the platforms which support DB2.
IBM also offers DB2 as a part of a pre-configured bundle along with the operating system, which on the whole
produces improved performance since the OS is configured for DB2 database support.
Powerful Structure Query Language

It comprise of several features like object tables, before triggers, Java method support & support for arrays
which are not supported by MS SQL.
The database management interface of DB2 can be used to access data directly with the help of SQL
Can also be embedded in the code of other application programs such as COBOL & Java, which makes DB2 one
of the powerful RDBMS.
Self-Tuning Memory Management

As compared to other databases which supports transactional or analytical queries or Oracle, DB2 is
much cheaper.
The maintenance cost of DB2 is also very less as well as hardware up-gradation is also cost effective.
Disadvantages Of IBM DB2
There has been confusion regarding the effective usage of the monitoring tools in DB2,
where in many instances it is seen that developers end up using a less efficient tool for
performance or monitoring system. There are several efficient as well as less effective
monitoring tools in DB2, but the major problem lies in the fact that it is not clearly
mentioned which one is recommended by IBM.
The availability of good DB2 databases for a new project is very low when compared to
Oracle or SQL-server databases. In order to increase the availability of DB2 databases,
up-skilling of Oracle databases to DB2 can be considered which is comparatively an
easy task rather than finding pure DB2 databases.
Case Study : Coca Cola

A brand which was in a search of a technology that will give away the following 4
things:
Save the Money
Reliable technology
Easy to use
Standout performance
Coca cola used the DB2 with BLU acceleration to test a huge 7 gigabytes of data that
was compressed to half a gigabyte. Such Data will move into the system quickly, thus
leading to more queries.
With BLU, search data through rows and columns was easy.
Provides insights into new areas of business.
Case Study : University of Toronto

Revolutionizing analytics with 106-times faster reporting on student
enrolment data
Home to approximately 65,000 undergraduates, 15,000 postgraduates, 11,500 faculty

members, and 6,000 administrative staff members.
Acceptance rate of30.1%. Average for all engineering schools (63.5%).
The students are evaluated using analytics with the help of key performance indicators
like, course enrolment by subject, students performance on their chosen courses etc..
Data warehouse of the institution is growing 50% each year.
Queries take a lot of time to execute.This resulted in inefficiency and also waste of time
during admission seasons.
Case Study : University of Toronto

Revolutionizing analytics with 106-times faster reporting on student
enrolment data
The latest version of IBM DB2 with BLU Acceleration was chosen as the platform.
The test results of using IBM DB2 exceeded the targeted performance.
It was also simple to use and integrated seamlessly with IBM Cognos platform which
the university was already using.
The university has stated that using IBM DB2 has delivered a 15% increase in
performance for their overall reporting process.
By freeing up that time, resources will be able to run more reports and perform much
deeper analyses more efficiently.
References
Advantages of DB2. (n.d.). Retrieved from ehow: http://www.ehow.com/info_12106599_advantagesdb2.html

Benifits and Brawback of DB2 V8. (n.d.). Retrieved from searchdatamanagement.techtarget.com:
http://searchdatamanagement.techtarget.com/answer/The-benefits-and-drawbacks-of-DB2-V8
Coca-Cola Bottling Company Consolidated speeds decision making with BLU Acceleration in-memory
database. (n.d.). Retrieved from ibmbluhub: http://www.ibmbluhub.com/ccbc/
DB2 - Introduction. (n.d.). Retrieved from tutorialspoint:
http://www.tutorialspoint.com/db2/db2_introduction.htm
IBM DB2 TESTIMONIALS. (n.d.). Retrieved from ibm.com: https://www01.ibm.com/software/data/db2/zos/testimonials.html
University of Toronto revolutionizes analytics. (n.d.). Retrieved from ibmbluhub:
http://www.ibmbluhub.com/university-of-toronto-case-study/
THANK YOU

Ibm DB2 RDBMS

Uploaded by

Copyright:

Available Formats

Ibm DB2 RDBMS

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Ibm DB2 RDBMS

Uploaded by

Copyright:

Available Formats

IBM DB2

Version history of IBM DB2 family

Architecture and working of IBM

Selecting IBM DB2 for organizations

Different versions of IBM DB2

Companies that use IBM DB2

Advantages Of IBM DB2

Powerful Structure Query Language

Self-Tuning Memory Management

Disadvantages Of IBM DB2

Case Study : Coca Cola

Case Study : University of Toronto

Home to approximately 65,000 undergraduates, 15,000 postgraduates, 11,500 faculty

Case Study : University of Toronto

Advantages of DB2. (n.d.). Retrieved from ehow: http://www.ehow.com/info_12106599_advantagesdb2.html

You might also like