???????????

1
????????? ???????? ????????????
???? ??????????? ????????????? ???? ?????? ,
24 ?????? 2008 ? ???? ?????? ??????????
????????????????? Oracle Mark.Rivkin_at_oracle.com
2
??? ??????????? ?????????

• ??????? ??????????? ? ??????? ??????, ?????? ??
  ??????????? ???. ???????
• IBM ? MS ???????? Oracle
• ??????? ??????????? ? ???????
• ??????? ????????? ?????? MS SQL
• ????????, ????????????? MS ? IBM ???????
• ??????? ????? ?? ?????? Oracle 11g ???????????
  gt ???????????? ?? ?????? ??????? ????? ????
  (???????????? ??????????), ? ?? ?????????????
  ??????????? (?????????? ?????)

3
????????

• ???????????
• ?? ???, ? ???????? ?????? ?????????
• ?????? ?? ??????????
• ?????? ?? ????? (??????? ??????)
• ???????????? !!!!! ????????
• ??????? ?????? ?? ????????? ???? (2-3 ??????)
• 2 ??????
• ????????? ???????? ????
• ????????? ???????? ?????? ?? ?????? ????,
  ???????? ?? ??????? ????

4
??????? ??????

1. ????????????? ???????? ? GRID-??????????
2. ILM (Information LifeCycle Management) ? ????
3. ??????????????, ???????????????, ???????????
4. Real Application Testing ?????????
   ????????????? ???????????? ?????? ? ?????????
5. ????????????????? ?????????? ???? ???????????
   (?????? ?????? Standby, Active standby, Snapshot
   standby, ??????????? ??????? ???????? ????????,
   ??????????? ?????????? ? ?????? ????, online
   redefinition)
6. ????????? ????????? ??????? ? ????
7. ????? ???? ?????? (XML, RFID, Semantic Web,
   ?????, ????????, ??????? LOB ? ?.?.)
8. ????? ????????? ?????? ? ?????????? ????????????
9. ????????????????? ?????? ?????? (Data Vault,
   Audit Vault, AccessIdentity)

5
????????? ???????? ?????? ?? ?????? ????,
???????? ?? ??????? ????

• ????????? ??????
• In-memory ???? ????????? ??????? ??? ??? ???
  ???????????? ????
• ?????????? ??????, ????????????? ?
  ?????????????????? ??????? (???????????? DW, BDW
  Banking Data Warehouse), MDM
• ????????? ??? ?????? ? ???????????? ??????
  ????????? ??????

6
1. ????????????? ? Grid Computing

• Storage Grid
• Database Grid
• Application Grid
• Grid Control

???????? ???????? ??????????
???????? ??? ??????
Grid Control
??????? ????. ????????
7
GRID

• ????????????? ???????? ? ???????? ??????????
• ?????????????? ???????? ?? ?????? ???????
  ?????????
• ??????????/???????? ?? ????, ????????????,
  ????????????
• ???????? ????????????????? ????????
• ???????????? ????????? ? ????????? ???????
  ???????????? ?? ?????? ???????
• ????????????? ?? ????? ?????????? ????????
• ??????????
• ????? ??????????? ????????????? ????????
• ?????????????? ?????? ??? ???????????? ??????
• ??? ???? ????????????????
• ?????????????? ????????????, ??????????????,
  ????????????????? ????????

8
?????????????

• ?????? ?????????????????
• Refferences (?mazon, e-bay ????????? ??????? -
  Mercado Libre, EDS ABNAMRO )
• Oracle 11.2 (????? ????????? ?? ?????,
  ASHTTPDBASM ????? ??????? (VM), scaledown
  VM, ????????????? ?? ? ??????)
• Sybase ASE Cluster Edition
• IBM Grid, Globus toolkit

9
2. ???? ????? ??????
???? ????? ??????
Offline ?????
????? ????????
????????
????????????
??????? ?????
Online ?????
Offline ?????
??????? ?????
10
Partitioning ????????? ???????? ??? ILM

