Oracle ,

1
(No Transcript)
2
???? Oracle ??????????, ???????????? ?
?????????????????? ?????? ???????

• ????? ?????????
• ??????? ??????????? Oracle ???

3
????
ltInsert Picture Heregt

• ????? ???? ?????????? Oracle
• ??????????? Oracle Database 11g
• ????? Oracle Database 11g
• ???????????? ?????? ???? ?? Oracle

4
ltInsert Picture Heregt
????? ??????? ???? ?????????? Oracle
5
? Oracle ????? ????
Oracle Databases
Oracle 11g
???????????? ????
?????????????? ????
???????????
Hyperion
RDB
TimesTen
CODASYL
Berkeley DB
Express
Oracle Lite
6
Oracle TimesTen ???? ????????? ???????
7
Oracle TimesTen ?????? ??????????

• ??????-???????????????? ??, ??????? ??????????? ?
  RAM
• ?????? ??????????? ??? ?????????? ?????? ?? ????
• ??????????? ???????? ? ?????????? ??? ??????????
  ? ??????
• ?????? ????????? ? ????????????????

TimesTen
Disk Persistence/ Recovery
8
?????? TimesTen ??????? ???????? ????
??????????? ?????? ??????? ???????? ?? ?????
??????????
QueryOptimiser /Executor
TablePage
SQL
IPC
????????? ?????? ? ?????????? (via IPC)
Buffer Pool
??????????? ??????? ? Private Buffer
?????????? ????????? ?? ????? ???????? (Page
Pointer) ? ?????????????? ??????????? ? ?????????
??????
???????????, ??? ???????? ??? ? ??????...
Data Page
9
?????? TimesTen ??????? TimesTen
?????????? ??????? ?????? ? ?????? ??? ???????
??????
??????????
Query Optimiser / Executor
Memory Address
SQL
Memory-Resident Database
??????????? ?????? ? ?????? ??????????
??? ?? ????????? ? ????? ? ?????? ?? ?????? ??????
Data Store
10
??????????? ?????? ????????? ???????

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

???????? ?????????????? ? ???????????? ??????.
???????? ?????????? ? ?????????????
11
TimesTen Cache Connect to Oracle

• ??????????? ????????? ?????? ?? Oracle Database
• ?????? ?????? ??? ?????????
• ??????????????? ?????????
• ?? TimesTen ? Oracle
• ?? Oracle ? TimesTen
• ????????? ??????????? TimesTen ??? ????? Oracle
  DB
• ?????? ??????????

Network
Application Program
Application Program
TimesTen
TimesTen
Application-Tier Platforms
In-MemoryDatabase
In-MemoryDatabase
Cache Connectto Oracle
Oracle
12
??????????????
13
Oracle Berkeley DB
14
Berkeley DB ????????

• ?????? ? ????????????????? ???????? (engine)
  ??????? ? ??????
• ??????????? ??????????, ??????? ??????????? ?
  ??????????
• ??????????? ??????????? ??? ??????????
  ??????????
• ?? ????? ?????????????????
• ??????????? ???????????????? ? ?????????? ??
  ??????????
• ??????????? ?????? ?????? ?????? ?????????
• ?????????? ??????? ?????? ? ?????????? !

15
Oracle Berkeley DB
?Berkeley DB ?????????? ??? XQuery-??????? ?
XML-??????????
? ???????? ?????? ? ?? ??? ???????? ?? Java
? ???????? ?????? ? ?? ??? ???????? ?? C, C,
Java, PHP, Perl, etc.
16
Oracle Database Lite Edition
17
Oracle Database Lite
?????? ?????????? ?????? ? ??????????
??????????? ????????? ?????????????
Mobile Server Repository
????????? ???????
Mobile Server
Data and Applications
Sync Layer
Oracle Lite Database
????????????? ??????
Windows, Windows Mobile, Symbian, Linux,
Embedded Linux, etc.
18
?????? ??????? ????
Mobile Devices Consumer Electronics
Gateways / Routers / Switches Storage Systems
Management Security / Authentication Mobile
Services Software Appliances E-business
Telecom OSS/BSS Core Networking
Systems Securities Trading Call Centers /
CRM Supply Chain / Logistics Reservations
Business Application
Devices
Edge Applications
Core Applications
19
????? ??????????? Oracle Database 11g
20
Oracle Database 11g Result Cache
21
??????????? ????????

