Coriani 2
-
Upload
andrea-innocenti -
Category
Technology
-
view
336 -
download
0
description
Transcript of Coriani 2
La situazione di mercatoI benchmarkSicurezzaAffidabilitàScalabilitàCosti
TP
C-H
res
ults
abo
ve:
HP
Pro
Lian
t D
L585
-G1
12,6
00 Q
phH
@10
0GB
, 9.
43 $
/Qph
H@
100G
B,
avai
labl
e 11
/7/0
5; B
ull N
ovaS
cale
516
0, 1
7,05
9 Q
phH
@1T
B,
25.4
8 $/
Qph
H@
1TB
, av
aila
ble
5/5/
06;
HP
Int
egrit
y S
uper
dom
e, 3
0,95
6 Q
phH
@3T
B,
76.8
2 $/
Qph
H@
3TB
, av
aila
ble
5/5/
06;
NE
C E
xpre
ss58
00/1
320X
e, 2
8,39
0 Q
phH
@3T
B,
66.5
2 $/
Qph
H@
3TB
, av
aila
ble
5/5/
06.
R
esul
ts
as o
f 11
/27/
05.
12,600 12,600 QphHQphH
9.43 $/QphH9.43 $/QphH
HP: 17,725 QphHHP: 17,725 QphHBull: 25.48 Bull: 25.48
$/QphH$/QphH
TPC-H BenchmarksTPC-H Benchmarks
1 TB16P100 GB 3 TB
32P
30,956 30,956 QphHQphH
TP
C-C
res
ults
to
the
left
: H
P P
roLi
ant
DL5
85-G
1 20
6,18
1 tp
mC
, 2.
30 $
/tpm
C,
avai
labl
e 11
/7/0
5;
IBM
eS
erve
r xS
erie
s 46
0 16
P c
/s,
492,
307
tpm
C,
6.37
$/t
pmC
, av
aila
ble
5/20
/200
6; U
nisy
s E
S70
00/6
00 E
nter
pris
e S
erve
r (1
6P),
376
,045
tpm
C,
3.97
$/t
pmC
, av
aila
ble
1/3/
2006
; H
P
Inte
grity
Sup
erdo
me,
1,2
31,4
34 t
pmC
, 4.
91 $
/tpm
C,
avai
labl
e 5/
5/06
. R
esul
ts a
s of
11/
28/0
5.
206K tpmC206K tpmC2.30 $ / 2.30 $ / tpmCtpmC
IBM: 492K tpmCIBM: 492K tpmCUnisys: 3.97 Unisys: 3.97
$/tpmC$/tpmC1.2M tpmC1.2M tpmC
64P4P 16P
TPC-C BenchmarksTPC-C Benchmarks
2020
1313
7744
Database Security BulletinsDatabase Security Bulletins
Source: Company web sites, http://www.osvdb.org, http://www.secunia.com (Includes both SQL Server and
MDAC)
20022002 20032003 20042004 20052005
SQL SQL ServerServer
Oracle DBOracle DB
1111
22 11
1414
99.999% availability, Telecom 12,000 concurrent users, 5 TB of data99.999% availability, Gift Card Processor 500 concurrent users99.999% availability, Paper Manufacturing 433 tps100% availability, Manufacturing 900 tps99.990% availability, Retail 2,000 concurrent users99.998% availability, Stock Exchange 3,200 tps99.997% availability, Banking 500 tps
5.1 TB Credit Card DW, 5 Mil card holders5.1 TB Credit Card DW, 5 Mil card holders300 power users, complex query, OLAP, SSIS, SSRS, 300 power users, complex query, OLAP, SSIS, SSRS,
Office BSMOffice BSM
4 TB Consumer Packaged Goods (CPG) DW4 TB Consumer Packaged Goods (CPG) DW350 users, complex relational query, SSIS & SSRS350 users, complex relational query, SSIS & SSRS
3 TB Retail Data Warehouse on HP Superdome3 TB Retail Data Warehouse on HP SuperdomeUses SQL Server OLAP, SSIS, SSRSUses SQL Server OLAP, SSIS, SSRS
2 TB DW, originally migrated from Informix2 TB DW, originally migrated from Informix300 users, complex query, OLAP & Data Mining300 users, complex query, OLAP & Data Mining
2 TB of Clinical Data & growing, 50 TB storage2 TB of Clinical Data & growing, 50 TB storageUS Dept of Veterans Affairs, 1200+ facilities, 40+ OLAP US Dept of Veterans Affairs, 1200+ facilities, 40+ OLAP
MartsMarts
2.2 TB SAP Business Warehouse system2.2 TB SAP Business Warehouse systemIn the process of migrating SAP R/3 OLTP to SS2005In the process of migrating SAP R/3 OLTP to SS2005
Base ProductBase Product
ManageabilityManageability
(included)(included)
$0
0
50
100
150
200
250
300
350
Microsoft Oracle IBM
Multi-core
BusinessIntelligence
HighAvailability
Manageablity
Base product
High AvailabilityHigh Availability
Business Business IntelligenceIntelligence
Multi-coreMulti-core
$116K
$165K
$ 116K$ 232K$ 25K $ 330K $ 165K
Customer ready
Ottimizzazione Ottimizzazione prestazioniprestazioniGestione Gestione carichi di carichi di lavoro mistilavoro mistiScalabilità Scalabilità prestazioniprestazioni
Disponibilità dei Disponibilità dei sistemisistemiMinimizzazione Minimizzazione tempi di fermotempi di fermoAccesso Accesso concorrenteconcorrente
Accesso ai dati Accesso ai dati sicurosicuroProtezione dei Protezione dei sistemisistemiSemplificazionSemplificazione conformitàe conformità