• ?????? ??????
• ??????? ????????
• ???????? ????????/???????? /?????????????/??????
• ????????? ?????? ??????
• ?????????? ?? Hardware
• ????????? ??? ??????????
• ?????? ????? ????????-???? ASM ??? ??????????
  ?????????? ???????? ???????? (storage tiers)

????? ????????
????????????
????????
?????????? ????????
11
ILM Assistant
12
3. ??????????????, ???????????????, ???????????

• ????, ?????? ?????????? ? ???????????
  ????????????
• ???????? ???????, ? ?? ?????????
• ??????, ????/?????, ????????? ??????
• ???????? ? ?????????????, ???????????????????,
  ????????????? ? ??, ????????? ??????, ??????????
  ?? ?????????? ?????????
• ????????????? ???????? ???????? ??????, ???????,
  ????? ???? ? ? ?
• ?????????????? ?????????? ????? ? best practice
• ????????????? ?? ?????????? ??????? ????????????
• ????????? ?????? ?? ????? ?????????
  ??????????????, ?????? ?? ?????????????? ??
  (reparing adviser)
• ?????????????? backup/restore

13
??????????????, ???????????????, ???????????

• ????????????? ???????? SQL
• ????????????????? ???????????? (????
  ????????????? ??????????????, ??????????? ??????
  ???????, profiles, ????????? ???????????? ???????
  ? ? ?)
• ?????????? ????? ?????
• ??????? ?????? ?????????? (????? ???????, ???????
  ???????, ????? ??????? ? ? ?)
• ???????? ??????? ? ?????? ???? ?????????
  ??????????????
• ???????????? ? ??? ?????????? ??? ???????,
  ??????????? ?????
• ???????? ? ?????? ?????????? ??? Guru
• DBA ?? ?????

14
4. RAT ????????? ????????????? ????????????
?????? ? ?????????

• ????????? ? ?? ? ???????????? ???? ????? ?????.
• ????????? ????? ??????? ??????? ????????? ??????,
  ??? ?? ????????????.
• ??????????? ???????????? ??????? ??????? ? ?????.
• ????????? ????? ????????? ?????? ???????? ??
  ??????? ????????????
• ????? ??????? ????????? ?? ???????????
• ????????? ????????? ????????? ??
  ?????????????????? ? ??????????? ???????
• ???????? ??????? ?????????? ???????????? -
• ????????????? ????????????? ???????? ????????
• RAT ????????? ???????? ??????????? ????????????
  ? ???????? ?????????.

15
?????? ? ??????????????? ???????? ???? - Database
Replay
Beta
Rec

• ?????? ???? ? ????????
• ?????????? ?????????? ? ???????? ????, ???????
  ?????? ?????????? ?? ??????????????? ????????
• Database Replay - ????????????
• ????????????? ???????? ? ???????? ???????
  (workload with actual timing)
• ?????? ? ??????????
• ?????? ?? ???????
• ????????? ??????
• ????????? ??????????????????
• ????????????? ADDM ??? ??????????? ???????
  ??????????????????

?????? ? ????????
?????? ? ??????????
16
?????? ? ??????????????? ???????? SQL SQL Replay
Beta

• ????? ?? ???????? ? ????????? ??? ?????????? SQL
  ??????????
• ????????? ?????? ?????????????????? ??????????
  SQL ?????????
• ?????? ?????????? ??? SQL Workload ?
  ???????????????? ???????
• ??????????? ????? SQL, ?????, bind variables,
  ?????????? ??????????
• ?? ????????? ?????? ???????
• ????? ????????? ?????????? ??? SQL ? Oracle
  Database 10g Release 2
• ??????????????? SQL Workload ? ???????? ?????
• ???????? ?????????? SQL ? ???????? ?????
• ???????? SQL ? ????????????? ??????? ?????????? ?
  SQL ? ???????????? ???????????????????
• ??? ????????????? SQL ????? ???????? ????????? ?
  ??????? SQL Tuning Advisor (10g)
• ?????????? ?????? ? ??????

