Introduction to IBM DB2 7.5.2009 Tallinn

basesprocketData Management

Oct 31, 2013 (3 years and 7 months ago)

84 views

5.5.2009

© Juhani Välimäki
HAAGA
-
HELIA University of Applied Sciences

1

Introduction to IBM DB2


7.5.2009 Tallinn



HAAGA
-
HELIA University of Applied Sciences



When selecting or replacing the DBMS



IBM DB2 9.5 Express
-
C



Certification courses as part of curriculum?



IBM DB2 9.5 Express
-
C Labs in 319


5.5.2009

© Juhani Välimäki
HAAGA
-
HELIA University of Applied Sciences

2

HAAGA
-
HELIA University of Applied Sciences

Your Erasmus Exchange Partner in Helsinki, Finland

5.5.2009

© Juhani Välimäki
HAAGA
-
HELIA University of Applied Sciences

3

Haaga
-
Helia University of Applied Sciences



Your
partner

for Erasmus Student exchange in Finland


10 000 students (Business, Tourism, Food, Sports
trainers, Journalists, Business IT, …)


Helsinki 4 sites, Porvoo(50km) and Vierumäki(130 km)


Not in Haaga
-
Helia: Health care, Social studies or
Engineering. Metropolia University of Applied Sciences
teaches them.

5.5.2009

© Juhani Välimäki
HAAGA
-
HELIA University of Applied Sciences

4

Haaga
-
Helia


All IT studies in Helsinki



(IT program in Finnish, 1200 students, 50 teachers)


IT program in English: Business Information
Technology, Bite.


17 Teachers, 70 new students each year, 300 in total


Current Bite curriculum started Fall 2007


Generic Application Development studies (As the first
tool we use Microsoft Environment)


Students have to be present, only some courses use
distance learning.


5.5.2009

© Juhani Välimäki
HAAGA
-
HELIA University of Applied Sciences

5

Introduction to IBM DB2 Express
-
C

Free database that is useful even in small business

Easy
-
to
-
install virtual environment

Documentation for self
-
study

5.5.2009

© Juhani Välimäki
HAAGA
-
HELIA University of Applied Sciences

6

IBM DB2 is one of the Big Three (by $ale$)

1.
Oracle (
Many

platforms
,
even

mainframes
)

2.
IBM DB2 (
Many

platforms
,
even

mainframes
)

3.
Microsoft SQL Server




MySQL

(
has

most

downloads

and
installations
)


5.5.2009

© Juhani Välimäki
HAAGA
-
HELIA University of Applied Sciences

7

All big vendors have their free databases


Can be used in real business without royalties


Limitations to the free DBMS version:


Amount of RAM that can be used (1GB
-
4GB)


Amount of disk space for the data (4GB
-

to unlimited)


Number of processor cores used (1
-
2)


Processor power units


Number of simultaneos network connections


Limited set of features


Optimization and performance tuning features often missing

5.5.2009

© Juhani Välimäki
HAAGA
-
HELIA University of Applied Sciences

8

All big vendors have their free databases


Oracle 10g Express Edition


1 CPU, 1 GB RAM, 4GB Data


IBM DB2 9.5 Express
-
C


2 CPU
,
2 GB RAM
,
Unlimited Data

(IBM: ”Generous offer”)


Microsoft SQL Server Express


1 physical CPU (
multiple cores
), 1 GB RAM, 4GB Data


5.5.2009

© Juhani Välimäki
HAAGA
-
HELIA University of Applied Sciences

9

Vendors buying each other


Volatile market


Oracle bought InnoDB (The transaction capable
database motor used by MySQL) in 2005


IBM bought Finnish Solid in 2007


Sun bought MySQL (originally Swedish
-
Finnish) in 2008



What happens to LA
M
P?


Can one put all eggs in one small basket (Small
databases)? Or commit to the Big Three?


5.5.2009

© Juhani Välimäki
HAAGA
-
HELIA University of Applied Sciences

10

What to look at when selecting a database?


Performance


Tools


Connections


Own platform


Development tools and environment


Support


Own skills, training


Price, Licences





5.5.2009

© Juhani Välimäki
HAAGA
-
HELIA University of Applied Sciences

11

What to consider in a new DBMS? 1/2 …


Platform and installation


Hardware including hard disks


User accounts (E.g. Windows AD, Linux, DBMS users)


Terminology changed: Cluster, Server, Database,
Instance, Catalog, Schema (every product uses
different terms for these. SQL
-
99 specifies standard
names)


5.5.2009

© Juhani Välimäki
HAAGA
-
HELIA University of Applied Sciences

12

What to consider in a new DBMS? … 2/2


System roles and privileges, security features


Registration, name services, listeners


(Binding in Mainframes and batch runs)


Connectivity and drivers


Loading old data


Integration to other systems


SQL dialect is the smallest problem



5.5.2009

© Juhani Välimäki
HAAGA
-
HELIA University of Applied Sciences

13

Which one to select? All have their strenghts


Oracle is
widely

used


IBM DB2
spans

from

small

systems

to
mainframes


Microsoft SQL Server is
optimized

for Windows and
ADO.NET/ASP.NET
applications


MySQL

is
free

and
most

popular

in LAMP
style

packages

(
But

now

own

by

Sun)


PostgreSQL
,
open

source

db

by

community


… Big
part

of the
commitment

will

be

product

dependent


5.5.2009

© Juhani Välimäki
HAAGA
-
HELIA University of Applied Sciences

14

IBM DB2 9.5 Express
-
C


Installation package downloadable and free for
business


(Now here) Ready
-
made virtual machine image for
getting quick look at Linux installation.


Documentation available for self
-
study labs


Certification for the Fundamentals available


Course held twice a year as intensive course in Haaga
-
Helia.


IBM Finland offered free certification tests for students
and staff of Haaga
-
Helia



5.5.2009

© Juhani Välimäki
HAAGA
-
HELIA University of Applied Sciences

15

IBM DB2 9.5 Express
-
C

Topics

in the Fundamentals
Certification

exam
:

1.
Database

Planning

2.
Security

3.
Accessing

data

4.
Working

with

data

5.
Working

with

DB2
objects

6.
Data
concurrency

7.
XML Data and
XQuery



5.5.2009

© Juhani Välimäki
HAAGA
-
HELIA University of Applied Sciences

16

Certification courses as part of the
curriculum?

5.5.2009

© Juhani Välimäki
HAAGA
-
HELIA University of Applied Sciences

17

In Haaga
-
Helia


Obligatory courses in the curriculum teach all subjects
as tool independent as possible.


Tool certification courses mainly as intensive courses.


There are 9 intensive weeks during the academic year


Certification courses could bring quality and knowledge
about how things are done in the enterprises?


Effort might be large, 50
-
150 hours to pass an exam

5.5.2009

© Juhani Välimäki
HAAGA
-
HELIA University of Applied Sciences

18

In Haaga
-
Helia DB2 Certification Test 730


Student’s basic knowledge checked before admission


5 days x 7 hours = 35 hour intensive course


Self
-
study 2 days


Course exam for all students



Self
-
study for 7 more days for the most motivated &
skilled


Certification exam offered for the most motivated