Transcript Oracle9iR2

IBM DB/2 UDB
vs
ORACLE
Andrei Solntsev,
Aprill 2003
5 aastat tagasi
• IBM
• Oracle
• Informix
• SysBase
Vähendasid klientide
olemasolevate süsteemide
arendamise võimalused
1
• Internet
Täna
• 24 x 7 x 365
• kaugajaline partner
• IBM
• Oracle
• Microsoft
• NCR TeraData
• Tõkestatud skaleeruvus
• ainult keskkondades Windows
NT/2000
• Ebakindel tulevik
• Tagasihoidlik koht äriturul
2
• Internet
Täna
• 24 x 7 x 365
• kaugajaline partner
• IBM
• Oracle
• Microsoft
• NCR TeraData
• Tõkestatud skaleeruvus
• ainult keskkondades Windows
NT/2000
• Ebakindel tulevik
• Tagasihoidlik koht äriturul
DB/2 ja Oracle:
Ühised muudatused
• Internet-tehnoloogiad:
• Java
• XML
• ...
• Klasteriseerimine
• Usaldusväärsus
• Arhitektuuri täiustamine
3
Uued baasfunktsioonid
Oracle
DB/2
• IFC Integrated File System
• DataLinks
• Application Server
• WebSphere
• JServer
• WebDB
• InterMedia
• Virtual Private Database
• Visuaalsed vahendid Java salvestatud
protseduuride loomiseks
• Administrative Java toolkit
• XML süntaktiline analüsaator
• Sisseehitatud otsingu vahendid
• DataJoiner
• Intelligent Miner
• Visual Warehouse
4
DataLinks
data in files no longer
needs to be imported
into the database
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
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
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'
SS#
Customer
Table
(char)
(2) return URL info
Name
Photo
(varchar)
(DATALINK )
546952311
Blogs Joe
236911144
Jane Mary
URL2
...
...
...
...
...
...
URL1
Server "n"
FileServer
•
•
•
•
•
•
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
Uued baasfunktsioonid
Oracle
DB/2
• IFC Integrated File System
• DataLinks
• Application Server
• WebSphere
• JServer
• WebDB
• InterMedia
• Virtual Private Database
• Visuaalsed vahendid Java salvestatud
protseduuride loomiseks
• Administrative Java toolkit
• XML süntaktiline analüsaator
• Sisseehitatud otsingu vahendid
• DataJoiner
• Intelligent Miner
• Visual Warehouse
4
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
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
Internet-platvormid
IBM: WebSphere
• Ise AB
• Platvormidevaheline tarkvara
• Instrumentaalsed vahendid
Oracle : Appication Server
• Resurside planeerimine
• Klientidega suhtlemine
7
Platvormid
Oracle
DB/2
• UNIX
• UNIX
• WINDOWS
• WINDOWS
• Tasku riistvara
• Tasku riistvara
DB2 Server
Windows CE, Palm Pilot ja EPOC
baasil:
DB2 Everywhere
• AIX
• OS/2
• NUMA-Q
• OS/400
• SCO UnixWare
• VSE, VM
• Solaris
• HP-UX
• Dynix/ptx
5
Arhitektuur
IBM: DB2 UDB
eraldi
iga keskonna jaoks
Oracle :
ühine süsteem,
adapteerimine
6
Usaldatavus
IBM: DB2 UDB EEE
Enterprise Extended Edition
• Suured klasterid
• Massilise parallelismi realiseerimine
HP +
Oracle: Parallel Failsafe
• Klasteriseerimine
8
Produktiivsus
Unix
NT
Mainframes
AS/400
TPC-testid
Võrdsed
IBM
10
COST ANALYSIS –
DATABASE DEVELOPMENT
10
COST ANALYSIS DATABASE DEVELOPMENT
Oracle9iR2’s
DB2 allows tocreate database
Both:
Probably
most
significant
isthe
DB2
Oracle9iR2
ismeetings
notoriously
difficult
Change
link
syntax
•Oracle9iR2’s
DB2’s
single-system
attending
UDB
cost-based
V8.1
image
optimization
ESE
with
is to
• DB2
create
servers,
wrappers,
parallel
load,
fast
load,
etc.
install.
UDB
V8.1’s
Installing
advantages
RAC:
in the
Management
Utility
Database
more
mature:
Partitioning
Feature
and
function
mappings
•Coding
centralized
coordinating
management
and scheduling
of all
tasks
and
Debugging
category,
fast
loader!
••DB2:
requires
to
create
more
links
requires
a
bit
more
work
to
cocreate
raw
files
define
thedevices
relationship
among
•nodes
more
along
complete
setfor
of all
optimization
where
the
new
Development
•
reduces
by
half
the
amount
•locate
is less
conducive
to reuse. of
data
in its shared-nothing
them
•
Copy
Table
strategies
and
techniques,
•environment,
create
Center’s
ancomprehensive
ASCII
thateffort
lists each
dedicated
to
cleanup
•time
automated
installation
thisfile
extra
procedure
is
DB2’s
graphical
interface:
database
functionality
and
superior
the of special
•not
Warehouse
Center
Furthermore,
Oracle9iR2
cover
required
aobject
broader
inand
a single-partition
range
Non-DB2
data
appears
toof
• Data
automates
the
process
corresponding
interface
give
raw
it
a
50%
device
advantage
file
name
requires
toif create
and local
maintain
-environment,
greater
situations,
however.
of automation
than
users
aslevel
they
were
change
management
over
Oracle9iR2.
files
for each
link.
The
DBA
inserts
the CD,
runsto
Oracle9iR2
•ASCII
set
an
environmental
variable
DB2
tables.
Otherwise,
planning and
Oracle9iR2:
-setup
guides
the
one
DBA
database
through
partition
a
point
toonthe
ASCII
modeling
tasks
are mapping
database file.
server,
in
sequence
certain
andinstances
then
of steps.
copies
the
DB2
to all query
the
This
architecture
promotes
But:
•
Transportable
Tablespaces
A
20%
initial
benefit
is
independent
and
hence,
equivalent
•operation
create aadding
UNIX
account
andas
mountothers,
can complete
logical
nodes
orders
of
reuse,
eliminates
estimated
for
DB2,
growing
to
for
both
DBMSs.
point
directory
on
each
node
$3,000 per
processor
appropriate.
magnitude
faster
–
one
hour
instead
redundancies,
50%
or more asand
the streamlines
distributed
DB2
UDB
V8.1
style
can
reduce
of
ten,
etc.
•environment
replicate
to reduces
allof
nodes
the
process
making
Oracle9iR2
the
costisof
grows
and
staff
related activities by up to 25%.
changes.
data-loading
30%.
modified
over
time.
10
COST ANALYSIS DATABASE DEVELOPMENT
When
considerable difference exists between the two vendors,
it can often be attributed
to a difference in the target user.
DB2:
Oracle9iR2:
• a greater level of automation
• 40% streamlining
of the change
The impact
of update,
these efficiencies
on the
• 50% advantage in installation
and
management effort
line varies greatly, depending on
query optimizations bottom
and distributed
• 30% reduction of the data
database.
the size and nature of the
project.effort
movement
• 25% advantage in staff-related activities
• most significant advantages in the Coding
and Debugging
Pricing
EXHIBIT 1:
DB2 UDB V8.1 ESE vs.
EE (Enterprise Server Edition)
Oracle9i R2
• 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
Pricing
EXHIBIT 3:
DB2
vs.
Oracle9i R2 SMP
Data Warehouse
EXHIBIT 2:
DB2 ESE
vs. Oracle9i R2 Data
Warehouse Clusters
10
Pricing
EXHIBIT 5:
Discounted Price with
EXHIBIT 4:
One Year of Service
SCALABILITY CLUSTERS
WITH FAILOVER
10
Kokkuvõte
While
the two products provide
functionally equivalent
technologies,
they
vary significantly in total
cost
Kokkuvõte
Although
the weights of these expense
categories may vary by customer
environments and applications,
DB2’s
advantages suggest that it is the more
economical choice over a five-year
period for almost all scenarios.
Kasutatud linke:
1.
http://www-3.ibm.com/software/data/db2/udb/
2.
http://www.almaden.ibm.com/cs/datalinks/
3.
http://www.citforum.ru/seminars/cbd2001/day_1_1_ibm.shtml
10