IBM DB/2 UDB

1
IBM DB/2 UDB
vs
ORACLE
Andrei Solntsev, Aprill 2003
2
5 aastat tagasi

• IBM
• Oracle
• Informix
• SysBase

1
3

• Internet
• 24 x 7 x 365
• kaugajaline partner

Täna

• IBM
• Oracle
• Microsoft
• NCR TeraData

2
4

• Internet
• 24 x 7 x 365
• kaugajaline partner

Täna

• IBM
• Oracle
• Microsoft
• NCR TeraData

5
DB/2 ja Oracle
Ühised muudatused

• Internet-tehnoloogiad

• Java
• XML
• ...

• Klasteriseerimine
• Usaldusväärsus
• Arhitektuuri täiustamine

3
6
Uued baasfunktsioonid
DB/2
Oracle

• IFC
• Application Server
• JServer
• WebDB
• InterMedia
• Virtual Private Database

• DataLinks
• WebSphere
• Visuaalsed vahendid Java salvestatud
  protseduuride loomiseks
• Administrative Java toolkit
• XML süntaktiline analüsaator
• Sisseehitatud otsingu vahendid
• DataJoiner

Integrated File System

• Intelligent Miner
• Visual Warehouse

4
7
DataLinks
data in files no longer needs to be imported into
the database
8
DataLinks
Problem Domain Addressed...

• 70-95 of data resides in file systems as
  compared to databases
• Internet has exacerbated this divide

• File system limitations
• Search
• Security
• Integrity -- referential, domain, etc.
• Transactional semantics
• Administration

9
DataLinks
Problem Domain Addressed...

• Many applications need to integrate database
  systems with file systems
• They all need database level integrity, security,
  backup and recovery, replication and transaction
  consistency

• Storing files in BLOBs gives it DBMS capabilities
• Files must be copied/migrated to the BLOBs
• Performance issues

10
Data Links Programming Model
Client application
FileServer
(3) Open filename
SQL API
File system API (or http protocol)
Server "1"
(4) direct data delivery
....
....
(1) SQL SELECT
SELECT DLURLPATH(PHOTO) FROM CUSTOMER WHERE SS
'236911144'
(2) return URL info
Server "n"
Photo
Name
SS
FileServer
Customer Table
(varchar)
(char)
(
DATALINK
)

• Leave the files as is
• Define metadata as columns
• Define a DATALINK column -- logical reference to
  the file in URL notation
• Populate the table
• Use SQL to search the metadata and find the files
  of interest -- get the URL of the file from the
  DATALINK column
• Access the file using the native file system APIs

URL1
546952311
Blogs Joe
URL2
236911144
Jane Mary
...
...
...
...
...
...
11
Uued baasfunktsioonid
DB/2
Oracle

• IFC
• Application Server
• JServer
• WebDB
• InterMedia
• Virtual Private Database

• DataLinks
• WebSphere
• Visuaalsed vahendid Java salvestatud
  protseduuride loomiseks
• Administrative Java toolkit
• XML süntaktiline analüsaator
• Sisseehitatud otsingu vahendid
• DataJoiner

Integrated File System

• Intelligent Miner
• Visual Warehouse

4
12
WebSphere Application Server

• WebSphere Application Server, V5 is the premier
  Java 2 Enterprise Edition (J2EE) and Web
  services technology-based application platform,
  offering one of the first production-ready
  application servers for the deployment of
  enterprise Web services solutions for dynamic
  e-business.
• Provides J2EE 1.3 support to simplify enterprise
  applications by basing them on standardized,
  modular components
• Lowers total cost of ownership and improves your
  ability to leverage assets
• Allows you to move seamlessly between
  configurations with one browser-based
  administration across all deployment options

13
WebSphere Application Server

• Improves programmer productivity and simplifies
  enterprise development with JMS API, while
  supporting core Web services standards like XML,
  SOAP, and WSDL
• Enhances security through extensive support of
  open, standards-based Java specifications and
  WebSphere software's pluggable security
  architecture
• Offers improved performance analysis and
  application tuning with IBM HTTP Server 2.0
• Provides integrated tools support with WebSphere
  Studio Application Developer
• Delivers broad cross-platform support

14
Internet-platvormid
IBM WebSphere

• Ise AB
• Platvormidevaheline tarkvara
• Instrumentaalsed vahendid

Oracle Appication Server

• Resurside planeerimine
• Klientidega suhtlemine

7
15
Platvormid
DB/2
Oracle

• UNIX
• WINDOWS
• Tasku riistvara

• UNIX
• WINDOWS
• Tasku riistvara
• AIX
• NUMA-Q
• SCO UnixWare
• VSE, VM

• OS/2
• OS/400
• Solaris
• HP-UX
• Dynix/ptx

5
16
Arhitektuur
IBM DB2 UDB
eraldiiga keskonna jaoks
Oracle
ühine süsteem,adapteerimine
6
17
Usaldatavus
IBM DB2 UDB EEE
Enterprise Extended Edition

• Suured klasterid
• Massilise parallelismi realiseerimine

HP
Oracle Parallel Failsafe

• Klasteriseerimine

8
18
Produktiivsus
TPC-testid
UnixNT
Võrdsed
Mainframes AS/400
IBM
10
19
COST ANALYSIS
DATABASE DEVELOPMENT
10
20
COST ANALYSIS -
DATABASE DEVELOPMENT
10
21
COST ANALYSIS -
DATABASE DEVELOPMENT
When considerable difference exists between the
two vendors, it can often be attributed to a
difference in the target user.
The impact of these efficiencies on the bottom
line varies greatly, depending on the size and
nature of the project.
22
Pricing
EXHIBIT 1 DB2 UDB V8.1 ESE vs. Oracle9i
R2 EE
(Enterprise Server Edition)

• more than 50 users per processor

DB2 lists at 54 of Oracle9iR2

• fewer than 27 users per processor

DB2 UDB V8.1 ESE lists slightly higher than
Oracle9iR2.
10
23
Pricing
EXHIBIT 3 DB2 vs. Oracle9i R2 SMP
Data Warehouse
EXHIBIT 2 DB2 ESE vs. Oracle9i R2 Data
Warehouse Clusters
10
24
Pricing
EXHIBIT 5 Discounted Price with One Year of
Service
EXHIBIT 4 SCALABILITY CLUSTERS WITH FAILOVER
10
25
Kokkuvõte
While
the two products provide functionally equivalent
technologies,
they
vary significantly in total cost
26
Kokkuvõte
Although
the weights of these expense categories may vary
by customer environments and applications,
DB2s
advantages suggest that it is the more economical
choice over a five-year period for almost all
scenarios.
27

• Kasutatud linke
• http//www-3.ibm.com/software/data/db2/udb/
• http//www.almaden.ibm.com/cs/datalinks/
• http//www.citforum.ru/seminars/cbd2001/day_1_1_ib
  m.shtml

10