Coriani 2

8
La situazione di mercato I benchmark Sicurezza Affidabilità Scalabilità Costi

description

 

Transcript of Coriani 2

Page 1: Coriani 2

La situazione di mercatoI benchmarkSicurezzaAffidabilitàScalabilitàCosti

Page 2: Coriani 2
Page 3: Coriani 2

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

Page 4: Coriani 2

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

Page 5: Coriani 2

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

Page 6: Coriani 2

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

Page 7: Coriani 2

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

Page 8: Coriani 2

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à