TDM ????

1
TDM ????
2
??

• GoldenGate????
• GoldenGate TDM???????
• GoldenGate TDM???????
• GoldenGate ????
• GoldenGate????????
• ????
• ?????

3
GoldenGate????

• ???1995?
• ?????????
• ??????????????
• ????4,000?????,???????????????????????????????,???
  ??????500???
• ?Oracle?IBM?HP?Microsoft?Sybase?Teradata??????????
  ????
• ?????????????GoldenGate???????????????

4
????(??????)
Healthcare
Banking
Cable, Telco, and Manufacturing
Financial and Insurance Services
eBusiness, Retail, Public/Govt., Services
5
??????
6
??

• GoldenGate????
• GoldenGate TDM???????
• GoldenGate TDM???????
• ????
• ?????

7
GoldenGate TDM ????
Capture ????????????????????.
???? ??????.
?? ???????????????.
Delivery?????????,?????????????.
??
????
?????
8
??????Transactional Data Management

• GoldenGate TDM???????????????????????

• TDM ??
• ???
• ?????
• ??????
• ????????????????
• ????????
• ???????

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

9
GoldenGate TDM???????
Databases O/S and Platforms
Capture ?? Oracle ?? DB2 UDB ?? Microsoft SQL Server ?? Sybase ASE ?? Teradata ?? Ingres ?? Enscribe ?? SQL/MP ?? SQL/MX Delivery ?? All listed above ?? MySQL, HP Neoview, Netezza ?? And ODBC compatible databases Windows 2000, 2003, XP Linux Sun Solaris HP NonStop HP-UX HP TRU64 IBM AIX IBM z/OS
10
???????
???? ?????
???? ????????
??? ?????
???? ????
???? ?????N1??
???? ???????
11
??

• GoldenGate????
• GoldenGate TDM???????
• GoldenGate TDM???????
• GoldenGate ????
• GoldenGate????????
• ????
• ?????

12
GoldenGate TDM????

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

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

13
?????????????
1 ????
????
2 ????
3 ?????
Unplanned outage
??
????
??
????
??
14
???? ???????

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

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

15
???? ???????

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

• ??
• ????/??/????????????????????

16
???? ?????(Active-Active)

• ??
• ????,????????
• ????,???????
• ???????

17
(No Transcript)
18
Active-Active for Continuous Availability
??????????

• ??????????IT??
• ???????
• ????????
• ???????
• ??????,?????????
• ???IT??
• ????,??????
• ????,RTO?0
• ??????
• ??????,????????????,???????????????,???????????

19
Active-Active???

• ??????
• GoldenGate?????????????????
• ?????????
• ???????????
• ??????????
• ????????????
• ?????????
• ??????????????
• ????

20
GoldenGate????

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

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

21
????????

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

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

22
????

• ??
• ???????????,?????????
• ?????????

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

23
??

• GoldenGate????
• GoldenGate TDM???????
• GoldenGate TDM???????
• GoldenGate ????
• GoldenGate????????
• ????
• ?????

24
Oracle PackagingNew Products Based on GoldenGate
Technology
Oracle Products Description ???????
Oracle GoldenGate v10.4 Includes GoldenGate Capture, Deliver and Active Data Guard and XStream on Oracle DB and support for other open systems databases. Transactional Data Management (TDM) Capture Delivery, Rollback
Oracle GoldenGate for Mainframe v10 Includes GoldenGate Capture and Deliver for HP Non-Stop and IBM DB2 on Mainframe, plus Syncfile. TDM CaptureDelivery, Syncfile, Rollback
Oracle GoldenGate Veridata v3 Add-on capability to validate data in replicated systems. GoldenGate Veridata
Management Pack for GoldenGate v2 Add-on management pack (was Director). Restricted use WebLogic SE. GoldenGate Director
Oracle GoldenGate Adapters (for Siebel, Cerner, Amdocs, Base24, JMS/Flat File, Logger-Enscribe) Pre-packaged application content. Base 24 Add-on Modules, Integration Edition for Java Flat Files, Logger
24
25
?? 2009-10-1 ???
26
Management Pack for GoldenGate

• Auto-discovery of all running GoldenGate
  instances
• Integration with existing enterprise monitoring
  systems
• Customizable views based on solutions
• User management and security
• Customizable thresholds alerts
• Statistics and monitors built into the
  infrastructure
• Analytics reports

27
Veridata