• ????????????? ???????? ?????????? ????????,
  ??????????? (query blocks)
• ??? ????????? ???????????? ?????????? SQL
  ??????????? ? ???????? ?????????????
• ???????????? ????????? ??? ???????? ??????
  (read-only / read-mostly data)
• ???????? ??? ??????????? ?????? ??????

22
??????????? ???????? ???????? ???????????? ????

• ????????? ??????? ????????
• ???????? hints
• ??????? table caching DDL
• ?????? ???????? lt???????? force or auto or
  manualgt
• ????????????? ?????????? ??????????? ????????
  ?????????? ????????? ???????????
• ?????? ?????? ??? ???? ???????? DBA
• ?????? ??????????????? ??????????
• ??? ??????????? ??? ????????? ??????, ?? ???????
  ??????? ?????????? ?????????

23
??????????? ??????????? ? PL/SQL???????? ??????
PL/SQL VM
??????? ??? ?????????? c ?????? ????????????
???
????? ??????? Func1
?????????? ???????
SGA
Result Cache
24
??????????? ?? ???????OCI Client Result Cache
????????? ???????????
Application Server
Database

• ???????? ?????????? ??????? ?? ???????
• ???????? ?????????????????? ?????? ? ?????????,
  ????????????? ? ???????? ??? ?????? (read-mostly)
• ????? ??????? ????? ??????? ???????????
  ???????? ?? ????
• ????????? ???????? ?? ?????????? ???????
• ?????????? ? ????????
• ??? ?????????? ???????????, ????? ??????????
  ???????
• ???????????? ???? (??? ? RAC)

25
Real Application Testing
26
Real Application Testing?????? ?? ?????????????
???????

• ??? ??????????? ????????? ??
• ???????????? ???????
• ?????? ??????? production-???????
• ??? ????????????? ????????? ?? ?????? ???????
  (????????, ????? ?????????????, SQL-??????? ? ?.)
  ?
• ?????????? ?????? ??? ??????
• ???????? ?????????? ? ?? ??????
• ???????? ????????

Deploy
Test
Change
Remediate
?????????? ??????? ??? ?????? ?????????????
??????? !
27
Real Application TestingDatabase Replay ?????
??????
??????
????????????
File 1
?????????- ??????? ??
???????? ??
???? ? ??????? ????????
28
Real Application TestingDatabase Replay - ??????
? ??????????????? ???????? ????
Rec

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

?????? ? ????????
?????? ? ??????????
29
Active DataGuard
30
Oracle DataGuard (StandBy)?? Oracle Database 11g
????????????
????????????????
????? ???????!

• ?????????? ????????? ?????? ?????????? !
• ????????? ? ?????? ?????? ? ?????? ????????? ?
  ???????? ??
• ???? ????????? ??? ? read-only, ?? ?? ???????????
  ?????????

31
?????????? standby ? real-time query????? ?????
? 11g Active DataGuard
??????? ? ?????? ????????? ???????
??????????? ???????? ? ?????????? ?????????
Primary ??
????????? ?? (Standby DB)

• ??????? ?????? ?? ?????? ?? ????????? ???????
  ???????????? ? ????????? ? ??????????? ?????????
  ? primary ??
• ????????? RAC ?? primary ?/??? standby
• ??????? ???????? ????????????? ?? ???????????
  ????????? (consistent transactions)
• ????????? ???? ????? ?????? (??? ??????????
  ??????? !)

32
Oracle Active DataGuard??????? ??????????

• ????????? ???????????? ????????????
• ????????? ???????????? ????????????? ??????? ???
  ??????? ????? ???????
• ??? ?????????? ?????? ?? ????????
• ??????? ????????? ?????????? ?? standby
  (?????????? ???????? ?????? !)