17
SQL Replay ?????? ??????????????????
18
5. ????????????????? ???????-??? ????????????
??????????? ?????? ?? ???????????????? ?????
(????? ?????? ???????)
??????????Standby
????????? ???????
?????????? SQL
??????? ???????????? (???)
???????????????? ??
?????????????? ??????? ? Materialized Views
?????????? ????????? ? ????????? ??? ??????
(???)
????? ?????????? (???)
??????????Standby
19
???????? ????????? ?? ????????? ????????????????
??
??????? ? ???????? ???????

• ?????????? ???????????? ?????????, ??????
  ???????, backup, read-only ?????????? ??
  ????????? ???? ??????

Standby ??
???????????????? ???? ??????
20
????????????????? ?????????? ???? ???????????

• ??????????? ??????? ???????? ????????
• online redefinition ????????? ??
• Online ?????
• Rolling Upgrade SW ? HW
• ????????? ??????????
• ??????????? ?????? ????
• ??????????? ?????????? ????
• ???????????? ??????
• ???????????? ????????, ???????, views
• C?????????????? ?????? ? ????? ?????? ??????????,
  ?????????? ? ?????? ? ???? ?? ???????

21
6. ????????? ????????? ??????? ? ???? Flashback
- ??????????? ?????? ????????

• ?????????????? ?? ???? ??????? ? ?????????
  ??????? ???????
• ??????? ??
• Flashback Database ??????????????? ?? ???????
• ?????????? Flashback Logs
• ??????? ??????
• Flashback Table ??????????????? ?????? ? ??????
  ??????
• ?????????? UNDO ? ??
• Flashback Drop ??????????????? ????????? ???????
  ? ???????
• ?????????? Recycle bin
• ??????? ??????
• ?????????????? ?????????? ???????
• ????????????? Flashback Query
• New ????? ??????????

Database
Customer
Order
22
???????????? ??????? ? ??????? ???????? ?? ???????

• Flashback Query
• ????????? ??? ?????? ?? ???????????? ??????
  ???????

select from Emp AS OF 200 P.M. where

• Flashback Version Query
• ?????????? ??? ?????? ????? ? ???????? ?????????
  ???????
• ?????????? ??????????, ??????? ???????? ??????

Tx 3
select from Emp VERSIONS BETWEEN 200 PM and
300 PM where
Tx 2

• Flashback Transaction Query
• ?????????? ??? ?????????, ????????? ???????????

Tx 1
select from FLASHBACK_TRANSACTION_QUERY where
xid 000200030000002D
23
Flashback Data Archive ????? RECALL

• ????????? ??????? ? ??
• ?????????????? ???????? - ????
• ????????????? ????????? ??? ????????? ???
  ????????? ?????? ? Flashback Data Archive
• ????? ?? ????? ???? ???????
• ?????? ?????? ????????? ? ???????????? ?
  ????????? ??????????
• ????? ?????????? ?????????? ??????? ?? ?????
  ?????? ??????? ? ??????? Flashback SQL
• ???????????? ???
• ???????????? ?????????
• ILM
• ?????????????? ??????? ?????????
• ??????
• ???????????? ???????????????? (Compliance)

Select from orders AS OF Midnight
31-Dec-2004
ORDERS
Archive Tables
?????????
User Tablespaces
Flashback Data Archive
Oracle Database
?????? ???????
24
7. ????? ???? ??????

• RFID
• Semantic Web,
• ?????
• Life Science (????????, ????????, ?????,
  ????????, ???????????, ????????, ???????? ....),
  ???????? BLAST
• ??????? LOB
• XML
• ? ? ?
• ??????????? ??????? ????????, ??????????????,
  ???????????
• ????? ??????????? ????????

25
????????????? ????

• Oracle Database 11g ?????? ????????????
  ????????, ??????????????, ?????????? ? ????????
  ????????????? ???? ?? ?????????? ??????????
  ?????????? RDF ? OWL.