• Veridata, 2009
• Additional platforms SQL Server, DB2, Teradata
• Mapping across like data types from different
  platforms

28
Oracle Products for Data Movement Comparing How
They Work
INCREASING TRANSFORMATION
Disaster Recovery Data Protection
Redo in Memory Buffer
Active Data Guard
DECREASING LATENCY
Direct Write to Logs
Direct Memory Access
Real Time Data Integration High Availability
GoldenGate
Read On-Disk Logs
Fast SQL
HETEROGENEOUS
Data Integration for Data Warehouse SOA
Data Integrator
SQL Query
Set-based, Complex SQL
28
29
Query Offloading Continuous Availability
Active Data Guard and GoldenGate
Active Data Guard Physical Standby
Central Hub
Example of a how a global hub spoke
manufacturing operation may be deployed using
both Active Data Guard and GoldenGate
DB2
Oracle 10g
SQL Server
Oracle 9i
29
30
Oracle Real Time Data Integration Oracles Unique
Offering for Real Time Business Intelligence
2
1

• Oracle GoldenGate
• Real time extracts from
• transactional systems
• Non-invasive on sources
• Continuous streaming load
• into ODS Schema of target
• Latency in seconds

• Oracle Data Integrator EE
• High Performance E-LT on
• target data warehouse
• Periodic mini-batches (15 min)
• Transform in the Database
• Never go back to sources

Source 1
Oracle Data Integrator
On-Disk Logs
Oracle GoldenGate
Source 2
Oracle GoldenGate
On-Disk Logs
ODS Schema
DW Schema
30
31
Summary Oracle Data Movement Transformation
Products per Solution
Golden Gate Active Data Guard Data Integrator EE Data Quality
Continuous Availability Disaster Recovery / Data Protection
Continuous Availability Data Distribution / Synchronization
Continuous Availability Zero Downtime Migrations / Upgrades
Continuous Availability Query Offloading
Continuous Availability Grid Scalability (Oracle RAC) (Oracle RAC) (Oracle RAC) (Oracle RAC)
Data Integration Operational Reporting (plus BI Publisher) (plus BI Publisher) (plus BI Publisher)
Data Integration Real Time BI
Data Integration Typical Data Warehouse
Data Integration Data Integration for SOA
Data Integration Migrating Between Different Apps
Non-Oracle
Oracle
Hetero-geneous
Oracle to Oracle
31
32
Comparing GoldenGate Streams
GoldenGate is Oracles strategic replication
solution
Streams continues to be a supported Oracle
Database feature

• Question I already have Streams for free? Why
  buy GoldenGate?
• Better ROI overall GoldenGate is lower cost to
  implement and maintain
• Enterprise-wide solution GoldenGate easily
  expands to new use cases
• Support for Streams continues Continue to use
  Streams where its deployed

Lead with GoldenGate
32
33
??

• GoldenGate????
• GoldenGate TDM???????
• GoldenGate TDM???????
• GoldenGate ????
• GoldenGate ???????
• ????
• ?????

34
Quest SharePlex

• GoldenGate????????,??????? SharePlex??????????

GoldenGate SharePlex
??????? ?? ???Oracle
???? ???,???????commit???,??,??????,?????????? ???,???????,??????,?????????,?????????
?? gt 1TB/? 300500GB/?
????? ??? ??????
??Log??? Oracle?? Oracle???
???1N, N1 ?? ???
35
DSG RealSync

• GoldenGate????????,???????DSG(???)??????

GoldenGate RealSync
??????? ?? ???Oracle
???? ??? ???
?? ? ???GoldenGate
???? ????? ??
?? ???HA??????????? ??????
??Log??? Oracle?? Oracle???
?,??Sybase Replication Server?????,?????Sybase
IQ?????????
36
??

• GoldenGate????
• GoldenGate TDM???????
• GoldenGate TDM???????
• GoldenGate ????
• GoldenGate ???????
• ????
• ?????

37
???? ? ? ?
GoldenGate has helped the Bank of America
accommodate growth. Michele Schwappach, Vice
President and Senior Systems Manager
??????
? ?
? ?

• ?????????????????????
• ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? (HP NSK) ? ? ?
  ?
• ? ? ATM 7X24????

? ? ? ? ? ? ? ? ?
? ?
? ?
38
??????????????

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

39
?????????????

• N1????
• ???????
• ???
• ???

40
?????????

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

41
??
Q
A