????? Oracle Exadata and Database Machine

1
????? Oracle Exadata and Database Machine

• ?????? ???????,
• ???????? ?? ????????? Database Options Oracle ???

2
EXADATA????????????? ?????????????????????
???????? ??????
3
???????????????? ???? ??????? ??????

• Gartner ?????? ??????? ?????? ????? ???????????
  ?????? ??? !
• Winter Corp ????????? ?????? ??????
  ???????????????? ? ???????? ?????? ??? ????

4
????????? ?????? ?????? ? ??????
???????? ?????? ?????? ??? ????
Data Warehouse Size (TB)
?????? ??????? ? ???, ????? ????????????
?????????? ?????????????????? ???????? ?? ????
??????
Projected
Actual
Source Winter TopTen Survey, Winter Corporation,
Waltham MA, 2008.
5
??????? ? ?????????? ??????

• ?????? ????? ??????????? ???????????
  ????????????? ???????????????? ???? ???
  ??????????? ???????????? ? ????????????
• OLAP, Bitmap Indexing, Join indexing,
  Materialized Views, Result Caches, Range
  Partitioning,...
• ?????? ?????? ?????????? ???????????
  ????????????? ??????? ???????????? ??? ??????????
  ???????????? ? ??????????? ??????? ?????? ????
• ?????? ?????? ?????????? ??????????? ????????
  ?????? ? ??? ??????, ????? ???????? ????????????
  ?????? ?????????? ?? ???????

6
???????? ??????? ??????????? ????????????????????
? ??????????? ?????? ???????? ??????

• ???????????? ?????????? ???????? ?????? ?????
  ????? ???????? ??????????? ????????,
  ??????????????? ???????? ?????? ? ?????? ??
  ???????
• ?????????? ???????? Storage Array ?? ???????????
  ? ?????? Fibre Channel
• ???????????? ???????? ???? Fibre Channel ?
  ????????
• ? ?????? ?????????????????? ??????? SAN
• ?????? ????? ??????? ? ????????? ?? 10 ?? 100
  ??? ????????? ????, ??? ????????? ??? ????????
  ?????? ???????? ???????

7
??????? ?? ??????????? ??????????? ??????????
??????????? ???????

• ?????????? ?? ??????? ?????? ??????
• ???????? ?????? ???????
• ??????? ?????? ??????

8
Query ProcessingUsing Traditional Storage
Oracle Database Grid
Storage Array
What Were Yesterdays Sales?
Retrieve Entire Sales Table
Select sum(sales) where salesdate 08-Oct-2008
SUM
9
Query Processing Using Exadata Storage Server
Oracle Database Grid
Oracle Exadata Storage Grid
What Were Yesterdays Sales?
Retrieve Sales for Oct 08 2008
Select sum(sales) where salesdate 08-Oct-2008
SUM
10
??? ????? ?????? Exadata Storage Server

• Hardware by HP
• Software by Oracle

HP Oracle Exadata Storage Server

• Will work with any Oracle Database server
• Linux x86 today
• Other operating systems coming
• Implements data intensive processing directly in
  storage
• Scans tables and indexes filtering out data that
  is not relevant to a query
• 10x or more data reduction is typical

• Industry standard components
• 2 Intel processors
• 12 SAS or SATA disks
• Up to 12 TB raw storage
• InfiniBand connectivity
• Building block of a massively parallel storage
  grid
• Up to 1 GB/Sec. of data bandwidth

11
Database Machine

• 8 Oracle Database 11g servers
• Oracle Enterprise Linux
• Oracle Real Application Clusters
• Oracle Partitioning
• 4 Infiniband switches
• 14 GB/Sec. data bandwidth
• 14 HP Oracle Exadata Storage Servers
• 112 Intel Processor Cores
• 168 SAS or SATA Disk Drives

12
HP Oracle Database Machine

• ??????????????? ??????? ??? ???????? ??????
• Database Server Grid
• Storage Server Grid
• ????????????? ? ?????????????????? ??
• ?????????? ??????????????????
• ? 10-100 ??? ???????, ??? ???????????? ???????
• ?????????????? Exadata Storage
• ?????????????? ????????????????
• ??????????? ?????????? ????? ?????
• ?????????? ? ?????????????
• ?????? ???????????????? ????????? ??????
• ?????????? ? ???????????? ?????????????? ??????
• ???????? ????????? ?? ? ????????????
  ?????????????? ??????