• ??? ????? ???????? ? ???????? ??????,
  ???????????? ?? ??????? ? ??????? ??? ??????
  ?????? ?????????????????? RDF ? OWL ????.
• Oracle ???????????? ????? ??????????? ? ??????
  ???????? ??????? ? ????????? ????? ?????????
  ?????????? ???????????? SQL ?????????? ?? ????
  ??????????? ?????????????? ?????? ? ?????????????
  ????????.

26
8. ????? ????????? ?????? ? ??????????
????????????

• ??????? ????? ?????????? ??????
• ?????? ?????????????????/??????????? ??????
• ?????? ??????????????????? ??????
• ?????? ??? backup
• ?????? ???????? ???????
• ?????? ??? Data Pump (?? 75)
• ?????? ??? Data Guard (gap resolution ? 2 ????
  ???????)
• ??? ??????? ?? ??????????????????
• OLTP ? DSS
• ?????? ????????? ??? ?????? ??????

Redo logs
Backups
Standby
27
SecureFiles - C?????

• ????????????? ??????????, ??? SecureFile ?????
  ?????
• ?? ????????? ?????? ??? ??? ?????? ??????
• ?? ????????? ??????, ???? ???????? ????? ?????
  ??????????? ??? ???????
• ??? ?????? ??????
• ?????? ?????? MEDIUM (default), HIGH
• ??? ???? ??????? ??????, ??? ?????? ???????? ?
  ???????? ?? CPU
• ?????? SecureFiles ?????????? ?? ?????? ?????? ?
  ????????
• ?????? ??????????? ?? ???????
• ??? ?????? ? ??????? ??????, ??????????? ??????
  ??????????? ?????
• ????? ???? ?????? ?? ?????? partition

28
OLTP Table Compression
Overhead
Inserts are again uncompressed
Free Space
Uncompressed
Compressed
Block usage reaches PCTFREE triggers Compression
Inserts are uncompressed
Block usage reaches PCTFREE triggers Compression

• ??????????, ??????????? ??????
• ?????? ??????????? ?????????????, ?????
  ??????????? ?????????? ????? PCTFREE
• ?????? ????????? ?????, ??????????? ??? ????????
  ??????? ? ????????????? ?????? ????????????
  ?????????? ???????????? ? ?????

29
9. ????????????????? ?????? ??????

• Audit Vault DW ???? ????? ??????????
  ???????????
• ????? ??????????
• ????????, ?? ?????????
• ??????????? ??????, DataMining
• AccessIdentity Management ????????? ??????????
  ??????????????, ???????????, ??????????
  ???????????? ? ???????? ??????? ?? ????
• ????? ??????? ?????????
• Workflow
• ?????? ????????
• Single Sign On
• LDAP Directory
• ?????????????
• Data Vault

30
Oracle Database Vault?????????????? ????????
?????????? ???????
??????
?????????????? ???????????
?????
??????????????? ????????? ????????????
????????????????????? ?????? ????????????
31
10. ????????? ??????

• ??? ?????? ?????????? ??????? ?????? (???????,
  ???????? ....)
• ???????? ?? ??? ???????????? ? ?????????? ?
  ?????? ????????
• Data Masking Pack
• ?????? ?? ????????? ????????, ?????????,
  ?????????????, ???????? ?? ??????, ?????????????
  ???????????????? ????????
• ?????, ???????? ? ?????????? ??????? ?
  ???????????
• ????????? ??????????? ???? ? ?????? ??????????
• ?????????? ??????????? ???????? (?????, ????????
  ....)
• ????????????
• ??????, ? ???????? ??????

32
11. In-memory ???? ????????? ??????? ??? ??? ???
???????????? ????

• ????????????? IBM ????? Solid
• TimesTen in-Memory ????
• ??????? ??? ??? ???????? ????
• ????????? ?????? ? ?????? ????????? ???????
• ??? ?????? ?? ????, ?????????? ?? ????
  ??????????
• ????? ????????? ??????????????

33
???????? ??????????? TimesTen