• ?????? ????????? ?????? (???????? ????????
  ???????? ?????????) ?? standby
• ??????? ?? ?????? ?????????????? ?? ??????
  ???????? ????????
• ?????? ? ???????? ????????????? ???????? ?
  ???????????? ?? ???????

33
ltInsert Picture Heregt
????????????
34
19 ???????????? ???????????? !!!
35
??????????????
?????????????
???????????
??
????????????
?????? ??????????
Backup
36
???????????? ? ??
?????????????
???????????
??
????????????
?????? ??????????
Backup
Virtual Privat Database Oracle Lable
Security Encryption (TDE/crypto)
37
???????????? ??? ???????? ??????
?????????????
???????????
(Network encryption)
encrypted
??
encrypted
????????????
?????? ??????????
encrypted
Backup
38
?????? ?????? ?? ????????????????? ?????????????
Database Vault
?????????????
???????????
encrypted
??
encrypted
????????????
?????? ??????????
encrypted
Backup
39
Securing Backup
???????? Database Vault
?????????????
???????? Database Vault
???????????
encrypted
??
encrypted
????????????
?????? ??????????
encrypted
encrypted
???????? Secure Backup
Backup
40
Advanced Compression Option
41
Advanced Compression Option?????? ???? ??????

• ?? 11g ?????? ???????? ?????? ?? ?????????
  ???????? ????????
• ??????????? ? ?????????? ?????? ? ???????
• ? 11g ?????? ???????? ??? ???? ????? ??????????
• ???????? ??? ?????????? (update) ????? ????????
• ? ??????? - ?????????? ?????? ? 2-3 ????
• ?????? ???????? ? ?????? ??? ??????????
• ????????? ????? 10 ????? ??????? ?????? ? ??
• ?????????? ??????? ? 2 ????, ?????????? ????????
  ?????????? ???????? ?? 3-5
• ?????????? ?????? ?? ?????, ???. ?????, ???????
  ?????? ? ?.?.
• ?????????? ??????????????????

42
ltInsert Picture Heregt
???????????? ?????? ???? ?? Oracle
43
?????????? Oracle ???????

• ?????????? ????????????? ?? ? ????
• 275,000 ??????????
• 30,000 ?????????? Oracle Applications
• 190,000 ?????????? ? SMB ???????
• 68,000 ??????????? 7,500 ??????????? ?????????
• 19,000 ?????????
• 9,000 ISV ????????
• ???????? ? 145 ???????

44
30 ??? ??????????? ?????????
Total Recall
SOA Suite Audit Vault


Apps Integration Arch


Business Process Mgmt


Self Managing Database

Grid
Computing

Oracle Data Guard

Real Application
Clusters

First Comprehensive CRM Suite

Flashback Query

First Internet Applications

Built-in Java VM

Partitioning Support

Full Applications Implementation Methodology

Industry-Specific Business Applications

Object Relational Support
Multimedia
Support
Data Warehousing Optimizations
First Unix-Based
Applications
Parallel Operations
Distributed SQL Transaction Support
Cluster MPP Support
Multi-version Read Consistency
Client/Server Support Platform
Portability Commercial SQL Implementation
2000
1990s
1980s
1970s
45
Oracle N1 ?? ????? ????
Oracle
??????
14,4
48,6
Microsoft
15
IBM
22
???????? Gartner May 2006, Worldwide RDBMS
Total Software Revenue
46
????????????? ?? ????????

• ???????????? ???????
• z/390
• TRU64
• Solaris
• AIX
• HP UX
• Windows
• Linux
• ??????

• ??????? ?????????
• TCP/IP
• LU6.2
• SPX/IPX
• OSI
• DECnet
• ??????

• ??-???????
• MS Windows
• Web-???????
• ?????? ??

• ????????????
• Compaq
• Sun
• HP
• IBM
• Mac
• Intel
• ??????

47

• ????? ?????????
• ??????? ??????????? Oracle ???
• Email Igor.Melnikov_at_oracle.com
• Phone [phone]
• Direct 7 (495) 641 14 42
• Mobile [phone]

48
(No Transcript)