???????? ?? Oracle 11g
13
Plamen Zyumbyulev Head of Database
Administration M-Tel
?????? ?????? ??????????? ??????? ?? Exadata ??
????????? ? ????????????? ?????????. ???????????
????????? ?????????????????? ???? ? 10 ???, ?
????? ??????? ? ?????????? 72 ????.
14
????????? ????? M-Tel??????? ?????? ?????? ??
?????????
1/2 Database Machine
???????????? ???????
2 IBM P570s
EMC CX3-40 Storage
???? ?????????????????? ? ??????? ? 28 ???
15
M-Tel Exadata Speedup 10X to 72X
28x Average Speedup
16
Grant Salmon Chief Executive Officer LGR
Telecommunications
?????? ??????? ?????? ??????, ??????? ??????
?????????? ????? 30 ?????, ?????? ??????????? ?
??????? ????? ??? 1 ??????. ??? ??????????
??????????????????.
17
?????????? ????? LGR??????? ?????? ?????? ??
?????????
???????????? ???????
1/2 Database Machine
HP Superdome Server
Hitachi XP24000 Storage Array
???? ?????????????????? ? ??????? ? 20 ???
18
Walt Litzenberger Director Enterprise Database
Systems The CME Group
Oracle Exadata ?? ??????????? ???? ???????????
?? ??????????? ???, ??? ?? ??????????? ?????, ??
10 ?? 15 ???. ???? ??????? ?????? ???????? ?
????.
19
Giant Eagle Test Results????????? ?????? ??
???????? ???????? ????
1/2 Database Machine
???????????? ???????
13 IBM P570 CPUs
EMC CLARiiON and DMX Storage Array
???? ?????????????????? ? ??????? ? 16 ???
20
Giant Eagle Exadata Speedup 3X to 50X
21
???????? ???????????????? ??? ??????????????
?????? ??????????? ??????,?????????? ???????????
? ???????? ????????? ??????
10 ?????
????????????????????????
Typical High-End Array
Typical Mid-Range Array
5 ?????
Typical NAS
Oracle Exadata Storage Grid
1 ???
?????? ???????
1TB
10 TB
100TB
22
Technology Comparison
23
Price Comparison
Use your existing database licenses 0
discount on storage server software using SATA
drives
24
Exadata ????? ???????????????????????
??????????? ?????????? ???????????

• Exadata ???????? ?????? ?????? ????? ??????
• ????????? ???????? ?????????? ??????? ????????,
  ??? ??????????? ????????? ????? ??????,
  ?????????? ?? ????????? ??????????? ???????
• Exadata ???????? ??????? ?????? ???????
• Modular storage cell building blocks organized
  into Massively Parallel Grid
• ?????????? ??????????? ?????????????? ??????????
  ???????
• Exadata ???????? ?ó?????? ????????
• InfiniBand interconnect ???????? ?????? ? 5 ???
  ???????, ??? Fibre Channel

Exadata ???????? ???? ??????? ?????? ??????
??????????? ???????
25
??????????? Oracle Grid Computing ????????
??????? ?? ?????????? ???? ?????? ?? ???
26
????? ???????

• ??? ????? ???????? ?? Oracle
• HP Oracle Exadata Storage Server
• HP Oracle Database Machine
• ?????????? ??????????????????
• ?? ??????? ???? ? 10 ??? ???????, ???
  ???????????? ????????? ??????
• ?????????????? ????????????????
• ??????? ?????????????? ????? ?????????,
  ?????????? ??????????? ? ???????? ?????????
  ??????
• ?????????? ? ?????????????
• ???????????? HP, ??????????? ??????????? Oracle
• ??? ??????????? ??????????? ???????????,
  ???????????????? ? ?????? ? ?????????????

27
Add Performance and Capacity by Adding More
Database Machines
28
A
29
??????? ?????? Oracle CIS Email
Dmitry.Volkov_at_oracle.com Phone 7 (495)
641 14 00 Direct 7 (495) 641 13
56 Mobile [phone]
http//dsvolk.blogspot.com