• In Memory Database (gt 1 Tb)
• ????? ?????? ???????????? (?????? ???????????)!
• ??????????? ??????????? ? ??????? ??????????
• ????????????? ? ?????????? ????? ??????
• ?????????? ??????????? 100,000 TPS ? ????
• ???????? ??????????? ?????? ????????????? ??
  ????? ????????????? (ODBC API)
• ????????????? DBA - ??????????

34
??????????? ?????? Oracle Database

• Cache groups
• ??????????? ??? ????????? ???????
• ??? ??????? ??? ???????????? ????? ? ???????
• ????????? ????????? ?????? parent-child
• Read-only or updatable
• ??????????????? ??????????
• ?? TimesTen ? Oracle
• ?? Oracle ?TimesTen
• ????????? ????? ??? ????? Oracle DB

35
?????? TimesTen ??????? ???????? ????
??????????? ?????? ??????? ???????? ?? ?????
??????????
QueryOptimiser /Executor
TablePage
SQL
IPC
????????? ?????? ? ?????????? (via IPC)
Buffer Pool
??????????? ??????? ? Private Buffer
?????????? ????????? ?? ????? ???????? (Page
Pointer) ? ?????????????? ??????????? ? ?????????
??????
???????????, ??? ???????? ??? ? ??????...
Data Page
36
?????? TimesTen ??????? TimesTen
?????????? ??????? ?????? ? ?????? ??? ???????
??????
??????????
Query Optimiser / Executor
Memory Address
SQL
Memory-Resident Database
??????????? ?????? ? ?????? ??????????
??? ?? ????????? ? ????? ? ?????? ?? ?????? ??????
Data Store
37
12. ?????????? ??????, ?????? ??????

• DW, ??????????? DW, ????????? ??????, RT DW
• ????? ??? ????? ??? DW?
• ????? ?????? ??????????
• ????????? ????? ?????? ????? ????? ?? online
  ??????, ????? ?????
• Real Time Decision, IBM Dynamic DW, Sibel Server
• ????????????????? ? ???????????????????
  ?????????? ? DW
• ???????? ???????????? ????????? ?????????? ??????
• ?????? ??????????????? ?????? ?????? ? ?????
  ?????? ??????????
• ??????? ????????????? ? ??????? ? ??????????
• ??? ??????????? ??? ?????????? ?? ????,
  ??????????? ????? ?????? (IBM II)
• ??????????? ? ?????? ??????????, ???-? ????
• ?????????? ???????, ?? ?????????????? ??????????,
  ???????????? ?????????
• ???????????, ???????????? ????
• ?????? ???? ????????
• ?????????????? ???????? ? ??????
• Wrappers
• ??????????? ????????????? ???????? ? ???????????
  ?????? ? ? ?

38
?????? ?????? ??? DW

• ????????????? ?????????????? ??????, ???
  ????????? ??? ?????? ?????? DW (BDW, TDW, RDW,
  Sibel ? ? ?
• Best practice, ?????? ??????, ??????????
  ?????????, ??????????? ???????????, ??????? GAP
  ??????
• ????? ??????? ???????? ??????-?????????????? ?
  ????????? ??????????? ???????? ??? ??????????
  ????
• ?????? ??????????? MDM (Meta Data Modelling)
  ?????? ??????????? (????????????, ???????? ? ? ?)

39
13. ????????? ??? ?????? ? ???????????? ??????
????????? ??????

• ??????????? ????????? ?????? ???? ?? ?????? ?
  ???????
• ??? ?????? ? ?? ??
• ? ?????? ???? ??????? ? ??????????
• ?????? ????????? ?????? ? ??????????? ??????????
  (????? ???, ????, mail, Web ) mapping ?????
• ???? ??????? ??????????? ?????????????
• ?????? ??????????? ? ???? Web Service ??
  ??????????? ???????????

40
???????
41
??? ??? ?????...

• ??????? ? ??????
• (7 495) 641-14-00
• www.oracle.com/ru
• www.oracle.ru
• Email
• Mark.Rivkin_at_oracle.com